Skip to Content
0

BSAD Delta Logic

Feb 18 at 06:04 AM

50

avatar image
Former Member

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).

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers