Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Honored Contributor

Re: Join on SAP table in qlikview

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

Re: Join on SAP table in qlikview

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

Community Browser