Skip to Content
0
Former Member
Jan 29, 2018 at 09:52 AM

BPC 10.1 NW (BW 7.5 SP05) : integrating number of days overdue receivables data into BPC

50 Views

Hello BPC experts,

I would like to integrate the number of days overdue receivables information into BPC. I haven't seen any topic about that, if there is one, please send me the url.

To be more accurate, what data I need to obtain looks like the following :

Not past due

By less than 30 days

By between 30 and 60 days

By between 60 and 90 days

By between 90 and 180 days

By more than 180 days.

These number of days must always be calculated according to the last day of a fiscal year. In this case, that would always be according to calendar, so the 31st December.

I know that BEx does this with 0FIAR_C03_Q0005. However, the customer wants to consolidate these data as well and uses Input form for their non-SAP entities.

Therefore, I would need a new Dimension (we can call it "OVERDUE") with 6 members (referring to the example above : not past due, less than 30 days, etc.).

What can be done to retrieve these data into BPC ?

Thank you in advance for your help,

Dat