0FIAP_C03 Cash Mgmt Amounts into Due Date Buckets

[Former Member]

Using Cube 0FIAP_C03 A/P Payables in BW3.5 and Query Designer. I have a need to take the open items and ‘group’ them by days past due.

First step I created a new key figure to take today’s date (key date) and subtract the net due date. This provides a numeric value of the days past due. So far, so good.

Then I created another key figure that was the days past due divided by 7 and I displayed the output with zero decimals. This appears to get the buckets, but I can’t find a way to display/group the amount by these buckets for the report. But I can’t find a way to get the Amount (doc currency) to show in buckets (columns) like current, 1-7 days past, 7-14, etc.

All thoughts appreciated, I may of headed in the wrong direction when there is another approach. Thanks.

[Former Member · Accepted solution]

I hard code the buckets with RKFs

eg

RKF1 0 - 30 days Total is total of RKF2 + RKF3

RKF2 0- 30 days Open is

Amount

Posting date <= key date

item status is open

Net due date between key date and key date -30

RKF3 0- 30 days Cleared now but was open at key date of query is

Amount

Posting date <= key date

Clearing date > key date date

Net due date between key date and key date -30

You may or may not want to include partial payments/invoiced (inf ref field is blank)

And then you do the another set of RKFs for 31-60, 61-90, not yet due etc

[Former Member · Accepted solution]

Hi,

I have a similar requirement but I am not able to understand the logic provided by Simon, Please can someone explain me the same or any other logic to develop aging report for AP?

Thank you,

sam

[Former Member · Accepted solution]

Hi Simon,

I dont know how relevant this question related to this thread but....... I am working on Inventory Aging and using the query ZQ_ZMMIC03_SRM006. And here theres nothing like buckets and time frames, and for a specific material if we check the material aging it is giving in percentage value. I am not sure how this % is caluclated. Could you please take me out of this confusion. I am attaching the Link wht I am talking about and I couldnt understand what it exactly defines about the Inventory aging

http://help.sap.com/saphelp_crm50/helpdata/en/69/8693404f673028e10000000a1550b0/frameset.htm

I appreciate your help

Shane

[Former Member]

Hi Robert,

I have the requirement replacing the aging document report with std business content report falling in different time buckets(30/60/90). Can you please let me know which business content report I need to use.

thanks

[Former Member]

hi sampath or robert,

can anyone of u guys share the step by step document. appreciate ur help. my email id is srinis_sap@yahoo.com. i am bit desperate and would like to see ur response asap.

thanks,

sri

[Former Member]

Hi Robert,

Iam working on same scenerio, can you send me the step by step document (if you have done with it already) to create an aging report.

my email getursam@gmail.com

thanks

[stevenm_wilson]

I created something almost identical to what SIMON explained and it works well...the key is getting your RKF's correct, after that, it is acedemic. I am surprised SAP didn't create something like this from content...or maybe they did, I don't pay too much attention to thier content queries since we don't ever use them.

Cheers!

/smw

[Former Member]

Thanks. I was stuck because I couldn't find a way to restrict based on the key figure. I used your logic and created restricted key figures based on 'Net Due Date' ranges.