I_MaintenanceItemData

Maintenance Item Data | view: IMAINTITEMDATA | ATTR | Extraction: Full only | Component: Maintenance Task Lists
Tables used: EQUI, EQKT, EQUZ, IFLOS, IFLOT, IFLOTX, ILOA, MPOS, T399W, NRIV, TQ80, PRPS, CRHD, ITOBCUST, IFLOUSR, 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
WorkCenterTypeCode Object types of the CIM resource Show values
MaintenanceItemIsInactive Indicator that maintenance item is inactive Show values
ImmediateReleaseIsBlocked Do Not Release Immediately Show values
Column Name Description Domain name
MainWorkCenter Main work center for maintenance tasks ARBPL
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
OperationSystemCondition System Condition ANLZU
SalesDocument Sales Document VBELN
PurchaseOrder Purchase order number EBELN
PurchaseOrderItem Purchase order item number EBELP
SettlementOrdForServiceProcmt 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
WorkCenter Work Center ARBPL
AssetRoom Room CHAR8
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
Master Data Relations | to Other Relations ↓ Join Conditions
ABC Indicator for Technical Object
  • Client
  • ABC Indicator for Technical Object
  • I_MAINTENANCEITEMDATA.MANDT == T370C.MANDT
  • I_MAINTENANCEITEMDATA.ABCINDICATOR == T370C.ABCKZ
Assembly
  • Assembly
  • Client
  • I_MAINTENANCEITEMDATA.ASSEMBLY == MARA.MATNR
  • I_MAINTENANCEITEMDATA.MANDT == MARA.MANDT
Location of maintenance object
  • Client
  • Location of maintenance object
  • Maintenance Plant
  • I_MAINTENANCEITEMDATA.MANDT == T499S.MANDT
  • I_MAINTENANCEITEMDATA.ASSETLOCATION == T499S.STAND
  • I_MAINTENANCEITEMDATA.MAINTENANCEPLANT == T499S.WERKS
Business area
  • Client
  • Business Area
  • I_MAINTENANCEITEMDATA.MANDT == TGSB.MANDT
  • I_MAINTENANCEITEMDATA.BUSINESSAREA == TGSB.GSBER
Company Code
  • Client
  • Company Code
  • I_MAINTENANCEITEMDATA.MANDT == T001.MANDT
  • I_MAINTENANCEITEMDATA.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • I_MAINTENANCEITEMDATA.MANDT == TKA01.MANDT
  • I_MAINTENANCEITEMDATA.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • ?
  • Controlling Area
  • Cost Center
  • I_MAINTENANCEITEMDATA.MANDT == CSKS.MANDT
  • I_MAINTENANCEITEMDATA.[column in domain "DATBI"] == CSKS.DATBI
  • I_MAINTENANCEITEMDATA.CONTROLLINGAREA == CSKS.KOKRS
  • I_MAINTENANCEITEMDATA.COSTCENTER == CSKS.KOSTL
Equipment number
  • Equipment Number
  • Client
  • I_MAINTENANCEITEMDATA.EQUIPMENT == EQUI.EQUNR
  • I_MAINTENANCEITEMDATA.MANDT == EQUI.MANDT
Functional Location
  • Client
  • Functional Location
  • I_MAINTENANCEITEMDATA.MANDT == IFLOT.MANDT
  • I_MAINTENANCEITEMDATA.FUNCTIONALLOCATION == IFLOT.TPLNR
Maintenance activity type
  • Client
  • Maintenance activity type
  • I_MAINTENANCEITEMDATA.MANDT == T353I.MANDT
  • I_MAINTENANCEITEMDATA.MAINTENANCEACTIVITYTYPE == T353I.ILART
Order number
  • Client
  • Order number
  • I_MAINTENANCEITEMDATA.MANDT == AUFK.MANDT
  • I_MAINTENANCEITEMDATA.MAINTENANCEORDER == AUFK.AUFNR
Order Type
  • Client
  • Order Type
  • I_MAINTENANCEITEMDATA.MANDT == T003O.CLIENT
  • I_MAINTENANCEITEMDATA.MAINTENANCEORDERTYPE == T003O.AUART
Maintenance plan
  • Client
  • Maintenance Plan
  • I_MAINTENANCEITEMDATA.MANDT == MPLA.MANDT
  • I_MAINTENANCEITEMDATA.MAINTENANCEPLAN == MPLA.WARPL
Maintenance Plant
  • Client
  • Maintenance Plant
  • I_MAINTENANCEITEMDATA.MANDT == T001W.MANDT
  • I_MAINTENANCEITEMDATA.MAINTENANCEPLANT == T001W.WERKS
Maintenance strategy
  • Client
  • Maintenance Strategy
  • I_MAINTENANCEITEMDATA.MANDT == T351.MANDT
  • I_MAINTENANCEITEMDATA.MAINTENANCESTRATEGY == T351.STRAT
