I need to compare the number of records between ECC tables and BW datasource. My requirement is my number of records between the Datasource and Cube is tallying. However, when my client is comparing the record number between the ECC tables and datasources; the number of records are not matching.
Please help me to explain them the logic behing this
IF you want to Reconcile Number of Records between ECC Tables & Datasources
ECC R/3 side > check the data source in RSA3 extract checker for number of records.
Data source BW side> Initial loading target, Check the no of records from recetly loaded request .
if you want compare within BW side use t.code > LISTCUBE to find out the number of records.
please check with this link
Edited by: Rambabu velanati on Jun 11, 2010 6:27 AM
My datasource 0FI_GL_20 is getting data from FAGLFLEXA according to help.sap.com.
However, when I check the number of entries in FAGLFLEXA, its showing around 65000 entries, whereas my datasource & cube have a matching figure of around 2,00,000
User needs an explanation for this...
Did you compare the number of records against FAGLFLEXT table? (Instead of FAGLFLEXA).
The DataSource 0FI_GL_20 provides the general ledger transaction figures from table FAGLFLEXT, according to sap.help see b below.
Edited by: Francisco Milan on Jun 11, 2010 1:26 AM
Sorry for the inconvenience.....
My Datasource is referring to FAGLFLEXT which has 65000 records....
Now when I checked FALFLEXA, it has around 1.25 lakhs.
Can somebody please help me with this????? This is very critical for me
Edited by: Sneha Santhanakrishnan on Jun 11, 2010 8:00 AM
To extract data from FAGFLEXA table you need to use the 3FI_GL_XX_SI DataSource, check the link below.
Edited by: Francisco Milan on Jun 11, 2010 1:49 PM