Explanations on Sample Report Template

Prerequisites

The following prerequisites must be fulfilled in order for the symbols to be expanded during manual generation (see also Prerequisites under Document Template Layout Editing):

  • The values of the characteristics, phrases, and table fields to which the symbols refer exist for the following objects:

    • The specification for which the report is generated

    • The components that belong to the hazardous ingredients of this specification because the symbols are used to access these in Section C

  • The usage specified for the individual value assignments must have the same validity area and rating as the generation variant.

  • The active indicator has been set for the individual value assignments.

  • The values for the symbols of type Parameter have been entered manually in parameter entry (here: product: EXTRATHION and report no.: 000001). (The SAP system only expands data for symbol type Parameter from the corresponding SAP component when shipping is triggered automatically.)

Section A

Row 1- 3: Symbol EHS_L_TEXT (symbol type Descriptor) references text modules from a phrase library. The key of the phrase library and phrase key are shown in parentheses, separated by a hyphen.

Row 3: The symbol of symbol type Parameter references data from other SAP components (symbol key GLIPSARKTX references the material description).

Section B

Row 3, 4: Symbol type Specification with symbol name GESTRIDENT references identifiers.

Row 3: All identifiers of category NAM and type TRIV are selected.

Row 4: All identifiers of category NAM and type CC are selected.

Row 6: Phrase codes are output for a phrase-enabled characteristic with symbol type Specification and expansion type GPC + C. In the example, the phrase codes relate to characteristic Hazard Symbol (symbol name G1023001SY) of value assignment type Labeling (symbol name SAP_EHS_1023_001). The asterisk * in symbol <01G1023001SY (C;*)> means that all phrase codes of the characteristic value assignment record are output.

A repeating group of type master group M,SAP_EHS_1023_001) is defined around the symbol G1023001SY in case several value assignment records exist for value assignment type Labeling. The asterisk * (M,SAP_EHS_1023_001;*) denotes that the system is to expand all value assignment records.

The repeating group is defined by the control objects ‘start of repeating group’ (BRG001) and ‘end of repeating group’ (ERG001), as well as by the master group assignment (M,SAP_EHS_1023_001;*).

The system therefore searches in all value assignment records for all value assignments of the characteristic G1023001SY for the value assignment type with the key SAP_EHS_1023_001 and outputs the values as a phrase code.

All repeating groups terminate with End of Repeating Group (ERGnnn). All control objects are automatically assigned a serial number.

Section C

You can use the Microsoft Word function Table when you want to define a table in your layout.

Row 3: Symbol type Descriptor references the column headings of the tables.

Row 5, 6 / column 1: Symbol type Specification with symbol key GESTRIDENT references identifiers. All identifiers of category NAM and type IUPAC are selected.

Row 5 / column 2: Symbol type Specification with expansion type GPC + C outputs the phrase codes for the phrase-enabled characteristic Risk Phrases (symbol key G1023001R2) of value assignment type Labeling (symbol key SAP_EHS_1023_001).

Row 5-8 / column 3: Symbol type Specification is used three times here for table fields of SAP component Specification Management:

  • Symbol key GESTVPRECL references the Operator lower limit field and outputs <, >, or nothing, depending on the field value.

  • Symbol key GESTVCOMPL references the Lower limit component field and outputs the value of the field.

  • Symbol key GESTVCOMPE references the Exponent field and outputs the exponent type, for instance, %, %%.

Rows 4 and 6 or 9: The definition of a repeating group of type Slave Group (S:POS) ensures that the system outputs all components listed under substance characteristic category Hazardous Ingredients. The system outputs the following data for these components according to the symbols:

  • Identifiers (IUPAC-NAME)

  • All risk records

  • The percentage of the individual components in the hazardous ingredients

In order to define a line break after each component, you need to enter SHIFT + RETURN after control object <BRGnnn(SPOS;*)>.

Rows 2 and 10: To ensure that all the hazardous components (symbol key SAP_EHS_1012_004) in the tables defined above are read, you need to define a repeating group type Master Group that references characteristic category SAP_EHS_1012_004 around the whole table.

Section D

Row 3, 4: You want to output all phrases allocated to phrase-enabled characteristic First Aid: Eye (symbol key G1015003AD) as a list with each item separated by an asterisk. Please note that you need to enter periods that you want to output at the end of a phrase manually.

Using symbol type Specification of expansion type GPC + P, you first define that the system only outputs the first phrase of the phrase-enabled characteristic.

You now need to insert the same symbol once more and define that the system outputs all phrases with the exception of the first. Insert a repeating group type D (discrete expansion of multiple values) around the symbol. You need to specify, both in the control object as well as in the symbol that the system is to output all values with the exception of the first (2-*). Set a return to insert a line break after the control object <11BRGnnn(D;2-*)>. Define a colon as separator.

Note Note

If you only want to output the phrases as a list without a separator, you only need to define a repeating group type D around the symbol and a line break character behind it:

<11BRG004(M,SAP_EHS_1015_003;*)>

<11BRG005(D;*)> <01G1015003AD(P;*)><11ERG005>

<11ERG004>

The quantity definition in the discrete repeating group does not have any effect on the report output. Instead, it is the quantity definition at the symbol that determines the number of values the system outputs for a characteristic with multiple values.

End of the note.

Section E

Row 3: You created a table and created the following data in the table columns:

Descriptions (symbol type Descriptor ). You want to output the description and a colon only once in the first column. For this reason, the conditioned text function is used to define this descriptor.

Values for various characteristics (symbol type Specification). These characteristics are part of characteristic category PH Value (symbol key SAP_EHS_1013_019).

Row 2, 4: To output all value assignment records, you need to define a repeating group of type Master Group around the complete table.

Row 5- 7: A table for characteristic category Density (symbol key SAP_EHS_1013_005) is defined in a similar way in these rows.

Section F

Row 1: Apart from symbol type Descriptor, the footer also contains symbol type Parameter that is used to output the report number. When the report is generated from Sales and Distribution (SD), the report number is assigned automatically by the system.