P_MaintOrderForComplPreAggr

Number of Open Purchase Order Items | view: PMAINTORDCOMPL | Extraction: Not supported | Component: Plant Maintenance
Tables used: AFIH, AFKO, EKKO, EKPO, EKKN, RESB, JSTO, JEST, TKA01, 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
MaintOrdHasOpenPurchaseOrders Checkbox Show values
MaintOrdHasOpenServices Checkbox Show values
MaintOrderHasOpenReservations Checkbox Show values
Column Name Description Domain name
MaintenanceOrderDesc Description TEXT40
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
  • P_MAINTORDERFORCOMPLPREAGGR.CONTROLLINGAREA == TKA01.KOKRS
  • P_MAINTORDERFORCOMPLPREAGGR.MANDT == TKA01.MANDT
Order Currency
  • Client
  • Order Currency
  • P_MAINTORDERFORCOMPLPREAGGR.MANDT == TCURC.MANDT
  • P_MAINTORDERFORCOMPLPREAGGR.CURRENCY == TCURC.WAERS
Equipment Number
  • Equipment Number
  • Client
  • P_MAINTORDERFORCOMPLPREAGGR.EQUIPMENT == EQUI.EQUNR
  • P_MAINTORDERFORCOMPLPREAGGR.MANDT == EQUI.MANDT
Order Number
  • Order Number
  • Client
  • P_MAINTORDERFORCOMPLPREAGGR.MAINTENANCEORDER == AUFK.AUFNR
  • P_MAINTORDERFORCOMPLPREAGGR.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • P_MAINTORDERFORCOMPLPREAGGR.MAINTENANCEORDERTYPE == T003O.AUART
  • P_MAINTORDERFORCOMPLPREAGGR.MANDT == T003O.CLIENT
Location Plant
  • Location Plant
  • Client
  • P_MAINTORDERFORCOMPLPREAGGR.MAINTENANCEPLANT == T001W.WERKS
  • P_MAINTORDERFORCOMPLPREAGGR.MANDT == T001W.MANDT
Revision for Plant Maintenance and Customer Service
  • Revision for Plant Maintenance and Customer Service
  • Maintenance Planning Plant
  • Client
  • P_MAINTORDERFORCOMPLPREAGGR.MAINTENANCEREVISION == T352R.REVNR
  • P_MAINTORDERFORCOMPLPREAGGR.MAINTENANCEPLANNINGPLANT == T352R.IWERK
  • P_MAINTORDERFORCOMPLPREAGGR.MANDT == T352R.MANDT
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • P_MAINTORDERFORCOMPLPREAGGR.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • P_MAINTORDERFORCOMPLPREAGGR.MANDT == ILOA.MANDT
Responsible Cost Center
  • Controlling Area
  • ?
  • Responsible Cost Center
  • Client
  • P_MAINTORDERFORCOMPLPREAGGR.CONTROLLINGAREA == CSKS.KOKRS
  • P_MAINTORDERFORCOMPLPREAGGR.[column in domain "DATBI"] == CSKS.DATBI
  • P_MAINTORDERFORCOMPLPREAGGR.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • P_MAINTORDERFORCOMPLPREAGGR.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
  • P_MAINTORDERFORCOMPLPREAGGR.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • P_MAINTORDERFORCOMPLPREAGGR.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • P_MAINTORDERFORCOMPLPREAGGR.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • P_MAINTORDERFORCOMPLPREAGGR.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • P_MAINTORDERFORCOMPLPREAGGR.MANDT == T399I.MANDT