Displaying Properties (SAP Library - Product Safety (EHS-SAF))

Displaying Properties

Prerequisites

You must have carried out substance drill-down reporting in the substance information system and be in the hit list.

Procedure

Select the substances you want to output.

Choose Utilities ® Change output.

A dialog box appears.

3.	If you want to display data	Then choose
	As a list in the R/3 System	VALUATION
	As an Excel list	EXCEL or EXCEL-LAB To output an EXCEL list in the standard, you must select the substance characteristic categories manually, but to output an EXCEL-LAB list, the substance characteristic categories are predefined in Customizing and are related to the identification data. In the standard system, you can define additional data in Customizing for EXCEL output. For further information, see the documentation for the IMG activity Specify parameters for substance information system.

Choose Utilities ® Choose output parameter.

You use the parameter for user exit type SUB_ISOUT to control the output in the IMG activity Manage user exits.

If you have set the FLG_ENV_VALCAT_ONLY parameter	Then the system displays
To be equal to TRUE	A note that parameter entry has been disabled in Customizing. For further information, see the documentation for the IMG activity Specify parameters for substance information system.
To be equal to FALSE, or not defined	The properties tree in a dialog box where you can select substance characteristic categories manually Select the required substance characteristic categories. If you have already selected substance characteristic categories on the initial screen using the Substance with property search function, these are selected automatically as default. If you have not selected any substance characteristic categories, those specified in Customizing are selected as default.

If you use Microsoft Excel, you can select a maximum of 50 substance characteristic categories.

Choose Goto ® Output.

Output VALUATION

The output VALUATION displays the property data in the R/3 System as a list. All selected substances are displayed one below the other. In the header section, the identifiers are displayed for each substance according to the column selection on the hit list.

Within the output, you can

Select more substance characteristic categories by choosing Edit ® Choose properties

Specify the additional information (assessment, source, usage, user-defined texts) to be displayed by choosing Edit ® Set output filter

Output EXCEL and EXCEL-LAB

The R/3 System determines the following for the substances selected:

The data for the substance characteristic categories entered

Additional information - assessment, source and usage

The data are then downloaded to your PC and Excel is started:

A table is displayed in the Excel folder for each property.

A line is output in the appropriate table for each substance and characteristic data record.

One column in the table is output for each characteristic. This ensures that all characteristics for a substance characteristic category are taken into account. Multiple characteristic value assignments are separated by a semi-colon.

The R/3 System lists the selected substances with three identifiers each.

Any values the R/3 System finds that correspond to the selection criteria are displayed.

In Excel, you can process the data further and store them in an Excel file. However, you cannot import the changes back into the R/3 System. Excel is a display program only for the R/3 data.