P_OverdueMaintenanceOrderC

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

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

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

Column Name	Description
MaintenanceOrder FK	Order Number

Column Name	Description

Column Name	Description

Column Name	Description
ReferenceDate	Basic finish date

Column Name	Description
MaintenanceProcessingPhase	Maintenance Processing Phase	Show values

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
MaintenanceWorkCenter	Work Center	ARBPL
MaintenanceWorkCenterText	Work Center Text	TEXT40
MainWorkCenter	Work Center	ARBPL
MainWorkCenterText	Work Center Text	TEXT40
OverdueDays	null

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

Other Relations \| to Master Data Relations ↑	Join Conditions
Planner Group for Customer Service and Plant Maintenance Client Planner Group for Customer Service and Plant Maintenance Maintenance Planning Plant	`P_OVERDUEMAINTENANCEORDERC.MANDT == T024I.MANDT` `P_OVERDUEMAINTENANCEORDERC.MAINTENANCEPLANNERGROUP == T024I.INGRP` `P_OVERDUEMAINTENANCEORDERC.MAINTENANCEPLANNINGPLANT == T024I.IWERK`
Maintenance Planning Plant Client Maintenance Planning Plant	`P_OVERDUEMAINTENANCEORDERC.MANDT == T399I.MANDT` `P_OVERDUEMAINTENANCEORDERC.MAINTENANCEPLANNINGPLANT == T399I.IWERK`