| 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 | IWERK | Maintenance Planning Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | IWERK | Allow NULL? |
| 3 | SVOBJ_ID | Service object ID | nvarchar | 2 | 0 | CHAR | (N' ') | No | | SVOBJ_ID | Allow NULL? |
| 4 | SVOBJ | Service object | nvarchar | 30 | 0 | CHAR | (N' ') | No | | SVOBJ | Allow NULL? |
| 5 | AUART | Order Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T003O | AUFART | Allow NULL? |
| 6 | VAPLZ | Main work center for maintenance tasks | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | GEWRK | Allow NULL? |
| 7 | VAWRK | Plant associated with main work center | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERGW | Allow NULL? |
| 8 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 9 | STDNR | Key for Task List Group | nvarchar | 8 | 0 | CHAR | (N' ') | No | PLKO | PLNNR | Allow NULL? |
| 10 | STDAL | Group Counter | nvarchar | 2 | 0 | CHAR | (N' ') | No | | PLNAL | Allow NULL? |
| 11 | PLNTY | Task List Type | char | 1 | 0 | CHAR | (N' ') | Yes | TCA01 | PLNTY | Allow NULL? |
| 12 | BZGSART | Reference type when creating PM/SM order automatically | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BZGSART | Allow NULL? |
| 13 | BZGSOBJTYP | Technical reference object type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BZGSOBJTYP | Allow NULL? |
| 14 | BZGSOBJ | Technical reference object | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | BZGSOBJ | Allow NULL? |
| 15 | BZGSERNR | Serial Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | GERNR | Allow NULL? |
| 16 | ILART | Maintenance activity type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T353I | ILA | Allow NULL? |
| 17 | KENNZ_AVO | Determine Settlement Rule | char | 1 | 0 | CHAR | (N' ') | Yes | | KENNZ_AVO | Allow NULL? |
| 18 | AUFNR_AVO | Order Template for Copying a Settlement Rule | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | AFIH | AUFNR_AVO | Allow NULL? |
| 19 | REQ_CAPACITY | Required Capacity in Minutes | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | EEWM_REQ_CAPACITY | Allow NULL? |
