Table PIWRK
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PIWRK | PKW | Temporary journal traceability | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SKW0 | PRONUM+LEV | No | |
| SKW1 | CREUSR+CREDAT+PRONUM+LEV | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCNUM | Internal number | L | 8 | |||||
| AUUID | Single identifier | AUUID | ||||||
| BPRNUM | BP | BPR | [BPR]BPR0=[PKW]BPRNUM | Other | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CURVCR | Currency | CUR | [TCU]TCU0=[PKW]CURVCR | Other | ||||
| DUDLIG | Due date number | C | 3 | |||||
| IPTDAT | Entry date | D | ||||||
| JOU | Journal | JOU | [JOU]JOU0=JOU;[V]GSUPCLE | Other | ||||
| LEV | Level | A | 60 | |||||
| LEVALP | Level | A | 20 | |||||
| LEVNUM | Level | C | 2 | |||||
| ORDATI | Line amt. + tax | MD1 | ||||||
| ORDATID | Line amt. + tax (folder) | MD1 | ||||||
| ORDATIL | Line amt. + tax (company) | MD1 | ||||||
| ORDNOT | Line amt. - tax | MD1 | ||||||
| ORDNOTD | Line amt. - tax (folder) | MD1 | ||||||
| ORDNOTL | Line amt. - tax (company) | MD1 | ||||||
| PRONUM | Search | A | 50 | |||||
| PROUID | Process number | L | 8 | |||||
| REP1 | Sales rep 1 | REP | [REP]REP0=[PKW]REP1 | BSRA | RE1 | |||
| REP2 | Sales rep 2 | REP | [REP]REP0=[PKW]REP2 | BSRA | RE2 | |||
| SALFCY | Sales site | FCY | [FCY]FCY0=[PKW]SALFCY | Other | ||||
| SEL | Sign | A | 20 | |||||
| STOFCY | Shipment site | FCY | [FCY]FCY0=[PKW]STOFCY | Other | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[PKW]UPDUSR | Other | ||||
| VCRLIN | Entry line no. | L | 8 | |||||
| VCRLINORI | Source document line | L | 8 | |||||
| VCRNUM | Entry | A | 40 | |||||
| VCRNUMCALC | Calculation journal | A | 40 | |||||
| VCRNUMORI | Original document | A | 40 | |||||
| VCRSTAT1 | Part status | DCO | ||||||
| VCRSTAT2 | Part status | DCO | ||||||
| VCRSTAT3 | Part status | DCO | ||||||
| VCRSTAT4 | Part status | DCO | ||||||
| VCRTYP | Entry type | M | 15 | 477 | ||||
| VCRTYPORI | Source document type | M | 15 | 477 |