I_MaintOrdersForPlanningC

Maintenance Orders for Planning | view: IMAINTORDPLANC | 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, TJ30, CRHD

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

Column Name	Description
MaintenanceOrder FK	Order Number

Column Name	Description

Column Name	Description

Column Name	Description
ReferenceDate	Basic Start Date

Column Name	Description
MaintenanceProcessingPhase	Maintenance Processing Phase	Show values

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
MaintenanceWorkCenter	Work Center	ARBPL
MainWorkCenter	Work Center	ARBPL
UserStatus	User Status	J_ESTAT
NmbrOfOutstandingMaintOrders	Number of Outstanding Maintenance Orders	MCZAEHLER
StatusProfileName	Text (30 Characters)	TEXT30

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

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