Generic delta field not working

[Former Member]

Hi guys we have a ztable from which we are extracting data using generic extraction.There is an ID field which is set as a numeric pointer delta field.In the first run all the data from the table is extracted by initiating deltas.Now when we are requesting delta records,all the records are coming(including new and modified records).I have checked RSA7 for the position of delta pointer,it is showing fine.We have tested many times, every time all the records are being extracted.

We haven't set any safety upper or lower limits.

please suggest me how to extract only new or modified delta records.

Regards

Sattee.

[Former Member · Accepted solution]

Hi,

May be the obsolete change pointers are not deleted periodically.

Go to Tcode BD22 and execute the change pointer deletion. You can see the message type for the Ztable in the standard table BDCP2

Also check:

http://help.sap.com/saphelp_nw70/helpdata/en/12/83e03c19758e71e10000000a114084/content.htm

[Former Member]

Hi,

This has happened because the PSA was not cleared before the delta loads.(right click on the data source and click manage, you can check teh req which are still there in the PSA)

Add the Delete PSA step in the process chain before the infopackage is started.

Also, delete the enitre data and do a new init and run a full repair.

This should solve your problem.

Regards,

Rahul

[Former Member]

hi,

in BI7.0 flow first delete the PSA and then load the new delta.

regards,

Arvind.

[former_member222556]

Hi,

-->First Check the field on which delta is applied is proper or not

-->apply safty interval (Upper limit ) as 1

then

-->delete the init pointer

-->initialize without data transfer

-->rapaifull load

-->check the delta

Best Regards

Obaid