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

Delta extraction from FI module in R/3

Hello,

Could you please tell me how the delta records are updated in BI in the case of extraction from FI? I understand that RSA7 is not updated with the delta records as in the case of LO extraction. How can the delta records be validated on the BI side? BWFI_TIMEST and BWFI_AEDAT would only give the time stamps of change in documents. Can RSA3 be used to validate the records? Please help!!

Thank you.

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 11, 2012 at 04:28 PM

    Hi Nick,

    Have you actually checked/confirmed this? I just had a quick look in RSA7 and can see all the records for the FI extractors we use ie 0FI_GL_X, 0FI_AR_X, 0FI_AP_X....

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Nick,

      I think the help you referenced actually answers this a bit further down;

      Recording Changed Line Items

      In the case of Financial Accounting line items that have been changed since the last data request in the SAP R/3 system, there is no reliable time stamp that can document the time of the last change. For this reason, all line items that are changed in a way relevant for BW must be logged in the SAP R/3 system. Changed line items, together with the document key and the time of the last change are recorded in table BWFI_AEDAT.

      Field Name

      Key

      Description

      MANDT

      X

      Client

      BUKRS

      X

      Company Code

      BELNR

      X

      Accounting document number

      GJAHR

      X

      Fiscal year

      AEDAT

      Date of last document change

      AETIM

      Time of last document change

      Example

      MANDT

      BUKRS

      BELNR

      GJAHR

      AEDAT

      AETIM

      600

      1000

      1900000010

      2001

      21 Feb. 2001

      10:23:17

      600

      1000

      1000000016

      2001

      21 Feb. 2001

      10:28:34

      Using the log table and the time stamp procedure described above, the extractors can find a delta dataset from changed Financial Accounting line items.

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.