Hierarchy
SAP_FIN (Software Component) SAP_FIN⤷
FI-SL-IS (Application Component) Information System⤷
GRWT (Package) Report Painter / Report Writer
Basic Data
| Data Element | ROW_LEVEL |
| Short Description | Hierarchy level of the row coordinate |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | TLEVEL | |
| Data Type | CHAR | Character String |
| Length | 3 | |
| Decimal Places | 0 | |
| Output Length | 3 | |
| 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 | Level |
| Medium | 15 | Level |
| Long | 20 | Level |
| Heading | 5 | Level |
Documentation
Definition
The row coordinate of a cell normally refers to a specific total in the report, that is, to the total that is directly addressed by the symbolic name
If you enter a hierarchy level, this means that the row coordinate refers to totals at lower levels in the hierarchy. Hierarchy level 1 represents the grand total, level 2 the subtotals, and so on.
You can only enter the hierarchy level if the symbolic name for the row coordinate is assigned to the header of the row set.
Example
A report has the following row set (dimension 'Account'):
|-----------| /TOTAL/
|MATERIALS | Materials
|-----------|
|
| |-----------|
|---|RAWMAT | Raw materials
| |-----------| 400100
| 400200
|
| |-----------|
|---|OPERMAT | Operating supplies
|-----------| 404100
404200
The symbolic name TOTAL has been assigned to the header of the set MATERIALS.
The report should have the following columns:
(1) Costs
(2) Percentage of total costs
(3) Percentage of costs for raw materials or operating supplies
The column set would then be defined as follows:
|-----------| <001>/<TOT1>*100
|COSTS_COL | Consumption
|-----------| HSL-0 /COSTS/
=
=<001>/<TOT2>*100
The symbolic name COSTS is assigned to the first set line (column 1); the formulas for column 2 and 3 use the cells <TOT1> and <TOT2>.
When creating the report, you must define the cells as follows (in brackets, the definition of <TOT2>):
Block number 1
Cell <TOT1> (<TOT2>)
Set ID COSTS_COL
Dimension RACCT
Column coordinate
Column set COSTS_COL
Coordinate COSTS
Level 1
Row coordinate
No. Set ID Coord. Level
1 MATERIALS TOTAL 1 (2)
The definition of <TOT1> and <TOT2> only differs in the definition of the level for the row coordinate:
- <TOT1> refers to the grand total, that is, level 1
- <TOT2> refers to the subtotals directly below the total level, that is, level 2
The following report would be output with these definitions:
|--------------------|--------|-----------|-----------|
| | Costs | % Total | % Group |
|--------------------|--------|-----------|-----------|
| 400100 | 100 | 10 | 25 |
| 400200 | 300 | 30 | 75 |
| * Raw materials | 400 | 40 | 100 |
|--------------------|--------|-----------|-----------|
| 404100 | 200 | 20 | 33 |
| 404200 | 400 | 40 | 67 |
| * Operating supp. | 600 | 60 | 100 |
|--------------------|--------|-----------|-----------|
| ** Materials | 1000 | 100 | |
|--------------------|--------|-----------|-----------|
History
| Last changed by/on | SAP | 20010607 |
| SAP Release Created in |
