You can use the following abbreviations when programming:
One character corresponds to one column,
Blank columns are filled with blanks (
+BC must be followed by three blanks, for example, and then further data is entered from column 7 onwards).
Description of Line |
Column 1-max. 5 |
From Column 7 Onwards |
Comment |
+C |
Up to end of line (column 80) |
Font (ISO-LATIN 1) |
+SC |
ISO-LATIN 1 (max. 30 characters) |
Identification |
+ID |
Database name, max. 30 characters, IUCLID for example |
Version |
+V |
Max. 30 characters, 2.22, for example |
Export date |
+D |
YYYYMMDD, 19970128, for example |
Key date for export |
+VD |
YYYYMMDD, 19970128, for example |
Set languages for export |
+SL |
E, for example |
Date format within the file |
+DF |
DD.MM.YYYY, for example |
Decimal notation within the file |
+DN |
. for example |
The decimal separator and date format are defined in the header of the import file. All values must then comply with this format.
If you do not specify a decimal separator and date format, the data in the file must correspond to the user settings in the system.
Begin data provider |
+BA |
|
Identification |
+ID |
ID1, for example |
Company name |
+NAME |
BASF, for example |
City (headquarters) |
+CITY |
Ludwigshafen, for example |
Country |
+CNTY |
DE, for example |
End data provider |
+EA |
|
Begin phrase library |
+BC |
Library type: max. 30 characters |
End phrase library |
+EC |
|
Begin specification |
+BS |
Official specification name: up to end of line (column 80) |
End specification |
+ES |
|
Begin R/3 table or begin value assignment type |
+BV |
$Table name or name of value assignment (max. 30 characters) |
End R/3 table or end value assignment type |
+EV |
|
Begin additional R/3 table |
+BAI |
$Table name or type of additional information (max. 30 characters) |
End additional R/3 table |
+EAI |
|
End of file |
+EOF |
For value assignment types, the field names are composed of $table name-field name. Example: $ESTVA-UPDDAT
The arrangement of characteristic names and data entries for a value assignment line are displayed in the diagram: Syntax for a Value Assignment Line.
See also:
Example: Transfer File for Phrases Example: Transfer File for Sources Example: Transfer File for Specifications Example: Transfer File for a Property Tree Example: Transfer File for a Report Template