Show TOC

Background documentationCustomer-Specific Settings

 

You can find a detailed description of customer-specific settings in Customizing under Start of the navigation path Customer Relationship Management Next navigation step CRM Middleware and Related Components Next navigation step Exchanging Data with External Components Next navigation step ASCII Adapter Setup End of the navigation path.

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.

Example

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