Skip to Content
avatar image
Former Member

BSAD Delta Logic

Hi All,

I'm not sure this is the right place to post.

Working on the 'Account Receivable' application in Qlikview.

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 my BSAD table (not in SAP table)

BSAD:

LOAD

*

, BUKRS & GJAHR & BELNR & BUZEI as Documentitem;

SELECT * FROM BSAD WHERE AUGBL IN

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

concatenate (BSAD)

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

This result of this report should exactly match with the SAP transaction 'FBL5n' based on the Keydate.

It is working fine, but some of the BELNR is available in both table (BSID and BSAD) (due to historical load).

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers