8 Replies Latest reply: May 6, 2013 8:51 AM by Amirali Vastani RSS

    SAP Join Syntax

    Amirali Vastani

      I am using the following syntax and it doesn't work

       

      Test:

      LOAD VBRK~VBELN, VBRP~WERKS;

      Sql Select VBRK~VBELN VBRP~WERKS

      FROM VBRK

      JOIN VBRP ON VBRK~VBELN = VBRP~VBELN

      WHERE VBRK~FKDAT = '2012-04-01';

       

      If I remove the Load statement it works fine. What am I missing here? How can we use the Preceding Load or is it that Preceding Loads are not possible in a join scenario when using SAP Connector.

        • Re: SAP Join Syntax
          Sokkorn Cheav

          Hi amirvas,

           

          amirvas wrote:


          If I remove the Load statement it works fine. What am I missing here? How can we use the Preceding Load or is it that Preceding Loads are not possible in a join scenario when using SAP Connector.

          Now let try

          LOAD VBRK~VBELN As F1, VBRP~WERKS As F2;

          Sql Select VBRK~VBELN VBRP~WERKS

          FROM VBRK

          JOIN VBRP ON VBRK~VBELN = VBRP~VBELN

          WHERE VBRK~FKDAT = '2012-04-01';

           

          Regards,

          Sokkorn