Hierarchy
⤷ CA-GTF-DCM (Application Component) Data Transfer
⤷ BKD (Package) Tools for (external) data transfer
Basic Data
Data Element | CFFLINE |
Short Description | Key figure formula line |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | CHAR60 | |
Data Type | CHAR | Character String |
Length | 60 | |
Decimal Places | 0 | |
Output Length | 60 | |
Value Table |
Further Characteristics
Search Help: Name | ||
Search Help: Parameters | ||
Parameter ID | ||
Default Component name | ||
Change document | ||
No Input History | ||
Basic direction is set to LTR | ||
No BIDI Filtering |
Field Label
Length | Field Label | |
Short | 10 | KFig.form. |
Medium | 15 | KFig.form.line |
Long | 20 | Key fig.formula line |
Heading | 55 | Key figure formula line |
Documentation
Definition
Formula components/Syntax
The formula editor is used in various applications. If differences in syntax occur, these are highlighted in the relevant place.
Valid formulas consist of identifiers (), +, -, *, / and other operators. The number of valid operators depends on the application. The syntax is checked and you may only enter valid operators. You separate the components of the formula with blank spaces. When you define forms, you can include variables in the formulas. Variables begin with '&' and have a maximum of 9 characters (including '&'). In forms you can also define local variables that begin with '&$'.
Example
Formula Description
REVENUE - COST Normal subtraction
REVENUE MAX COST Maximum of REVENUE and COST
REVENUE %A COST COST as a percentage of REVENUE
REVENUE + ABS ( COST ) Total of REVENUE and the absolute COST
If you use constants or natural numbers in the formula, you enter these in Table TKCC. Numbers, with or without a decimal point, and a maximum of 5 decimal places do not need to be entered in Table TKCC.
Operators such as +, -, *, /, ABS, COS, SIN are maintained in Table TKCKO. When you maintain forms, the number of valid operators is different. You cannot alter this. If you do not choose a valid operator, the system issues an error The following operators are valid:
Operator Description
% Percentage variance, i.e. a % b = 100 * (a - b) / abs(b)
%A Percentage share, i.e. a %A b = 100 * a / b
%T Percentage of grand total in report *)
%S Percentage of total in the result line *)
RC Percentage of total * Operand *)
TC Percentage of grand total * Operand *)
* Multiplication
** Raise to a power
+ One-place plus
+ Addition
- One-place minus
- Subtraction
/ Division
ABS Absolute amount
CNT 1 if Operand <> 0, otherwise 0
COS Cosine
DIV Division of integers
EXP Potential function
LOG Logarithm
MAX Maximum
MX0 Maximum of Operand and Nill
MIN Minimum
MN0 Minimum von Operand and Nill
MOD Remainder (division of integers)
NDI Key figure value without dimension
DTA Goto function: 1 when Operand equals Nill, otherwise nill
REF Value 1 without dimension. The operator is used to control
the replacement of variables.
REF ( X001 ) means that variables in the formula are to be
replaced by the values from column X001.
The operator should be at the beginning of the formula. *)
SIN Sine
SQT Square root
Operations indicated with *) can only be used when maintaining forms for drill-down reports. 'Total' refers to the value in the results row for the current drill down. 'Grand total' refers to the value in the results row if the key figures have been aggregated over all characteristics.
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in |