2 Replies Latest reply: Jul 22, 2009 5:30 PM by Pieter Boots RSS

    Sap Join in Qlikview

    Pieter Boots
    Pieter Boots Jul 22, 2009 4:11 PM

      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?

       

       

       

       

       

        • Sap Join in Qlikview
          Rakesh Mehta
          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
              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' ;