Context

In this function, you configure a hierarchical P/L (Profit Loss) or balance item calculation schema to be used by an item report function. Item forms and item reports are split into two separate functions to enable you to reuse an item form easily (by linking it to different input data in the item report), for example, for a product profitability report, a planning profitability report, or a customer profitability report.

Item forms can be used for two purposes:

1. Dynamic Reporting

   In dynamic reporting, the item form uses aggregated key figures as an input for the leaf nodes. Formulas for the total nodes then use the results of the leaf nodes and other total nodes.

2. Reconciliation

   In Reconciliation, the item form uses mapping items as an input for the leaf nodes. Formulas for the total nodes then use the results of the leaf nodes and other total nodes.

Prerequisites

A characteristic with appropriate master data values is maintained. The master data values of this characteristic will then be used as P/L item IDs when defining the item form function.

Steps

Settings Configuration

1. In the Settings roadmap step, choose the input item form category from the dropdown list. Possible input item form categories are Dynamic reporting, Pre-allocation reconciliation or Post-allocation reconciliation.

2. In the Settings roadmap step, choose the input item characteristic.

Item Form (Values) Configuration

1. In the Values roadmap step, choose Add to get a new line.

2. In the Item column (field value), maintain the ID of the item. This can be any alphanumerical text in capital letters.

3. In the Item category column, choose whether it is a leaf node (key figure) or a subtotal node.

4. In the Level column, define the indentation (hierarchy level) that is to be used to display the item in the hierarchy.

5. In the Item Text (description) column, define a short description of the item ID.

6. If the item form category is Dynamic Reporting and the item category column is leaf (key figure), then, in the Key Figure From and Key Figure To columns, you can enter the key figures that are to be totaled for this item. If the item form category is Reconciliation, then the reconciliation result from the mapping specified for this item in item reconciliation function is taken over automatically, thus the Key Figure From and Key Figure To columns are not available.

7. If the Item category is Subtotal, then you can enter in the Formula column an arithmetic expression using other items and constants, for example, I1000 + I2000 / 3 (where I1000 and I2000 are items).

8. In the Sign column, choose whether the result shall be taken as it is (sign = +) or multiplied by -1 (sign = -).

9. In the Hide column, choose whether the result shall be displayed or it is only an internal interim result and thus it shall be hidden.

Result

This function does not produce an output by itself, rather it is used as a calculation formula set in the item report later.