C_MaintOrderTechObjQuery

Maint. Order Analysis Query w. Techn.Obj | view: CMNTORDTOQUERY | TRAN | Extraction: Not supported | Component: Maintenance Orders

Tables used: AFKO, AFIH, HIKO, JSTO, JEST, EQUI, EQKT, EQUZ, IFLOS, T370S, IFLOT, IFLOTX, ILOA, AUFK, IHPA, CRHD, ITOBCUST, IFLOUSR

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

Column Name	Description
MaintenanceOrder FK	Order Number

Column Name	Description

Column Name	Description

Column Name	Description
CreationDate	Created On
CreationTime	Time created
LastChangeDate	Change Date for Order Master
LastChangeTime	Changed At
PlannedStartDate	Basic Start Date
PlannedStartTime	Basic Start (Time)
PlannedEndDate	Basic finish date
PlannedEndTime	Basic Finish (Time)
ScheduledBasicStartDate	Scheduled start
ScheduledBasicStartTime	Scheduled Start (Time)
ScheduledBasicEndDate	Scheduled finish
ScheduledBasicEndTime	Scheduled finish time
ActualStartDate	Actual start date
ActualStartTime	Actual start time
ConfirmedEndDate	Confirmed Order Finish Date
ConfirmedEndTime	Confirmed Order Finish (Time)
MaintOrderReferenceDate	PM Order: Reference Date

Column Name	Description
MaintenanceOrderPlanningCode	Maintenance order planning indicator	Show values
IsMarkedForDeletion	Deletion Flag	Show values
TechObjIsEquipOrFuncnlLoc	Technical Object Type	Show values
MaintenanceOrderIsHistorical	Indicator: Is Historical Maintenance Order	Show values

Column Name	Description	Domain name
MaintenanceOrderDesc	Description	TEXT40
SerialNumber	Serial Number	GERNR
MaintenanceItem	Maintenance item	POSNU
MainWorkCenter	Main work center for maintenance tasks	ARBPL
WorkCenter	Work Center	ARBPL
ReferenceElement	Reference Element PM/PS	ADDCOMPARE_CORE
CreationDateTime	Creation Date/Time	TZNTSTMPS
ScheduledBasicEndDateTime	Scheduled End Date/Time	TZNTSTMPS
ConfirmedEndDateTime	Confirmed Finish Date/Time	TZNTSTMPS
CreatedByUser	Entered By	USNAM
LastChangedByUser	Last Changed By	USNAM
TechnicalObject	Technical Object	EAMS_TEC_OBJ
TechnicalObjectType	null
AssetRoom	Room	CHAR8
MaintOrdPersonResponsible	Partner Responsible for Execution (Person/User)	I_PARNR
SuperiorProjectNetwork	Number of superior network	AUFNR
TaskListGroup	Bill of Operations ID	PLNNR
TaskListGroupCounter	Bill of Operations Variant	ALTNR
TaskListType	Bill of Operations Type	PLNTY
OrderLeadTimeDuration	Order Lead Time in Working Days Acc. to Factory Calendar	DURN
OrderRuntimeDuration	Order Runtime in Calendar Days	DURN
NumberOfCreatedMaintOrders	Number of Created Maintenance Orders	MCZAEHLER
NumberOfOrders	Number of All Not Deleted Maintenance Orders	MCZAEHLER
NumberOfCompletedMaintOrders	Number of Completed Maintenance Orders	MCZAEHLER
NumberOfPlannedMaintOrders	Number of Planned Maintenance Orders	MCZAEHLER
NumberOfUnplannedMaintOrders	Number of Unplanned Maintenance Orders	MCZAEHLER
NumberOfImmediateMaintOrders	Number of Immediate Orders	MCZAEHLER
NmbrOfMaintOrdsNotToBeExecuted	Number of Maintenance Orders Not to be Executed	MCZAEHLER
NmbrOfOutstandingMaintOrders	Number of Outstanding Maintenance Orders	MCZAEHLER
NmbrOfMaintOrdsCompletedOnTime	Number of Maintenance Orders Completed On Time	MCZAEHLER
NmbrOfHistoricalOrders	Number of Historical Maintenance Orders	MCZAEHLER

