Table PPRIVARWRK
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
PPRIVARWRK | PPV | Purchase price variance report | Purchasing |
Key | Description | Duplicates | Activity code |
---|---|---|---|
PPV | PID | Yes |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
AUUID | Single identifier | AUUID | ||||||
BPSNAM | Company name | NAM | ||||||
BPSNUM | Supplier | BPS | [BPS]BPS0=[PPV]BPSNUM | Other | ||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | User | AUS | [AUS]CODUSR=[PPV]CREUSR | Other | ||||
CSTTOT | Total cost | MD8 | ||||||
CUR | Currency | CUR | [TCU]TCU0=[PPV]CUR | Block | ||||
FCY | Site | FCY | [FCY]FCY0=[PPV]FCY | Block | ||||
ITMDES1 | Description 1 | DES | ||||||
ITMREF | Product | ITM | [ITM]ITM0=[PPV]ITMREF | Block | ||||
NETPRI | Net price | MD8 | ||||||
NUM | Invoice number | VCR | ||||||
PID | Processes | A | 20 | |||||
PIDPRI | Invoice price | MD8 | ||||||
PLIN | Line | L | 8 | |||||
PNUM | Document no. | VCR | ||||||
POHNUM | Order no. | VCR | ||||||
QTYSTU | STK quantity | QTY | ||||||
STKVAR | Stock itm variance | MD8 | ||||||
STU | Stock unit | UOM | [TUN]TUN0=[PPV]STU | Block | ||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | User | AUS | [AUS]CODUSR=[PPV]UPDUSR | Other |