Problem with Data Transfer Process

[Former Member]

Hi,

I am extracting my field values from an ECC source system and then passing the value to the bw system via infopackage.

For e.g. Value of Field A = 10 for transaction ID 001. Extracted using delta ( at infopackage level), the value becomes -11 but when extracted using full the value remains as 10 which is correct.

My question is why the delta is retrieving this weird -11 value?

Let me know if you require any further details.

Thank you very much in advance for your time and efford!

Kind regards,

Rebekah

[timkorba · Accepted solution]

If this is a delta, then the extractor is probably receiving some reversal records (before and after image).  I would ask the following questions:

• Has this record been deleted in the source system?  It may show 11 but really the duration was reversed and is now 0?
• Is there another record in the PSA that is the after image?
• What does the record look like after you load into the DSO?
• Does the transformation for this key figure set to summation?  This may be simply answered if there isn't an InfoCube.

In many cases there will be a before and after image for the delta record being sent across the system.  This may be any field within the original field was changed.

Hope this helps.

[Former Member · Accepted solution]

Hi Tim,

My reply to your questions:

• No the record was not deleted in the source system. It works well for the full load at PSA. Only the delta is sending out negative values.
• No there are no old records.
• The error is at the PSA level. So the values remain negative when I load it to the DSO as well.
• There is an infocube.

How do i check the before and after image?

Please advice.

Thank you!

[Mohamed_Shadab_Shaikh · Accepted solution]

Hi Sunil,

     Please check in rsa2, for the delta process in delta extraction. You can check if its before and after image.

[Former Member · Accepted solution]

Hi,

I've checked RSA2 and the delta process is AIMD After-Images with Deletion Flag Via Delta Queue (e.g. BtB).

Is this the correct setting or this has to be changed?

Other options are as below:

Please advice.

Thank you!

[pradip_nikam2 · Accepted solution]

This is standard Datasource and its working fine by looking @ extracted data. You just need to bring stnadrad DSO as first staing after PSA to get correct records in the target cube or in the reports.

Regards,

Pradip

[Former Member · Accepted solution]

Hi,

Is there a way to do a delta load at the source system (CRM)?

Please advice.

Thank you!

[RamanKorrapati · Accepted solution]

Hi ,

At crm side, based on record combination data, you need to cross check.

Take the bw record combination and cross verify at crm source tables.

you need to find the records which are changed/created in particular time/date.

As per the delta settings newly created/changed records will send to CRM T code - RSA7. Later thru delta info pack we pull them int PSA/BW.

Thanks