A delivery request refers to an existing open order line: the contract and product must exist.
The main file to be set up remains the SORDEC file (contract line). Indeed it is the file linked to the SOQ object.
In the import template for delivery requests, you need to set up two identifiers:
During an import, the existence of the main object (contract line) is recognized automatically by means of the main key representing the contract number, and the line number (SOHNUM + SOPLIN).
The identification of the existence of the detail lines is made, if they exist, in two ways as a function of the presence or not of the quote line number in the import template:
If two lines have the same delivery date, it is necessary to set up the line number in order to differentiate them. If this is not done, it is always the first line corresponding to the search criteria that will be processed.
The import processes the deletion of a line. A request is deleted if it is imported with an ordered quantity equal to zero.
You need to set up the sequencing field (CAD) in order to properly integrate daily, weekly and monthly requests.
This is a special case: this field is neither entered nor displayed in standard mode. However, for imports, the field needs to be set up in order to differentiate the various types of requests.
If the field is no longer present in the template, or is equal to zero, the system considers this is a daily request.
The following tables are used by the function. Their content must be updated if necessary :
Table | Table description |
---|---|
SALESREP [REP] | |
SORDERC [SOC] | Sales orders - early / late |
SORDERQ [SOQ] | Sales orders - quantities |
(*) In some management cases, a contract line being recognized may not depend on the contract line number. In that case, the system makes it possible not to enter these pieces of information. Yet the information provided must make it possible to clearly identify a contract line. In case of uncertainty, the system rejects the import.
The alternate solutions are:
This template can be used in import and export modes. The data is updated in the following tables :
Table | Table description |
---|---|
BPARTNER [BPR] | |
BPCUSTMVT [MVC] | Customer transactions |
BPCUSTOMER [BPC] | |
BPDLVCUST [BPD] | |
FACILITY [FCY] | |
ITMBPC [ITU] | |
ITMFACILIT [ITF] | |
ITMMASTER [ITM] | |
ITMMVT [ITV] | Product-site totals |
ITMSALES [ITS] | |
ITMWRH [ITW] | |
SORDER [SOH] | |
SORDERC [SOC] | Sales orders - early / late |
SORDERP [SOP] | Sales orders - price |
SORDERQ [SOQ] | Sales orders - quantities |
TABSOHTYP [TSO] | |
TABUNAVAIL [TUV] | |
WAREHOUSE [WRH] |