Hierarchy
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services⤷
FIN-FSCM-TRM-TM (Application Component) Transaction Manager⤷
FTAC (Package) R/3 customizing for Treasury money, forex, forward
IMG Activity
| ID | TRMK | Maintain Key Figures |
| Transaction Code | S_ALR_87007400 | IMG Activity: TRMK |
| Created on | 19981222 | |
| Customizing Attributes | TRMK | Maintain Key Figures |
| Customizing Activity | TRMK | Maintain Key Figures |
Document
| Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
| Document Name | TRMK |
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.
Note
Key figure formulas may be up to 4096 bytes long. Note that key figures in the info system are substituted internally.
Actions
- 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.
Further information
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.
Example
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'.
Further notes
Transport of settings
Business Attributes
| ASAP Roadmap ID | 207 | Establish Reporting |
| Mandatory / Optional | 2 | Optional activity |
| Critical / Non-Critical | 2 | Non-critical |
| Country-Dependency | A | Valid for all countries |
Assigned Application Components
| Documentation Object Class | Documentation Object Name | Current line number | Application Component | Application Component Name |
|---|---|---|---|---|
| SIMG | TRMK | 0 | HLA0100040 | Information System |
Maintenance Objects
| Maintenance object type | C | Customizing Object |
| Assigned objects | ||||||
|---|---|---|---|---|---|---|
| Customizing Object | Object Type | Transaction Code | Sub-object | Do not Summarize | Skip Subset Dialog Box | Description for multiple selections |
| TRMK | T - Individual transaction object | TRMK | TRMK |
History
| Last changed by/on | SAP | 19981222 |
| SAP Release Created in |
