cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with ODS overwrite

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (5)

Answers (5)

former_member188011
Active Contributor
0 Kudos

Hi Paulo:

In case you don't have the values 20 and 236 on any of the 2 DSOs that feed the Infoset then you are dealing with a program error and you need to file an OSS message to SAP.

Regards,

Francisco Milán.

Former Member
0 Kudos

Thanks everybody for all answers provide here.

I openned a OSS to SAP and when I got the solution I will post here.

Best regards,

Paulo

former_member188011
Active Contributor
0 Kudos

Hi Paulo:

Please take a look at this blog series provided by sunmit bhandari, they might help understand why you are getting your values multiplied by the InfoSet.

Infoset Keyfigure multiplicity Part 1

/people/sunmit.bhandari/blog/2009/04/14/infoset-keyfigure-multiplicity-part-1

Infoset Keyfigure multiplicity Part 2

/people/sunmit.bhandari/blog/2009/04/14/infoset-keyfigure-multiplicity-part-2

Infoset Keyfigure multiplicity Part 3

/people/sunmit.bhandari/blog/2009/04/14/infoset-keyfigure-multiplicity-part-3

Regards,

Francisco Milán.

P.S. I apologize for my previous recommendation to file an OSS message, it seems that wasn't neccesary at all.

Edited by: Francisco Milan on May 25, 2010 2:12 PM

rathy_moorthy2
Active Contributor
0 Kudos

Hi Paulo,

I still strongly feel u have the record with 20 and 236 values, which is getting overwritten.

Probably it is got to do with the infoset design. If u do a display on infoset data (display data or listcube transaction), u still see only these 2 records?

Beacuse in change log u get this record as a new record which overwrite on the 10 and 118 values, so it must be produced somewhere in the infoset process

Regards,

Rathy

Former Member
0 Kudos

Hello,

Sorry, but I don't have the values 20 and 236 in the display data of the infoset.

I have only 2 time the values 10 and 118 (1010 =20 and 118118=236) .

Follow some print sreens for you see the problem in my envirmoment:

http://www.sistemasguarani.com.br/download/ods_problem.doc

thanks and best regards,

Paulo

former_member188011
Active Contributor
0 Kudos

Hi Paulo:

Could you please provide more details?

1. How are the keys defined on the 2 DSOs that feed the InfoSet?

2. How are the 2 DSOs linked on the InfoSet definition?

3. How many records you get if you review the contents of each of the 2 DSOs filtering by 0COMP_CODE=A000, 0ID_BUPLA=A001, 0ID_DOCNUM=422715, 0ID_ITMNUM=10?

Regards,

Francisco Milán.

Former Member
0 Kudos

Do you have a semantic key in DTP?

former_member188011
Active Contributor
0 Kudos

Hi Paulo:

Could you please provide more details? How are the keys defined in the 2 DSOs that feed the InfoSet? How are the 2 DSOs linked on the InfoSet definition? How many records you get if you review the contents of each of the 2 DSOs using their own keys?

Review the data on your InfoSet by applying the following filters 0COMP_CODE=A000, 0ID_BUPLA=A001, 0ID_DOCNUM=422715, 0ID_ITMNUM=10

Probably you have more than 1 record with this key combination, and the record at the bottom has 0QUANTITY=20 FD and 0NET_VALUE= 236 BRL.

If this is the case you would be able to solve the problem by maintaining your key (for example by adding the 0MATERIAL).

Regards,

Francisco Milán.

Edited by: Francisco Milan on May 20, 2010 1:31 PM

Former Member
0 Kudos

Hello Francisco, thanks for your answer.

I have already tried this.

When I use this filter, I found only these value:


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

0ID_ITMNUM is the item from the doc number 0ID_DOCNUM than is impossible to have two diferentes materias for the same 0COMP_CODE, 0ID_BUPLA, 0ID_DOCNUM and 0ID_ITMNUM.

former_member188011
Active Contributor
0 Kudos

Hi Paulo:

Do you have Rotuines on your Transformation (Start Routine, Transformation Routine, etc.)?

Regards,

Francisco Milán.

Former Member
0 Kudos

Hello,

No, I don't have routines in my transformation. All the infoobjects is mapped with direct assignment.

Thank you.

Pravender
Active Contributor
0 Kudos

Please check how many entries you have in the change log table of DSO. It can give a better picture of whats going on.

Former Member
0 Kudos

Hello,

I don't have semantic key in my DTP.

Pravender there is 616182 entries in the Change Log of the DSO and 616100 in the Acitve Data.

Only one point, yesterday I delete all contents of DSO (shift + F2) and reload all the data again, but the problem persist.

Thanks for yours answers.

Pravender
Active Contributor
0 Kudos

Could you check change log entries for these key combinations:

0COMP_CODE 0ID_BUPLA 0ID_DOCNUM 0ID_ITMNUM

A000 A001 422715 10

Former Member
0 Kudos

Hello Pravender

In the change log using this filter I have the following values


REQUEST = ODSR_555VWWJ4G686TVTESMQ5W82DH
DATAPAKID =  11
RECORD = 7948
0COMP_CODE = A000
0ID_BUPLA = A001
0ID_DOCNUM = 422715
0ID_ITMNUM = 10
0MATERIAL = 000000000000010005
0QUANTITY = 20 FD
0NET_VALUE = 236 BRL

thanks

Paulo

Former Member
0 Kudos

Paulo, did you solved this problem?

Former Member
0 Kudos

No, not yet!

I have already clean all the data in the data target and source and reolad all but the problem still ocurring.

Thanks.

Former Member
0 Kudos

Hi ,

While deleting all the data from the DSO, did you also delete all the data from the change log.If not please do so, to get a clear picture.

-Vikram

Former Member
0 Kudos

Hello Vikram,

Yes, I have already deleted all the data in DSO (Active Data and Change Log).

thanks