on 01-10-2007 3:57 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.