cancel
Showing results for 
Search instead for 
Did you mean: 

Need SAP BW AR Aging Report with R/3 Aging Report Should Match

Former Member
0 Kudos

Hello All,

Could you please let me know SAP Delivered AR Aging Report on BW Side should match with SAP R/3 AR Aging Report for a given Customer.

When I ran the report on BW Side I am able to match the report values with InfoProvider Values and also with RSA3 Extractor (0FI_AR_4).

But when i tried to compare BW report with ECC Report values are not Matching at a given Customer Number.

Please explain the best practice to match the values of BW Standard Aging report with ECC standard AR aging report.

Thanks,

Geetha

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Reduce the reconcilaition to one customer and trace the data back.

Pl check data in your BW report for one cusotmer with the data in the source table ; BSID / BSAD.

Filter your BW report on currency type - doc currency.

Ravi Thothadri

Former Member
0 Kudos

Hi,

I am actually running the SAP Delivered Report in BW.

So I didn't changed any thing in report.

I m running the report in ECC using s_alr_87016128 tcode.

Still I m getting the amount difference.

I have checked at customer level with company code and Key date.

Can i get inputs on these.

ECC Report s_alr_87012168

BW Report:0FIAR_C03_Q0005

Thanks,

Geetha

Former Member
0 Kudos

are you comparing it with FBL5N tcode in ECC ??

Hope it Helps

Chetan

@CP..

Former Member
0 Kudos

Hi,

I am using s_alr_87012168 Tcode to run ECC AR Aging Report. I am not sure what date restrictions used in ECC Side.

Becoz I m running both SAP Delivered reports on both the sides.

Still i m getting difference in amount. I am giving same selection values (like company code and key date).

I am able to match Extractor - PSA- Multiprovider - Report values.

But i m facing the problem when i tried to compare with BW report with ECC Report.

Please suggest

Thanks,

Geetha

Former Member
0 Kudos

try using the FBELN5 and compare with rite dates.

Its always the dates which are the isses

Hope it Helps

Chetan

@CP..

Former Member
0 Kudos

just to add to what others suggested - check if you are looking at only open items, cleared items or all on the key date

Former Member
0 Kudos

When values are not matching it might be because of date retrictions.

Aging report is based on a date. so in BW your values should be between these dates.

Check if BW value is greater than R/3 values for a customer.

Check all restrictions applie don both sides.

Talk to a R/3 consultant and ask him the details fo R/3 report

apply restrictions in your BW report accordingly

Mey