| 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 | WPEXT | External number range for maintenance plan | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WPEXT | Allow NULL? |
| 3 | WPINT | Internal number range for maintenance plan | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WPINT | Allow NULL? |
| 4 | CAPID | Application | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TC04 | CAPID | Allow NULL? |
| 5 | ARTPR | Priority Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T356A | ARTPR | Allow NULL? |
| 6 | EQTYP | Equipment category | char | 1 | 0 | CHAR | (N' ') | Yes | T370T | EQTYP | Allow NULL? |
| 7 | STWAE | Statistics currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | STWAE | Allow NULL? |
| 8 | DIALOG_PRT | Print Online (On = Online, Off = Update) | char | 1 | 0 | CHAR | (N' ') | Yes | | DIALOG_PRT | Allow NULL? |
| 9 | SERUNI | Serial Number Unique to Material | char | 1 | 0 | CHAR | (N' ') | Yes | | SERUNI | Allow NULL? |
| 10 | STLAN | BOM Usage | char | 1 | 0 | CHAR | (N' ') | Yes | T416 | STLAN | Allow NULL? |
| 11 | POSTP | Item Category (Bill of Material) | char | 1 | 0 | CHAR | (N' ') | Yes | T418 | POSTP | Allow NULL? |
| 12 | QLOSMEPM | Unit of Measure for Inspection Lot | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | QLOSMEPM | Allow NULL? |
| 13 | SEL_STRU | Checkbox | char | 1 | 0 | CHAR | (N' ') | Yes | | XFELD | Allow NULL? |
| 14 | SEL_BOM | Checkbox | char | 1 | 0 | CHAR | (N' ') | Yes | | XFELD | Allow NULL? |
| 15 | ILOAI | ILOA Individual | char | 1 | 0 | CHAR | (N' ') | Yes | | ILOAI | Allow NULL? |
| 16 | IBASE_SYNC | Reserve IBASE Synchronization (KA5 -> IBASE_SYNC, IB_IBTYP) | char | 1 | 0 | CHAR | (N' ') | Yes | | IBASE_TEMP | Allow NULL? |
| 17 | IB_IBTYP | IB: Installed Base Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T371A | IB_IBTYP | Allow NULL? |
| 18 | MCP_EXT | Enhancement Multiple Counter Plan | char | 1 | 0 | CHAR | (N' ') | Yes | | IND_MCP_EXT | Allow NULL? |
