Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jan 29, 2018 at 05:01 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 29, 2018 at 06:08 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.