Skip to Content
0
Former Member
Mar 25, 2009 at 04:06 AM

Problem while extracting data from 2LIS_11_VAITM

116 Views

Hi All

I am extracting data in to an ODS from a standard data source 2LIS_11_VAITM..i am extracting fields like sales document number(VBELN),customer(KUNNR),material(MATNR) and a key figure object Order quantity(KWMENG)..i am facing 2 problems while extracting this..

1.There are records in data source with this combination of characteristics is having order quantity as 1 positive figure and an equivalent negative figure..and when is go and check in the table VBAP from the document number..the document entry is not found in any of the sales tables..but the document numbers which is picking only positive values those document numbers were found in the table..

2. When it is transfrred to the ODS all the positive values are becoming negative for the key figure order quantity..i checked in the change and the active table..both the tables are having -ve values...

can any one tell me as to how i have to resolve this problem

Thanks in advance..

Rgds

Shilpa