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_TEXT |
| Short Description | Name of the key figure block |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | TEXT60 | |
| 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 | Text |
| Medium | 15 | Name |
| Long | 20 | Name |
| Heading | 55 | Name |
Documentation
Definition
You can enter a description for each key figure block. This text can later be output as a heading for the key figure block.
If the key figure block is printed at the beginning of the current list page, the text is always printed as a heading.
If the key figure block is printed at another position on the page, you can set whether the text is to be printed as the heading of the key figure block using the check box 'Print heading' on the 'Rows' screen.
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 |
