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:
- Select the entire Excel table, and define the
cells as text under Category by choosing
Format -> Cells -> Number.
- When entering values, remember to include the
leading zeros.
- If a field in the R/3 System has possible
entries facility, check the permitted values online. Enter one permitted value
only for the corresponding import parameter.
- You must enter a value in all required fields
online.
- If you do not want to fill a cell, enter
!. Cells may not be empty, apart from cells along
the third line.
- Maintain one new variant (data record) for
each line.
- To import a data record, you must have entered
the key value from the data record.
- The R/3 System transfers check boxes if they
are flagged.
- You can maintain up to 99,999 data
records.
- When carrying out the import, the R/3 System
reads the values from the fourth line onwards.
- Be very careful when working with excel.
Please ensure that you do not mix up any fields, for example.
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:
- Existing data records are not deleted for
first database. The system simply notes in the log that this item already
exists.
- Entries to be overwritten must be deleted
manually beforehand.
- The Excel document must be closed before it is
imported into the R/3 System.
- A check routine permits date entries for
01.01.1300 or later.
- The material must have been created
already.
- Engineering change management (changing with
change numbers) can be used.
- The system parameter
rdisp/max_wprun_time can be used to prevent any overlapping time
intervals in the R/3 System. To use this, contact your system
administrator.
- Input fields can appear several times online.
However, they only appear once in file currently being processed.
- If an error message occurs in the log, the
test process can be restarted by positioning the cursor on the test process,
and choosing "Execute". This causes the test process to restart with
processing mode in the foreground. In this mode, you can filter the fields
where the errors occurred.
- Under the path System -> User profile ->
Own data, fixed values should be entered in decimal point format.
- To enter character strings, the string must
begin with two single apostrophes, and end with one single apostrophes
(''string', for example).