Overwriting of all records in DSO for records with ROCANCEL = 'X'
We have implemented a custom flow from 2LIS_03_BF to DSO.
Transformation includes all the necessary field mapping in the standard rule group and ROCANCEL is mapped to 0RECORDMODE in technical rule group.
During the load from PSA we observed that all the fields(Apart from Key fields) are being blanked out in DSO for the record with ROCANCEL = 'X' even though the fields contain value in PSA.
For record with ROCANCEL = ' ' the field values are being populated fine in DSO.
Can any one please help in understanding the reason behind this behaviour.
Thanks in advance!!!!
Based on SAP NOTE 581778
ROCANCEL should not be mapped in 0recordmode.
In transformation there is a rule called technical rule where you will see the mapping of 0recordmode.
Remove the mapping and reload the cube using full load with filter of X in ROCANCEL.
Hope it helps.