cancel
Showing results for 
Search instead for 
Did you mean: 

2LIS_02_ITM records not matching with EKPO

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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).

Former Member
0 Kudos

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

Former Member
0 Kudos

Can you explain what you mean by 'Sub-Item of a PO Line Item'?

I have never come across this.

sathiendiran_balu
Contributor
0 Kudos

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