cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi Siva,

The entry is already there.

And my issue is that the created documents are not getting picked up, while changed documents are coming fine.

The created documents are coming in 0FI_GL_4 but corresponding vendor documents are not coming in 0FI_AP_4. same holds good with 0FI_AR_4

Regards,

Pradhiba

Former Member
0 Kudos

Hi,

There might be chances of Records merging , Check first in R/3 and compare BW . also check out in Rsa3.

Regards

Sujan

Former Member
0 Kudos

Sujan, RSA3 also doesn't pick up. there is not question of merging.

We debugged the code, we find that in the Select query (for newly created documents), there is a where condition like AEDAT in 19000101 99991231, wherein for newly created documents the AEDAT will be initial. so the conditon is not satisfied, that why no documents are getting picked up.

when we debugged further we found that in the function module BWFIR_READ_BSIK_CPUDT_DATA , there is code for deleting all selection variables after moving it to ranges, while the code for AEDAT is missing, thats why it is passed to the select query.

So we want to find out if the code in missing only in our installation or if the delta works without that code also. Thats y i am asking if someone who has delta working to check if the code is there in their system or not.

Regards,

Pradhiba

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

No, we are implementing AP/AR for the first time and we have started with 0FI_AP_4 / 0FI_AR_4. 0FI_AP_3/0FI_AR_3 is not installed at all.

Former Member
0 Kudos

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

Former Member
0 Kudos

No, we have set the flag to pick documents created on the same days also. It picks up the documents in 0FI_GL_4.

If that is the case, i dont see the documents created a day before as well. So thats not the issue.

Regards,

Pradhiba

Private_Member_9643
Active Contributor
0 Kudos

Just for cross check, Hope u r loading GL delta before AP & AR? Its recommended to load GL data first, then AP & AR to get proper delta load.

Former Member
0 Kudos

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