on 04-05-2011 11:17 AM
Hi All,
Currently I have a data store created that allows me to load all data from 2LIS_02_ITM. This DSO only contains EBELN and EBELP. Therefore it will supposed to contains the number of records similiar to EKPO. Apparently some of the records are missing from the extraction. Anyone could tell me in what condition records will be deleted from this extractor?
Remarks: I do know that this data source will also contain goods receipt and invoice records, that's the reason why I am creating a DSO to just match the number of PO Line Item with EKPO in ECC.
Thanks
David Yee
First of all, what is the type of DSO that you are using - Standard or Write-Optimized?
If its a Write-optimized, it will load all possible records coming from the source - RECORDMODE: X, Blank, R etc.
But in Standard DSO, some records cancel out.
Did you compare the data in your PSA (2LIS_02_ITM) with that in RSA7 (I assume you are loading a Delta)?
If not, please compare.
Once you have done that & if you do not find any irregularities, check the code in update rule / transformation (as said above) and see if there is / are any filter(s).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
Thanks for the reply. I believe it has nothing to do with all the suggestions so far. As I noticed, while extracting data with RSA3 certain data seem to be missing even after filling the setup table again. Therefore even if I load it using write optimized DSO it won't come into BW.
I believe it was some kind of logic with sub-item. As certain PO Line Item contains sub-items or thing like that. Those that contain sub-items will not get extracted at all.
Thanks
David Yee
HI David ,
Check the start routine in the update rule /Transformation of 2LIS_02_ITM , I believe some invalid records will be deletd there in the standard flow
Regards,
Sathya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.