Advanced Distribution for Financial Planning 

Use

You use this function to simplify the process of manually entering amounts for a financial view in a financial group.

To apply the advanced distribution, you navigate as follows: Portfolio Management ® Portfolio Management. In an object dashboard, select an object. In the object overview, choose Financial Planning, click a particular category. This takes you to the Financial Planning: Category Groups view. Here you can expand all the views of a group for the selected category. Select a view and click Advanced Distribution.

Prerequisites

·        You have defined the distribution type of the financial group in Customizing of SAP xApp Resource and Portfolio Management (SAP xRPM) under Global Customizing  ® Portfolio-Independent Settings  ® Define Financial and Capacity Categories.

·        You have defined the financial views as Manual in Customizing of SAP xApp Resource and Portfolio Management (SAP xRPM) under Global Customizing  ® Portfolio-Independent Settings  ® Define Financial and Capacity Views.

Activities

...

In the Advanced Distribution view, you must fill out the following fields:

Field	Explanation
Valid From	You specify the starting date for the distribution. If you do not enter a value in this field, the system takes the current financial planning start date. You can specify this date as a date before the present financial planning start date. In this case, the system adds and displays new columns for new periods.
Valid To	You specify the end date for the distribution. If you do not enter a value in this field, the system takes the current financial planning end date. You can specify this date as a date after the present financial planning end date. In this case, the system adds and displays new columns for new periods.
Required Amount	You specify the amount which is to be distributed along the time line.
Currency	This is the currency present at the item/initiative/bucket or what-if level. It is read-only and cannot be changed here.
Action Type	You select the action type from the drop down list. The action type indicates how the distributed amount affects the current amount. The following action types are available: ... ·        Set required financial amount ·        Add required financial amount to current amount ·        Subtract required financial amount from current amount
Calculation Base	You select the calculation base from the drop down list. The calculation base decides how the required value is distributed along the timeline. You have the following calculation bases available: ... ·        Per day ·        Complete interval ·        This option is retrieved from the financial planning period breakdown type defined for the item/initiative/bucket or what-if level.
Distribution Type	The distribution type determines how actual calculations are done during advanced distribution, that is, whether to divide amounts approximately or divide according to factory calendar and so on. This is a read-only field. You have set the value of this field, for example the distribution type for a particular group, in the IMG activity Define Financial and Capacity Categories. You can choose between the following distribution types: ·        Based on factory calendar working days ·        Based on calendar days ·        Based on fixed number of days ·        Based on number of months in the period

      

       1.      To distribute the amounts when you have entered values in all the fields mentioned above, choose Confirm.

       2.      The distributed amounts are displayed in the main Financial Planning: Category Groups view.

       3.      You can change these amounts.

Example

Consider the example of an item with monthly financial breakdown type.

Let the number of days and working days in the months January to May be as shown below:

Month	Jan (22-31)	Feb	Mar	Apr	May (1-15)	Total
Days	10	28	31	30	15	114
Working Days	8	20	24	25	11	88

Following are the choices made in the distribution function and the calculated amounts for January and February depending on the choices:

·        Required Amount: 1000

·        Valid from: 22 Jan 2006

·        Valid to: 15 May 2006

1. Calculation Base: Per Day

1.1. Distribution Type: Factory Calendar Working Days

Amount for January: 8 * 1000

Amount for Feb:  20*1000

1.2. Distribution Type: Fixed Number of Days

Amount for January: (10  /  31 * 22 ) * 1000

Amount for Feb : 22 * 1000

1.3. Distribution Type: Calendar Days

Amount for January: 10 * 1000

Amount for Feb : 28 * 1000

1.4. Distribution Type: Based on Number of Months

Amount for January:  10 * 1000

Amount for Feb:  28 * 1000

 

2. Calculation Base: Complete Interval

2.1. Distribution Type: Factory Calendar Working Days

Amount for January: 8  * 1000 /  88

Amount for Feb:  20  * 1000 /  88

2.2. Distribution Type: Fixed Number of Days

Days in January = (10  /  31 * 22 )

Amount for January: Days in January * 1000 / (Sum of days in Jan to May)

Days in Feb =  22

Amount for Feb: Days in Feb * 1000 / (Sum of days in Jan to May)

2.3. Distribution Type: Calendar Days

Amount for January: 10 * 1000 / 114

Amount for Feb:  28  * 1000 /  114

2.4. Distribution Type: Based on Number of Months

Amount for January:  1000 / 5

Amount for Feb: 1000 / 5

 

3. Calculation Base: From Periodic Breakdown

3.1. Distribution Type: Factory Calendar Working Days

Amount for January: 8 / 22 * 1000

Amount for Feb:  1000

3.2. Distribution Type: Fixed Number of Days

Amount for January: 10/22 * 1000

Amount for Feb: 1000

3.3. Distribution Type: Calendar Days

Amount for January: 10 / 31 * 1000

Amount for Feb: 1000

3.4. Distribution Type: Based on Number of Months

Amount for January:  1000

Amount for Feb: 1000