How to check a data load balanced from R/3 to BW for extractor 0FI_AR_4?

[Former Member]

We are required to prove our data loads balanced from R/3 to BW daily from the delta loads of 0FI_AR_4. Does anyone have any ideas and suggestions?

Thank you,

Cora

[Former Member · Accepted solution]

Run any of the the aged debt reports/account balance reprots in R3 and create one in BW - the ageings should match and so will the values

You will need to schedule the R3 aged debt report at a particular time

If you are using the FI extraction without the Overlap parameter set - then schedule the R3 job to run at 00:01 (this will work of your GL4 and AR 4 run after 0200)

Thus this will balance with the data extracted to BW

Youc an of course run the reconciliation remote cubes (if they do exist for AR4) - but I never use them - no need - the above will work very nicely with no overhead on R3

If the overlap parameter is set then schedule the aged debt report to run at exactly the same time as the AR4 extract (if you are running 24/7 then you will have to be more clever than that - but hopefully the above will work)

[Former Member · Accepted solution]

Hi Simon,

Thank you very much for your suggestion. This is what our current balancing procedure is. The issue is our company need to process a very high volume of data and there is always active posting in the R/3 system. With the overlap parameter on, there is no way for us to balance during the week or even on the weekend with the R/3 reports. Even we run this aged debt report every 30 minutes. We can tell the number is kept changing.

Regards,

Cora

[Former Member · Accepted solution]

So you have the same problem as me - this is what I do..

The aged debt report is run at the same time as the extract is started - but that may not be the timestamp caught in the Setttings table

However I do know the physical time the timestamp was set at

So I run a compact document line journal in R3 - this is good because it has a CPU date field on it

tick customer on , material, GL vendor OFF

Run it - and balance the two systems (take the document numbers out of this and balance to the document numbers in the AR4 ODS)

Nasty - but okay for a one off...

The other way is to ABAP - the extractor is quite simple - just replicate that

select * from bsid where CPUDT between x and y

select * from bsad where CPUDT between x and y

select * from bwfi_aedat where AEDAT between x and y

[Former Member · Accepted solution]

Hi Simon,

Cool that I know I am not the only one in trouble. Thank you! I hope SAP will have a tool to do the balancing for us. Well, I am thinking about the custom ABAP too this morning and I will give it a try.

Thanks

Cora