Hi,
When i load the data from R/3 to BI for Data Source: 2lis_13_vditm,the values are not matching, when i have done drill down approach in BI System, I observed few billing document are missing in the DSO.So i deleted the data in the DSO and also the setup tables, Reloaded the data to BI by filling up the Setup tables inR/3 but still the same. The net value is not matching with R/3 values and also few billing doc are missing.
Data Target: SO (Business Content)
Data Source: 2lis_13_vditm
Properties of DSO are
Key fields: BILLING DOCUMENT, Billing Item and Fiscal year
Data fields: Net value Update mode is ADDITION in Update rule
Checked in VBRPand VBRK table to whether they maintained any -ve values but the value are in +ve sign for Net value fields. Can you please suggest.
Thanks,
Sanjeev