C_OverdueMaintenanceOrderQ

Overdue Maintenance Orders | view: COVDMAINTORDQ | Extraction: Not supported | Component: Plant Maintenance

Tables used: AFIH, AFKO, JSTO, JEST, ILOA, T353I, T353I_T, AUFK, T003O, T003P, T356, T356_T, CRTX, CRHD

🔑 Keys (1)
💰 Amounts
∑ Quantities
📅 Dates (1)
☰ Categorical
Other (10)
🔗 Relations (14)

Column Name	Description
MaintenanceOrder FK	Order Number

Column Name	Description

Column Name	Description

Column Name	Description
ReferenceDate	Basic finish date

Column Name	Description

Column Name	Description	Domain name
MaintenanceOrderDesc	Description	TEXT40
MaintenanceOrderTypeName	Name of an Order Type	TEXT40
MaintPriorityDesc	Priority Text	TEXT20
MaintPriorityColorCode	null
MaintenanceActivityTypeName	Description of maintenance activity type	TXT30
MainWorkCenter	Work Center	ARBPL
MainWorkCenterText	Work Center Text	TEXT40
MaintenanceWorkCenter	Work Center	ARBPL
MaintenanceWorkCenterText	Work Center Text	TEXT40
OverdueDays	null

Master Data Relations \| to Other Relations ↓	Join Conditions
Controlling Area Controlling Area Client	`C_OVERDUEMAINTENANCEORDERQ.CONTROLLINGAREA == TKA01.KOKRS` `C_OVERDUEMAINTENANCEORDERQ.MANDT == TKA01.MANDT`
Equipment Number Equipment Number Client	`C_OVERDUEMAINTENANCEORDERQ.EQUIPMENT == EQUI.EQUNR` `C_OVERDUEMAINTENANCEORDERQ.MANDT == EQUI.MANDT`
Maintenance Activity Type Maintenance Activity Type Client	`C_OVERDUEMAINTENANCEORDERQ.MAINTENANCEACTIVITYTYPE == T353I.ILART` `C_OVERDUEMAINTENANCEORDERQ.MANDT == T353I.MANDT`
Order Number Order Number Client	`C_OVERDUEMAINTENANCEORDERQ.MAINTENANCEORDER == AUFK.AUFNR` `C_OVERDUEMAINTENANCEORDERQ.MANDT == AUFK.MANDT`
Order Type Order Type Client	`C_OVERDUEMAINTENANCEORDERQ.MAINTENANCEORDERTYPE == T003O.AUART` `C_OVERDUEMAINTENANCEORDERQ.MANDT == T003O.CLIENT`
Location Plant Location Plant Client	`C_OVERDUEMAINTENANCEORDERQ.MAINTENANCEPLANT == T001W.WERKS` `C_OVERDUEMAINTENANCEORDERQ.MANDT == T001W.MANDT`
Revision for Plant Maintenance and Customer Service Revision for Plant Maintenance and Customer Service Maintenance Planning Plant Client	`C_OVERDUEMAINTENANCEORDERQ.MAINTENANCEREVISION == T352R.REVNR` `C_OVERDUEMAINTENANCEORDERQ.MAINTENANCEPLANNINGPLANT == T352R.IWERK` `C_OVERDUEMAINTENANCEORDERQ.MANDT == T352R.MANDT`
Plant Client Plant Plant	`C_OVERDUEMAINTENANCEORDERQ.MANDT == T001W.MANDT` `C_OVERDUEMAINTENANCEORDERQ.MAINWORKCENTERPLANT == T001W.WERKS` `C_OVERDUEMAINTENANCEORDERQ.MAINTENANCEWORKCENTERPLANT == T001W.WERKS`
Location and account assignment for technical object Location and account assignment for technical object Client	`C_OVERDUEMAINTENANCEORDERQ.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN` `C_OVERDUEMAINTENANCEORDERQ.MANDT == ILOA.MANDT`
Priority Priority ? Client	`C_OVERDUEMAINTENANCEORDERQ.MAINTPRIORITY == T356.PRIOK` `C_OVERDUEMAINTENANCEORDERQ.[column in domain "ARTPR"] == T356.ARTPR` `C_OVERDUEMAINTENANCEORDERQ.MANDT == T356.MANDT`
Plant Client Plant Plant	`C_OVERDUEMAINTENANCEORDERQ.MANDT == T001W.MANDT` `C_OVERDUEMAINTENANCEORDERQ.MAINWORKCENTERPLANT == T001W.WERKS` `C_OVERDUEMAINTENANCEORDERQ.MAINTENANCEWORKCENTERPLANT == T001W.WERKS`
Responsible Cost Center ? Controlling Area Responsible Cost Center Client	`C_OVERDUEMAINTENANCEORDERQ.[column in domain "DATBI"] == CSKS.DATBI` `C_OVERDUEMAINTENANCEORDERQ.CONTROLLINGAREA == CSKS.KOKRS` `C_OVERDUEMAINTENANCEORDERQ.RESPONSIBLECOSTCENTER == CSKS.KOSTL` `C_OVERDUEMAINTENANCEORDERQ.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_OVERDUEMAINTENANCEORDERQ.MAINTENANCEPLANNERGROUP == T024I.INGRP` `C_OVERDUEMAINTENANCEORDERQ.MAINTENANCEPLANNINGPLANT == T024I.IWERK` `C_OVERDUEMAINTENANCEORDERQ.MANDT == T024I.MANDT`
Maintenance Planning Plant Maintenance Planning Plant Client	`C_OVERDUEMAINTENANCEORDERQ.MAINTENANCEPLANNINGPLANT == T399I.IWERK` `C_OVERDUEMAINTENANCEORDERQ.MANDT == T399I.MANDT`