Table CCMIMPITMDET
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| CCMIMPITMDET | CCMITMD | Impact analysis-Stock sites | Common Data | CCM |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CCMITD0 | CRID+LINENO | No | |
| CCMITD1 | CRID+SORTSEQ | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACTIONER | Actioner | CCMAUS | [AUS]CODUSR=[CCMITMD]ACTIONER | Block | ||||
| ACTIONID | Action ID | CCMACT | ||||||
| AUUID | Single identifier | AUUID | ||||||
| BLOCK | Block | M | 4 | 1 | ||||
| COMMENT | Comment | A | 50 | |||||
| COMPLETEDATE | Complete by | D | ||||||
| CREDATTIM | Created on | ADATIM | ||||||
| CREUSR | Creation user | AUS | [AUS]CODUSR=[CCMITMD]CREUSR | Other | ||||
| CRID | Request ID | CCMCRID | ||||||
| ECCVALMAJ | Major version | CCMECS | ECC | |||||
| ECCVALMIN | Minor version | CCMEVL | ECC | |||||
| ENDDATE | End date | D | ||||||
| FCYORDSTO | On reorder | QTY | ||||||
| FCYPHYALL | Total allocated | QTY | ||||||
| FCYPHYSTO | Available stock | QTY | ||||||
| FCYSALSTO | On sales orders | QTY | ||||||
| ITMREF | Product | ITM | [ITM]ITM0=[CCMITMD]ITMREF | Block | ||||
| LINENO | No. | C | 4 | |||||
| LINESTATUS | Status | M | 15 | 2040 | ||||
| SORTSEQ | Sort sequence | C | 4 | |||||
| STARTDATE | Start date | D | ||||||
| STOFCY | Storage site | FCY | [FCY]FCY0=[CCMITMD]STOFCY | Block | ||||
| TRANTYPE | Transaction type | M | 15 | 2039 | ||||
| UPDDATTIM | Updated on | ADATIM | ||||||
| UPDUSR | Updated by | AUS | [AUS]CODUSR=[CCMITMD]UPDUSR | Other |