Allocation

Allocation

  1. Navigate to Main Menu > Data Actions

  1. Select the Data Action tile under Create.

  1. Enter the following details in the Data Action Settings:

    • Name: Admin###_Process1

    • Description: Admin### Allocation Process1

  1. Under the Default Settings section, choose the drop-down for Default Model and select the underlying model that you have created earlier - My Files > PnL_Admin_NEW###.

Note

If you are running this module standalone, select the underlying model that you have copied earlier -

  1. Save the data action by clicking the Save icon in the toolbar then Save.

  1. Select My Files to ensure you are saving to your local directory, name the Data Action PnL_Admin###_Process1 with description PnL_Admin### Allocation Process1 and then select Save.

  1. Under the Add Step menu, click the Add Allocation Step button.

  1. In the Name field enter Indirect Expenses Allocation.

  2. Under Write Mode, select the option Keep Source.

  1. Under the Allocation Rules section, choose the drop-down in the first row under Source Dimension.

  2. Choose Accounts > Default Hierarchy

  1. In the second row under Source Dimension, click the selection button and choose PL 310 - Personnel Cost from Select Source Member

  1. Under the Driver Dimension section, choose the drop-down in the first row and choose Accounts >> Default Hierarchy

  1. In the second row under Driver Dimension, click the selection button and choose PL010 - Product Sales from Select Source Member

  1. Click OK

  2. Under the Target Dimension section, choose the drop-down in the first row under and choose Products >> Default Hierarchy

  1. In the second row under Target Dimension, click the selection button and choose APL from Select Source Member

  1. Click OK

  2. In the third row under Source Dimension, click the selection button and choose PL 400 - Indirect Expenses from Select Source Member

  1. Click OK.

  2. In the third row under Driver Dimension, click the selection button and choose NF010 - Nr Units from Select Source Member

  1. In the third row under Target Dimension, click the selection button and choose APL from Select Source Member

  2. The Allocation Rules should be displayed as follows :

  1. Save the data action by clicking the Save icon in the toolbar then Save.

Learning

SAP FacebookSAP YoutubeSAP LinkedIn