Check how unique records are identified in the data.
check the keys in the ECC table and put the same keys in the DSO if possible
1) Check if you have any Routine writeen to remove the data...
2) Check the DTP restrictions
Hi Imran,
Check if any code is written in START Routine or End routine to delete the number of records. You can even check if any DTP filters are there.
When you are loading data to DSO you need to check what is the DSO key fields as sometime the data gets overwritten.
Another check you can do is, before activation and after data load just check how many records are loaded in New Data table?
Regards,
Durgesh.
Hi Imran,
It is beacuse of the definition of key in DSO. Pls check the key and test it.
Thanks,
Murthy
Hi All,
The Key fields in R/3 table are
MANDT
OPBEL
OPUPK
OPUPW
OPUPZ
RPNUM
Do you mean to say that the same key fields have to be added in key fields(sans MANDT) in the DSO as I have only put OPBEL n RPNUM.?
Will this result in data to be read in the correct manner? Your answer shall be a learning to me as I am not aware of this fact.
Also I have created a cube for test purpose and it has read complete data, why did this happen in comparison to the DSO.
rgds
Imran
Hi Imran,
Yes, You can set the new key for DSO as OPBEL OPUPK OPUPW OPUPZ RPNUM as key fields and load data. it works fine now.
Answer to your second question: DSO loads are based on the key of the DSO while Infocube it works on Dimensions and KFs based on additive property of KFs for the same set of Dimensions.
Hope it clears..
Murthy
Resolved...
Thank you all for the guidance.
Really appreciate quick response from you all.
rgds
Imran
