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