Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Join on SAP table in qlikview

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.

2 Replies
fkeuroglian
Partner - Master
Partner - Master

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

Not applicable
Author

I would also to recommend to load the tables first into QlikView and do the join after this.