Location/account assignment to item object
  • Client
  • Location and account assignment for technical object
  • I_MAINTENANCEITEMDATA.MANDT == ILOA.MANDT
  • I_MAINTENANCEITEMDATA.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
Priority
  • Client
  • Priority
  • ?
  • I_MAINTENANCEITEMDATA.MANDT == T356.MANDT
  • I_MAINTENANCEITEMDATA.MAINTPRIORITY == T356.PRIOK
  • I_MAINTENANCEITEMDATA.[column in domain "ARTPR"] == T356.ARTPR
WORK CENTER
  • Client
  • Object ID of the Work Center
  • Object types of the CIM resource
  • I_MAINTENANCEITEMDATA.MANDT == CRID.MANDT
  • I_MAINTENANCEITEMDATA.MAINWORKCENTERINTERNALID == CRID.OBJID
  • I_MAINTENANCEITEMDATA.WORKCENTERTYPECODE == CRID.OBJTY
Plant
  • Client
  • Plant
  • Plant
  • I_MAINTENANCEITEMDATA.MANDT == T001W.MANDT
  • I_MAINTENANCEITEMDATA.WORKCENTERPLANT == T001W.WERKS
  • I_MAINTENANCEITEMDATA.MAINWORKCENTERPLANT == T001W.WERKS
Material number
  • Client
  • Material Number
  • I_MAINTENANCEITEMDATA.MANDT == MARA.MANDT
  • I_MAINTENANCEITEMDATA.MATERIAL == MARA.MATNR
Notification type
  • Client
  • Notification Type
  • I_MAINTENANCEITEMDATA.MANDT == TQ80.MANDT
  • I_MAINTENANCEITEMDATA.NOTIFICATIONTYPE == TQ80.QMART
Plant Section
  • Client
  • Plant Section
  • Maintenance Plant
  • I_MAINTENANCEITEMDATA.MANDT == T357.MANDT
  • I_MAINTENANCEITEMDATA.PLANTSECTION == T357.BEBER
  • I_MAINTENANCEITEMDATA.MAINTENANCEPLANT == T357.WERKS
Settlement order
  • Client
  • Settlement order
  • Settlement order
  • I_MAINTENANCEITEMDATA.MANDT == AUFK.MANDT
  • I_MAINTENANCEITEMDATA.SETTLEMENTORDER == AUFK.AUFNR
  • I_MAINTENANCEITEMDATA.SETTLEMENTORDFORSERVICEPROCMT == AUFK.AUFNR
TASK LIST TYPE
  • Client
  • Task List Type
  • I_MAINTENANCEITEMDATA.MANDT == TCA01.MANDT
  • I_MAINTENANCEITEMDATA.TASKLISTTYPE == TCA01.PLNTY
Object ID of PP work center
  • Client
  • ?
  • Object ID of PP work center
  • I_MAINTENANCEITEMDATA.MANDT == CRID.MANDT
  • I_MAINTENANCEITEMDATA.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_MAINTENANCEITEMDATA.WORKCENTERINTERNALID == CRID.OBJID
Plant
  • Client
  • Plant
  • Plant
  • I_MAINTENANCEITEMDATA.MANDT == T001W.MANDT
  • I_MAINTENANCEITEMDATA.WORKCENTERPLANT == T001W.WERKS
  • I_MAINTENANCEITEMDATA.MAINWORKCENTERPLANT == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Maintenance plan category
  • Client
  • Maintenance item category
  • Maintenance plan category
  • I_MAINTENANCEITEMDATA.MANDT == T399P.MANDT
  • I_MAINTENANCEITEMDATA.MAINTOBJECTCATEGORY == T399P.MITYP
  • I_MAINTENANCEITEMDATA.MAINTENANCEPLANCATEGORY == T399P.MITYP
Maintenance planner group
  • Client
  • Maintenance Planning Plant
  • Planner Group for Customer Service and Plant Maintenance
  • I_MAINTENANCEITEMDATA.MANDT == T024I.MANDT
  • I_MAINTENANCEITEMDATA.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_MAINTENANCEITEMDATA.MAINTENANCEPLANNERGROUP == T024I.INGRP
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • I_MAINTENANCEITEMDATA.MANDT == T399I.MANDT
  • I_MAINTENANCEITEMDATA.MAINTENANCEPLANNINGPLANT == T399I.IWERK
Maintenance item category
  • Client
  • Maintenance item category
  • Maintenance plan category
  • I_MAINTENANCEITEMDATA.MANDT == T399P.MANDT
  • I_MAINTENANCEITEMDATA.MAINTOBJECTCATEGORY == T399P.MITYP
  • I_MAINTENANCEITEMDATA.MAINTENANCEPLANCATEGORY == T399P.MITYP