You can find a detailed description of customer-specific settings in Customizing under
.Customer-specific settings for the ASCII Adapter are made in the following files and tables:
CRMASCAD.PAR (maintain main parameter file)
In the parameter file CRMASCAD
, you define, for example, the directory structures for the ASCII Adapter and you enter information about the database to be used.
SMO7ASCAD (maintain control table for data conversion)
In the main control table SMO7ASCAD
, you define the names of the temporary tables in the CDB and the names of the ASCII files.
SMO7ASCSTR (maintain structure definition table)
In the structure definition table, SMO7ASCSTR
, you define the structure of the ASCII files at field level.
Part of structure definition table SMO7ASCSTR for material information with fixed record length:
FIELDNAME |
FIELDCOLUMN |
FIELDLEN |
FIELDTYPE |
---|---|---|---|
ARTNR |
1 |
5 |
C |
BEZ1 |
6 |
20 |
C |
BEZ2 |
26 |
20 |
C |
BEZ3 |
46 |
20 |
C |
KURZBZ |
66 |
20 |
C |
WERK |
86 |
2 |
C |
VOEAN |
88 |
2 |
C |
EANNR |
90 |
13 |
C |
EINHEI |
103 |
2 |
C |
NETTO |
105 |
7 |
N |
BRUTTO |
112 |
7 |
N |
ERFASS |
119 |
8 |
D |
Length |
1 |
126 |
Part of structure definition table SMO7ASCSTR for material information with delimiters:
FIELDNAME |
FIELDCOLUMN |
FIELDLEN |
FIELDTYPE |
---|---|---|---|
ARTNR |
1 |
N/A |
C |
BEZ1 |
2 |
N/A |
C |
BEZ2 |
3 |
N/A |
C |
BEZ3 |
4 |
N/A |
C |
KURZB |
5 |
N/A |
C |
WERK |
6 |
N/A |
C |
VOEAN |
7 |
N/A |
C |
EANNR |
8 |
N/A |
C |
EINHEI |
9 |
N/A |
C |
NETTO |
10 |
N/A |
N |
BRUTTO |
11 |
N/A |
N |
ERFASS |
12 |
N/A |
D |
Part of the ASCII file using delimiters:
00001,,,,Material 1,NI,,192837AN125M,,32,35,01.06.95
00002,,,,Material 2,OM,,,,32,35,01.06.95