How can i create a generic delta from VBPA( a table without a time stamp).

[Former Member]

Hi ALL,

How can i create a generic delta from VBPA( a table without a time stamp). We have joined VBPA with VBAP to get the ERDAT and AEDAT, but we couldn't find a way to use the generic delta, since in a delta you want to capture both created documents and changed documents since the last delta.

[Former Member · Accepted solution]

I think you can do two things. The first one is to use 2lis11_vaitm datasource which extracts vbap and manage deltas in LBWE. If this datasource haven't your fields you can enhance the datasource to include them.

Other option is to chec CDHDR table. This table is a log with the modifications, Check in this table if the changes in VBPA are stored and you can create a view with this table.

I hope it helps.

[Former Member · Accepted solution]

If i am going for the second option then what will be the keys for the join.

Anpther option that i thought is joining VBPA with LIKP and getting the creation date and change date from LIKP. Any comments

[Former Member]

Hi,

refer to the below How to document:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/10b68b99-022e-2a10-999d-c4dc9ec2...

Assign points if useful

Regards

Venkata Devaraj