Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am facing issue while joining two SAP table in qlikview my query is:
sql select
MSEG~MANDT
MSEG~EBELN
MSEG~EBELP
MSEG~MBLNR
MSEG~MJAHR
MSEG~ZEILE
MSEG~LINE_ID
MSEG~PARENT_ID
MSEG~BWART
MSEG~XAUTO
MSEG~MATNR
MSEG~WERKS
MSEG~LGORT
MSEG~CHARG
MSEG~LIFNR
MSEG~KUNNR
MSEG~SHKZG
MSEG~WAERS
MSEG~BWTAR
MSEG~MEINS
MSEG~ERFME
MSEG~KOSTL
MSEG~AUFNR
MSEG~GJAHR
MSEG~UMMAT
MSEG~UMWRK
MSEG~UMLGO
MSEG~UMCHA
MSEG~KZZUG
MSEG~BUKRS
MSEG~SMBLN
MSEG~SMBLP
MSEG~SJAHR
MSEG~GRUND
MSEG~UMMAB
MSEG~DMBTR
MSEG~BNBTR
MSEG~MENGE
MSEG~ERFMG
MSEG~PBAMG
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.
Hi,
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
Fernando
I would also to recommend to load the tables first into QlikView and do the join after this.