Example of a Parameter Hierarchy
In this example, the relevant objects are assigned to the parameter hierarchy ORDERLIST
and the interdependencies are defined. You define the objects themselves in Customizing independent of the parameter hierarchy. The parameter hierarchy ORDERLIST
is assigned to the symbol group whose determination function module determines default parameter values for the application area Order
.
Definition in Customizing
You have created the relevant parameter objects in the Customizing activity Specify Parameter Objects
:
Parameter Object | Description |
|---|---|
| Order |
| Item |
| Schedule line |
In the Customizing activity Specify Parameter Hierarchies
, you specify the parameter hierarchy ORDERLIST
using the following definition. In the Customizing activity, you also assign a suitable report symbol group to the parameter hierarchy ORDERLIST
.
Object | Description | Parent Parameter Object | Start Object |
|---|---|---|---|
| (Order) | X | |
| (Item) | ORDER | |
| (Schedule line) | ITEM |
This definition means a hierarchy tree with the branch Order list
will appear in the Windows Wordprocessor Integration
(WWI) application in the symbol tree for symbols of the type Parameter
under the Parameter Hierarchies
node (see also Inserting Repeating Groups). This node contains the branch Order
, which contains the branch Item
, which in turn contains the symbol Schedule line
.
In the report template, you can use the hierarchy tree to create the necessary parameter repeating groups, for example:
< < < < < < < < < < < < < < |
Note
Only the repeating group that belongs to the start object may be used as the most outer repeating group.
The Windows Wordprocessor Integration
(WWI) application specifies the parameter hierarchy-parameter object
symbol explicitly for the end of the repeating group ("*ERG*") of type Parameter hierarchy
for the control symbols. This is an exception compared with all other types of repeating groups for which the control symbol "<11ERG00*> at the end of the repeating group suffices.
The function module for default parameter determination is found because of the assignment between the parameter hierarchy and the report symbol group. Within the function module, a table must be created in which the values and structural interdependencies are stored.
The example below shows this using the following sample data:
Sales organization: 1000
Sold-to party: 0815
Order: 4711
Purchase order number: 0020201
Item: 10
Material number: COLOUR_10
Schedule line: 1
Confirmed quantity: 50L
Schedule line: 2
Confirmed quantity: 40L
Item: 20
Material number: COLOUR_20
Schedule line: 1
Confirmed quantity: 100L
Order: 4712
Purchase order number: 020202
Item: 10
Material number: COLOUR_20
Schedule line: 1
Confirmed quantity: 30L
Schedule line: 2
Confirmed quantity: 30L
Schedule line: 3
Confirmed quantity: 30L
Order: 4713
Purchase order number: 0020203
Item: 10
Material number: COLOUR_10
Schedule line: 1
Confirmed quantity: 80L
Item: 20
Material number: COLOUR_30
Schedule line: 1
Confirmed quantity: 70L
Item: 30
Material number: COLOUR_50
Schedule line: 1
Confirmed quantity: 50L
The above sample data is returned to a table that is comprised of the following export tables:
The export table E_CVDDP_TAB contains the values for the symbols outside the repeating groups.
The export table E_CVDDP_RG_TAB contains the values for the symbols inside the repeating groups.
You can use the following columns in the table to store the structural dependencies for each value:
PARHIER (Parameter hierarchy)
PAROBJ (Parameter object)
PAROBJ-KEY (Key of parameter object)
PAROBJPAR (Parent parameter object)
PAROBJ-PARKEY (Key of parent parameter object)
LENRECD (Maximum nesting depth of a repeating group)
For the above example of parameter hierarchy Order list
, the table for the structural interdependencies of each value is as follows (the nesting depth in this example is zero; the table contains other fields that you can use to specify values, such as the value category):
PARHIER | PAROBJ | PAROBJ-KEY | PAROBJ-PAR | PAROBJ-PARKEY | LEN-RECD | OBJECT | ATTRIB | VALUE |
|---|---|---|---|---|---|---|---|---|
TVKO | VKORG | 1000 | ||||||
VBAK | KUNNR | 0815 | ||||||
ORDERLIST | ORDER | 4711 | 0 | VBAK | VBELN | 4711 | ||
ORDERLIST | ORDER | 4711 | 0 | VBAK | BSTNK | 020201 | ||
ORDERLIST | ORDER | 4712 | 0 | VBAK | VBELN | 4712 | ||
ORDERLIST | ORDER | 4712 | 0 | VBAK | BSTNK | 020202 | ||
ORDERLIST | ORDER | 4713 | 0 | VBAK | VBELN | 4713 | ||
ORDERLIST | ORDER | 4713 | 0 | VBAK | BSTNK | 020203 | ||
ORDERLIST | ITEM | 471110 | ORDER | 4711 | 0 | VBAP | POSNR | 10 |
ORDERLIST | ITEM | 471110 | ORDER | 4711 | 0 | MARA | MATNR | COLOUR_10 |
ORDERLIST | ITEM | 471120 | ORDER | 4711 | 0 | VBAP | POSNR | 20 |
ORDERLIST | ITEM | 471120 | ORDER | 4711 | 0 | MARA | MATNR | COLOUR_20 |
ORDERLIST | ITEM | 471210 | ORDER | 4712 | 0 | VBAP | POSNR | 10 |
ORDERLIST | ITEM | 471210 | ORDER | 4712 | 0 | MARA | MATNR | COLOUR_20 |
ORDERLIST | ITEM | 471310 | ORDER | 4713 | 0 | VBAP | POSNR | 10 |
ORDERLIST | ITEM | 471310 | ORDER | 4713 | 0 | MARA | MATNR | COLOUR_10 |
ORDERLIST | ITEM | 471320 | ORDER | 4713 | 0 | VBAP | POSNR | 20 |
ORDERLIST | ITEM | 471320 | ORDER | 4713 | 0 | MARA | MATNR | COLOUR_30 |
ORDERLIST | ITEM | 471330 | ORDER | 4713 | 0 | VBAP | POSNR | 30 |
ORDERLIST | ITEM | 471330 | ORDER | 4713 | 0 | MARA | MATNR | COLOUR_50 |
ORDERLIST | SCHED_LINE | 4711101 | ITEM | 471110 | 0 | VBEP | ETENR | 1 |
ORDERLIST | SCHED_LINE | 4711101 | ITEM | 471110 | 0 | VBEP | BMENG | 50L |
ORDERLIST | SCHED_LINE | 4711102 | ITEM | 471110 | 0 | VBEP | ETENR | 2 |
ORDERLIST | SCHED_LINE | 4711102 | ITEM | 471110 | 0 | VBEP | BMENG | 40L |
ORDERLIST | SCHED_LINE | 4711201 | ITEM | 471120 | 0 | VBEP | ETENR | 1 |
ORDERLIST | SCHED_LINE | 4711201 | ITEM | 471120 | 0 | VBEP | BMENG | 100L |
ORDERLIST | SCHED_LINE | 4712101 | ITEM | 471210 | 0 | VBEP | ETENR | 1 |
ORDERLIST | SCHED_LINE | 4712101 | ITEM | 471210 | 0 | VBEP | BMENG | 30L |
ORDERLIST | SCHED_LINE | 4712102 | ITEM | 471210 | 0 | VBEP | ETENR | 2 |
ORDERLIST | SCHED_LINE | 4712102 | ITEM | 471210 | 0 | VBEP | BMENG | 30L |
ORDERLIST | SCHED_LINE | 4712103 | ITEM | 471210 | 0 | VBEP | ETENR | 3 |
ORDERLIST | SCHED_LINE | 4712103 | ITEM | 471210 | 0 | VBEP | BMENG | 30L |
ORDERLIST | SCHED_LINE | 4713101 | ITEM | 471310 | 0 | VBEP | ETENR | 1 |
ORDERLIST | SCHED_LINE | 4713101 | ITEM | 471310 | 0 | VBEP | BMENG | 80L |
ORDERLIST | SCHED_LINE | 4713201 | ITEM | 471320 | 0 | VBEP | ETENR | 1 |
ORDERLIST | SCHED_LINE | 4713201 | ITEM | 471320 | 0 | VBEP | BMENG | 70L |
ORDERLIST | SCHED_LINE | 4713301 | ITEM | 471330 | 0 | VBEP | ETENR | 1 |
ORDERLIST | SCHED_LINE | 4713301 | ITEM | 471330 | 0 | VBEP | BMENG | 50L |
Note
The corresponding symbols are determined from the OBJECT
and ATTRIB
fields (see Default Parameter Value Determination).
As the keys for the instances of parameter objects must be unique within parameter hierarchies, it may be necessary to form artificial keys.
The symbols from the example above are then expanded as follows when the report is generated:
Sales organization: 1000
Sold-to party: 0815
Order: 4711
Purchase order number: 0020201
Item: 10
Material number: COLOUR_10
Schedule line: 1
Confirmed quantity: 50L
Schedule line: 2
Confirmed quantity: 40L
Item: 20
Material number: COLOUR_20
Schedule line: 1
Confirmed quantity: 100L
Order: 4712
Purchase order number: 020202
Item: 10
Material number: COLOUR_20
Schedule line: 1
Confirmed quantity: 30L
Schedule line: 2
Confirmed quantity: 30L
Schedule line: 3
Confirmed quantity: 30L
Order: 4713
Purchase order number: 0020203
Item: 10
Material number: COLOUR_10
Schedule line: 1
Confirmed quantity: 80L
Item: 20
Material number: COLOUR_30
Schedule line: 1
Confirmed quantity: 70L
Item: 30
Material number: COLOUR_50
Schedule line: 1
Confirmed quantity: 50L