Example: Transfer File for Specifications

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 table

+BV

$ESTRH

Table field

SUBID

IU-91236

Table field

SUBCAT

REAL_SUB

......Table field

OWNID

ID1

End table

+EV

Begin table

+BV

$ESTRI

Table field

IDTYPE

NUM

Table field

IDCAT

CAS

Table field

IDENT

91-23-6

Table field

OWNID

ID1

Begin additional table

+BAI

$ESTRL

Table field

SLSTID

EINECS

Table field

OWNID

ID1

End additional table

+EAI

End table

+EV

Begin 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 table

+BAI

$ESTRL

Table field

SLSTID

EINECS

Table field

OWNID

ID1

End additional table

+EAI

End 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 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 table

+EAI

Begin additional 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 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 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 table

+EAI

Begin additional 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 table

+EAI

Begin additional 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 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