Below are steps to import a sample Sales Order.
Step 1 - Complete the follow data in DTW import templates.
| ORDR - Documents | Input of Sales Order header information |
| RDR1 - Document_Lines | Input of Sales Order Line details |
| RDR3 - DocumentsAdditionalExpenses | Input of Freight details |
Please refer to sample data with file name ends with 'TEST'
Please note :
- The above generic template only contain few sample columns for test import only.
- Freight import is optional. For Freight Code, please check the field value in table OEXD. The fieldname for Freight code is ExpnsCode.
Step 2 - Save data into Tab-deliminated format
In each of the DTW import template, save the file as 'Tab-Delimited' text file.
Below are example of files saved as Tab-delimited Text File.
Step 3 - Import data via DTW
Logon to DTW.
Please test import with TEST Dummy company before proceed with import to Production Company. Imported transaction cannot be reversed.
Select 'Transactional Data'.
Select 'Add New Data'
Select 'Sales Order'
Select the relevant text file for import:
| Documents (Sales Order Header) | ORDR - Documents |
| Document_Lines (Sales Order Line) | RDR1 - Document_Lines |
| DocumentAdditionalExcenses (Freight) | RDR3 - DocumentsAdditionalExpenses |
Select Source Data tab and check data for each file, if required
Select 'Ignore up to 10 Errors ' option and Run Simulation to test import.
Please troubleshoot each column in the source file, if the test import failed.
Below is a sample of successful Test Import
Click Next and select Import to proceed import.
A successful import is shown as below.
Inspect data in SAP document to confirm.
