Delta on VBPA in SAP BW

[venkat_korivi]

Dear Users,

We have a requirement on VBPA table to be extracted the VBELN, POSNR, ADRNR, KUNNR and PARVW.

We dont have any date fields on VBPA table.But We have huge amount of data in VBPA.So we are about to thinking enabling delta.could you please let me know how to maintain delta for mentioned fields.

Thanks.

Venkat

[former_member259349 · Accepted solution]

Hi Venkat,

Can you check the tables CDHDR/CDPOS? These are the change logs tables - they are pretty huge though, and will still take some time to extract from.

Try to change the partner functions of the sales document, and check if an entry is created here:

Please use the following parameters:

CDPOS-OBJECTCLASS = 'VERKBELEG'

CDPOS-OBJECTID = Sales Document number (Be sure to include the leading zeroes, and then an asterisk at the end, in case data is maintained at the line item level)

CDPOS-TABNAME = 'VBPA'

If you can find an entry for this, you may need to create a new datasource based on this table (with the correct filters, of course) and then read the any other needed data from VBPA. This could either be a custom function module-based extractor/datasource, or possibly a generic view/table-based data source + user exit.

Please note though that in any case, the speed may not be very efficient due to the nature of the source tables (large amount of data).

If you cannot find an entry for this in CDHDR/CDPOS, then you may need to have some additional development. Possibly a user exit when saving the sales document (partner functions) that would update some separate custom table which would be the basis for extraction.

Thanks.

Regards,

Lorenzo