| 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 | WAPOS | Maintenance item | nvarchar | 16 | 0 | CHAR | (N' ') | No | | WAPOS | Allow NULL? |
| 3 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | MPLA | WARPL | Allow NULL? |
| 4 | WSTRA | Maintenance strategy | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T351 | STRAT | Allow NULL? |
| 5 | WPPOS | Item in the maintenance plan | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | WPPOS | Allow NULL? |
| 6 | PSTXT | Item Short Text | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | POSTXT | Allow NULL? |
| 7 | EQUNR | Equipment Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | EQUI | EQUNR | Allow NULL? |
| 8 | OBKNR | Object list number | int | 10 | 0 | INT4 | ((0)) | Yes | * | OBJKNR | Allow NULL? |
| 9 | ERKNZ | Creation indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ERKNZ | Allow NULL? |
| 10 | AEKNZ | Change indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | AEKNZ | Allow NULL? |
| 11 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 12 | ERSDT | Date of creation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EDATUM | Allow NULL? |
| 13 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 14 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 15 | PLNTY | Task List Type | char | 1 | 0 | CHAR | (N' ') | Yes | TCA01 | PLNTY | Allow NULL? |
| 16 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | PLNNR | Allow NULL? |
| 17 | PLNAL | Group Counter | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PLNAL | Allow NULL? |
| 18 | STATUS | Maintenance Item Status | char | 1 | 0 | CHAR | (N' ') | Yes | | MPSTAT | Allow NULL? |
| 19 | LTKNZ | Long Text Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | MPLTX | Allow NULL? |
| 20 | WPGRP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T024I | INGRP | Allow NULL? |
| 21 | OBJTY | Object types of the CIM resource | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CR_OBJTY | Allow NULL? |
| 22 | GEWRK | Object ID of the Work Center | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | CRID | LGWID | Allow NULL? |
| 23 | IWERK | Maintenance Planning Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T399I | IWERK | Allow NULL? |
| 24 | LANGU | Language key of the long text | char | 1 | 0 | LANG | (N' ') | Yes | * | MPLANGU | Allow NULL? |
| 25 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | ILOA | ILOAN | Allow NULL? |
| 26 | ILOAI | ILOA Individual | char | 1 | 0 | CHAR | (N' ') | Yes | | ILOAI | Allow NULL? |
| 27 | LAUFN | Order number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | AUFK | LAUFN | Allow NULL? |
| 28 | BAUTL | Assembly | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | BAUTL | Allow NULL? |
| 29 | ANLZU | Syst.Condition | char | 1 | 0 | CHAR | (N' ') | Yes | * | ANLZU | Allow NULL? |
| 30 | AUART | Order Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T003O | AUFART | Allow NULL? |
| 31 | INACT | Indicator that maintenance item is inactive | char | 1 | 0 | CHAR | (N' ') | Yes | | INACT | Allow NULL? |
| 32 | ILART | Maintenance activity type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T353I | ILA | Allow NULL? |
| 33 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 34 | OBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | ONR00 | J_OBJNR | Allow NULL? |
| 35 | IND_ABRVO | Indicator showing settlement rule maintained | char | 1 | 0 | CHAR | (N' ') | Yes | | IND_ABRVO | Allow NULL? |
| 36 | PSPEL | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PS_PSP_PNR | Allow NULL? |
| 37 | STD_NETZ | Key for Task List Group | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | PLNNR | Allow NULL? |
| 38 | STD_AVO | Number of the task list node | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | PLNKN | Allow NULL? |
| 39 | KDAUF | Sales Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VBELN_VA | Allow NULL? |
| 40 | KDPOS | Sales Document Item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | POSNR_VA | Allow NULL? |
| 41 | MITYP | Maintenance item category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T399P | MITYP | Allow NULL? |
| 42 | BSTNR | Purchase Order Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BSTNR | Allow NULL? |
| 43 | BSTPO | Purchase Order Item Number | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | * | BSTPO | Allow NULL? |
| 44 | PACKNO | Package number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | PACKNO | Allow NULL? |
| 45 | NETPR | Net price | decimal | 11 | 2 | CURR | ((0)) | Yes | | NETPR | |
| 46 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 47 | SAKTO | Cost Element | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KSTAR | Allow NULL? |
| 48 | AUFNR | Settlement order | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | ILOM_ORDST | Allow NULL? |
| 49 | APFKT | Execution factor for whole task list | decimal | 3 | 0 | DEC | ((0)) | Yes | | APFKT | |
| 50 | SCRRENTY | SCREEN TYPE: for order-order category (see domain) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | SCREENTY | Allow NULL? |
| 51 | SERIALNR | Serial Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | GERNR | Allow NULL? |
| 52 | SERMAT | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 53 | DEVICEID | Additional Device Data | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | DEVICEID | Allow NULL? |
| 54 | QMNUM | Notification No | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | QMEL | QMNUM | Allow NULL? |
| 55 | QMART | Notification Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TQ80 | QMART | Allow NULL? |
| 56 | LBLNI | Entry Sheet Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LBLNI | Allow NULL? |
| 57 | TASK_DETERMINE | Automatic task determination in the notification | char | 1 | 0 | CHAR | (N' ') | Yes | | TASK_DETERMINE | Allow NULL? |
| 58 | PRIOK | Priority | char | 1 | 0 | CHAR | (N' ') | Yes | T356 | PRIOK | Allow NULL? |
| 59 | QMKAT | Catalog Type - Coding | char | 1 | 0 | CHAR | (N' ') | Yes | * | QMKAT | Allow NULL? |
| 60 | QMGRP | Code Group - Coding | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | QMGRP | Allow NULL? |
| 61 | QMCOD | Coding | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | QMCOD | Allow NULL? |
| 62 | PHYNR | Physical Sample Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | QPHYSPRNR | Allow NULL? |
| 63 | ART | Inspection Type | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | QPART | Allow NULL? |
| 64 | PRUEFLOS | Inspection Lot Number | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | QPLOS | Allow NULL? |
| 65 | TSTMP_BW | Time Stamp for BI Delta Extraction | decimal | 16 | 0 | DEC | ((0)) | Yes | | TSTMP_BW_EXT | |
| 66 | NO_AUFRELKZ | Do Not Release Immediately | char | 1 | 0 | CHAR | (N' ') | Yes | | NO_AUFRELKZ | Allow NULL? |
| 67 | DESNUM | CU: Design Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | /CUM/DESNUM | Allow NULL? |
| 68 | CYCLESEQIND | Cycle Set Sequence | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CYCLESETSEQ | Allow NULL? |
| 69 | ADPSP | Reference Element PM/PS | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | * | ADDCOMPARE_CORE | Allow NULL? |
| 70 | IND_MPOS_API | Maintenance Item Was Created/Changed by API | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | IND_MPOS_API | Allow NULL? |
