I am facing issue while joining two SAP table in qlikview my query is:
from MSEG join MKPF on ( MSEG~MBLNR = MKPF~MBLNR ) and ( MSEG~MJAHR = MKPF~MJAHR )
where MSEG~MANDT = '100' and
(( MKPF~CPUDT >= '$(test)' and MKPF~AEDAT = '00000000' )
OR ( MKPF~CPUDT like '%' and MKPF~AEDAT >= '$(test)' ));
Any help would be appreciated.
What is the problem that you have, what happend..
please add some example for us to help you
a better idea could be extract the information for sap and save as a qvd and then do the join between qvds
I would also to recommend to load the tables first into QlikView and do the join after this.