P_MaintOrderSearch

Maintenance Order anchor view for CDS search model | view: PMAINTSEARCH | TRAN | Extraction: Not supported | Component: Plant Maintenance
Tables used: AFIH, AFKO, AUFK_TEXT, ESH_SR_LTXT, AUFK
Column Name Description
MaintenanceOrder FK Order Number
Column Name Description
Column Name Description
Column Name Description
MaintOrderReferenceDate PM Order: Reference Date
MaintOrdBasicStartDate Basic Start Date
MaintOrdBasicEndDate Basic finish date
LatestAcceptableCompletionDate Final Due Date
Column Name Description
MaintenanceProcessingPhase Maintenance Processing Phase Show values
WorkCenterTypeCode Object Type of CIM Resources for Work Center Show values
MaintenanceOrderPlanningCode Maintenance order planning indicator Show values
MaintenanceOrderCategory Order category Show values
OrderHasLongText Order Has Long Text Show values
Column Name Description Domain name
SerialNumber Serial Number GERNR
MaintenanceItem Maintenance item POSNU
ReferenceElement Reference Element PM/PS ADDCOMPARE_CORE
MaintOrderRoutingNumber Routing number of operations in the order AUFPL
MaintenanceOrderDesc Description TEXT40
CreatedByUser Entered By USNAM
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
AdditionalDeviceData Additional Device Data DEVICEID
PlainLongText Long Text
Master Data Relations | to Other Relations ↓ Join Conditions
Assembly
  • Client
  • Assembly
  • P_MAINTORDERSEARCH.MANDT == MARA.MANDT
  • P_MAINTORDERSEARCH.ASSEMBLY == MARA.MATNR
Scheduling type
  • Client
  • Scheduling type
  • P_MAINTORDERSEARCH.MANDT == T482.MANDT
  • P_MAINTORDERSEARCH.BASICSCHEDULINGTYPE == T482.TERMKZ
Business Area
  • Business Area
  • Client
  • P_MAINTORDERSEARCH.BUSINESSAREA == TGSB.GSBER
  • P_MAINTORDERSEARCH.MANDT == TGSB.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_MAINTORDERSEARCH.CONTROLLINGAREA == TKA01.KOKRS
  • P_MAINTORDERSEARCH.MANDT == TKA01.MANDT
Equipment Number
  • Client
  • Equipment Number
  • P_MAINTORDERSEARCH.MANDT == EQUI.MANDT
  • P_MAINTORDERSEARCH.EQUIPMENT == EQUI.EQUNR
Maintenance Activity Type
  • Maintenance Activity Type
  • Client
  • P_MAINTORDERSEARCH.MAINTENANCEACTIVITYTYPE == T353I.ILART
  • P_MAINTORDERSEARCH.MANDT == T353I.MANDT
Order Number
  • Order Number
  • Client
  • P_MAINTORDERSEARCH.MAINTENANCEORDER == AUFK.AUFNR
  • P_MAINTORDERSEARCH.MANDT == AUFK.MANDT
Order Type
  • Client
  • Order Type
  • P_MAINTORDERSEARCH.MANDT == T003O.CLIENT
  • P_MAINTORDERSEARCH.MAINTENANCEORDERTYPE == T003O.AUART
Maintenance Plan
  • Client
  • Maintenance Plan
  • P_MAINTORDERSEARCH.MANDT == MPLA.MANDT
  • P_MAINTORDERSEARCH.MAINTENANCEPLAN == MPLA.WARPL
Location Plant
  • Location Plant
  • Client
  • P_MAINTORDERSEARCH.MAINTENANCEPLANT == T001W.WERKS
  • P_MAINTORDERSEARCH.MANDT == T001W.MANDT
Revision for Plant Maintenance and Customer Service
  • Revision for Plant Maintenance and Customer Service
  • Maintenance Planning Plant
  • Client
  • P_MAINTORDERSEARCH.MAINTENANCEREVISION == T352R.REVNR
  • P_MAINTORDERSEARCH.MAINTENANCEPLANNINGPLANT == T352R.IWERK
  • P_MAINTORDERSEARCH.MANDT == T352R.MANDT
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • P_MAINTORDERSEARCH.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • P_MAINTORDERSEARCH.MANDT == ILOA.MANDT
Priority
  • Priority Type
  • Client
  • Priority
  • P_MAINTORDERSEARCH.MAINTPRIORITYTYPE == T356.ARTPR
  • P_MAINTORDERSEARCH.MANDT == T356.MANDT
  • P_MAINTORDERSEARCH.MAINTPRIORITY == T356.PRIOK
Priority Type
  • Priority Type
  • Client
  • P_MAINTORDERSEARCH.MAINTPRIORITYTYPE == T356A.ARTPR
  • P_MAINTORDERSEARCH.MANDT == T356A.MANDT
System Condition
  • System Condition
  • Client
  • P_MAINTORDERSEARCH.OPERATIONSYSTEMCONDITION == T357M.ANLZU
  • P_MAINTORDERSEARCH.MANDT == T357M.MANDT
Responsible Cost Center
  • Controlling Area
  • Responsible Cost Center
  • Client
  • ?
  • P_MAINTORDERSEARCH.CONTROLLINGAREA == CSKS.KOKRS
  • P_MAINTORDERSEARCH.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • P_MAINTORDERSEARCH.MANDT == CSKS.MANDT
  • P_MAINTORDERSEARCH.[column in domain "DATBI"] == CSKS.DATBI
Object ID of the Work Center
  • Object ID of the Work Center
  • Client
  • Object Type of CIM Resources for Work Center
  • P_MAINTORDERSEARCH.WORKCENTERINTERNALID == CRID.OBJID
  • P_MAINTORDERSEARCH.MANDT == CRID.MANDT
  • P_MAINTORDERSEARCH.WORKCENTERTYPECODE == CRID.OBJTY
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Client
  • P_MAINTORDERSEARCH.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • P_MAINTORDERSEARCH.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • P_MAINTORDERSEARCH.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • P_MAINTORDERSEARCH.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • P_MAINTORDERSEARCH.MANDT == T399I.MANDT