11 Replies Latest reply: Feb 15, 2018 9:12 AM by Settu Periyasasamy RSS

    BSID - BSAD Delta Logic

    Settu Periyasasamy

      Hi All,

      Could anyone provide the SAP 'BSAD' table incremental load logic?

      Implemented the below logic but with one issue.  if the Document is moved from BSAD to BSID (Open items), it is still there in BSAD.

       

      BSAD:

      LOAD 

      *

      , BUKRS & GJAHR & BELNR & BUZEI as Documentitem;


      SELECT * FROM BSAD WHERE AUGBL IN

      ( SELECT BELNR FROM BSAD WHERE CPUDT >= '$(vLastChangeDate_num)' );

      concatenate (BSAD)


      LOAD *
      from BSAD.qvd (qvd)
      where not exists(Documentitem);