Skip to Content
0
Former Member
May 20, 2010 at 03:04 PM

Problem with ODS overwrite

48 Views

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