Show TOC

 Function Uses

Use

In the Function Use view, determine in which template cells (row/column intersection) a function can be used.

When arranging functions in sub-environments , the row categories, columns and column types available for you to process depends on the template application you chose. You can choose the template application through your filter entry before creating the function (see the example below and also Editing Functions , section "Creating functions").

See also: Example: Creating a Function .

Features

Overview/All Columns Tabs

Overview / All Columns : you can use the tab page Overview or All Columns for your entries. In the Overview all the types of template columns are shown; for example, Object, Quantity, Activation, and Allocation Event. A marking applies to all columns of a particular type. All existing columns are shown in All Columns ; for example, Object, Plan Quantity, Plan Activation, Plan Allocation Event, Actual Quantity, Actual Activation, Actual Allocation Event.

In the editing mode: The selection in the Overview is valid for the column type (for example Quantity ). In the All Columns tab you can, therefore, edit all available columns with that type (for example if you deselect Plan Qty, the selection of Actual Qty remains).

The selection on the Overview tab shows you whether selections on the All Columns tab have been made uniformly or not:

Selection on Overview tab ( in editing mode)

Settings in All Columns

Tick in white field (changes possible)

All columns are selected

Tick in gray field (changes only possible in All Columns tab)

At least one, but not all columns are selected

No tick (changes possible)

No columns are selected

Column Type

The column type shows you which row categories are available (for example, Process, Sub-Template, Calculation Row , and so on). Which column types are available depends on the template application chosen (see example below).

Other Columns

Additional columns (object, quantity, and others): by marking the checkbox, you decide that the functions in these column-row combinations can be chosen.

Filter

By using the icon (Filter) next to a cell, you can activate or deactivate further requirements, and thereby constrain the use requirements:

  • In the columns for quantities and allocation events you can determine whether a function can be used as a formula component and/or as a parameter.

  • In the columns for Object and Activation, you can decide whether the function can be used as a Column Header (comparison operand 1), Column Entry (comparison operand 2), and/or Parameter .

In the editing mode: If you call the filter in the overview tab, you see through the selection of the usage criteria, whether they are uniformly set or not (in the individual columns of the All columns tab).

Selection on Overview tab (in editing mode)

Settings in All Columns

Tick in white field (changes possible)

The usage criteria are selected in all columns

Tick in gray field (changes only possible in All Columns tab)

Usage criteria selected for at least one, but not all columns

No tick (changes possible)

No usage criteria selected

Switching between Applications

When you display functions, you can switch between the template applications by choosing Start of the navigation path Environment Next navigation step Other template applications Next navigation step and see the various row/column combinations. End of the navigation path

Create a function in the subenvironment 101. Various column types and row categories are made available depending on what template application you chose.

Chosen template application

Column types available

Row types available

Cost object/costing COB

Object, quantity, activation, allocation event

Process

Calculation row (process)

Flexible function (process)

Cost center / activity type

Calculation row (cost center/activity type)

Cost center/process activity allocation SBP

Object, quantity/costs, activation

Process

Cost center / activity type

Calculation row (process)

Calculation row (cost center/activity type)

Profitability segment PAC

Object, quantity, activation

Process

Calculation row (process)

Flexible function (process)

Cost center / activity type

Calculation row (cost center/activity type)