Below are steps to import a sample Sales Order.


Step 1 - Complete the follow data in DTW import templates.

 

ORDR - DocumentsInput of Sales Order header information
RDR1 - Document_LinesInput of Sales Order Line details
RDR3 - DocumentsAdditionalExpensesInput 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.