Example: Transfer File for Substances 

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

Notes

Column 1-6

Column 7-30

   

or for table fields and characteristics:

Column 1-30

 

Column 32-80

         

Comment

+C

Administrative section

Character set

+SC

ISO-LATIN 1

   

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

D

Comment

+C

Identification for data owner

Begin data owner

+BA

 

Identification

+ID

ID1

Data owner name

+NAME

BASF

City (headquarters)

+CITY

Ludwigshafen

Country

+CNTY

DE

End data owner

+EA

 

Begin data owner

+BA

 

Identification

+ID

ID2

Data owner name

+NAME

HOECHST

City (headquarters)

+CITY

Frankfurt

Country

+CNTY

DE

End data owner

+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

Substance Data

   

Begin substance

+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 characteristic category

+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

etc.

.

 

.

Characteristic

SAP_EHS_1018_003_VALUE_S1

 

10 mg/l

Begin additional R/3 table

+BAI

$ESTDF

   

Table field

OWNID

   

ID1

Table field

LANGU

   

D

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

   

D

Table field

UPDNAM

   

EUCLID

Table field

TEXTCAT

   

RE

Table field

TEXT

   

Text parameter: AFZ

End additional R/3 table

+EAI

     

End characteristic category

+EV

     

Begin characteristic category

+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

   

D

Table field

UPDNAM

   

EUCLID

Table field

TEXTCAT

   

RU

Table field

TEXT

   

Firma; 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

   

D

Table field

OWNID

   

ID1

End additional R/3 table

+EAI

     

End characteristic category

+EV

     

End substance

+ES

     

End of file

+EOF

     

See also:

Specifying the Sequence of the External Data Structure

Abbreviations and Syntax Rules

Structure of Programming Lines