Table SPRICLINK
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SPRICLINK | SPK | Sales price list search | Sales |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SPK0 | CLE | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| BETCPY | Intercompany | M | 4 | 1 | ||||
| BETFCY | Intersites | M | 4 | 1 | ||||
| BPCGRU | Group customer | BPC | [BPC]BPC0=[SPK]BPCGRU | Other | ||||
| BPCINV | Bill-to customer | BPC | [BPC]BPC0=[SPK]BPCINV | Other | ||||
| BPTNUM | Carrier | BPT | [BPT]BPT0=[SPK]BPTNUM | Other | ||||
| CLCAMT1 | Tax calculation basis 1 | MD1 | ||||||
| CLCAMT2 | Tax calculation basis 2 | MD1 | ||||||
| CLE | Key | A | 3 | |||||
| CPY | Sales company | CPY | [CPY]CPY0=[SPK]CPY | Other | ||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[SPK]CREUSR | Other | ||||
| CRY | Country | CRY | [TCY]TCY0=[SPK]CRY | Other | ||||
| CSTTYP | Cost type | M | 15 | 219 | ||||
| CUSORDREF | Customer order ref | A | 20 | |||||
| ECCVALMAJ | Major version | ECS | ECC | |||||
| ECCVALMIN | Minor version | EVL | ECC | |||||
| EECICT | Incoterm | ICT | [ICTH]ICT0=[SPK]EECICT | Other | ||||
| FOCITM | Free product | M | 4 | 1 | ||||
| LINTYP | Line type | M | 20 | 423 | ||||
| LINTYP_A | Line category | M | 30 | 469 | ||||
| LINTYP_B | Product cat. | M | 30 | 470 | ||||
| LINTYP_C | Component C. | M | 30 | 471 | ||||
| MDL | Delivery mode | MDL | [TMD]TMD0=[SPK]MDL | Other | ||||
| PCK | Packaging | PCK | [TPA]TPA0=[SPK]PCK | Other | ||||
| PJT | Project | PJT | [PIM]PIM0=[SPK]PJT | Block | ||||
| PJTNUM | Project number | PJT | [PIM]PIM0=[SPK]PJTNUM | Block | ||||
| PLIBPRCNR | BP concerns | M | 15 | 2210 | ||||
| PNTITMREF | Parent product | ITS | [ITS]ITS0=PNTITMREF | RTZ | ||||
| PTE | Payment term | PTE | [TPT]TPT0=PTE;[V]GCURLEG;1 | Other | ||||
| SALFCY | Sales site | FCY | [FCY]FCY0=[SPK]SALFCY | Other | ||||
| SAT | Subdivision | SAT | ||||||
| SOHTYP | Order type | TSO | [TSO]TSO0=SOHTYP;[V]GSUPCLE | Other | ||||
| STOFCY | Shipment site | FCY | [FCY]FCY0=[SPK]STOFCY | Other | ||||
| TSCCOD | Statistical group | ADI | [ADI]CODE=indice+30;TSCCOD(indice) | Other | STC | |||
| TSICOD | Statistical group | ADI | [ADI]CODE=indice+20;TSICOD(indice) | Other | STI | |||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[SPK]UPDUSR | Other | ||||
| USEPLC | Location reference | A | 30 | |||||
| VACBPR | Tax rule | TVB | [TVB]TVB0=VACBPR;[V]GSUPCLE | Other |