Ansicht
Dokumentation
ASCII_ADAPTER_ASCAD - Maintain Data Conversion Control Table
General Material Data Addresses (Business Address Services)This documentation is copyright by SAP AG.
Table SMO7ASCAD is the main control table for converting data.
In table SMO7ASCAD, you specify information such as the name of the temporary CDB table, the name of the ASCII file, or the name of the structure definition table. It contains one entry per conversion direction and temporary CDB table.
The table is empty to start with and must be filled with data as part of the customizing process for each ASCII file to be processed. This can be done either manually or automatically.
Entries in this table dominate the settings in the parameter file CRMASCAD.
Before you can work with the ASCII Adapter, you have to fill table SMO7ASCAD for each ASCII file to be processed. This can be done either manually or automatically. Automatically generated entries can afterwards be changed manually.
Example
Filling the Table Manually:
You have two options for manually filling table SMO7ASCAD.
- Via the main menu of the CRM System:
- Choose Tools-> ABAP Workbench -> Development → Dictionary.
- Enter SMO7ASCAD as the database table you want to edit.
- Make the required entries.
- Via the command field of the CRM System:
- Call up transaction ASC2.
- In the displayed dialog box, enter the name of the temporary table for which you want to fill table SMO7ASCAD.
- ChooseTable information, enter the required information into the displayed dialog box and save your entries.
Filling the Table Automatically:
To fill table SMO7ASCAD automatically, you have to call up the ASCII adapter in order to start automatic generation.
- Go to the MS-DOS command mode and call up the ASCII Adapter as follows:
-
CRMASCAD
-G [[<table-2>] ]
-
The value of
determines the kind of generation (see table below). Elements in brackets ([ ]) are optional.
- Specify at least one table for the automatic generation. If you specify a table that has already been generated, this table will be skipped (which means that it will not be overwritten).
The information required for an automatic generation is partly information on the specified table(s) that comes from the corresponding database catalog, and partly information coming from parameter file CRMASCAD.
To be able to fill table SMO7ASCAD automatically, you need to have an insert permission for this table.
Table SMO7ASCAD requires the following entries:
Field | Manual Entry | Automatic Filling |
---|
ACT,,Direction of the conversion,,Is filled with the value of <act>
Available options are: | (see program call above). | |
A (from ASCII to DBMS) | ||
B (from ASCII to DBMS with delimiters) | ||
D (from DBMS to ASCII) | ||
E (from DBMS to ASCII with delimiters) | ||
DBFNAME | Name of the temporary CDB table. | Is filled with the name of |
This name must be unique | the temporary CDB table, | |
throughout the entire system. | for which generation is to be | |
If a table is imported and exported | performed (see program | |
use different names in the CDB. | call above). | |
Customer tables must begin with the | letter Y or Z. | |
ASCNAME | Name of the ASCII file. | Is filled with the value of |
The full path is specified in parameter | ||
file CRMASCAD. | ||
CONVTABLE | Not applicable | Not applicable |
SHOWSUCC | Name of the result file in the LOG directory. | Is filled withthe value of |
SATZDELI | Separator (delimiter) to be used between | Is filled with the default |
data records in the ASCII file. | value ASCII 10,13 (return, | |
The default value is ASCII 10,13 | linefeed). | |
(carriage return, linefeed). | ||
If you do not enter a delimiter, this default | ||
value will be used. | ||
DEZDELI | Character to be used to separate whole | Is filled with a value from |
numbers from decimal fractions in numeric | parameter file | |
fields. The default value is ".". | CRMASCAD with either | |
If you do not specify any value, this default | #A2D_DeliWith or | |
value will be used. | #D2A_DeliWith, depending onthe value of |
|
MODAT | Currently not used | Currently not used |
MEMODELI | Currently not used | Currently not used |
READLINE | Currently not used | Currently not used |
DATEFORMAT | Format for date fields. | Is filled with the value of |
Available options are: | #ATODateFormat from parameter | |
DD.MM.YY | file CRMASCAD. | |
YYYYMMDD | ||
EXT_BUFFER | Number of lines a processing block | Is filled with 10 for LONG fields |
is to contain for database operations | and with 500 for any other fields. | |
(values between 100 and 500 arerecommended). | ||
EXT_ZAPTBL | Specifies whether source and | Is filled with 3. |
target tables are to be cleared | ||
(i.e. values deleted) before external | ||
data is imported. | ||
Available options are: | ||
0 or N (tables remain as they are, | ||
i.e. new data is appended) | ||
1, J or Y (target tables are cleared | ||
before an import, target files are deleted | ||
before an export) | ||
2 (source files are deleted after an import, | ||
source tables are cleared after an export) | ||
3 (combination of 1 and 2) | ||
SMO7ASCAD | GUID (not applicable) | Is filled with a valid GUID. |
SELCLAUSE | Static WHERE clause for the database | Is not automatically filled. |
selection (SQL SELECT) of the ASCII | ||
Adapter (only relevant for data export from | ||
temporary CDB tables). |
SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up BAL_S_LOG - Application Log: Log header data
This documentation is copyright by SAP AG.
Length: 10599 Date: 20240524 Time: 000703 sap01-206 ( 77 ms )