topic Join on SAP table in qlikview in QlikView

Join on SAP table in qlikview

Mon, 26 Jan 2026 21:26:37 GMT

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.

Re: Join on SAP table in qlikview

fkeuroglian — Sat, 22 Mar 2014 22:02:30 GMT

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

Re: Join on SAP table in qlikview

Tue, 25 Mar 2014 08:16:43 GMT

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