GL Aging report

[#1]

Hello everyone,

I need some clarification on what it means by an Aging report in SAP BW. Is there or can there be such a thing as a "GL Aging report" or are there only AR/AP aging reports? What is the structure of an aging report in terms of report layout (characteristics and key figures)? Are there special formulae? Is the calculation done at report level or at cube level? I have searched quite a bit for specifics on GL aging report in BW but haven't seen anything. Is there a standard (business content) aging report?

I'm sorry if this is too basic a question but I would appreciate an explanation on what aging really is and then a step by step possibly on how to create one.

Thanks a lot in advance for your input.

[Former Member]

Hi,

I only used/created and AP/AR aging report and have never been requested to create a GL aging report probably because it doesn't make much business sense.

Here is an example of the report that I found on google.

The aging reports are created using Restricted Key figures in Columns. Each restricted Keyfigure  would be a bucket or time 1 - 30 days, 31 - 60 days etc. You can manage this using Offsets on a date range.

I think either AP or AR has a business content report which can be activate.

In the Rows section of your query designer one would generally have the necessary Vendors/Customer either AP or AR.

I hope this helps.

Regards

-Sid