on 11-02-2015 10:39 AM
Hi All,
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!!!!
Regards,
Saurabh
Hi Saurabh,
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.
Regards,
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Saurabh
You should check the validity of the data available in the base tables. If you are in development system, this might be right. So please transport the changes to quality system and check the data.
More information of 0recordmode and rocancel.
0RECORDMODE is a predefined characteristic which is responsible to load data into target.
Below are explanation for the different values.
AFTER IMAGE - " " :How is the data after the change
BEFORE IMAGE - "X":How was the record before change
ADDITIVE IMAGE - "A": Show only the difference for all numeric values
NEW IMAGE - "N": For each change that is made, a new unique record is generated.
DELETE - "D" : Only provide the key information required to make deletion.
REVERSE - "R": This will be same as after image with reverse sign
Below link also gives you a clear explanation on how this behaves with proper example.
Hope this helps. Please let us know if you need any more information.
Regards
Karthik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Saurabh,
Alternatively you can also try with the following piece of code in your start routine -
BEGIN******************************
LOOP AT DATA_PACKAGE.
if DATA_PACKAGE-recordmode eq 'X'.
DATA_PACKAGE-recordmode = ''.
modify DATA_PACKAGE.
endif.
endloop.
END********************************
Hope it helps.
Regards,
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kumar,
Please share the error screen shot.
regards
sathya.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.