Problem with Extraction

[Former Member]

hello Guru's

i have enchanced two feilds to two data sources and checked the data at rsa3(extract checker).

0fi_gl_10 is the datasource build on FAGLFLEXT table. i see the difference in the data at the extract checker and data base table (FAGLFLEXT). I FIND MORE RECORDS ARE EXTRACTED FROM TABLE. HOW COME IT IS POSSIBLE

SAME IS WITH 0CO_OM_CCA_9 DATASOURCE AS WELL WITH CORRESPONDING TABLES COSS AND COSP.

CAN ANY ONE PLZ HELP ME WHAT IS HAPPENING BACKGROUND WHY EXTRACT STRUCTURE IS EXTRACTING MUCH MORE RECORDS THAN WHAT DATA THEY HAVE IN DATA BASE TABLES.

Thanks

RAD

[Former Member]

Hi Rad

The datasources in FI extract data for different currency types.

For example, currency type 10, 20 and 30 where 10 could be document currency, 20 could be company code currency and 30 could be group currency.

Each of these currency types result in one row. This could be one of the answers for multiple records. Check and let us know.

Please award points if you find this useful.

Regards

Prakash

[Former Member]

hi Subray Hegde

CAN YOU EXPAIN 0FI_GL_10(FAGL_EXTSTRUCT_LEAD) EXTRACTOR IS BASED ON HOW MANY TABLES. CAN WE KNOW WHAT ARE THE TABLES RELATED TO THAT PARTICULAR EXTRACTOR.

Thanks

RAD

[Former Member]

Hi Rad,

The best way for you to know that is an SQL trace (ST05). Activate the trace for your id and in another sap window, run this extractor in RSA3. Display the trace and see what were the FI tables that this extractor hits. Hope this helps.

Thanks and Regards

Subray Hegde

[Former Member]

hello Subray Hegde

Thankyou for your reply. i haen't written any code for populating data to the feilds. this is the standard one and the feilds are available in the database table. i have checked the the table it shows only 180 records but in the extract checker it shows thousands of records.

can you plz through ligth on this

Thanks

RAD

[Former Member]

Hi Rad,

Did you write any code in the user exit to populate the data? If you have written any code, you are controlling the data selection so, you might need to look into your code. If it is standard, please check the table from where it is extracting the data. You might be thinking it is extracting data from one table but the extractor might be looking at a different table. Hope this helps.

Thanks and Regards

Subray Hegde