1 Reply Latest reply: Dec 21, 2013 4:01 AM by Yaniv Feldman RSS

    BKPF and BSEG

      How extract data from BSEG with Connector 5.8 with filter on date in field CPUDT from BKPF ? With this Connector i have Error if i use JOIN or Subquery (((

        • Re: BKPF and BSEG
          Yaniv Feldman

          Hi Kirill

           

          You need to use: SUBSELECT in order to do the extraction.

          Here is an example from the Reference Manual of SAP Connector 5.8:

           

          SQL SUBSELECT BUKRS BELNR GJAHR BUZEI BUZID AUGDT

                  FROM BSEG

                   WHERE BUKRS BELNR GJAHR IN

                                ( SELECT BUKRS BELNR GJAHR FROM BKPF WHERE BLDAT GE '20070101' );

           

           

          Yaniv