Hello,
I'm having a problem with the ODS overwrite.
Follow the scenary:
1 - Key fields for the ODS: 0COMP_CODE, 0ID_BUPLA, 0ID_DOCNUM, 0ID_ITMNUM.
2 - In the transformation, the aggreagtion for the objects 0QUANTITY and 0NET_VALUE is Overwrite.
3 - The data come from a Infoset to the ODS. The infoset is composed with 02 ODS.
The problem is that sometimes the overwrite does not work correctly.
Follow one example with some data that you have in the infoset:
0COMP_CODE 0ID_BUPLA 0ID_DOCNUM 0ID_ITMNUM 0MATERIAL 0QUANTITY 0NET_VALUE A000 A001 422715 10 10005 10 FD 118 BRL A000 A001 422715 10 10005 10 FD 118 BRL A000 A001 422715 20 10027 50 FD 716,79 BRL A000 A001 422715 20 10027 50 FD 716,79 BRL
For this case, the ODS will have this data:
0COMP_CODE 0ID_BUPLA 0ID_DOCNUM 0ID_ITMNUM 0MATERIAL 0QUANTITY 0NET_VALUE A000 A001 422715 10 10005 20 FD 236 BRL A000 A001 422715 20 10027 50 FD 716,79 BRL
Why in the first case the overwrite does not work correctly?
For me the 0QUANTITY have to take the value 10 and 0NET_VALUE 118, but the ODS is doing a summation instead of overwrite and in the second case the overwrite don't have any problems.
Have some one ever seen this problem?
Am I doing some thing wrong or there is some SAP notes for this?
Thanks for any help.
Best regards,
Paulo