Record Mapping

The record mapping table contains the regulations for mapping records in the set of rules to value assignment types in EH&S.

Table Fields in the Record Mapping Table

Table Field	Meaning
Internal_Id	Name of the record in the set of rules
Group	Optional assignment of the record to a composition in the set of rules In the rule editor, this assignment is visible in the tree structure and is not therefore listed explicitly.
External_Id	Name of the assigned value assignment type or identifier in EH&S (see “Syntax” section)
Description	Description text for the record
Options	Options that govern access to the data in EH&S more closely

The first two fields together identify the record uniquely in the set of rules.

Assignment to Value Assignment Types and Identifiers

You can assign records in the set of rules to the following elements in EH&S:

Value assignment types (property tree)
Identifiers
External tables from a Microsoft Access database

Syntax

Caution Caution

In the following syntax description, optional parts are shown in square brackets [ ] . The square brackets themselves do NOT belong to the syntax.

Three periods ... indicate a random number of repetitions of the previous syntax element.

End of the caution.

Value assignment types

You assign records to the value assignment types in EH&S by entering the value assignment type in the External_Id field in the syntax M:<Value assignment type> .

Example
The value assignment type Density from the standard property tree would be entered in the following way:

M:SAP_EHS_1013_005

End of the example.

Facts for records that are assigned to value assignment types can only have the letters M, A, F, S, R, L, U, 7, b, d, or f in their External_Id, meaning they represent fields of the value assignment table ESTVA or characteristics, or additional information.
Identifiers

You assign records to identifiers in EH&S by entering the identifier in the External_Id field in the syntax I:<Category>,<Type> [,<List> ][,<Language> ] .

Facts for records that are assigned to identifiers can only have the letters I or U in their External_Id, meaning they represent fields of the identifier table ESTRI or usages.
External tables

You assign records to tables in an external Microsoft Access database by entering the table and database name in the External_Id field in the syntax T:<Table>/<Database> .

<Table> here is the name of the table in the database. <Database> is the name of the Microsoft Access database file including the file extension.mdb.

The database must be accessible from the EH&S Expert server PC and can be present in Access 97 or Access 2000 format.

<Database> is the file name of the Microsoft Access database. If a full path is not specified, the database is expected to be in the same directory as the rule file. For sets of rules saved in the SAP system, the working directory entered in the administration tool for EH&S Expert applies.

Facts for records that are assigned to external tables can only have the key letter T in their External_Id.

Options for Records

Option	Meaning
/USAGE=<Rating>,<Validity area>. [ ,Exclude indicator [ ,Active indicator [ ,Relevance indicator ]]] [ ;... ]	The value assignments of the value assignment type are read or written with the specified list of ratings and validity areas. As an option, you can set the exclude indicator with X or – . You can still set or deactivate the active indicator and the relevance indicator either with X or – . If not specified, the exclude indicator is not set, the active indicator is set, and the relevance indicator is not set. For records that are read from EH&S, specifying the active and relevance indicators has no effect. Only active value assignments are read. Note You can specify a number of selection criteria simultaneously under the option /USAGE by separating them with the character ; (semicolon). A logical AND link is then valid for the selection criteria. This means, all criteria must be fulfilled. End of the note. For more information about using the /USAGE option as a selection criterion, see Data Selection by Usage .
/NOUSAGE	This option prevents the usage entered in EH&S Expert as a parameter for this value assignment type from being written. This option must be used if a usage that is defined as a fact is to cancel the default setting. Otherwise the usage that is defined as a fact would be written additionally. This option is not necessary for header data and identifiers in EH&S 2.7B. Here the usage passed as a parameter is not written implicitly. If a usage is required, it must be written explicitly with the /USAGE option or by means of a fact.
/DEF=<Characteristic>:<Value> [,... ]	When reading a value assignment type (record) you can use this option to specify a selection of data records, for example, only oral toxicity data records of type "LD50." You must enter the internal phrase key as the default value for phrase-enabled characteristics. You cannot fill characteristics with a default value.
/DELETE	Use the /DELETE option if you also want to delete other value assignment types that are not included in the result. If the respective record does not contain any data after the set-of-rules run, the corresponding value assignment type is marked for deletion. In R mode, all instances in this value assignment type are deleted. For more information, see SAP Note 1079895.
/REF	See Fact Mapping

Linking Data from Several Different Tables

You can also use records to link the data from several separate tables that are dependent on each other.

Example:

In this example, the dangerous goods regulation (SAP_EHS_1022_024_LWDG) in the dangerous goods regulations value assignment type (SAP_EHS_1022_024) is linked with the risk potential (LWDG) in the risk classification (table ID d:).

Record Mapping

Internal_Id	External_Id
DG	M:SAP_EHS_1022_024

Fact Mapping

Internal_Id	Record	External_Id
RECN	DG	A:RECN
LWDG	DG	M:SAP_EHS_1022_024_LWDG;SAP_EHS_1022_024
DPOT	DG	d:DPOT

In the set of rules:

RECORD DG (IN,OUT)

RECN

LWDG

DPOT

END,