Table STOALL
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| STOALL | STA | Allocations | Stock |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| STA0 | STOFCY+ITMREF+STOCOU+SEQ | No | |
| STA1 | VCRTYP+VCRNUM+VCRLIN+VCRSEQ+STOCOU | Yes | |
| STA2 | ITMREF+VCRTYP+VCRNUM+VCRLIN+VCRSEQ+ALLTYP+STOFCY | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ALLDAT | Reservation ends | D | ||||||
| ALLTYP | Allocation type | M | 15 | 294 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BESDAT | Requirement date | D | ||||||
| BPAADD | Delivery address | ADR | ||||||
| BPRNUM | BP | BPR | [BPR]BPR0=[STA]BPRNUM | Other | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| DEFLOC | Def consump. locn. | EMP | ||||||
| DEFLOCTYP | Default consump locn type | A | 5 | |||||
| DEFWRH | Default conso whouse | DEP | ||||||
| ECCVALMAJ | Major version | ECS | ECC | |||||
| EXPNUM | Export number | L | 8 | |||||
| ITMREF | Product | ITM | [ITM]ITM0=[STA]ITMREF | Block | ||||
| LOC | Location shortage | EMP | ||||||
| LOT | Lot shortage | LOT | ||||||
| MVTDES | Movement description | DES | ||||||
| PRECOD | Preparation code | PRC | ||||||
| PRENUM | Picking no. | VCR | ||||||
| QTYSTU | STK quantity | QTY | ||||||
| QTYSTUACT | Active quantity STK | QTY | ||||||
| SCOFLG | Type of supply | M | 30 | 2225 | ||||
| SEQ | Sequence | L | 8 | |||||
| SERNUM | Serial number in shortage | SER | ||||||
| SLO | Sublot shortage | SLO | ||||||
| SRGLIN | No. list lines | L | 8 | |||||
| SRGLOC | Consumption location | EMP | ||||||
| SRGNUM | Storage list no. | VCR | ||||||
| SRGQTYSTU | Storage quantity STK | QTY | ||||||
| STA | Shortage status | A | 3 | |||||
| STOCOU | Chronological stock | DCB | 10 | |||||
| STOFCY | Storage site | FCY | [FCY]FCY0=[STA]STOFCY | Block | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VCRLIN | Entry line no. | L | 8 | |||||
| VCRNUM | Order no. | VCR | ||||||
| VCRSEQ | Document sequence no. | L | 8 | |||||
| VCRTYP | Entry type | M | 15 | 701 | ||||
| WRH | Shortage warehouse | DEP |