on 12-17-2008 9:50 AM
Hi SAP-Professionals!
there is a kind of phenomenom regarding the keyfigure 0DLV_QTY of 2LIS_11_V_SCL: In our cube, there are only values for the current deliveries. All the former deliveries have been "cancelled", this is, there a negated records in the cube, neutralizing the former delivery information (the deliveries were not cancelled!).
My customer complains that he cannot do any analysis about past deliveries.
Is this the normal way the business content extractor works and is there a workaround for that?
Thanks a lot in advance,
Stefan
Hi
check the Extract structure whether you have enabled the Inversion check box for the relevant field.
Hope it helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Aduri,
thanks for your hint. I now know that the "problem" lies within the overall process of how SAP handles schedule lines which already have been delivered. They are deleted in VBEP shortly after being processed! Consequently, the extractor creates an item with negated keyfigures to delete the according line in the cube as well.
Regarding your hint, the Inversion checkbox IS checked for the relevant keyfigure.
I now wonder if there is a way set a flag to be able to filter the cancellation items if required.
Maybe you have an idea?
Regards,
Stefan
Thanks Aduri, I had a look in the query but I think I'll have to modify the datamodel. The idea is to add a flag characteristic that has to be flagged when
1) stornoflag is set
2) another characteristic (TODO!!) has a certain value which uniquely marks a cancellation which was done just because the original schedule line has been processed
a first idea of this additional characteristic may be if the goods issue date-field of a cancelled record contains a date in the past. This should imply that there was a real goods issue, so the cancellation only was done because the original record has been deleted in VBEP.
What about this approach using the goods issue field?
Regards,
Stefan
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.