Entering content frameThis graphic is explained in the accompanying text Example: Transfer File for Specifications Locate the document in its SAP Library structure

The following example shows a transfer file (.DAT) for specifications.

Explanations

Column 1-6

Column 7-30

 

or for table fields and characteristics:

Column 1-31

Column 32-80

Comment

+C

Administrative section

Character standard

+SC

ISO-R/3

 

Identification (database name)

+ID

IUCLID

 

Format version

+V

2.21

 

Export date

+D

19960304

 

Key date for export

+VD

19960304

Set languages for export

+SL

E

Date format

+DF

DD.MM.YYYY

Decimal separator

+DN

.

Comment

+C

Identification for data provider

Begin data provider

+BA

 

Identification

+ID

ID1

Data provider name

+NAME

BASF

City (headquarters)

+CITY

Ludwigshafen

Country

+CNTY

DE

End data provider

+EA

 

Begin data provider

+BA

 

Identification

+ID

ID2

Data provider name

+NAME

HOECHST

City (headquarters)

+CITY

Frankfurt

Country

+CNTY

DE

End data provider

+EA

 

Comment

+C

Identification phrase library

Begin phrase library

+BC

Phrases

 

Identification

+ID

IUCL

 

Version

+V

2.21

 

Date

+D

19960101

 

End phrase library

+EC

   

Comment

+C

Specification data

 

Begin specification

+BS

2-nitroanisole

 

Begin R/3 table

+BV

$ESTRH

 

Table field

SUBID

 

IU-91236

Table field

SUBCAT

 

REAL_SUB

......Table field

OWNID

 

ID1

End R/3 table

+EV

   

Begin R/3 table

+BV

$ESTRI

 

Table field

IDTYPE

 

NUM

Table field

IDCAT

 

CAS

Table field

IDENT

 

91-23-6

Table field

OWNID

 

ID1

Begin additional R/3 table

+BAI

$ESTRL

 

Table field

SLSTID

 

EINECS

Table field

OWNID

 

ID1

End additional R/3 table

+EAI

   

End R/3 table

+EV

   

Begin R/3 table

+BV

$ESTRI

 

Table field

IDTYPE

 

NAM

Table field

IDCAT

 

IUPAC

Table field

IDENT

 

anisole

Table field

LANGU

 

E

Table field

OWNID

 

ID1

Begin additional R/3 table

+BAI

$ESTRL

 

Table field

SLSTID

 

EINECS

Table field

OWNID

 

ID1

End additional R/3 table

+EAI

   

End R/3 table

+EV

   

Begin value assignment type

+BV

SAP_EHS_1018_003

Table field

§ESTVA-UPDDAT

19930225

Table field

$ESTVA-UPDNAM

MAIER

Table field

$ESTVA-OWNID

ID1

Characteristic

SAP_EHS_1018_003_PREC

F30-04

Characteristic

SAP_EHS_1018_003_METHOD

F26-17

Characteristic

SAP_EHS_1018_003_GLP

F25-01

And so on

.

.

Characteristic

SAP_EHS_1018_003_VALUE_S1

10 mg/l

Begin additional R/3 table

+BAI

$ESTDF

 

Table field

OWNID

 

ID1

Table field

LANGU

 

E

Table field

UPDNAM

 

EUCLID

Table field

TEXTCAT

 

RM

Table field

TEXT

 

Text parameter: AUZ

End additional R/3 table

+EAI

   

Begin additional R/3 table

+BAI

$ESRDF

 

Table field

OWNID

 

ID1

Table field

LANGU

 

E

Table field

UPDNAM

 

EUCLID

Table field

TEXTCAT

 

RE

Table field

TEXT

 

Text parameter: AFZ

End additional R/3 table

+EAI

   

End value assignment type

+EV

   

Begin value assignment type

+BV

SAP_EHS_1013_003

Table field

§ESTVA-UPDDAT

19921130

Table field

$ESTVA-UPDNAM

HOFMANN

Table field

$ESTVA-OWNID

ID1

Table field

$ESTVA-COMPREL

w/w

Begin additional R/3 table

+BAI

$ESTDF

 

Table field

OWNID

 

ID1

Table field

LANGU

 

E

Table field

UPDNAM

 

EUCLID

Table field

TEXTCAT

 

RU

Table field

TEXT

 

Company; product

Line continuation

+*

Information

°

Line continuation

+**

Fine Chemicals

End additional R/3 table

+EAI

   

Begin additional R/3 table

+BV

$ESTVP

 

Table field

SUBIDREF

 

IU-135134

Table field

COMPACT

 

IMPURITY

Table field

PRECL

 

=

Table field

COMPLOW

 

1

Table field

PRECU

 

=

Table field

COMPEXP

 

%

End additional R/3 table

+EAI

   

Begin additional R/3 table

+BAI

$ESTRI

 

Table field

IDTYPE

 

NUM

Table field

IDCAT

 

CAS

Table field

IDENT

 

135-13-4

Table field

LANGU

 

E

Table field

OWNID

 

ID1

End additional R/3 table

+EAI

   

End value assignment type

+EV

   

End specification

+ES

   

End of file

+EOF

   

See also:

Specifying the Sequence of the External Data Structure

Abbreviations and Syntax Rules

Structure of Programming Lines

Leaving content frame