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