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

[ram_makkena]

Hi Venkat,

I am also having the same issue. Could you please let me know how you solved it?

Ram M

[venkat_korivi]

Hi All,

Thanks for the reply and it was resolved.

Thanks,

Venkat

[former_member210445]

Hi Venkat,

So you are talking about data in SAP BW or the data is still in ECC? If you already replicated the data in SAP BW then you can use the "Zero Downtime concept".

You can create a "time stamp" (inti with no data transfer) and then followed by the delta and full loads. This will create a timestamp in the ECC system and your data will be in the queue.

Regards,

Venkata K