cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

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

Former Member
0 Kudos
298

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

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member186338
Active Contributor
0 Kudos

You can import transaction data with dates as integer and then perform calculations in the BPC badi...

Former Member
0 Kudos

Thank you for your answer.

I need to wait for some decisions of the higher-ups before...

former_member186338
Active Contributor
0 Kudos

First of all, please explain what BPC are you using: standard or embedded?

Former Member
0 Kudos

Hi Vadim,

Standard version.