Table CBNDET
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| CBNDET | CBD | MRP detail | Stock |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CBD0 | STOFCY+ITMREF+BUC+REQDAT+WIPTYP+WIPNUM | No | |
| CBD1 | STOFCY+SUGTYP+SUGSTA+SUGNUM | Yes | |
| CBD2 | STOFCY+ITMREF+WIPTYP+WIPSTA | Yes | |
| CBD3 | ITMREF+STOFCY+BUC+REQDAT+WIPTYP+WIPNUM | No | |
| CBD4 | ITMREFORI+STOFCY+WIPTYP+WIPSTA | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ALLQTY | Allocated quantity | QTY | ||||||
| AUUID | Single identifier | AUUID | ||||||
| BOMALT | BOM code | TBO | [TBO]TBO0=BOMALTTYP;BOMALT | Delete | ||||
| BOMALTTYP | BOM type | M | 15 | 224 | ||||
| BOMOFS | Operation lead time | C | 4 | |||||
| BOMOPE | Operation number | OPE | ||||||
| BPRNUM | Source BP | BPR | [BPR]BPR0=[CBD]BPRNUM | Other | ||||
| BUC | Period | C | 4 | |||||
| COVQTY | Coverage quantity | QTY | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| DEMBUC | Demand period | L | 8 | |||||
| ECCVALMAJ | Major version | ECS | ECC | |||||
| ECCVALMIN | Minor version | EVL | ECC | |||||
| ENDDAT | End date | D | ||||||
| EXPNUM | Export number | L | 8 | |||||
| EXTQTY | Planned quantity | QTY | ||||||
| ITMREF | Product | ITM | [ITM]ITM0=[CBD]ITMREF | BSRA | ||||
| ITMREFORI | Source product | ITM | [ITM]ITM0=[CBD]ITMREFORI | BSRA | ||||
| MRPDAT | MRP date | D | ||||||
| MRPMES | MRP message | M | 15 | 318 | ||||
| MRPQTY | MRP quantity | QTY | ||||||
| MTOQTY | Quantity assigned | QTY | ||||||
| MTOREF | MTO network | MTO | [MTO]MTO0=MTOREF | RTZ | ||||
| PJT | Source project | PJT | [PIM]PIM0=[CBD]PJT | Block | ||||
| REQDAT | Requirement date | D | ||||||
| REQQTY | Demand/Supply | QTY | ||||||
| RMNEXTQTY | Remaining quantity | QTY | ||||||
| RPLFLG | Re-planning flag | M | 4 | 1 | ||||
| STOFCY | Storage site | FCY | [FCY]FCY0=[CBD]STOFCY | Block | ||||
| STOQTY | Available stock | QTY | ||||||
| STRDAT | Start date | D | ||||||
| SUGNUM | Order no. | VCR | ||||||
| SUGSTA | WIP status | M | 1 | 342 | ||||
| SUGTYP | Order type | M | 2 | 341 | ||||
| TRCFLG | Log | M | 4 | 1 | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[CBD]UPDUSR | Other | ||||
| VCRLIN | Entry line no. | L | 8 | |||||
| VCRNUM | Entry | VCR | ||||||
| VCRSEQ | Document sequence no. | L | 8 | |||||
| VCRTYP | Entry type | M | 15 | 701 | ||||
| WIP | In progress | M | 4 | 1 | ||||
| WIPLINORI | Source line | L | 8 | |||||
| WIPNUM | Order no. | VCR | ||||||
| WIPNUMORI | Source order no. | VCR | ||||||
| WIPSEQORI | Source sequence | L | 8 | |||||
| WIPSTA | WIP status | M | 1 | 342 | ||||
| WIPSTAORI | Source status in progress | M | 1 | 342 | ||||
| WIPTYP | Order type | M | 2 | 341 | ||||
| WIPTYPORI | Source order type | M | 2 | 341 |