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.
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.