Hierarchy
SAP_FIN (Software Component) SAP_FIN⤷
FI-SL-IS (Application Component) Information System⤷
GRWT (Package) Report Painter / Report Writer
Basic Data
| Data Element | RATIO_COLU |
| Short Description | Column text of a key figure (short) |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | RATIO_COLU | |
| Data Type | CHAR | Character String |
| Length | 10 | |
| Decimal Places | 0 | |
| Output Length | 10 | |
| 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 | Column |
| Medium | 15 | Column |
| Long | 20 | Column |
| Heading | 10 | Column |
Documentation
Definition
When you define a key figure block, you must first define both the rows and the columns of the key figure block.
To define the rows or the columns, you must enter a text that appears later as a row or column text in the list.
General information for defining key figures
It is often necessary to combine amounts within a report and thus create new key figures.
Example
Actual Plan
-------------------------------------------
Personnel costs 30 40
Material costs 110 90
* Total costs 140 130
Number of employees 10 10
Costs per employee 14 13 <-- key figures
Personnel csts per empl. 3 4 <--
Key figure blocks are used to define key figures. A key figure block contains the definition of several key figures.
A key figure is defined using a formula that contains cells. Cells pinpoint an exact coordinate in the report using a row and a column address.
For the above example, the following block matrix would be created:
Column block 1
----------------------
Row block 1 | |
----------------------
Row block 2 | |
----------------------
Key figure block 1 | |
----------------------
The key figure block consists of two rows and two columns. It contains the following formulas:
Actual Plan
-------------------------------------
Costs per employee | ACOSTS/AEMPLOY | PCOSTS/PEMPLOY |
-------------------------------------
Personnel costs per | APERSON/AEMPLOY | PPERSON/PEMPLOY |
employee -------------------------------------
These formulas contain the cells ACOSTS (actual costs), PCOSTS (planned costs), AEMPLOY (actual no. of employees), PEMPLOY (planned no. of employees), APERSON (actual personnel costs), PPERSON (planned personnel costs).
Coordinates (symbolic names) from sets are used to define these cells. It makes no difference whether you use set line or header coordinates.
The following sets are used in the above example:
Row block 1:
----------------
| Total costs | <-- with header
---------------- coordinate TCOST
---------------|--------------
with head.--------|--------- ---------|--------
coord.--> | Personnel costs| | Material costs |
PCOST --------|--------- ---------|--------
| |
All personnel accts All material accts
Row block 2:
The basic set EMPLOYEES containing the statistical activity type EMPLOYEES. This set contans the header coordinate EMPLOYEE.
Column block 1:
Key figure set PLANACT with the lines
001 actual entry with the coordinate ACT
002 plan entry with the coordinate PLAN
Cell definition:
Row/Coord. Column/Coord.
ACOSTS = ( 001/TCOST , 001/ACT )
PCOSTS = ( 001/TCOST , 001/PLAN )
AEMPLOY = ( 002/EMPLOYEE , 001/ACT )
PEMPLOY = ( 002/EMPLOYEE , 001/PLAN )
APERSON = ( 001/PCOST , 001/ACT )
PPERSON = ( 001/PCOST , 001/PLAN )
History
| Last changed by/on | SAP | 20010607 |
| SAP Release Created in |
