Source Allocation Relation (tfcat4620m000)

Use this session to view and maintain the range of source and destination dimensions based on which the allocation relations are generated by LN in the Allocation Relations (tfcat4500m000) session. For each range of source dimension you can define multiple destination dimensions. You can also define range of periods for which allocation relation can be generated.

Field Information

Relation

The type of allocation relation.

Allowed values

Budget Year

These relations are used for allocations within Single Dimension Budgets per Year.

Budget Period

These relations are used for allocations within Single Dimension Budgets per Period.

Actual

These relations are used for allocations within Actual Costs.

Period From

The From and To fields define a range of: years for which the allocation relation are applicable.

Note: You must specify this value if the Relation field is set to Actual.
Period From

The From and To fields define a range of: periods for which the allocation relation are applicable.

Note: You must specify this value if the Relation field is set to Actual.
Budget

The budget to which the allocation relation is applicable.

Description

The description or name of the code.

Processed

Indicates that the actual allocation relations are verified by the budget figures.

Source Dimension Type

The dimension type to be credited for the allocation.

Dimension Description

The description or name of the code.

Source Dimension From

The first dimension to be credited from the range of dimensions for generating individual allocation relation.

Note: 
  • The dimensions, must be of the Source Dimension Type.
  • This dimension range must be specified in the alphabetically ascending order.
Dimension Description

The description or name of the code.

Source Reference Unit From

The first reference unit to be credited from the range of reference units. If the source dimension use a reference unit, the amount of this reference unit represents the actual cost value of the dimension used by the allocation process.

Description

The description or name of the code.

Source Dimension To

The last dimension to be credited from the range of dimensions, for generating individual allocation relation.

Source Reference Unit To

The last reference unit to be credited from the range of reference units. If the source dimension use a reference unit, the amount of this reference unit represents the actual cost value of the dimension used by the allocation process.

Source Ledger Account

The source ledger account to be credited.

Note: This account is a Profit & Loss account with sublevel zero (0).
Ledger Account Description

The description or name of the code.

Destination Dimension Type

The dimension type to be debited for allocation.

Base Dimension Type

The dimension type for the base dimension. When using the base dimension type, the allocation process is always based on the actual costs. The allocation across the various destinations is based on the distribution of actual costs on the relevant base dimensions. The actual costs that are already available in the destination dimensions are not relevant for the allocation process.

Destination Allocation Type

The allocation type that depends on the parameters of the destination reference unit. You must use a uniform allocation type within the combination of relation, year, budget, period, and destination reference unit.

Allowed values

Performance
Cost
Equal
Distribution

The code that defines how the actual costs are distributed over the reference units that are linked to the dimension.

Description

The description or name of the code.

Allocation Type

The allocation type that is based on the parameters of the source reference unit. You must use a uniform allocation type for a combination of relation, year, budget, period and source reference unit.

Reference Unit Type Quantity Based Amount Based
Planning type Retrograde Progressive Retrograde Progressive
Quantity yes yes no no
Amount no yes no yes
Percentage no yes no yes

Allowed values

Quantity

Indicates that the allocation relations are based on performance values. The quantity-based allocation method assumes that the source dimension must contain at least one relevant reference unit. The reference unit must also be quantity-based and progressive.

Amount

Indicates that a fixed amount is reallocated, independent of the imported actual costs. As a result, both amounts laser or greater than 100% of the imported costs can be re-allocated.

Percentage

Indicates the fraction of costs to be written down on the dimension. When reference units with activated percentage-based periodic allocation is used, a percentage by period indicates a portion of the allocated costs.

Quantity

The quantity specified for quantity-based allocation.

Unit

The unit in which the quantity is measured.

Amount

The amount specified for the amount-based allocation. This fixed amount is debited to the destination dimension.

Note: This field is enabled only if the Allocation Type field is set to Amount.
Currency

The currency in which the amount is specified.

Percentage

The percentage specified for a percentage-based allocation. This percentage of the budget or actual costs must be debited from the destination dimension.

Note: This field is enabled only if the Allocation Type field is set to Percentage.
Percentage Sign

The percentage sign.

Equal Periodic Distribution

If this check box is selected,, the distribution across periods for Destination Allocation Type set to Cost or Performance (Actual Allocations) is applicable independent of the Actual Costs or Actual Allocations (Performance) occurred in that period. The redistribution is performed equally across the destination dimensions. If this check box is cleared, the redistribution is performed proportional to the Actual Costs incurred in the respective periods.

Periodic Distribution Percentage

The relationship between the period and year percentage or quantity for the Budget Period relation and the Actual relation.

Period / year x 100

for example:

20% / 80% x 100 = 25%

Valuation

Indicates if the valuation is performed based on actual or budget figures. Budget relations and actual Actual relations are respectively based on budget or actual figures, either from the Financial Budgeting System module or the Cost Accounting module.

Allowed values

Budget Figures

LN derives the amounts for calculating the allocation costs from the single dimension budget per year/period. For a budget year/period relation, the budget of the relation is used. For an actual relation, LN uses the actual budget as defined in the Finance Company Parameters (tfgld0503m000) session.

Actual Figures

LN derives the amounts for calculating the allocation costs from the actual costs by reference unit. Budget allocation relations are only allowed to be valuated with budget figures. Actual allocation relations may be valuated either by budget figures or by actual figures.

Valuated Portion

The part of the budget or costs that is allocated to the destination dimension.

Cost Category

The cost category to be credited for allocation. This is used to limit the primary cost amounts. For quantity or percentage based allocation (ie. allocation types which use imported costs) only the cost types related to the indicated category are reallocated.

Note: This field is applicable only if the Allocation Type field is set to Percentage.