P_MaintOrdersForPlanningC

Maintenance Orders for Planning | view: PMAINTORDPLANC | TRAN | Extraction: Not supported | Component: Plant Maintenance
Tables used: QMEL, AFIH, AFKO, JSTO, JEST, ILOA, T353I, T353I_T, AUFK, T003O, T003P, T356, T356_T, T356A, T356A_T, TJ30, CRHD
Column Name Description
MaintenanceOrder FK Order Number
Column Name Description
Column Name Description
Column Name Description
ReferenceDate Basic Start Date
Column Name Description
MaintenanceProcessingPhase Maintenance Processing Phase Show values
Column Name Description Domain name
MaintenanceActivityTypeName Description of maintenance activity type TXT30
OrderTypeName Name of an Order Type TEXT40
MaintPriorityDesc Priority Text TEXT20
MaintPriorityTypeDesc Priority Type Text TEXT20
MaintenanceWorkCenter Work Center ARBPL
MainWorkCenter Work Center ARBPL
StatusCode Object status J_STATUS
UserStatus User Status J_ESTAT
NmbrOfOutstandingMaintOrders Number of Outstanding Maintenance Orders MCZAEHLER
Master Data Relations | to Other Relations ↓ Join Conditions
Controlling Area
  • Controlling Area
  • Client
  • P_MAINTORDERSFORPLANNINGC.CONTROLLINGAREA == TKA01.KOKRS
  • P_MAINTORDERSFORPLANNINGC.MANDT == TKA01.MANDT
Equipment Number
  • Equipment Number
  • Client
  • P_MAINTORDERSFORPLANNINGC.EQUIPMENT == EQUI.EQUNR
  • P_MAINTORDERSFORPLANNINGC.MANDT == EQUI.MANDT
Maintenance Activity Type
  • Maintenance Activity Type
  • Client
  • P_MAINTORDERSFORPLANNINGC.MAINTENANCEACTIVITYTYPE == T353I.ILART
  • P_MAINTORDERSFORPLANNINGC.MANDT == T353I.MANDT
Order Number
  • Order Number
  • Client
  • P_MAINTORDERSFORPLANNINGC.MAINTENANCEORDER == AUFK.AUFNR
  • P_MAINTORDERSFORPLANNINGC.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • P_MAINTORDERSFORPLANNINGC.MAINTENANCEORDERTYPE == T003O.AUART
  • P_MAINTORDERSFORPLANNINGC.MANDT == T003O.CLIENT
Revision for Plant Maintenance and Customer Service
  • Revision for Plant Maintenance and Customer Service
  • Maintenance Planning Plant
  • Client
  • P_MAINTORDERSFORPLANNINGC.MAINTENANCEREVISION == T352R.REVNR
  • P_MAINTORDERSFORPLANNINGC.MAINTENANCEPLANNINGPLANT == T352R.IWERK
  • P_MAINTORDERSFORPLANNINGC.MANDT == T352R.MANDT
Maintenance Plant
  • Maintenance Plant
  • Client
  • P_MAINTORDERSFORPLANNINGC.MAINTENANCEWORKCENTERPLANT == T001W.WERKS
  • P_MAINTORDERSFORPLANNINGC.MANDT == T001W.MANDT
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • P_MAINTORDERSFORPLANNINGC.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • P_MAINTORDERSFORPLANNINGC.MANDT == ILOA.MANDT
Priority
  • Priority Type
  • Priority
  • Client
  • P_MAINTORDERSFORPLANNINGC.MAINTPRIORITYTYPE == T356.ARTPR
  • P_MAINTORDERSFORPLANNINGC.MAINTPRIORITY == T356.PRIOK
  • P_MAINTORDERSFORPLANNINGC.MANDT == T356.MANDT
Priority Type
  • Priority Type
  • Client
  • P_MAINTORDERSFORPLANNINGC.MAINTPRIORITYTYPE == T356A.ARTPR
  • P_MAINTORDERSFORPLANNINGC.MANDT == T356A.MANDT
Plant
  • Client
  • Plant
  • P_MAINTORDERSFORPLANNINGC.MANDT == T001W.MANDT
  • P_MAINTORDERSFORPLANNINGC.MAINWORKCENTERPLANT == T001W.WERKS
Notification Type
  • Client
  • Notification Type
  • P_MAINTORDERSFORPLANNINGC.MANDT == TQ80.MANDT
  • P_MAINTORDERSFORPLANNINGC.NOTIFICATIONTYPE == TQ80.QMART
Responsible Cost Center
  • Responsible Cost Center
  • ?
  • Controlling Area
  • Client
  • P_MAINTORDERSFORPLANNINGC.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • P_MAINTORDERSFORPLANNINGC.[column in domain "DATBI"] == CSKS.DATBI
  • P_MAINTORDERSFORPLANNINGC.CONTROLLINGAREA == CSKS.KOKRS
  • P_MAINTORDERSFORPLANNINGC.MANDT == CSKS.MANDT
Status Profile
  • Status Profile
  • Client
  • P_MAINTORDERSFORPLANNINGC.STATUSPROFILE == TJ20.STSMA
  • P_MAINTORDERSFORPLANNINGC.MANDT == TJ20.MANDT
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_MAINTORDERSFORPLANNINGC.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • P_MAINTORDERSFORPLANNINGC.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • P_MAINTORDERSFORPLANNINGC.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • P_MAINTORDERSFORPLANNINGC.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • P_MAINTORDERSFORPLANNINGC.MANDT == T399I.MANDT