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

0FI_AP_4 / 0FI_AR_4 delta is not picking newly created documents

Posted on Jan 10, 2007 at 03:57 AM 230 Views

Hi,

In delta loads of datasources 0FI_AP_4 and 0FI_AR_4, the newly created documents are not getting picked up. But the changed documents are coming in. This is both is RSA3 and BI Infopackage.

We are in PI 2004_1_470. 0FI_GL_4 is already implemented and working fine.

Have anyone faced this sort of problem???

We debugged the datasource and found that in the function module BWFIR_READ_BSIK_CPUDT_DATA , the following code is missing.

LOOP AT R_FISEL WHERE FIELDNM EQ 'AEDAT'.

MOVE-CORRESPONDING R_FISEL TO R_AEDAT.

APPEND R_AEDAT.

DELETE R_FISEL.

ENDLOOP.

Can anyone tell me if in your system (where these datasource is implemented and delta working fine) whether this part of the code is there or not?

This will help us in resolving the issue.

If you know any other solution also do let me know..

Regards,

Pradhiba

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 04:17 AM
    0

    Hi Pradhiba,

    By default the FI extractors pick the delta data only after a day. Was your document created a day before. Just check the creation date.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Jan 10, 2007 at 05:35 AM

      Ya, that route was also tried. moreover we are in a version where all the 3 datasources are delinked. so not an issue.

      if this datasource is implemented in your system, pl check if the said code is available or not and let me know. it would be very helpful

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 04:56 AM
    0

    Hi,

    Please check whether you were using 0FI_AP_3 / 0FI_AR_3 at any time in the past. If yes, then you might need to apply some notes related to 0FI_3 / 0FI_4 before you can start using 0FI*_4 datasources.

    regards,

    Pinaki

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 06:20 AM
    0

    Hi Pradhiba,

    Check out whether Records have been recorded in the below mentioned table

    The R/3 BWFI_AEDAT table records FI changed documents. To start recording these changes, call transaction code SM30 and insert this row in the R/3 Business Transaction Events TPS31 table:

    Process Function Module

    00005011 BWFIP_WRITE_AEDAT_POINTER

    Note: It is always recommended to load FI-GL data first rather then AR and AP data then you can find right integrity of data.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Jan 10, 2007 at 07:39 AM

      Hi,

      For your information:

      Extractor looks into the table BWFI_AEDAT only for changed records to be fetched by delta.

      And for new records the extrctor does the following thing:

      <i>With Financial Accounting line items that have been posted in the SAP R/3 system since the last data request, the extractors identify the following delta dataset using the time stamp in the document header (BKPF-CPUDT).</i>

      With rgds,

      Anil Kumar Sharma .P

    Comment on This Answer

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.