Skip to Content
0
Dec 02, 2010 at 10:35 AM

Question about order inbound analysis

40 Views

Hi

R/3: Relase 7.01 - Level 6

BW: Release 7.01 - Level 6

We create in R/3 in SD Module via VA01 Orders and load them with Delta Queue 2LIS_11... into BW.

We want to show in BW the effective order inbound quantity of the positions - that means if we create an order in January with one positions with quantity 60 and value 600 then we receive in 2LIS_11_VAITM this information and we can report it.

If someone change the quantity in February from 60 to 40 then we receive in the Delta Queue 2LIS_11_VAITM 2 Records:

One with Quantity -60 and Value -600

One with Quantity +40 and Value +400

This means we have in February an order inbound of quantity -40 and value -400.

This is what we want and this would work so fare, because we want to show the effective order inbound for a specific time period - and if per month then we have to show in January order inbound of quantity 60 and in February quantity of -20.

For the year the total order inbound would be 40.

The only problem is that if we have to reload (Initialload) of the 2LIS_11 Datasources then we loose this information (changes of positions) - we only receive one record for January with Quantity 40 and Value 400.

Loading the data via CO/PA is not possible, because this specific positiions type don't create a CO receipt.

So does anybody have an idea / solution how I can Initialload the SD data and receive the details (changes) in the initialload?

Thank you very much

Roger