CRM Extractor issue 0CRM_SRV_IBASE_ATTR

[Former Member]

Hello,

This is a production issue.

CRM system has the installed bases created and extracted to BW and reporting is fine.

When there is a change to these installed bases such as

* serial number is changed AND/OR

* material number is changed

the delta still brings in the complete hierarchy 'After Image' only.

Meaning old material number and old serial number still remains in the BW cube and hence reporting is faulty.

Example.

In Ibase 30, Material 500085 with Qty 1, is overwritten/changed in CRM as Material 600088. (This is seen in Activity log in CRM correctly).

The extractor sends whole Ibase content as one row for Component header and one row for Material 600088 details(as seen in PSA).

However material 500085 row is still valid in BW as the validto is 12/31/9999.

So BW reports qty as 2 instead of 1.

I see the extractor delta process is AIM.

So this should have been an ongoing issue. However user complained only now.

How to solve this problem. Since this is a generic extractor others would also face this situation i would think.

Please advise.

Thanks

[Former Member]

Hi Meenakshi,

Do you have a DSO in between PSA and Cube in your data model?

Can you check how the entries are behaving in DSO?

Thanks

Amit

[Former Member]

One more thing, if you are using DSO please ensure that it is in overwrite mode.

I think its not in overwrite mode and hence you end up in having multiple entries.

Thanks

Amit

[Former Member]

Hi Amit,

Same scenario in DSO as well.

Thanks

[Former Member]

Hi Amit,

DSO is in overwrite mode only.

The previously existing material is not overwritten, and No deletion image passed from source.

So it just stays undisturbed.

Thanks

[Former Member]

Hi Meenakshi,

In you DSO can you able to see two records for Ibase(Coz two materials).If not add the material into key fields,Besides you require two materials for reporting right? and in dtp mention load the records form changelog table not from active data table.

Regards,

Rambabu

[Former Member]

Hi Rambabu,

No material can't be a key field.

Its a 3X one, so its using update rules. I dont see similar option there to load from change log.

Please advise.

Thanks

[Former Member]

Hi Meenakshi,

As i understand you had two issues 1. with the new material 2.with qty.I hope the modified record is not coming to DSO.Some part of the code in the start routine is blocking the record.Please analyze the code in start routine.And check the change log table for this record for any clue how it is not being overwritten.

Regards,

Rambabu