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