Problem in Data extraction for NEW GL DSO 0FIGL_O10

35 Views

Hello all.,

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
10 2011000 K4 370,831.44 370,831.44 370,831.44 100 P01101 101
10 2011001 K4 370,831.44 0 0 100 P01201 101
10 2011000 K4 801,114.74 801,114.74 801,114.74 100 P01201 101
10 2011001 K4 801,114.74 0 0 100 P06101 101
10 2011000 K4 0 0 0 100 P01101 101 101 10 2011000 K4 287,155.77 287,155.77 287,155.77 100 P01101 101 101 10 2011001 K4 287,155.77 0 0 100 P01101 101 101 10 2011000 K4 0 0 0 100 P01101 101 101 10 2011001 K4 0 0 0 100 P01101 101 101 10 2011002 K4 0 0 0 100 P01101 101 101 10 2011003 K4 0 0 0 100 P01101 101 101 10 2011004 K4 275,000.97 275,000.97 275,000.97 100 P01101 101 101 10 2011005 K4 275,000.97 0 0

100 P01101 101 101 10 2011002 K4 1,317,945.68 1,317,945.68 1,317,945.68 100 P01101 101 101 10 2011003 K4 1,317,945.68 0 0

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
10 2011000 K4 370,831.44 370,831.44 370,831.44 100 P01101 101
10 2011001 K4 370,831.44 0 0 100 P01201 101
10 2011000 K4 801,114.74 801,114.74 801,114.74 100 P01201 101
10 2011001 K4 801,114.74 0 0 100 P06101 101
10 2011000 K4 0 0 0

100 P01101 101 101 10 2011002 K4 1,317,945.68 1,317,945.68 1,317,945.68 100 P01101 101 101 10 2011003 K4 1,317,945.68 0 0

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.

Regards,

Pavan