C_MaintOrderForCompletionQ

Orders for Completion | view: CMAINTORDCOMPQ1 | TRAN | Extraction: Not supported | Component: Plant Maintenance
Tables used: AFIH, AFKO, EKKO, EKPO, EKKN, RESB, JSTO, JEST, BUT000, TKA01, TPMUS, AUFK, T000
Column Name Description
MaintenanceOrder FK Order Number
Column Name Description
Column Name Description
Column Name Description
ReferenceDate Basic finish date
Column Name Description
MaintOrderHasOpenReservations Checkbox Show values
MaintOrdHasOpenPurchaseOrders Checkbox Show values
MaintOrdHasOpenServices Checkbox Show values
CompleteTechlyAndSetNotifSts Complete Technically and Determine Notification Status Show values
MaintenanceProcessingPhase Maintenance Processing Phase Show values
Column Name Description Domain name
MaintenanceOrderDesc Description TEXT40
PersonResponsibleName Full Name TEXT80
MaintenanceOrderThumbnailURL null
MaintOrdTotalCost null
MaintOrdCostCriticality null
MaintOrdPersonResponsible Person Responsible ID I_PARNR
MainWorkCenter Main work center for maintenance tasks ARBPL
MainWorkCenterPlant Plant associated with main work center WERKS
Master Data Relations | to Other Relations ↓ Join Conditions
Controlling Area
  • Controlling Area
  • Client
  • C_MAINTORDERFORCOMPLETIONQ.CONTROLLINGAREA == TKA01.KOKRS
  • C_MAINTORDERFORCOMPLETIONQ.MANDT == TKA01.MANDT
Order Currency
  • Client
  • Order Currency
  • C_MAINTORDERFORCOMPLETIONQ.MANDT == TCURC.MANDT
  • C_MAINTORDERFORCOMPLETIONQ.CURRENCY == TCURC.WAERS
Equipment Number
  • Equipment Number
  • Client
  • C_MAINTORDERFORCOMPLETIONQ.EQUIPMENT == EQUI.EQUNR
  • C_MAINTORDERFORCOMPLETIONQ.MANDT == EQUI.MANDT
Order Number
  • Order Number
  • Client
  • C_MAINTORDERFORCOMPLETIONQ.MAINTENANCEORDER == AUFK.AUFNR
  • C_MAINTORDERFORCOMPLETIONQ.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • C_MAINTORDERFORCOMPLETIONQ.MAINTENANCEORDERTYPE == T003O.AUART
  • C_MAINTORDERFORCOMPLETIONQ.MANDT == T003O.CLIENT
Location Plant
  • Location Plant
  • Client
  • C_MAINTORDERFORCOMPLETIONQ.MAINTENANCEPLANT == T001W.WERKS
  • C_MAINTORDERFORCOMPLETIONQ.MANDT == T001W.MANDT
Revision for Plant Maintenance and Customer Service
  • Maintenance Planning Plant
  • Revision for Plant Maintenance and Customer Service
  • Client
  • C_MAINTORDERFORCOMPLETIONQ.MAINTENANCEPLANNINGPLANT == T352R.IWERK
  • C_MAINTORDERFORCOMPLETIONQ.MAINTENANCEREVISION == T352R.REVNR
  • C_MAINTORDERFORCOMPLETIONQ.MANDT == T352R.MANDT
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • C_MAINTORDERFORCOMPLETIONQ.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • C_MAINTORDERFORCOMPLETIONQ.MANDT == ILOA.MANDT
Responsible Cost Center
  • Responsible Cost Center
  • ?
  • Controlling Area
  • Client
  • C_MAINTORDERFORCOMPLETIONQ.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • C_MAINTORDERFORCOMPLETIONQ.[column in domain "DATBI"] == CSKS.DATBI
  • C_MAINTORDERFORCOMPLETIONQ.CONTROLLINGAREA == CSKS.KOKRS
  • C_MAINTORDERFORCOMPLETIONQ.MANDT == CSKS.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
  • C_MAINTORDERFORCOMPLETIONQ.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • C_MAINTORDERFORCOMPLETIONQ.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • C_MAINTORDERFORCOMPLETIONQ.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • C_MAINTORDERFORCOMPLETIONQ.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • C_MAINTORDERFORCOMPLETIONQ.MANDT == T399I.MANDT