Ansicht
Dokumentation
SIMG_CFMENUOKCMKCK0 - Maintain key figure
Vendor Master (General Section) BAL_S_LOG - Application Log: Log header dataThis documentation is copyright by SAP AG.
In this step, you maintain the key figures.
The basic key figures of an aspect are the value and quantity fields in the relevant data structure. In order to prevent redundant data being stored, you should only save values/quantities on the database which cannot be calculated from other values/quantities. Calculated key figures can be defined using the key figure transaction.
You need to enter an arithmetic formula to form a calculated key figure. Valid components of the formula are the basic key figures of the aspect, constants and key figures already defined.
Key figure formulas may be up to 4096 bytes long. Note that key figures in the info system are substituted internally.
- Choose an aspect for which you wish to maintain key figures.
- Enter a new key figure or edit an existing one.
- Maintain the short text, the description and enter a formula.
- You can assign the key figure to a key figure group which is used in reporting when defining reports. Each key figure is attached to a particular aspect, however, if all the basic key figures used in it are also available in a second aspect, the resulting key figure can also be used in the second aspect if you enter it in table TKCTA.
Using the function 'Display basic fields', you can display the possible components for the formula. Using the function 'Switch basic fields', you can switch between basic key figures, existing key figures and constants.
The following operators are supported in the formula:
| Operator | Description |
|---|---|
| +, -, *, / | Basic arithmetic operations |
| % | Percentage variance |
| %A | Percentage |
| ** | Raise to a power |
| = | Assignment |
| ABS | Absolute amount |
| COS | Cosine |
| DIV | Division (of integers) |
| EXP | Exponential function |
| LOG | Logarithm |
| MAX | Maximum |
| MIN | Minimum |
| MOD | Remainder (of division of integers) |
| SIN | Sine |
| SQT | Square root |
Before saving, you should execute the 'Check formula' function. The formula is then checked for correct syntax, the formula stages are generated and the technical attributes are set to default values. The formula stages are the different steps which build up the complete formula.
To reset the formula to that saved in the database or the last saved version, you can use the function 'Reset formula'.
When you choose the function 'Substitute formula', the key figures are replaced by the formulas behind them until the formula contains only basic key figures and constants.
Using the function 'Get formula(s)', you can display or hide the formulas for the key figures in the lower section of the formula area. You can specify the key figures by entering the name or subgroup.
Using the function 'Switchover paging', you can switch between the upper and lower formula areas.
Using the function 'Evaluate formula(s)', you can enter values in the basic key fields and have the system evaluate the formula ('Calculate key fig.'). The system displays the calculated values on the formula stage screen (you may have to switch between the value and attribute display).
Using the function 'Check recursive act.', you check whether recursive relationships exist between key figures.
The function 'EIS stage forms' is for internal purposes only.
If you choose the function 'Formula stages', you branch to another screen. Here, the system displays in which stages the key figure is calculated. In addition, you can set the time-based and non-time-based aggregation rules, reference field, 'No aggregation' flag and the display (number format).
The 'No aggregation' flag specifies how the key figure is to be calculated in the results row. It is either aggregated or calculated according to the rules of the formula from the aggregated basic key figures.
| A | B | A/B |
| 1 | 10 | 0.1 |
| 10 | 1 | 10 |
| ---- | ---- | ----- |
| 11 | 11 | 10.1 or 1 ? |
The 'No aggregation' flag must be set if:
- operators other than '=', '+' and '-' are used in the key figure,
- a key figure used in the formula has the flag 'No aggregation' set,
- a time-based or non-time-based aggregation rule other than 'SUM' is used in a key figure used in the formula.
The (non-time-based) aggregation rule determines how the data is to be summarized. The following functions are available:
| Function | Description |
|---|---|
| MAX | Maximum |
| MIN | Minimum |
| NOP | No aggregation |
| SC+ | Summation where > 0 |
| SC- | Summation where < 0 |
| SUM | Summation |
The time-based aggregation rule determines how the key figures are summarized with respect to time. If you have chosen a rule other than 'SUM', you need to enter a reference field. You can enter '&PERI' if the time-based aggregation should be based on fiscal year and period. The following functions are available:
| Function | Description |
|---|---|
| AVG | Average |
| CNT | Counter |
| FIR | First value |
| LAS | Last value |
| MAX | Maximum |
| MIN | Minimum |
| NOP | No aggregation |
| SC+ | Summation where > 0 |
| SC- | Summation where < 0 |
| STD | Standard deviation |
| SUM | Summation |
| VAR | Variance |
You can maintain time-based and non-time-based aggregation separately. For stock (e.g. average warehouse stock), you may wish to choose time-based aggregation 'AVG' and non-time-based aggregation 'SUM'.
For any time-based aggregation other than 'SUM', you must enter a reference field. This can either be '&PERI' (for fiscal year and period) or a valid characteristic of type 'D'.
ABAP Short Reference ABAP Short Reference
This documentation is copyright by SAP AG.
Length: 9159 Date: 20240524 Time: 003057 sap01-206 ( 131 ms )
