I need ur guidance on an immediate issue that I am facing.
I created a z extractor with delta taken on OPBEL. RSA3 shows complete extraction of number of records.
When in BW data load on info-package also shows complete data being loaded in PSA. Mind you update option is selected to full upload.
However when I goto manage and check for a DSO, it only shows half the number of records have been uploaded. Active data also shows incomplete upload.
I have refreshed the data many times, but still cant get complete data to get uploaded.
Please suggest what am I missing here
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?
The Key fields in R/3 table are
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.
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..