| 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 | AUFNR | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | No | AUFK | AUFNR | Allow NULL? |
| 3 | ARTPR | Priority Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T356A | ARTPR | Allow NULL? |
| 4 | PRIOK | Priority | char | 1 | 0 | CHAR | (N' ') | Yes | T356 | PRIOK | Allow NULL? |
| 5 | EQUNR | Equipment Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | EQUI | EQUNR | Allow NULL? |
| 6 | BAUTL | Assembly | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | BAUTL | Allow NULL? |
| 7 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | ILOA | ILOAN | Allow NULL? |
| 8 | ILOAI | ILOA Individual | char | 1 | 0 | CHAR | (N' ') | Yes | | ILOAI | Allow NULL? |
| 9 | ANLZU | Syst.Condition | char | 1 | 0 | CHAR | (N' ') | Yes | T357M | ANLZU | Allow NULL? |
| 10 | IWERK | Maintenance Planning Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T399I | IWERK | Allow NULL? |
| 11 | INGPR | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T024I | INGRP | Allow NULL? |
| 12 | APGRP | Responsible planner group/department | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T024A | VAGRP | Allow NULL? |
| 13 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PM_OBJTY | Allow NULL? |
| 14 | GEWRK | Object ID of the Work Center | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | CRID | LGWID | Allow NULL? |
| 15 | KUNUM | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | KUNUM | Allow NULL? |
| 16 | ANING | Name of Person Reponsible for System | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ANING | Allow NULL? |
| 17 | GAUZT | Planned downtime in hours | float | 15 | 16 | FLTP | ((0)) | Yes | | GAUZT | |
| 18 | GAUEH | Unit for Breakdown Duration | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MAUEH | Allow NULL? |
| 19 | ANLBD | Date until which the system is available | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ANLBD | Allow NULL? |
| 20 | ANLVD | Date from which the system is available | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ANLVD | Allow NULL? |
| 21 | ANLBZ | Time until which the system is available | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ANLBZ | Allow NULL? |
| 22 | ANLVZ | Time from Which System is Available | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ANLVZ | Allow NULL? |
| 23 | INSPK | Name of Person Responsible for Technical Inspection | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | INSPK | Allow NULL? |
| 24 | DATAN | Date of Technical Inspection | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATAN | Allow NULL? |
| 25 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | MPLA | WARPL | Allow NULL? |
| 26 | ABNUM | Maintenance Plan Call Number | int | 10 | 0 | INT4 | ((0)) | Yes | | ABNUM | Allow NULL? |
| 27 | WAPOS | Maintenance item | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | WAPOS | Allow NULL? |
| 28 | LAUFN | Order number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | AUFK | LAUFN | Allow NULL? |
| 29 | OBKNR | Object list number | int | 10 | 0 | INT4 | ((0)) | Yes | SER00 | OBJKNR | Allow NULL? |
| 30 | REVNR | Revision for Plant Maintenance and Customer Service | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | T352R | REVNI | Allow NULL? |
| 31 | ADDAT | PM Order: Reference Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ADDAT | Allow NULL? |
| 32 | ADUHR | Time of Reference Date | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ADUHR | Allow NULL? |
| 33 | IPHAS | Maintenance Processing Phase | char | 1 | 0 | CHAR | (N' ') | Yes | | PM_PHASE | Allow NULL? |
| 34 | ILART | Maintenance activity type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T353I | ILA | Allow NULL? |
| 35 | QMNUM | Notification No | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | QMEL | QMNUM | Allow NULL? |
| 36 | HISDA | PM request: History date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | HISDA | Allow NULL? |
| 37 | AKKNZ | Order Category Indicator Plant Maintenance | char | 1 | 0 | CHAR | (N' ') | Yes | | AKKNZ | Allow NULL? |
| 38 | PLKNZ | Maintenance order planning indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | AUF_PLKNZ | Allow NULL? |
| 39 | SERIALNR | Serial Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | GERNR | Allow NULL? |
| 40 | SERMAT | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 41 | DEVICEID | Additional Device Data | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | DEVICEID | Allow NULL? |
| 42 | SCREENTY | Scenario or Subscreen Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TQBT | SCRTP | Allow NULL? |
| 43 | ADPSP | Reference Element PM/PS | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | * | ADDCOMPARE_CORE | Allow NULL? |
| 44 | RSUPG | Upgrade Order Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RSUPG | Allow NULL? |
| 45 | /ISDFPS/OBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | J_OBJNR | Allow NULL? |
| 46 | /ISDFPS/MEQUI | Master Equipment | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | /ISDFPS/MEQUI | Allow NULL? |
| 47 | UII | Unique Item Identifier | nvarchar | 72 | 0 | CHAR | (N' ') | Yes | | UII_CHAR72 | Allow NULL? |
