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