Skip to Content

About FI Extractors Mechanism

Hi All,

Currently we are in SAP ECC 6.0.

I am using the FI data source 0FI_GL_10. As per the SAP note 1012874, the table BWFI_AEDA3 is the table which is holding the Change data Pointer details. As i checked in the System, there is no entry in this table. We have intilzed the delta one year back and we are pulling delta records to BW. And I can able to pull delta records many times in a day. As i am checing the TCODE SMQ1 and RSA7, i can see entry for the data source 0FI_GL_10.

My Queries :

1. What is a table, that stores time of data pulled for the data source 0FI_GL_10.

2. As i specified, I am running the infopackage multiple times in a day and getting records from ECC. Just want to know what is the background job running that moves the data to delta queue (RSA7)

3. As i checked in the production system, there are 2 crore records available in table BWFI_AEDAT. But there is no entry in RSA7. As i checked the table ROOSOURCE, the entry is there for data source 0FI_GL_4 with delivered version. Can you please let me know, is there any job needs to run to pick data from BWFI_AEDAT to RSA7.

4. For clearing the 2 crore records, will i do reinit for the data source 0FI_GL_3 from BW side ?

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 18, 2016 at 04:32 AM

    First of all ->>> BWFI_AEDA3: This table is FI log table for changed credit management data.

    1. What is a table, that stores time of data pulled for the data source 0FI_GL_10.

    BWOM2_TIMEST

    2. As i specified, I am running the infopackage multiple times in a day and getting records from ECC.

    Just want to know what is the background job running that moves the data to delta queue (RSA7)

    RSA7 will not hold any records, it holds only a simulation of what delta will come.Go to SM37 and see the job which triggered from BW ( it starts for BIREQU_* in ECC).

    3. As i checked in the production system, there are 2 crore records available in table BWFI_AEDAT. But there is no entry in RSA7. As i checked the table ROOSOURCE, the entry is there for data source 0FI_GL_4 with delivered version. Can you please let me know, is there any job needs to run to pick data from BWFI_AEDAT to RSA7.

    no job required.This table contains the list of document that have changed along with the date and time stamp. This table forms the basis for picking up records for delta extraction.

    4. For clearing the 2 crore records, will i do reinit for the data source 0FI_GL_3 from BW side ?

    No. Make sure you pull the delta first, then just adjust the new value for DELTIMEST in the table BWOM_SETTINGS for a data source decides for how long the data will be retained in this table.

    Regards,

    Sandeep

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.