| 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 historical | nvarchar | 12 | 0 | CHAR | (N' ') | No | | AUFNR_H | Allow NULL? |
| 3 | AUART | Order Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T003O | AUFART | Allow NULL? |
| 4 | AUTYP | Order category | nvarchar | 2 | 0 | NUMC | (N'00') | No | | AUFTYP | Allow NULL? |
| 5 | KTEXT | Description | nvarchar | 40 | 0 | CHAR | (N' ') | No | | AUFTEXT | Allow NULL? |
| 6 | LTEXT | Long Text Exists | char | 1 | 0 | CHAR | (N' ') | No | | AUFLTEXT | Allow NULL? |
| 7 | LOEKZ | Deletion flag | char | 1 | 0 | CHAR | (N' ') | No | | AUFLOEKZ | Allow NULL? |
| 8 | MAUFNR | Number of superior order historical | nvarchar | 12 | 0 | CHAR | (N' ') | No | HIKO | MAUFNR_H | Allow NULL? |
| 9 | LEAD_AUFNR | Number of leading order historical | nvarchar | 12 | 0 | CHAR | (N' ') | No | HIKO | LAUFNR_H | Allow NULL? |
| 10 | PLVAR | Plan Version | nvarchar | 2 | 0 | CHAR | (N' ') | No | T778P | PLVAR | Allow NULL? |
| 11 | OBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | No | ONR00 | J_OBJNR | Allow NULL? |
| 12 | VAPLZ | Main work center for maintenance tasks | nvarchar | 8 | 0 | CHAR | (N' ') | No | | GEWRK | Allow NULL? |
| 13 | VAWRK | Plant associated with main work center | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERGW | Allow NULL? |
| 14 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 15 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 16 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | TGSB | GSBER | Allow NULL? |
| 17 | KOKRS | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | TKA01 | KOKRS | Allow NULL? |
| 18 | WAERS | Order Currency | nvarchar | 5 | 0 | CUKY | (N' ') | No | TCURC | AUFWAERS | Allow NULL? |
| 19 | GLTRP | Basic finish date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | CO_GLTRP | Allow NULL? |
| 20 | GSTRP | Basic start date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | CO_GSTRP | Allow NULL? |
| 21 | GSTRI | Actual start date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | CO_GSTRI | Allow NULL? |
| 22 | GETRI | Confirmed Order Finish Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | CO_GETRI | Allow NULL? |
| 23 | PSPEL | Work breakdown structure element (WBS element) | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | PRPS | PS_PSP_ELE | Allow NULL? |
| 24 | PLNTY | Task List Type | char | 1 | 0 | CHAR | (N' ') | No | TCA01 | PLNTY | Allow NULL? |
| 25 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | CHAR | (N' ') | No | | PLNNR | Allow NULL? |
| 26 | PLNAL | Group Counter | nvarchar | 2 | 0 | CHAR | (N' ') | No | | PLNAL | Allow NULL? |
| 27 | ZAEHL | Internal counter | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | CIM_COUNT | Allow NULL? |
| 28 | ERNAM | Entered by | nvarchar | 12 | 0 | CHAR | (N' ') | No | | AUFERFNAM | Allow NULL? |
| 29 | ERDAT | Created on | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | AUFERFDAT | Allow NULL? |
| 30 | AENAM | Last changed by | nvarchar | 12 | 0 | CHAR | (N' ') | No | | AUFAENAM | Allow NULL? |
| 31 | AEDAT | Change date for Order Master | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | AUFAEDAT | Allow NULL? |
| 32 | ARTPR | Priority Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | T356A | ARTPR | Allow NULL? |
| 33 | PRIOK | Priority | char | 1 | 0 | CHAR | (N' ') | No | T356 | PRIOK | Allow NULL? |
| 34 | EQUNR | Equipment Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | EQUI | EQUNR | Allow NULL? |
| 35 | BAUTL | Assembly | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | BAUTL | Allow NULL? |
| 36 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | CHAR | (N' ') | No | ILOA | ILOAN | Allow NULL? |
| 37 | ILOAI | ILOA Individual | char | 1 | 0 | CHAR | (N' ') | No | | ILOAI | Allow NULL? |
| 38 | ANLZU | Syst.Condition | char | 1 | 0 | CHAR | (N' ') | No | T357M | ANLZU | Allow NULL? |
| 39 | IWERK | Maintenance Planning Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | IWERK | Allow NULL? |
| 40 | INGPR | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | CHAR | (N' ') | No | T024I | INGRP | Allow NULL? |
| 41 | APGRP | Responsible planner group/department | nvarchar | 3 | 0 | CHAR | (N' ') | No | T024A | VAGRP | Allow NULL? |
| 42 | PM_OBJTY | Object Type of CIM Resources for Work Center | nvarchar | 2 | 0 | CHAR | (N' ') | No | | PM_OBJTY | Allow NULL? |
| 43 | GEWRK | Object ID of the Work Center | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | CRID | LGWID | Allow NULL? |
| 44 | KUNUM | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | KNA1 | KUNUM | Allow NULL? |
| 45 | ANING | Name of Person Reponsible for System | nvarchar | 12 | 0 | CHAR | (N' ') | No | | ANING | Allow NULL? |
| 46 | GAUZT | Planned downtime in hours | float | 15 | 16 | FLTP | ((0)) | No | | GAUZT | |
| 47 | GAUEH | Unit for Breakdown Duration | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | MAUEH | Allow NULL? |
| 48 | ANLBD | Date until which the system is available | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ANLBD | Allow NULL? |
| 49 | ANLVD | Date from which the system is available | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ANLVD | Allow NULL? |
| 50 | ANLBZ | Time until which the system is available | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | ANLBZ | Allow NULL? |
| 51 | ANLVZ | Time from Which System is Available | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | ANLVZ | Allow NULL? |
| 52 | INSPK | Name of Person Responsible for Technical Inspection | nvarchar | 12 | 0 | CHAR | (N' ') | No | | INSPK | Allow NULL? |
| 53 | DATAN | Date of Technical Inspection | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | DATAN | Allow NULL? |
| 54 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | CHAR | (N' ') | No | MPLA | WARPL | Allow NULL? |
| 55 | ABNUM | Maintenance Plan Call Number | int | 10 | 0 | INT4 | ((0)) | No | | ABNUM | Allow NULL? |
| 56 | WAPOS | Maintenance item | nvarchar | 16 | 0 | CHAR | (N' ') | No | | WAPOS | Allow NULL? |
| 57 | LAUFN | Order number historical | nvarchar | 12 | 0 | CHAR | (N' ') | No | HIKO | LAUFN_H | Allow NULL? |
| 58 | OBKNR | Object list number | int | 10 | 0 | INT4 | ((0)) | No | * | OBJKNR | Allow NULL? |
| 59 | REVNR | Revision for Plant Maintenance and Customer Service | nvarchar | 8 | 0 | CHAR | (N' ') | No | T352R | REVNI | Allow NULL? |
| 60 | ADDAT | PM Order: Reference Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ADDAT | Allow NULL? |
| 61 | ADUHR | Time of Reference Date | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | ADUHR | Allow NULL? |
| 62 | IPHAS | Maintenance Processing Phase | char | 1 | 0 | CHAR | (N' ') | No | | PM_PHASE | Allow NULL? |
| 63 | ILART | Maintenance activity type | nvarchar | 3 | 0 | CHAR | (N' ') | No | T353I | ILA | Allow NULL? |
| 64 | QMNUM | Notification No | nvarchar | 12 | 0 | CHAR | (N' ') | No | QMEL | QMNUM | Allow NULL? |
| 65 | HISDA | PM request: History date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | HISDA | Allow NULL? |
| 66 | AKKNZ | Order Category Indicator Plant Maintenance | char | 1 | 0 | CHAR | (N' ') | No | | AKKNZ | Allow NULL? |
| 67 | PLKNZ | Maintenance order planning indicator | char | 1 | 0 | CHAR | (N' ') | No | | AUF_PLKNZ | Allow NULL? |
| 68 | USER4 | Estimated total costs of order | decimal | 11 | 2 | CURR | ((0)) | Yes | | AUFUSER4 | |
| 69 | SERIALNR | Serial Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | GERNR | Allow NULL? |
| 70 | SERMAT | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 71 | DEVICEID | Additional Device Data | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | DEVICEID | Allow NULL? |
| 72 | SCREENTY | Scenario or Subscreen Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TQBT | SCRTP | Allow NULL? |
| 73 | DUMMY_CI_AUFK | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 74 | /MRSS/PL_STRU_ID | Resource planning nodes | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | /MRSS/T_PLAN_STRUCT_ID | Allow NULL? |
| 75 | /MRSS/PL_MAN_TYP | Assignment to resource planner or contact person | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_MANAGER_TYPE | Allow NULL? |
| 76 | /MRSS/ORDER_PROB | Order probability in percent | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_ORDER_PROB | Allow NULL? |
| 77 | /MRSS/ACT_TYPE | Process variant | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_ACTIVITY_TYPE | Allow NULL? |
| 78 | /MRSS/INIT_DONE | Internal initialization carried out once | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_INIT_DONE | Allow NULL? |
| 79 | /MRSS/DATACHANGE | Data was changed in the controls on the user screen | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_USCREENCTL_DATACHANGED | Allow NULL? |
| 80 | /MRSS/SALES_ORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VKORG | Allow NULL? |
| 81 | /MRSS/NW_BOOKED | Network Set to "Booked" | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_NW_BOOKED | Allow NULL? |
| 82 | UII | Unique Item Identifier | nvarchar | 72 | 0 | CHAR | (N' ') | Yes | | UII_CHAR72 | Allow NULL? |
