2LIS_11_V_SCL "cancels" all former delivery amounts - workaround?

[Former Member]

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

[Former Member]

Hi

check the Extract structure whether you have enabled the Inversion check box for the relevant field.

Hope it helps.

[Former Member]

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

[Former Member]

Hi

1. Check if you can filter the same at Info Package -- Selection tab

2. you can Hide the - values at the report level in the querykfdisplay tab

3. Query display tab you can even reverse the +/- values. too

Hope it helps

[Former Member]

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

[Former Member]

Hi

But Goods Issue Date field also to be needed I guess in your case.

[Former Member]

Sorry Aduri, I didn't get your point. What did you want to tell me about the goods issue date field? Did you want to say that you agree with me?

Stefan