I_MaintenanceItem

Maintenance Item | view: IMAINTITEM | Extraction: Not supported | Component: Maintenance Task Lists
Tables used: ILOA, MPOS, T399W, NRIV, TQ80, T350, TPAER
Column Name Description
MaintenanceItem Maintenance item
Column Name Description
Column Name Description
Column Name Description
CreationDate Date of creation
LastChangeDate Last Changed On
Column Name Description
MaintenanceItemHasLongText Long Text Indicator Show values
WorkCenterTypeCode Object types of the CIM resource Show values
MaintenancePlanCallObject Call object for maintenance plan Show values
MaintItemCausesAreDisplayed Show Causes tab Show values
MaintItemReasonsAreDisplayed Show Reasons tab Show values
MaintenanceItemIsInactive Indicator that maintenance item is inactive Show values
ImmediateReleaseIsBlocked Do Not Release Immediately Show values
Column Name Description Domain name
SettlementRuleIsMaintained Indicator showing settlement rule maintained CHAR01
TaskListGroup Key for Task List Group PLNNR
TaskListGroupCounter Group Counter ALTNR
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
MaintenanceItemDescription Item Short Text TEXT40
MaintenancePlanItemPosition Item in the maintenance plan WPPOS
MaintPriorityType Priority Type ARTPR
SerialNumber Serial Number GERNR
MaintenanceItemObjectList Object list number OBJKN
OperationSystemCondition System Condition ANLZU
NumberOfTaskListExecutions Execution factor for whole task list AFAKT
SalesDocument Sales Document VBELN
PurchaseOrder Purchase order number EBELN
PurchaseOrderItem Purchase order item number EBELP
SettlementOrder Settlement order AUFNR
LastChangeDateTime Time Stamp for BI Delta Extraction RKE_TSTMP
MaintPlanLastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CycleSetSequence Cycle Set Sequence NUMC2
ReferenceElement Reference Element PM/PS ADDCOMPARE_CORE
ServiceDocumentType Business Transaction Type CRM_PROCESS_TYPE
ServiceContract Transaction ID CRM_OBJECT_ID
ServiceContractItem Shortened Item Number in Document CRMS4_NUMBER_INT
ServiceOrderTemplate Transaction ID CRM_OBJECT_ID
Product Product Number MATNR
ServiceDocumentPriority Activity Priority SC_PRIO
Master Data Relations | to Other Relations ↓ Join Conditions
Assembly
  • Assembly
  • Client
  • I_MAINTENANCEITEM.ASSEMBLY == MARA.MATNR
  • I_MAINTENANCEITEM.MANDT == MARA.MANDT
Business area
  • Client
  • Business Area
  • I_MAINTENANCEITEM.MANDT == TGSB.MANDT
  • I_MAINTENANCEITEM.BUSINESSAREA == TGSB.GSBER
Equipment number
  • Client
  • Equipment Number
  • I_MAINTENANCEITEM.MANDT == EQUI.MANDT
  • I_MAINTENANCEITEM.EQUIPMENT == EQUI.EQUNR
Functional Location
  • Client
  • Functional Location
  • I_MAINTENANCEITEM.MANDT == IFLOT.MANDT
  • I_MAINTENANCEITEM.FUNCTIONALLOCATION == IFLOT.TPLNR
Maintenance activity type
  • Client
  • Maintenance activity type
  • I_MAINTENANCEITEM.MANDT == T353I.MANDT
  • I_MAINTENANCEITEM.MAINTENANCEACTIVITYTYPE == T353I.ILART
Order number
  • Order number
  • Client
  • I_MAINTENANCEITEM.MAINTENANCEORDER == AUFK.AUFNR
  • I_MAINTENANCEITEM.MANDT == AUFK.MANDT
Order Type
  • Client
  • Order Type
  • I_MAINTENANCEITEM.MANDT == T003O.CLIENT
  • I_MAINTENANCEITEM.MAINTENANCEORDERTYPE == T003O.AUART
Maintenance plan
  • Client
  • Maintenance Plan
  • I_MAINTENANCEITEM.MANDT == MPLA.MANDT
  • I_MAINTENANCEITEM.MAINTENANCEPLAN == MPLA.WARPL
Maintenance strategy
  • Client
  • Maintenance Strategy
  • I_MAINTENANCEITEM.MANDT == T351.MANDT
  • I_MAINTENANCEITEM.MAINTENANCESTRATEGY == T351.STRAT
Location/account assignment to item object
  • Client
  • Location and account assignment for technical object
  • I_MAINTENANCEITEM.MANDT == ILOA.MANDT
  • I_MAINTENANCEITEM.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
Priority
  • ?
  • Client
  • Priority
  • I_MAINTENANCEITEM.[column in domain "ARTPR"] == T356.ARTPR
  • I_MAINTENANCEITEM.MANDT == T356.MANDT
  • I_MAINTENANCEITEM.MAINTPRIORITY == T356.PRIOK
WORK CENTER
  • Client
  • Object types of the CIM resource
  • Object ID of the Work Center
  • I_MAINTENANCEITEM.MANDT == CRID.MANDT
  • I_MAINTENANCEITEM.WORKCENTERTYPECODE == CRID.OBJTY
  • I_MAINTENANCEITEM.MAINWORKCENTERINTERNALID == CRID.OBJID
Material number
  • Client
  • Material Number
  • I_MAINTENANCEITEM.MANDT == MARA.MANDT
  • I_MAINTENANCEITEM.MATERIAL == MARA.MATNR
Notification type
  • Client
  • Notification Type
  • I_MAINTENANCEITEM.MANDT == TQ80.MANDT
  • I_MAINTENANCEITEM.NOTIFICATIONTYPE == TQ80.QMART
TASK LIST TYPE
  • Client
  • Task List Type
  • I_MAINTENANCEITEM.MANDT == TCA01.MANDT
  • I_MAINTENANCEITEM.TASKLISTTYPE == TCA01.PLNTY
Other Relations | to Master Data Relations ↑ Join Conditions
Maintenance plan category
  • Client
  • Maintenance item category
  • Maintenance plan category
  • I_MAINTENANCEITEM.MANDT == T399P.MANDT
  • I_MAINTENANCEITEM.MAINTOBJECTCATEGORY == T399P.MITYP
  • I_MAINTENANCEITEM.MAINTENANCEPLANCATEGORY == T399P.MITYP
Maintenance planner group
  • Client
  • Maintenance Planning Plant
  • Planner Group for Customer Service and Plant Maintenance
  • I_MAINTENANCEITEM.MANDT == T024I.MANDT
  • I_MAINTENANCEITEM.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_MAINTENANCEITEM.MAINTENANCEPLANNERGROUP == T024I.INGRP
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • I_MAINTENANCEITEM.MANDT == T399I.MANDT
  • I_MAINTENANCEITEM.MAINTENANCEPLANNINGPLANT == T399I.IWERK
Maintenance item category
  • Client
  • Maintenance item category
  • Maintenance plan category
  • I_MAINTENANCEITEM.MANDT == T399P.MANDT
  • I_MAINTENANCEITEM.MAINTOBJECTCATEGORY == T399P.MITYP
  • I_MAINTENANCEITEM.MAINTENANCEPLANCATEGORY == T399P.MITYP