C_MaintOrdersForPlanningQ

Maintenance Orders for Planning | view: CMAINORDPLANQ | 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, TJ20, TJ20T, TJ02T, TJ30, TJ30T, CRHD
Column Name Description
MaintenanceOrder FK Order Number
Column Name Description
Column Name Description
Column Name Description
ReferenceDate Basic Start Date
Column Name Description
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
MainWorkCenter Work Center ARBPL
UserStatus null
StatusName null
StatusProfile null
NmbrOfOutstandingMaintOrders Number of Outstanding Maintenance Orders MCZAEHLER
Master Data Relations | to Other Relations ↓ Join Conditions
Controlling Area
  • Client
  • Controlling Area
  • C_MAINTORDERSFORPLANNINGQ.MANDT == TKA01.MANDT
  • C_MAINTORDERSFORPLANNINGQ.CONTROLLINGAREA == TKA01.KOKRS
Equipment Number
  • Client
  • Equipment Number
  • C_MAINTORDERSFORPLANNINGQ.MANDT == EQUI.MANDT
  • C_MAINTORDERSFORPLANNINGQ.EQUIPMENT == EQUI.EQUNR
Maintenance Activity Type
  • Maintenance Activity Type
  • Client
  • C_MAINTORDERSFORPLANNINGQ.MAINTENANCEACTIVITYTYPE == T353I.ILART
  • C_MAINTORDERSFORPLANNINGQ.MANDT == T353I.MANDT
Order Number
  • Order Number
  • Client
  • C_MAINTORDERSFORPLANNINGQ.MAINTENANCEORDER == AUFK.AUFNR
  • C_MAINTORDERSFORPLANNINGQ.MANDT == AUFK.MANDT
Order Type
  • Client
  • Order Type
  • C_MAINTORDERSFORPLANNINGQ.MANDT == T003O.CLIENT
  • C_MAINTORDERSFORPLANNINGQ.MAINTENANCEORDERTYPE == T003O.AUART
Revision for Plant Maintenance and Customer Service
  • Revision for Plant Maintenance and Customer Service
  • Client
  • Maintenance Planning Plant
  • C_MAINTORDERSFORPLANNINGQ.MAINTENANCEREVISION == T352R.REVNR
  • C_MAINTORDERSFORPLANNINGQ.MANDT == T352R.MANDT
  • C_MAINTORDERSFORPLANNINGQ.MAINTENANCEPLANNINGPLANT == T352R.IWERK
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • C_MAINTORDERSFORPLANNINGQ.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • C_MAINTORDERSFORPLANNINGQ.MANDT == ILOA.MANDT
Priority
  • Client
  • Priority
  • Priority Type
  • C_MAINTORDERSFORPLANNINGQ.MANDT == T356.MANDT
  • C_MAINTORDERSFORPLANNINGQ.MAINTPRIORITY == T356.PRIOK
  • C_MAINTORDERSFORPLANNINGQ.MAINTPRIORITYTYPE == T356.ARTPR
Priority Type
  • Client
  • Priority Type
  • C_MAINTORDERSFORPLANNINGQ.MANDT == T356A.MANDT
  • C_MAINTORDERSFORPLANNINGQ.MAINTPRIORITYTYPE == T356A.ARTPR
Plant
  • Plant
  • Client
  • C_MAINTORDERSFORPLANNINGQ.MAINWORKCENTERPLANT == T001W.WERKS
  • C_MAINTORDERSFORPLANNINGQ.MANDT == T001W.MANDT
Notification Type
  • Client
  • Notification Type
  • C_MAINTORDERSFORPLANNINGQ.MANDT == TQ80.MANDT
  • C_MAINTORDERSFORPLANNINGQ.NOTIFICATIONTYPE == TQ80.QMART
Responsible Cost Center
  • Responsible Cost Center
  • Client
  • ?
  • Controlling Area
  • C_MAINTORDERSFORPLANNINGQ.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • C_MAINTORDERSFORPLANNINGQ.MANDT == CSKS.MANDT
  • C_MAINTORDERSFORPLANNINGQ.[column in domain "DATBI"] == CSKS.DATBI
  • C_MAINTORDERSFORPLANNINGQ.CONTROLLINGAREA == CSKS.KOKRS
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Planner Group for Customer Service and Plant Maintenance
  • Client
  • Maintenance Planning Plant
  • C_MAINTORDERSFORPLANNINGQ.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • C_MAINTORDERSFORPLANNINGQ.MANDT == T024I.MANDT
  • C_MAINTORDERSFORPLANNINGQ.MAINTENANCEPLANNINGPLANT == T024I.IWERK
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • C_MAINTORDERSFORPLANNINGQ.MANDT == T399I.MANDT
  • C_MAINTORDERSFORPLANNINGQ.MAINTENANCEPLANNINGPLANT == T399I.IWERK