Skip to Content
avatar image
Former Member

Delta on VBPA in SAP BW

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Dec 01, 2016 at 02:25 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 11, 2016 at 06:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 27, 2017 at 06:04 AM

    Hi All,

    Thanks for the reply and it was resolved.

    Thanks,

    Venkat

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2017 at 11:11 AM

    Hi Venkat,

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

    Ram M

    Add comment
    10|10000 characters needed characters exceeded