Show TOC

Create Import Files Using CATT

*.TXT files are generated on the frontend in the directory in which you have installed SAPGUI using predefined test procedures from the Computer Aided Test Tools (CATTs). These *.TXT files contain the fields to be filled (import parameters).

After you have completed these files with your own import data (with MS Excel, for example), make the files for the corresponding IMG activity available.

Standard Settings

The following test procedures are delivered in the R/3 standard system for the first database in the R/3 Dangerous Goods Management component.

Test procedure IMG activity
DG_CUST_DGCV Transfer UN numbers
DG_CUST_DGCA Transfer hazard notes
DG_CUST_DGCD Transfer hazard-inducing substances
DG_DATA2_DGP1 Transfer dangerous goods masters

Activities

1. Creating the *.TXT files
a) Choose Tools -> ABAP Workbench -> Test -> Test Workbench -> CATT -> Edit test case.
The Computer Aided Test Tool: Initial Screen appears.
b) In the Test case field, enter a key for a standard test procedure in the R/3 Dangerous Goods Management component (DG_CUST_DGCV, for example).
c) Choose Goto -> External variants -> Export defaults.
A dialog box appears in which the R/3 System proposes a path for the *.TXT-Datei. The test procedure key with file ending *.TXT is proposed as file name (C:\sappcadm\DG_CUST_DGCV.TXT , for example).
d) Choose Transfer.
The R/3 System exports the file to the directory entered.
2. Maintaining *.TXT files in Excel
a) Call the generated *.TXT files in Microsoft Excel (see the notes below on Microsoft Excel).
The sequential ASCII *.TXT file displayed consists of the following lines:
Line 1: import parameter (the character '&' is not transferred)
Line 2: short texts
Line 3: no values
Note: the third line is reserved for default values that are not available for the existing dangerous goods text procedures.
Line 4: contains the text "Changes to the default values displayed above are not effective". This text must be deleted.
From and including the fourth line, the values are entered.
3. Processing test files
a) Step 1
To create the test files, take the sample data from the relevant documentation for the corresponding IMG activities, and enter this data in the fourth line (the third line should remain empty).
b) Step 2
If the test was successful, enter the data to be imported from the fourth line onwards. If not, repeat the sequence above until the the data have been transferred correctly to the R/3 System. The data transferred to the R/3 System in the previous test must be deleted manually in a new test.
Notes on Microsoft Excel:
When you open the file, the Text Import Wizard - Step 1 of 3 dialog box appears.
Retain "Delimited - characters such as commas or tabs separate each field " (flagged as standard in Excel 4.0).
Proceed to step 2 of 3, and choose an apostrophe in the Text Qualifier field. Set the check box in the separator to tab.
Proceed to step 3 of 3, and flag all columns. Then choose the radio button text to select the column data format. Choose Finish.
Notes on maintaining data in Microsoft Excel
c) If the test was successful, enter the data to be imported from the fourth line on.
Notes on maintaining data:
d) Save the file as an Excel 4.0 *.TXT file. Choose the name of the corresponding test procedure as the file name DG_CUST_DGC3.TXT, for example).
General notes on the R/3 System: