Identifying Relevant Fields (SAP Library - Product Safety (EHS-SAF))

Identifying Relevant Fields

Prerequisites

The transfer file must be stored on a computer that can be accessed with Remote Function Call (RFC).

You must create a path for the transfer file in the external environment. This path may not have more than 40 characters.

File size is unrestricted. However, for performance reasons, it should not be more than 10 megabytes.

The transfer file must be a sequential ASCII file. We currently support ISO 8859-1 (ISO Latin 1).

Procedure

Choose your required table assignment.

Table Assignment: Phrases

Table Assignment: Sources

Table Assignment: Substances

Table Assignment: Properties Tree

Table Assignment: Report Template

You can call the individual tables in the R/3 System and compare the table fields. To do this, choose from the SAP R/3 System screen Tools ® ABAP Workbench, then Overview ® Data Browser, and enter the name of the table in the Table name field. After you have chosen ENTER, the system displays the requested table.

Specify the table fields to which you want to transfer the external data.

Observe the status and type entries for the table fields:

	Status M =	Required field
	Status K =	Optional field
	Status C =	The data in the table field are checked against a permitted quantity of values during import.

The following table fields occur in several tables. These fields are grouped under.ADMIN:

".ADMIN" fields

Table field	Status	Type	Comment
CRDAT	K	DATS8	Date of creation
CRNAM	K	CHAR12	Created by
UPDDAT	K	DATS8	Date of last change
UPDNAM	K	CHAR12	Name of the last person to change the data
OWNID	K	CHAR10	Key of data owner

If the CRDAT, CRNAM, UPDDAT, UPDNAM fields are not delivered with the import, the R/3 System enters the current date and importer.

Enter a unique ID and name in the substance transfer file for each data provider. The data provider ID for the transfer file need not correspond to the data owner/provider ID in the R/3 System. To assign the correct data owner/provider ID in the R/3 System, the R/3 System compares the data provider names in the transfer file with the addresses of the existing data owners/providers in the R/3 System, and replaces the imported data provider Ids with the data owner/provider IDs in the R/3 System.

When importing substances, there is a risk that phrases are imported that are used as values for characteristics but do not exist in the R/3 component Product Safety. To ensure that you do not lose this data, you can enter these phrase texts as characteristic-dependent user-defined texts for the relevant characteristics in the transfer file. You assign a value to the characteristic itself, for example, with the the phrase See user-defined text.

Characteristics to which you want to assign characteristic-dependent user-defined texts must fulfil certain requirements (see User-Defined Texts).