Hierarchy
SAP_FIN (Software Component) SAP_FIN⤷
FI-SL-IS (Application Component) Information System⤷
GRWT (Package) Report Painter / Report Writer
Basic Data
| Data Element | VVALUES |
| Short Description | Individual Value Indicator for Variation Range |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | XFELD | |
| Data Type | CHAR | Character String |
| Length | 1 | |
| Decimal Places | 0 | |
| Output Length | 1 | |
| 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 | IndivValue |
| Medium | 15 | Indiv. values |
| Long | 20 | Individual value ind |
| Heading | 1 | I |
Documentation
Definition
This indicator controls whether the variation range contains single values.
To activate the indicator, enter 'X' in the field.
X = the variation range contains single values
_ = the variation range does not contain single values
The organizational structure of the sample company COMPANY consists of administration (ADMIN), sales (SALES) and production (PROD) departments which are each subdivided into two cost centers:
Cost center hierarchy Level
-----------
| COMPANY | 1
-----------
| | |
------------- | ------------
| | |
----------- ----------- -----------
| ADMIN | | SALES | | PROD | 2 (=-2)
----------- ----------- -----------
^ ^ ^ ^ ^ ^
| | | | | |
v | v | v |
100 110 200 210 300 310 3 (=-1)
Assume the database contains the following data for fiscal year 1994:
Cost centers
Account 100 110 200 210 300 310
-------------------------------------------------------------
Wages 50.00 100.00 250.00 250.00 550.00 350.00
Salaries 500.00 250.00 150.00 450.00 150.00 100.00
-------------------------------------------------------------
If you do not vary the selection, a report using the cost center hierarchy as the selection set, the two accounts as the row definition and fiscal year 1994 as the column definition would look as follows:
------------------------
|Account | 1994 |
|------------|---------|
|Wages | 1550.00 | (total for all cost centers)
|Salaries | 1600.00 |
------------------------
Example 1:
Individual lists are to be produced for each cost center and each cost center group. This can be achieved in the Report Painter by activating the 'Explode' indicator. In the Report Writer, the variation area must be defined through the From level 1 and the To level 3 (or any other larger value). In addition, the single value indicator must be set. In the general data selection of the report definition, you must make the following entries:
Example 2:
Individual lists should be generated for the cost centers only. To do so in the Report Painter, the line item indicator must be active. In the Report Writer, the variation area must be defined through the From level 1. In addition, the line item indicator must be set. In the general data selection of the report definition, you must make the following entries:
Example 3: Assume you now want to create individual lists for each cost center and each cost center group and the list is to be suppressed at the highest node (COMPANY). This is only possible in the Report Writer. The variation area must be limited to the From level 2 and the To level 3. You must also set the single value indicator. In the general data selection of the report definition, you must make the following entries:
Alternatively, you could also enter 2- as the from-level.
With these settings, you can call up a list online for each hierarchy element in the variation range. For example, the following report would be displayed for the hierarchy node SALES with hierarchy level 2:
------------------------
|Account | 1994 |
------------------------
|Wages | 500.00 | (total for cost centers 200 and 210)
|Salaries | 600.00 |
------------------------
In background processing, nine lists would be printed for the elements ADMIN, 100, 110, SALES, 200, 210, PROD, 300 and 310.
History
| Last changed by/on | SAP | 20010607 |
| SAP Release Created in |
