I am using the using 2Lis_11_VAITM for getting the order data. I am using the standard cube to 0SD_C03. Unfortunately I dont have a DSO layer in between and the DS is directly updating the cube.
I have a infosource in between the DS and the cube. My ROCANCEL is mapped to 0STORNO from DS to Communication structure.
However in the transformation between the infosource and the cube this in not mapped.
I would like to understand how we can capture the delta without the DSO.
I have few records coming in PSA with ROCANCEL indicator as 'X'. For all the records with ROCANCEL is 'X' the value is negative.
My requirement is if the item netvalue is 1000 and then if the item value is recuded due to rejection or cancellation I would want to capture that too.
If the Item is created with value 1000 in Jan and then due to cancellation its reduced to -500 in Feb I would like to see the net value as 1000 in Jan and -500 in Feb.
Currently I dont think this is happening . I can I use ROCANCEL to capture the rejections and cancellations.
Any help would be hihly appreciated and rewarded.