Master Data Relations \| to Other Relations ↓	Join Conditions
ABC Indicator for Technical Object ABC Indicator for Technical Object Client	`C_MAINTORDERTECHOBJQUERY.ABCINDICATOR == T370C.ABCKZ` `C_MAINTORDERTECHOBJQUERY.MANDT == T370C.MANDT`
Assembly Assembly Client	`C_MAINTORDERTECHOBJQUERY.ASSEMBLY == MARA.MATNR` `C_MAINTORDERTECHOBJQUERY.MANDT == MARA.MANDT`
Location of maintenance object Location of maintenance object Maintenance Plant Client	`C_MAINTORDERTECHOBJQUERY.ASSETLOCATION == T499S.STAND` `C_MAINTORDERTECHOBJQUERY.MAINTENANCEPLANT == T499S.WERKS` `C_MAINTORDERTECHOBJQUERY.MANDT == T499S.MANDT`
Business Area Business Area Client	`C_MAINTORDERTECHOBJQUERY.BUSINESSAREA == TGSB.GSBER` `C_MAINTORDERTECHOBJQUERY.MANDT == TGSB.MANDT`
Company Code Company Code Client	`C_MAINTORDERTECHOBJQUERY.COMPANYCODE == T001.BUKRS` `C_MAINTORDERTECHOBJQUERY.MANDT == T001.MANDT`
Controlling Area Controlling Area Client	`C_MAINTORDERTECHOBJQUERY.CONTROLLINGAREA == TKA01.KOKRS` `C_MAINTORDERTECHOBJQUERY.MANDT == TKA01.MANDT`
Cost Center Controlling Area ? Cost Center Client	`C_MAINTORDERTECHOBJQUERY.CONTROLLINGAREA == CSKS.KOKRS` `C_MAINTORDERTECHOBJQUERY.[column in domain "DATBI"] == CSKS.DATBI` `C_MAINTORDERTECHOBJQUERY.COSTCENTER == CSKS.KOSTL` `C_MAINTORDERTECHOBJQUERY.MANDT == CSKS.MANDT`
Equipment Number Equipment Number Client	`C_MAINTORDERTECHOBJQUERY.EQUIPMENT == EQUI.EQUNR` `C_MAINTORDERTECHOBJQUERY.MANDT == EQUI.MANDT`
Asset Subnumber Asset Subnumber Main Asset Number Company Code Client	`C_MAINTORDERTECHOBJQUERY.FIXEDASSET == ANLA.ANLN2` `C_MAINTORDERTECHOBJQUERY.MASTERFIXEDASSET == ANLA.ANLN1` `C_MAINTORDERTECHOBJQUERY.COMPANYCODE == ANLA.BUKRS` `C_MAINTORDERTECHOBJQUERY.MANDT == ANLA.MANDT`
Functional Location Functional Location Client	`C_MAINTORDERTECHOBJQUERY.FUNCTIONALLOCATION == IFLOT.TPLNR` `C_MAINTORDERTECHOBJQUERY.MANDT == IFLOT.MANDT`
Leading Order in Current Processing Leading Order in Current Processing Client	`C_MAINTORDERTECHOBJQUERY.LEADINGORDER == AUFK.AUFNR` `C_MAINTORDERTECHOBJQUERY.MANDT == AUFK.MANDT`
Maintenance Activity Type Maintenance Activity Type Client	`C_MAINTORDERTECHOBJQUERY.MAINTENANCEACTIVITYTYPE == T353I.ILART` `C_MAINTORDERTECHOBJQUERY.MANDT == T353I.MANDT`
Order Number Order Number Settlement order Client	`C_MAINTORDERTECHOBJQUERY.MAINTENANCEORDER == AUFK.AUFNR` `C_MAINTORDERTECHOBJQUERY.SETTLEMENTORDER == AUFK.AUFNR` `C_MAINTORDERTECHOBJQUERY.MANDT == AUFK.MANDT`
Order Type Order Type Client	`C_MAINTORDERTECHOBJQUERY.MAINTENANCEORDERTYPE == T003O.AUART` `C_MAINTORDERTECHOBJQUERY.MANDT == T003O.CLIENT`
Maintenance Plan Maintenance Plan Client	`C_MAINTORDERTECHOBJQUERY.MAINTENANCEPLAN == MPLA.WARPL` `C_MAINTORDERTECHOBJQUERY.MANDT == MPLA.MANDT`
Maintenance Plant Maintenance Plant Client	`C_MAINTORDERTECHOBJQUERY.MAINTENANCEPLANT == T001W.WERKS` `C_MAINTORDERTECHOBJQUERY.MANDT == T001W.MANDT`
Revision for Plant Maintenance and Customer Service Revision for Plant Maintenance and Customer Service Maintenance Planning Plant Client	`C_MAINTORDERTECHOBJQUERY.MAINTENANCEREVISION == T352R.REVNR` `C_MAINTORDERTECHOBJQUERY.MAINTENANCEPLANNINGPLANT == T352R.IWERK` `C_MAINTORDERTECHOBJQUERY.MANDT == T352R.MANDT`
Plant associated with main work center Plant Plant associated with main work center Client	`C_MAINTORDERTECHOBJQUERY.WORKCENTERPLANT == T001W.WERKS` `C_MAINTORDERTECHOBJQUERY.MAINWORKCENTERPLANT == T001W.WERKS` `C_MAINTORDERTECHOBJQUERY.MANDT == T001W.MANDT`
Material Number Material Number Client	`C_MAINTORDERTECHOBJQUERY.MATERIAL == MARA.MATNR` `C_MAINTORDERTECHOBJQUERY.MANDT == MARA.MANDT`
System Condition System Condition Client	`C_MAINTORDERTECHOBJQUERY.OPERATIONSYSTEMCONDITION == T357M.ANLZU` `C_MAINTORDERTECHOBJQUERY.MANDT == T357M.MANDT`
Plant Section Maintenance Plant Plant Section Client	`C_MAINTORDERTECHOBJQUERY.MAINTENANCEPLANT == T357.WERKS` `C_MAINTORDERTECHOBJQUERY.PLANTSECTION == T357.BEBER` `C_MAINTORDERTECHOBJQUERY.MANDT == T357.MANDT`
Settlement order Order Number Settlement order Client	`C_MAINTORDERTECHOBJQUERY.MAINTENANCEORDER == AUFK.AUFNR` `C_MAINTORDERTECHOBJQUERY.SETTLEMENTORDER == AUFK.AUFNR` `C_MAINTORDERTECHOBJQUERY.MANDT == AUFK.MANDT`
Plant Plant Plant associated with main work center Client	`C_MAINTORDERTECHOBJQUERY.WORKCENTERPLANT == T001W.WERKS` `C_MAINTORDERTECHOBJQUERY.MAINWORKCENTERPLANT == T001W.WERKS` `C_MAINTORDERTECHOBJQUERY.MANDT == T001W.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_MAINTORDERTECHOBJQUERY.MAINTENANCEPLANNERGROUP == T024I.INGRP` `C_MAINTORDERTECHOBJQUERY.MAINTENANCEPLANNINGPLANT == T024I.IWERK` `C_MAINTORDERTECHOBJQUERY.MANDT == T024I.MANDT`
Maintenance Planning Plant Maintenance Planning Plant Client	`C_MAINTORDERTECHOBJQUERY.MAINTENANCEPLANNINGPLANT == T399I.IWERK` `C_MAINTORDERTECHOBJQUERY.MANDT == T399I.MANDT`