Identifying Relevant Fields

Prerequisites

The exchange file must be on a computer that can be accessed by Remote Function Call (RFC).

A path for the exchange file must be created in the external environment. This path must not consist of more than 40 characters.
There are no file size restrictions. However, for performance reasons, the exchange file must not be greater than 10 megabytes.
You must create the exchange file in the correct Character Standard.

Procedure

Select the table assignment you require.
- Table Assignment: Phrases
- Table Assignment: Sources
- Table Assignment: Specifications
- Table Assignment: Property Tree
- Table Assignment: Report Template
  
  Note
  You can call the individual tables in the SAP system and compare the table fields. In the SAP menu, choose Tools → ABAP Workbench → Overview → Data Browser. Enter the name of the table in the Table Name field. After confirming, the system shows you the table in question.
  
  End of the note.

Define the table fields to which you wish to transfer external data.

Note Note

Note the status and category information for the table fields:

Status	Description
Status M =	Mandatory field
Status K =	Optional field
Status C =	During the import, the table field data will be checked against a permissible value set.

End of the note.

The following table fields appear in multiple tables. These fields are grouped together in the affected tables with . ADMIN:

Table field	Status	Type	Comment
CRDAT	K	DATS8	Date Created
CRNAM	K	CHAR12	Name of creator
UPDDAT	K	DATS8	Date when data was last changed
UPDNAM	K	CHAR12	Name of person who made last change
OWNID	K	CHAR10	Key of the data provider

If the fields CRDAT, CRNAM, UPDDAT, UPDNAM are not supplied with the import, the SAP system inserts the current date and the current importer.

In the specification exchange file, enter a unique ID and name for every data provider. The data provider ID of the exchange file must not correspond to the data provider ID in the SAP system. To assign the correct data provider ID in the SAP system, the SAP system compares the data provider’s name, city, and country in the exchange file with the addresses of existing data providers in the SAP system, and replaces the imported data provider ID with the data provider ID of the SAP system.

Caution Caution

During specification import, there is a risk that phrases that are to be imported as the value assignment for a characteristic do not exist in SAP component Basic Data and Tools. To prevent the loss of this data, you can specify these phrase texts as characteristic-dependent user-defined text for the material in question in the exchange file. To assign the value for the characteristic itself, you can, for example, use phrase See User-Defined Text.

A characteristic to which you wish to assign a characteristic-dependent user-defined text must fulfill specific prerequisites (see User-Defined Texts and Documents).

End of the caution.