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 comment
10|10000 characters needed characters exceeded

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 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.