C_MaintenanceItemDEX

Maintenance Item Data Extractor | view: CMAINTITEMDEX | ATTR | Extraction: Full only | Component: Maintenance Task Lists
Tables used: EQUI, EQKT, EQUZ, IFLOS, IFLOT, IFLOTX, ILOA, MPOS, T399W, NRIV, TQ80, 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 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
Master Data Relations | to Other Relations ↓ Join Conditions
ABC Indicator for Technical Object
  • ABC Indicator for Technical Object
  • Client
  • C_MAINTENANCEITEMDEX.ABCINDICATOR == T370C.ABCKZ
  • C_MAINTENANCEITEMDEX.MANDT == T370C.MANDT
Assembly
  • Assembly
  • Client
  • C_MAINTENANCEITEMDEX.ASSEMBLY == MARA.MATNR
  • C_MAINTENANCEITEMDEX.MANDT == MARA.MANDT
Location of maintenance object
  • Client
  • Location of maintenance object
  • Maintenance Plant
  • C_MAINTENANCEITEMDEX.MANDT == T499S.MANDT
  • C_MAINTENANCEITEMDEX.ASSETLOCATION == T499S.STAND
  • C_MAINTENANCEITEMDEX.MAINTENANCEPLANT == T499S.WERKS
Business area
  • Business Area
  • Client
  • C_MAINTENANCEITEMDEX.BUSINESSAREA == TGSB.GSBER
  • C_MAINTENANCEITEMDEX.MANDT == TGSB.MANDT
Company Code
  • Client
  • Company Code
  • C_MAINTENANCEITEMDEX.MANDT == T001.MANDT
  • C_MAINTENANCEITEMDEX.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • C_MAINTENANCEITEMDEX.CONTROLLINGAREA == TKA01.KOKRS
  • C_MAINTENANCEITEMDEX.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • ?
  • Client
  • Cost Center
  • C_MAINTENANCEITEMDEX.CONTROLLINGAREA == CSKS.KOKRS
  • C_MAINTENANCEITEMDEX.[column in domain "DATBI"] == CSKS.DATBI
  • C_MAINTENANCEITEMDEX.MANDT == CSKS.MANDT
  • C_MAINTENANCEITEMDEX.COSTCENTER == CSKS.KOSTL
Equipment number
  • Client
  • Equipment Number
  • C_MAINTENANCEITEMDEX.MANDT == EQUI.MANDT
  • C_MAINTENANCEITEMDEX.EQUIPMENT == EQUI.EQUNR
Functional Location
  • Client
  • Functional Location
  • C_MAINTENANCEITEMDEX.MANDT == IFLOT.MANDT
  • C_MAINTENANCEITEMDEX.FUNCTIONALLOCATION == IFLOT.TPLNR
Maintenance activity type
  • Maintenance activity type
  • Client
  • C_MAINTENANCEITEMDEX.MAINTENANCEACTIVITYTYPE == T353I.ILART
  • C_MAINTENANCEITEMDEX.MANDT == T353I.MANDT
Order number
  • Client
  • Order number
  • C_MAINTENANCEITEMDEX.MANDT == AUFK.MANDT
  • C_MAINTENANCEITEMDEX.MAINTENANCEORDER == AUFK.AUFNR
Order Type
  • Client
  • Order Type
  • C_MAINTENANCEITEMDEX.MANDT == T003O.CLIENT
  • C_MAINTENANCEITEMDEX.MAINTENANCEORDERTYPE == T003O.AUART
Maintenance plan
  • Client
  • Maintenance Plan
  • C_MAINTENANCEITEMDEX.MANDT == MPLA.MANDT
  • C_MAINTENANCEITEMDEX.MAINTENANCEPLAN == MPLA.WARPL
Maintenance Plant
  • Client
  • Maintenance Plant
  • C_MAINTENANCEITEMDEX.MANDT == T001W.MANDT
  • C_MAINTENANCEITEMDEX.MAINTENANCEPLANT == T001W.WERKS
Maintenance strategy
  • Client
  • Maintenance Strategy
  • C_MAINTENANCEITEMDEX.MANDT == T351.MANDT
  • C_MAINTENANCEITEMDEX.MAINTENANCESTRATEGY == T351.STRAT
Location/account assignment to item object
  • Location and account assignment for technical object
  • Client
  • C_MAINTENANCEITEMDEX.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • C_MAINTENANCEITEMDEX.MANDT == ILOA.MANDT
Priority
  • Priority
  • ?
  • Client
  • C_MAINTENANCEITEMDEX.MAINTPRIORITY == T356.PRIOK
  • C_MAINTENANCEITEMDEX.[column in domain "ARTPR"] == T356.ARTPR
  • C_MAINTENANCEITEMDEX.MANDT == T356.MANDT
WORK CENTER
  • Object ID of the Work Center
  • Client
  • Object types of the CIM resource
  • C_MAINTENANCEITEMDEX.MAINWORKCENTERINTERNALID == CRID.OBJID
  • C_MAINTENANCEITEMDEX.MANDT == CRID.MANDT
  • C_MAINTENANCEITEMDEX.WORKCENTERTYPECODE == CRID.OBJTY
Plant
  • Plant
  • Plant
  • Client
  • C_MAINTENANCEITEMDEX.MAINWORKCENTERPLANT == T001W.WERKS
  • C_MAINTENANCEITEMDEX.WORKCENTERPLANT == T001W.WERKS
  • C_MAINTENANCEITEMDEX.MANDT == T001W.MANDT
Material number
  • Material Number
  • Client
  • C_MAINTENANCEITEMDEX.MATERIAL == MARA.MATNR
  • C_MAINTENANCEITEMDEX.MANDT == MARA.MANDT
Notification type
  • Client
  • Notification Type
  • C_MAINTENANCEITEMDEX.MANDT == TQ80.MANDT
  • C_MAINTENANCEITEMDEX.NOTIFICATIONTYPE == TQ80.QMART
Plant Section
  • Plant Section
  • Client
  • Maintenance Plant
  • C_MAINTENANCEITEMDEX.PLANTSECTION == T357.BEBER
  • C_MAINTENANCEITEMDEX.MANDT == T357.MANDT
  • C_MAINTENANCEITEMDEX.MAINTENANCEPLANT == T357.WERKS
Settlement order
  • Client
  • Settlement order
  • Settlement order
  • C_MAINTENANCEITEMDEX.MANDT == AUFK.MANDT
  • C_MAINTENANCEITEMDEX.SETTLEMENTORDFORSERVICEPROCMT == AUFK.AUFNR
  • C_MAINTENANCEITEMDEX.SETTLEMENTORDER == AUFK.AUFNR
TASK LIST TYPE
  • Client
  • Task List Type
  • C_MAINTENANCEITEMDEX.MANDT == TCA01.MANDT
  • C_MAINTENANCEITEMDEX.TASKLISTTYPE == TCA01.PLNTY
Object ID of PP work center
  • Object ID of PP work center
  • ?
  • Client
  • C_MAINTENANCEITEMDEX.WORKCENTERINTERNALID == CRID.OBJID
  • C_MAINTENANCEITEMDEX.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • C_MAINTENANCEITEMDEX.MANDT == CRID.MANDT
Plant
  • Plant
  • Plant
  • Client
  • C_MAINTENANCEITEMDEX.MAINWORKCENTERPLANT == T001W.WERKS
  • C_MAINTENANCEITEMDEX.WORKCENTERPLANT == T001W.WERKS
  • C_MAINTENANCEITEMDEX.MANDT == T001W.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Maintenance item category
  • Client
  • Maintenance item category
  • Maintenance plan category
  • C_MAINTENANCEITEMDEX.MANDT == T399P.MANDT
  • C_MAINTENANCEITEMDEX.MAINTENANCEITEMCATEGORYCODE == T399P.MITYP
  • C_MAINTENANCEITEMDEX.MAINTENANCEPLANCATEGORY == T399P.MITYP
Maintenance plan category
  • Client
  • Maintenance item category
  • Maintenance plan category
  • C_MAINTENANCEITEMDEX.MANDT == T399P.MANDT
  • C_MAINTENANCEITEMDEX.MAINTENANCEITEMCATEGORYCODE == T399P.MITYP
  • C_MAINTENANCEITEMDEX.MAINTENANCEPLANCATEGORY == T399P.MITYP
Maintenance planner group
  • Maintenance Planning Plant
  • Client
  • Planner Group for Customer Service and Plant Maintenance
  • C_MAINTENANCEITEMDEX.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • C_MAINTENANCEITEMDEX.MANDT == T024I.MANDT
  • C_MAINTENANCEITEMDEX.MAINTENANCEPLANNERGROUP == T024I.INGRP
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • C_MAINTENANCEITEMDEX.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • C_MAINTENANCEITEMDEX.MANDT == T399I.MANDT