Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Sap Join in Qlikview

Hello ,

I am trying to do a join on a sap query. It looks like this:

SQL Select EKPO.UMREZ EKPO.STATUS EKPO.MATNR EKPO.AEDAT EKPO.KUNNR EKPO.BUKRS EKPO.WERKS EKPO.ADRNR EKPO.MATKL EKPO.EBELN EKPO.EBELP from EKPO JOIN EKKO ON EKPO.EBELN = EKKO.EBELN WHERE EKKO.AEDAT = '20090717';

But the result is a SQL_ERROR

What am i doing wrong?

1 Solution

Accepted Solutions
Partner
Partner

You have 2 options:

1. Create a "Z" view in SAP joining these 2 tables and pulling data from that view, or

2. Pull EKKO and EKPO separately and join them in QV.

You will not be able to pull from SAP using join query.

View solution in original post

2 Replies
Partner
Partner

You have 2 options:

1. Create a "Z" view in SAP joining these 2 tables and pulling data from that view, or

2. Pull EKKO and EKPO separately and join them in QV.

You will not be able to pull from SAP using join query.

View solution in original post

Contributor III
Contributor III

Thanks for your reply,

I am going for option 2

Query 1:

load

..

..;

SQL Select UMREZ STATUS MATNR KUNNR BUKRS WERKS ADRNR MATKL EBELN EBELP from EKPO WHERE EBELN IN ( SELECT EBELN FROM EKKO where AEDAT => '20090701' and AEDAT <= '20090799' )

inner

load

..

..;

SQL Select AEDAT EBELN from EKKO where AEDAT => '20090701' and AEDAT <= '20090799' ;