I am facing Problem in extraction of records from SAP to BW.
When I extract the Data from SAP R/3, to this DSO ( 0FIGL_O10 ) the reocrds are getting over written
For Example When I go the the Mange Option ( InfoProvider Administration) the transferred Records and the Added Records are not same. The Added records are less then the Transfered reocords.
This is happening may be becuase of Key Filed Definations.
I have 16 Characterisics in the KEY FIELD, including Profit center, GL account, bus. area, sender Business area(trdg Part). When I loading data from PSA to DSO, the records in RED color are overwritten by BLUE color records.
That is why, my Balance sheet report in BI is not matching with ECC report.
Data in PSA.Account Nu Profit Cen Business A Trdg part. Currency t Fiscal yea Fiscal yea Accumulate Total debi Sales of t 100 P01101 101
Data In DSO:ccount Nu Profit Cen Business A Trdg part. Currency t Fiscal yea Fiscal yea Accumulate Total debi Sales of t 100 P01101 101
I need RED color records also in DSO, so that i can load into cube for further analysis.
Please help me to solve this issue.