Incorrect Value In master DATA

[Former Member]

Hi Everyone,

I am getting incorrect data for attribute "Standard Price" of 0MAT_PLANT Master Data. This issue is there only for single record of 0MAT_PLANT value.In PSA data is correct as it is matching with R3.

everyday there is  full load in 0MAT_PLANT,it as per business requirement.

Eg

provider level

Plant: ABCd

Standard Price : 40

PSA Level:

Plant: ABCd

Standard Price : 0.75

Note: here Standard Price is correct figure which i am getting.

Observations:

1. when i run dtp only for this record, i am getting correct Values.

2. In debugging of mode of DTP  i am too getting correct Value

Regards

Nadeem

[jayaprakash_subramanian · Accepted solution]

Hi Nadeem,

From your reply, I understood that, when you load single value, that record updated correctly.
But, when you load all the entries, You see, there's problem. Recently, I have resolved same kind of issue.

Details are given below :

Example :

When it's single record :

Material  -   Price 

MAT001 -   10

And the same is entered into Target correctly.

When, it's full load,

In PSA, We had entries as follows :

Customer  -   Price 

MAT001      -  10
MAT001-1  -   20

MAT001-2  -   30 ,

After transformation,

These values are converted as follows :  

Due to some issue in Transfer Routine (Some logic)

MAT001      -  10
MAT001      -   20

MAT001      -   30

So, Since the Key's are same, in Duplicate key check,
Last record was taken :

MAT001      -   30

We see, wrong price for MAT001.
----------------------------------------------------------

So the Suggestion is, in Info Package data selection,

Don't give the exact value for single record execution.

Give filter like,

MAT001* .

So that, Info Package will pull all the three entries and You can check the DTP for any duplicate message. Then, We can figure it out.

Assign points if this reply helps you.

Thanks,
Jay.

[Former Member]

Hi,

Include Plant and Standard Price in Semantic Groups and execute the DTP.

Let me know if there is any issue.

Regards,

PRK.

[timkorba]

is the transformation set up as summation possibly?

[sat_p2]

Hi Nadeem,

Please try to check mapping and also please try to check the currency type is it fixed or its get populated through code. that might be changing the values after loading the data to target.

Please give points if you are ok with my message.

Regards,

satya.

[sat_p2]

Hi one more comment in my previous post...since your are loading full load, Please try to delete PSA and try to pull data to matplant.

2.If you are loading only one source please try to delete entire data and try to load full load again.

3.If same issue happing in Quality system if happing in Quality system please try to test in Q.

Regards,

satya.

[yasemin_kilinc]

Hi Nadeem,

Maybe there is problem with unit or currency conversions. Check the key figure you used in master data. What is the currency type, is it set fixed, what comes in psa...

Hope it gives an idea

Regards

Yasemin..

[RafkeMagic]

is your mapping correct?

do you have any "manipulations" for "standard price" in your transformation?

[Former Member]

It is Direct Assignment.

[RamanKorrapati]

at target what value your getting for 0.75(at PSA)?

For every time you got the wrong value for one record?