P_MaintenanceItemSearch

Anchor View for Maintenance Item Search | view: PMAINITEMSEARCH | Extraction: Not supported | Component: Plant Maintenance
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
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
MaintenancePlanCallObject Call object for maintenance plan Show values
Column Name Description Domain name
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
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
Master Data Relations | to Other Relations ↓ Join Conditions
Assembly
  • Assembly
  • Client
  • P_MAINTENANCEITEMSEARCH.ASSEMBLY == MARA.MATNR
  • P_MAINTENANCEITEMSEARCH.MANDT == MARA.MANDT
Business area
  • Business Area
  • Client
  • P_MAINTENANCEITEMSEARCH.BUSINESSAREA == TGSB.GSBER
  • P_MAINTENANCEITEMSEARCH.MANDT == TGSB.MANDT
Equipment number
  • Equipment Number
  • Client
  • P_MAINTENANCEITEMSEARCH.EQUIPMENT == EQUI.EQUNR
  • P_MAINTENANCEITEMSEARCH.MANDT == EQUI.MANDT
Maintenance activity type
  • Maintenance activity type
  • Client
  • P_MAINTENANCEITEMSEARCH.MAINTENANCEACTIVITYTYPE == T353I.ILART
  • P_MAINTENANCEITEMSEARCH.MANDT == T353I.MANDT
Order number
  • Order number
  • Client
  • P_MAINTENANCEITEMSEARCH.MAINTENANCEORDER == AUFK.AUFNR
  • P_MAINTENANCEITEMSEARCH.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • P_MAINTENANCEITEMSEARCH.MAINTENANCEORDERTYPE == T003O.AUART
  • P_MAINTENANCEITEMSEARCH.MANDT == T003O.CLIENT
Maintenance plan
  • Maintenance Plan
  • Client
  • P_MAINTENANCEITEMSEARCH.MAINTENANCEPLAN == MPLA.WARPL
  • P_MAINTENANCEITEMSEARCH.MANDT == MPLA.MANDT
Maintenance strategy
  • Client
  • Maintenance Strategy
  • P_MAINTENANCEITEMSEARCH.MANDT == T351.MANDT
  • P_MAINTENANCEITEMSEARCH.MAINTENANCESTRATEGY == T351.STRAT
Location/account assignment to item object
  • Location and account assignment for technical object
  • Client
  • P_MAINTENANCEITEMSEARCH.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • P_MAINTENANCEITEMSEARCH.MANDT == ILOA.MANDT
Priority
  • Priority
  • ?
  • Client
  • P_MAINTENANCEITEMSEARCH.MAINTPRIORITY == T356.PRIOK
  • P_MAINTENANCEITEMSEARCH.[column in domain "ARTPR"] == T356.ARTPR
  • P_MAINTENANCEITEMSEARCH.MANDT == T356.MANDT
WORK CENTER
  • Object types of the CIM resource
  • Object ID of the Work Center
  • Client
  • P_MAINTENANCEITEMSEARCH.WORKCENTERTYPECODE == CRID.OBJTY
  • P_MAINTENANCEITEMSEARCH.MAINWORKCENTERINTERNALID == CRID.OBJID
  • P_MAINTENANCEITEMSEARCH.MANDT == CRID.MANDT
Material number
  • Material Number
  • Client
  • P_MAINTENANCEITEMSEARCH.MATERIAL == MARA.MATNR
  • P_MAINTENANCEITEMSEARCH.MANDT == MARA.MANDT
Notification type
  • Notification Type
  • Client
  • P_MAINTENANCEITEMSEARCH.NOTIFICATIONTYPE == TQ80.QMART
  • P_MAINTENANCEITEMSEARCH.MANDT == TQ80.MANDT
TASK LIST TYPE
  • Client
  • Task List Type
  • P_MAINTENANCEITEMSEARCH.MANDT == TCA01.MANDT
  • P_MAINTENANCEITEMSEARCH.TASKLISTTYPE == TCA01.PLNTY
Other Relations | to Master Data Relations ↑ Join Conditions
Maintenance plan category
  • Maintenance plan category
  • Maintenance item category
  • Client
  • P_MAINTENANCEITEMSEARCH.MAINTENANCEPLANCATEGORY == T399P.MITYP
  • P_MAINTENANCEITEMSEARCH.MAINTOBJECTCATEGORY == T399P.MITYP
  • P_MAINTENANCEITEMSEARCH.MANDT == T399P.MANDT
Maintenance planner group
  • Maintenance Planning Plant
  • Planner Group for Customer Service and Plant Maintenance
  • Client
  • P_MAINTENANCEITEMSEARCH.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • P_MAINTENANCEITEMSEARCH.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • P_MAINTENANCEITEMSEARCH.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • P_MAINTENANCEITEMSEARCH.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • P_MAINTENANCEITEMSEARCH.MANDT == T399I.MANDT
Maintenance item category
  • Maintenance plan category
  • Maintenance item category
  • Client
  • P_MAINTENANCEITEMSEARCH.MAINTENANCEPLANCATEGORY == T399P.MITYP
  • P_MAINTENANCEITEMSEARCH.MAINTOBJECTCATEGORY == T399P.MITYP
  • P_MAINTENANCEITEMSEARCH.MANDT == T399P.MANDT