Home > Default > Problem to extract data using DS 2LIS_11_VAHDR & 2LIS_11_VAITM

Problem to extract data using DS 2LIS_11_VAHDR & 2LIS_11_VAITM

November 30Hits:0
Advertisement
Hello Experts,
my requirement is to extract the SD sales Item & sales header data int BI.  while executing the Reports in BI  I find some incosistencies in data
Ex:  for for some Sales organizations  
      0CRM_NUMDOC = 17 and the corresponding   0NETVALORD = 0,00  
and for some sales organization
     0CRM_NUMDOC = 0 and the corresponding   0NETVALORD = 5200,00  
we are using  the data sopurce 2LIS_11_VAHDR to load Document header data  and the data sopurce 2LIS_11_VAITM to get  Item Net value data. and used two trtansformations to the same SAP standard cubes 0CSAL_C05 & 0CSAL_C03.
asper  my analysis in development system I find 
       VBAK contains  1405 records but the DS 2LIS_11_VAHDR extracts only 1235 records.
but
       VBAP conains   2665  records and the DS 2LIS_11_VAITM extracts all 2665  records.
is it creats the problem?
I deleted the setuptables and again fill them  even thought I have the same problem ?
If you have any idea regarding this issue please share with me.
Thanks in advance.
cheers.............

Answers

HI,
Check indeed the extraction in your source system with RSA3.
Also perform the load and check your data in PSA (before any transformation takes place).
Are you going to use delta or full loading? I assume it's delta? So if you perform your initial load with data, no use of the setup table is required...
If you have too much data to do this, try an initial load without data, first delta load and next a full repair load (which will read your setup table). Do not forget to fill your setup table with all the historical data you need in transaction SBIW.
Hope this helps.
Best Regards,
Michel Hoefkens

Read other 3 answers

Tags:

Related Articles

  • Problem to extract data using DS 2LIS_11_VAHDR & 2LIS_11_VAITMNovember 30

    Hello Experts, my requirement is to extract the SD sales Item & sales header data int BI.  while executing the Reports in BI  I find some incosistencies in data Ex:  for for some Sales organizations         0CRM_NUMDOC = 17 and the corresponding   0N

  • Problem in extracting dataNovember 30

    Hi All i am getting problem while extracting data. XML is . <po:PurchaseOrder xmlns:po="http://www.oracle.com/PO.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.oracle.com/PO.xsd http:/

  • Problem with extract data from R/3 to BWOctober 11

    I want extract data from R/3 system.the problem is when I run the infopackage,I can see the status is yellow In the Monitor and the data can't extract to BW.but in the source system,the job of extracting data has been finished. (use the Tcode: WE02)t

  • I have a problem to  extract data from oracle dump file (.dmp) using oracle database or any other tools.October 11

    There is IMP utility which provides me data as graphical way. But i need extract data in such a way so that i could able to use in my application. thanks, mohanHi, EdStevens Actually I was using SQL Developer. Sorry for the wrong define question. Now

  • Problem when extracting data from R/3 to BINovember 30

    Hi Experts, I am facing a strange problem. While i am extracting data from R/3 yo BI. One Infopackage is running successfully and i can see the data at Bi side. But while I am running another infopackage for another data source it is taking long time

  • Problems to extract data from 0HR_PY_1November 30

    Hi Experts, I'm using BW v.7 to extract data from standard data source 0HR_PY_1 of SAP-ECC, with delta update. When I try to extract the data job finishes with error (red status) and all data-packages have error message ABORT in customer routine 9998

  • Problems in extracting data from r/3November 30

    Hi Guys I am extracting data from r/3(QA) to BW(QA), into an ODS. Now, my previous load failed but i saw from RSMO that the load had more than 4 million records. I am scheduled the load again. And in monitor(RSMO) it says: (yellow symbol) 17:24:50 (

  • Problem in extracting data from source systemNovember 30

    HI    I am comparing source system and data in bW for a particular datasource.In this process in source system transaction RSA3 when i am trying to extract data its not showing the exact count.I couldnt able to understand the setting options like Dat

  • Problem in extracting data from Z totals table (special Ledger)October 11

    Hi Gurus, I am in a task of pulling in specific fields from the Z Totals Table of Special Purpose Ledger into the cube. We only need totals records and do not need line items. In SBIW, i have generated the transfer structure and datasource for totals

  • Problem in extracting data from another BW serverNovember 30

    Hello Experts I have two BW servers in landscape. One is used as stagins server and second server exctracts data form this server and is used as reporting server. I can see data in DSOs in stagins server, also checked export datasources in RSA3 in st

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.645 s.