Table SPRICLIST
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SPRICLIST | SPL | Customer price lists | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SPL0 | PLI+PLICRD+PLILIN | No | |
| SPL1 | PLI+PLICRI+PLISTRDAT | Yes | |
| SPL2 | PLI+PLICRI1+PLISTRDAT | Yes | |
| SPL3 | PLI+PLICRI2+PLISTRDAT | Yes | |
| SPL4 | PLI+PLICRI1+PLICRI2+PLICRI3+PLICRI4+PLICRI5 | 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=[SPL]CPNITMREF | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CUR | Currency | CUR | [TCU]TCU0=[SPL]CUR | Block | ||||
| DCGVAL | Charge/discount value | MD8 | SPR | |||||
| EXPNUM | Export number | L | 8 | |||||
| FOCAMTBKT | Free Class | MD1 | ||||||
| FOCAMTMIN | Free threshold | MD1 | ||||||
| FOCITMREF | Free product | ITM | [ITM]ITM0=[SPL]FOCITMREF | Block | ||||
| FOCQTY | Free quantity | QTY | ||||||
| FOCQTYBKT | Free Class | QTY | ||||||
| FOCQTYMIN | Free threshold | QTY | ||||||
| FOCUOM | Unit | UOM | [TUN]TUN0=[SPL]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 | SPC | [SPC]SPC0=[SPL]PLI | Delete | ||||
| PLICRD | Price list record | VCR | ||||||
| PLICRI | Criteria | SPX | ||||||
| PLICRI1 | Criteria 1 | SPU | ||||||
| PLICRI2 | Criteria 2 | SPU | ||||||
| PLICRI3 | Criterion 3 | SPU | ||||||
| PLICRI4 | Criterion 4 | SPU | ||||||
| PLICRI5 | Criterion 5 | SPU | ||||||
| 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=[SPL]UOM | Block | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |