Table PPRICLIST
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PPRICLIST | PPL | Supplier price lists | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PPL0 | PLI+PLICRD+PLILIN | No | |
| PPL1 | PLI+PLICRI+PLISTRDAT | Yes | |
| PPL2 | PLI+PLICRI1+PLISTRDAT | Yes | |
| PPL3 | PLI+PLICRI2+PLISTRDAT | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| COMCOE | Comm factor | CCR | ||||||
| CPNITMREF | Component | ITM | [ITM]ITM0=[PPL]CPNITMREF | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CUR | Currency | CUR | [TCU]TCU0=[PPL]CUR | Block | ||||
| DCGVAL | Charge/discount value | MD8 | PPR | |||||
| EXPNUM | Export number | L | 8 | |||||
| FOCAMTBKT | Free Class | MD1 | ||||||
| FOCAMTMIN | Free threshold | MD1 | ||||||
| FOCITMREF | Free product | ITM | [ITM]ITM0=[PPL]FOCITMREF | Block | ||||
| FOCQTY | Free quantity | QTY | ||||||
| FOCQTYBKT | Free Class | QTY | ||||||
| FOCQTYMIN | Free threshold | QTY | ||||||
| FOCUOM | Unit | UOM | [TUN]TUN0=[PPL]FOCUOM | Block | ||||
| IMPNUMLIG | Import line | L | 8 | |||||
| LTI | Lead time | C | 3 | |||||
| MAXAMT | Maximum value | MD1 | ||||||
| MAXQTY | Maximum quantity | QTY | ||||||
| MINAMT | Minimum value | MD1 | ||||||
| MINQTY | Minimum quantity | QTY | ||||||
| PLI | Price list code | PLI | ||||||
| PLICRD | Price list record | VCR | ||||||
| PLICRI | Criteria | PPX | ||||||
| PLICRI1 | Criteria 1 | PPU | ||||||
| PLICRI2 | Criteria 2 | PPU | ||||||
| PLICRI3 | Criterion 3 | PPU | ||||||
| PLICRI4 | Criterion 4 | PPU | ||||||
| PLICRI5 | Criterion 5 | PPU | ||||||
| PLIENDDAT | Validity end date | D | ||||||
| PLILIN | Line | L | 8 | |||||
| PLISTRDAT | Validity start date | D | ||||||
| PRI | Price | MD8 | ||||||
| PRIDIV | Price factor | C | 4 | |||||
| UOM | Unit | UOM | [TUN]TUN0=[PPL]UOM | Block | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |