BEX - Column showing amount and

[Former Member]

Hi,

In BEX, how to create a column that will show the amount (say 0amount) depending on the following:

We select a period (using a direct entry variable on 0calday) on execution of the query.

In Column 1, show the cumulated amount when the "selected period - 0netduedate" is between 0 and 30.

in Column 2, show the cumulated amount when the "selected period - 0netduedate" is between 30 and 60.

Could you guys plz advise.

Thx,

Ganesha

[former_member202718]

Hi Ganesh,

You can try to create Text variables on Calday and then create RKF for Amount,Netduedate and calday.

Try this out and let me know...

Rgds

SVU123

[Former Member]

Hi.

You can use virtual KF and code your logic.

Regards.

[Former Member]

Hi Ganesha:

It looks like you are trying to do an aging report like an AR or AP Aging Report.

The best solution is to use the SAP Standard AR or AP Aging Reports available in BI Business Content.

Go to RSA1 -> BI Content -> Query Elements -> Query -> Select Objects -> Financial Management & Controlling -> Financial Accounting -> Accounts Receivable Accounting -> FIAR Line Item -> Days Overdue Analysis.

This query is a SAP Standard AR Aging Query. Similar AP Aging query also is available under Accounts Payable Accounting.

If you have a different requirement, i suggest installing this standard content in sandbox and looking at how this type of keyfigures are created and then trying to creeate your own. It can get a little complex. It is a lot easier if you can look at one of these standard Aging Queries and duplicate it.

Even if you have to create it on your own it just takes time to build the key figure structure. You have to create multiple restricted key figures to get one calculation. You might have to use Posting date / Clearing Date, Net due date. In yiour restriction you can use offsets Posting Date < Posting Key date. There are standard variables for this such as 0P_KEYD3 that you can install from BI Content as well.

Good luck.

MP.