| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 3 | WHGBE | CMC: Key for Rotable Inventory Group | nvarchar | 16 | 0 | CHAR | (N' ') | No | | ADPM_IVGRPKEY | Allow NULL? |
| 4 | LGGRP | Inventory Group ID (Rotable Control) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ADPM_LGGRP | Allow NULL? |
| 5 | PRHIT | Hits in Days (Goods Movements in the Past) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ADPM_HITRATE | Allow NULL? |
| 6 | PRIND | Period Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | PERKZ | Allow NULL? |
| 7 | PRBCK | CMC: Periods Used for ROC Calculation | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ADPM_PRROC | Allow NULL? |
| 8 | PRFWD | CMC: Periods Used for ROC Calculation | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ADPM_PRROC | Allow NULL? |
| 9 | MNWHG | Main Inventory Group Indicator (Default) | char | 1 | 0 | CHAR | (N' ') | Yes | | ADPM_MAINWHG | Allow NULL? |
| 10 | MXTAT | Maximum Shopfloor Turnaround Time | decimal | 9 | 3 | QUAN | ((0)) | Yes | | ADPM_MXTAT | |
| 11 | TATUN | Normal duration/unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | DAUNORE | Allow NULL? |
| 12 | MXUSV | Maximum Stock Level of Unserviceable Parts (Used by CMC) | decimal | 13 | 3 | QUAN | ((0)) | Yes | | ADPM_MXUSVQTY | |
| 13 | TGROC | CMC: Target Stock for ROC Calculation | decimal | 13 | 3 | QUAN | ((0)) | Yes | | ADPM_ROCEND | |
| 14 | ITROC | CMC: Initial Range of Coverage [Days] | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ADPM_INITROC | Allow NULL? |
