Import/export template > Module Purchasing > Import/export template PPL (Purchase price lists)
Purchase price lists
Price lists are defined by a structure code and a list number. They consist of a header and several lines.
All lists for a given price code have lines based on the same structure. The validity dates are linked to the list and are the same for every line.
Prerequisite
Operation
The main OBJect is automatically detected with the main key corresponding to the price code and the list number.
The details lines are detected according to two criteria in this order:
1. Search with the line number if it is set up and assigned.
If the line exists, it is modified otherwise it is created.
This line number assigned during creation is unknown to the provider that transmits its prices. It is less suitable for line modification.
2. Search with the import line number IMPNUMLIG if it is set up and assigned.
If the line exists, it is modified otherwise it is created.
This line number is not specified during price creation. It is incremented during price import and enables to keep a number transmitted by the provider. If the import line number is zero, it is a creation.
Other prerequisites
Tables to be completed
The following tables are used by the function. Their content must be updated if necessary :
Table | Table description |
|---|---|
PPRICLIST [PPL] | Supplier price lists |
Mandatory fields in the template
In file PPRICLIST, criteria are grouped in a single element PLI.
In the template, they must be separately defined in the global variables.
- Criterion 1 = GIMP(1).
- Criterion 2 = GIMP(2).
- Criterion 3 = GIMP(3).
- Criterion 4 = GIMP(4).
- Criterion 5 = GIMP(5).
A specific variable is assigned to each criterion.
These correspondences must not be swapped.
Tables used
This template can be used in import and export modes. The data is updated in the following tables :
Table | Table description |
|---|---|
BPARTNER [BPR] | |
BPSUPPLIER [BPS] | |
BPSUPPMVT [MVS] | Supplier transactions |
ITMBPS [ITP] | |
ITMFACILIT [ITF] | |
ITMMASTER [ITM] | |
PPREASON [PPR] | |
PPRICCONF [PPC] | |
PPRICFICH [PPF] | |
PPRICLIST [PPL] | Supplier price lists |
PRICSTRUCT [PRS] | |
TABCUR [TCU] | |
TABUNIT [TUN] |