This content has been marked as final.
Show 2 replies
-
Sap Join in Qlikview
Rakesh Mehta Jul 22, 2009 5:10 PM (in response to Pieter Boots)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.
-
Sap Join in Qlikview
Pieter Boots Jul 22, 2009 5:30 PM (in response to Rakesh Mehta )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' ;
-