Skip to Content
author's profile photo Former Member
Former Member

Problem with Extraction

Posted on Aug 03, 2006 at 03:51 PM 13 Views

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

BW Content and Extractors
Add comment
10|10000 characters needed characters exceeded

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 05:14 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 06:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 08:31 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Aug 03, 2006 at 09:03 PM

      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

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 10:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded