I_MaintenanceItemTP

Maintenance Item (Transactional Processing) | view: IMAINTITEMTP | Extraction: Not supported | Component: Maintenance Plans
Tables used: PLKZ, PLKO, IFLOS, IFLOT, ILOA, MPOS, T399W, NRIV, TQ80, EAPL, TAPL, 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
ImmediateReleaseIsBlocked Do Not Release Immediately Show values
Column Name Description Domain name
TaskList null
TaskListGroup Key for Task List Group PLNNR
TaskListGroupCounter Group Counter ALTNR
MaintenanceItemDescription Item Short Text TEXT40
MaintPriorityType Priority Type ARTPR
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
MaintenancePlanItemPosition Item in the maintenance plan WPPOS
SerialNumber Serial Number GERNR
MaintenanceItemObjectList Object list number OBJKN
OperationSystemCondition System Condition ANLZU
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
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
MainWorkCenter Work Center ARBPL
Master Data Relations | to Other Relations ↓ Join Conditions
Assembly
  • Assembly
  • Client
  • I_MAINTENANCEITEMTP.ASSEMBLY == MARA.MATNR
  • I_MAINTENANCEITEMTP.MANDT == MARA.MANDT
Business area
  • Business Area
  • Client
  • I_MAINTENANCEITEMTP.BUSINESSAREA == TGSB.GSBER
  • I_MAINTENANCEITEMTP.MANDT == TGSB.MANDT
Equipment number
  • Client
  • Equipment Number
  • I_MAINTENANCEITEMTP.MANDT == EQUI.MANDT
  • I_MAINTENANCEITEMTP.EQUIPMENT == EQUI.EQUNR
Functional Location
  • Client
  • Functional Location
  • I_MAINTENANCEITEMTP.MANDT == IFLOT.MANDT
  • I_MAINTENANCEITEMTP.FUNCTIONALLOCATION == IFLOT.TPLNR
Maintenance activity type
  • Client
  • Maintenance activity type
  • I_MAINTENANCEITEMTP.MANDT == T353I.MANDT
  • I_MAINTENANCEITEMTP.MAINTENANCEACTIVITYTYPE == T353I.ILART
Order number
  • Order number
  • Client
  • I_MAINTENANCEITEMTP.MAINTENANCEORDER == AUFK.AUFNR
  • I_MAINTENANCEITEMTP.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • I_MAINTENANCEITEMTP.MAINTENANCEORDERTYPE == T003O.AUART
  • I_MAINTENANCEITEMTP.MANDT == T003O.CLIENT
Maintenance plan
  • Client
  • Maintenance Plan
  • I_MAINTENANCEITEMTP.MANDT == MPLA.MANDT
  • I_MAINTENANCEITEMTP.MAINTENANCEPLAN == MPLA.WARPL
Maintenance strategy
  • Maintenance Strategy
  • Client
  • I_MAINTENANCEITEMTP.MAINTENANCESTRATEGY == T351.STRAT
  • I_MAINTENANCEITEMTP.MANDT == T351.MANDT
Location/account assignment to item object
  • Client
  • Location and account assignment for technical object
  • I_MAINTENANCEITEMTP.MANDT == ILOA.MANDT
  • I_MAINTENANCEITEMTP.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
Priority
  • ?
  • Client
  • Priority
  • I_MAINTENANCEITEMTP.[column in domain "ARTPR"] == T356.ARTPR
  • I_MAINTENANCEITEMTP.MANDT == T356.MANDT
  • I_MAINTENANCEITEMTP.MAINTPRIORITY == T356.PRIOK
WORK CENTER
  • Object types of the CIM resource
  • Client
  • Object ID of the Work Center
  • I_MAINTENANCEITEMTP.WORKCENTERTYPECODE == CRID.OBJTY
  • I_MAINTENANCEITEMTP.MANDT == CRID.MANDT
  • I_MAINTENANCEITEMTP.MAINWORKCENTERINTERNALID == CRID.OBJID
Plant
  • Client
  • Plant
  • I_MAINTENANCEITEMTP.MANDT == T001W.MANDT
  • I_MAINTENANCEITEMTP.MAINWORKCENTERPLANT == T001W.WERKS
Material number
  • Material Number
  • Client
  • I_MAINTENANCEITEMTP.MATERIAL == MARA.MATNR
  • I_MAINTENANCEITEMTP.MANDT == MARA.MANDT
Notification type
  • Notification Type
  • Client
  • I_MAINTENANCEITEMTP.NOTIFICATIONTYPE == TQ80.QMART
  • I_MAINTENANCEITEMTP.MANDT == TQ80.MANDT
TASK LIST TYPE
  • Client
  • Task List Type
  • I_MAINTENANCEITEMTP.MANDT == TCA01.MANDT
  • I_MAINTENANCEITEMTP.TASKLISTTYPE == TCA01.PLNTY
Other Relations | to Master Data Relations ↑ Join Conditions
Maintenance plan category
  • Client
  • Maintenance plan category
  • I_MAINTENANCEITEMTP.MANDT == T399P.MANDT
  • I_MAINTENANCEITEMTP.MAINTENANCEPLANCATEGORY == T399P.MITYP
Maintenance planner group
  • Maintenance Planning Plant
  • Client
  • Planner Group for Customer Service and Plant Maintenance
  • I_MAINTENANCEITEMTP.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_MAINTENANCEITEMTP.MANDT == T024I.MANDT
  • I_MAINTENANCEITEMTP.MAINTENANCEPLANNERGROUP == T024I.INGRP
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • I_MAINTENANCEITEMTP.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • I_MAINTENANCEITEMTP.MANDT == T399I.MANDT