14 Replies Latest reply: Jul 14, 2015 11:00 AM by Roberto Medellin RSS

    SAP Connector: Fetching data from BKPF and BSEG using JOIN

    Jesper Bagge

      Hi,

      I noticed today that the usual JOIN statement doen't seem to work when calling the tables BKPF and BSEG.

      The following SQL Statement

       


      SQL Select
      BKPF~BELNR,
      BKPF~BUDAT,
      BKPF~GJAHR,
      BKPF~BUKRS,
      BSEG~SHKZG,
      BSEG~HKONT,
      BSEG~BUZEI,
      BSEG~DMBTR
      from BKPF JOIN BSEG ON BKPF~BELNR = BSEG~BELNR AND BKPF~GJAHR = BSEG~GJAHR AND BKPF~BUKRS = BSEG~BUKRS
      ;


      returns an error.

      Im using version 5.0.6526.0 of the SAP Connector.

      Using the same logic when fetching data from other tables work fine. It seems to only be when i call the tables BKPF and BSEG.

      Any thoughts on why I get an error? Bug perhaps?