For more details on customer-specific settings, see your SAP Implementation Guide under Customer Relationship Management ® CRM Middleware and Related Components ® External Data Load ® ASCII Adapter Setup.
Customer-specific settings for the ASCII Adapter are made in the following files and tables:
In this parameter file, you define, for example, the directory structures for the ASCII Adapter and you enter information on the database to be used.
In the main control table SMO7ASCAD, you define the names of the temporary tables in the CDB, the names of the ASCII files, and so on.
In the structure definition table, SMO7ASCSTR, you define the structure of the ASCII files at field level.
Example of SMO7ASCSTR
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 |
C |
|
BEZ1 |
2 |
C |
|
BEZ2 |
3 |
C |
|
BEZ3 |
4 |
C |
|
KURZB |
5 |
C |
|
WERK |
6 |
C |
|
VOEAN |
7 |
C |
|
EANNR |
8 |
C |
|
EINHEI |
9 |
C |
|
NETTO |
10 |
N |
|
BRUTTO |
11 |
N |
|
ERFASS |
12 |
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