I_MaintOrderTechObjCube

Maintenance Order With Tech Object - Cube | view: IMNTORDTOCUBE | TRAN | Extraction: Full only | Component: Maintenance Orders
Tables used: AFKO, AFIH, HIKO, JSTO, JEST, EQUI, EQKT, EQUZ, IFLOS, T370S, IFLOT, IFLOTX, ILOA, AUFK, IHPA, CRHD, ITOBCUST, IFLOUSR
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
MaintenanceOrderIsHistorical Indicator: Is Historical Maintenance Order Show values
MaintenanceOrderPlanningCode Maintenance order planning indicator Show values
MaintenanceProcessingPhase Maintenance Processing Phase Show values
IsMarkedForDeletion Deletion Flag Show values
TechObjIsEquipOrFuncnlLoc Technical Object Type Show values
WorkCenterTypeCode Object Type of CIM Resources for Work Center Show values
Column Name Description Domain name
MaintenanceOrderDesc Description TEXT40
SerialNumber Serial Number GERNR
MaintOrdPersonResponsible Partner Responsible for Execution (Person/User) I_PARNR
MaintenanceItem Maintenance item POSNU
TaskListType Bill of Operations Type PLNTY
TaskListGroup Bill of Operations ID PLNNR
TaskListGroupCounter Bill of Operations Variant ALTNR
AssetRoom Room CHAR8
MainWorkCenter Main work center for maintenance tasks ARBPL
WorkCenter Work Center ARBPL
ReferenceElement Reference Element PM/PS ADDCOMPARE_CORE
SuperiorProjectNetwork Number of superior network AUFNR
CreationDateTime Creation Date/Time TZNTSTMPS
LastChangeDateTime Changed On Timestamp with Date and 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
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
  • I_MAINTORDERTECHOBJCUBE.ABCINDICATOR == T370C.ABCKZ
  • I_MAINTORDERTECHOBJCUBE.MANDT == T370C.MANDT
Assembly
  • Assembly
  • Client
  • I_MAINTORDERTECHOBJCUBE.ASSEMBLY == MARA.MATNR
  • I_MAINTORDERTECHOBJCUBE.MANDT == MARA.MANDT
Location of maintenance object
  • Client
  • Location of maintenance object
  • Maintenance Plant
  • I_MAINTORDERTECHOBJCUBE.MANDT == T499S.MANDT
  • I_MAINTORDERTECHOBJCUBE.ASSETLOCATION == T499S.STAND
  • I_MAINTORDERTECHOBJCUBE.MAINTENANCEPLANT == T499S.WERKS
Business Area
  • Business Area
  • Client
  • I_MAINTORDERTECHOBJCUBE.BUSINESSAREA == TGSB.GSBER
  • I_MAINTORDERTECHOBJCUBE.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • I_MAINTORDERTECHOBJCUBE.COMPANYCODE == T001.BUKRS
  • I_MAINTORDERTECHOBJCUBE.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_MAINTORDERTECHOBJCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • I_MAINTORDERTECHOBJCUBE.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Cost Center
  • Client
  • I_MAINTORDERTECHOBJCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_MAINTORDERTECHOBJCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_MAINTORDERTECHOBJCUBE.COSTCENTER == CSKS.KOSTL
  • I_MAINTORDERTECHOBJCUBE.MANDT == CSKS.MANDT
Equipment Number
  • Equipment Number
  • Client
  • I_MAINTORDERTECHOBJCUBE.EQUIPMENT == EQUI.EQUNR
  • I_MAINTORDERTECHOBJCUBE.MANDT == EQUI.MANDT
Asset Subnumber
  • Main Asset Number
  • Asset Subnumber
  • Company Code
  • Client
  • I_MAINTORDERTECHOBJCUBE.MASTERFIXEDASSET == ANLA.ANLN1
  • I_MAINTORDERTECHOBJCUBE.FIXEDASSET == ANLA.ANLN2
  • I_MAINTORDERTECHOBJCUBE.COMPANYCODE == ANLA.BUKRS
  • I_MAINTORDERTECHOBJCUBE.MANDT == ANLA.MANDT
Functional Location
  • Functional Location
  • Client
  • I_MAINTORDERTECHOBJCUBE.FUNCTIONALLOCATION == IFLOT.TPLNR
  • I_MAINTORDERTECHOBJCUBE.MANDT == IFLOT.MANDT
Leading Order in Current Processing
  • Leading Order in Current Processing
  • Client
  • I_MAINTORDERTECHOBJCUBE.LEADINGORDER == AUFK.AUFNR
  • I_MAINTORDERTECHOBJCUBE.MANDT == AUFK.MANDT
Maintenance Activity Type
  • Maintenance Activity Type
  • Client
  • I_MAINTORDERTECHOBJCUBE.MAINTENANCEACTIVITYTYPE == T353I.ILART
  • I_MAINTORDERTECHOBJCUBE.MANDT == T353I.MANDT
Order Number
  • Order Number
  • Settlement order
  • Client
  • I_MAINTORDERTECHOBJCUBE.MAINTENANCEORDER == AUFK.AUFNR
  • I_MAINTORDERTECHOBJCUBE.SETTLEMENTORDER == AUFK.AUFNR
  • I_MAINTORDERTECHOBJCUBE.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • I_MAINTORDERTECHOBJCUBE.MAINTENANCEORDERTYPE == T003O.AUART
  • I_MAINTORDERTECHOBJCUBE.MANDT == T003O.CLIENT
Maintenance Plan
  • Client
  • Maintenance Plan
  • I_MAINTORDERTECHOBJCUBE.MANDT == MPLA.MANDT
  • I_MAINTORDERTECHOBJCUBE.MAINTENANCEPLAN == MPLA.WARPL
Maintenance Plant
  • Client
  • Maintenance Plant
  • I_MAINTORDERTECHOBJCUBE.MANDT == T001W.MANDT
  • I_MAINTORDERTECHOBJCUBE.MAINTENANCEPLANT == T001W.WERKS
Revision for Plant Maintenance and Customer Service
  • Maintenance Planning Plant
  • Client
  • Revision for Plant Maintenance and Customer Service
  • I_MAINTORDERTECHOBJCUBE.MAINTENANCEPLANNINGPLANT == T352R.IWERK
  • I_MAINTORDERTECHOBJCUBE.MANDT == T352R.MANDT
  • I_MAINTORDERTECHOBJCUBE.MAINTENANCEREVISION == T352R.REVNR
Priority
  • Priority Type
  • Client
  • Priority
  • I_MAINTORDERTECHOBJCUBE.MAINTPRIORITYTYPE == T356.ARTPR
  • I_MAINTORDERTECHOBJCUBE.MANDT == T356.MANDT
  • I_MAINTORDERTECHOBJCUBE.MAINTPRIORITY == T356.PRIOK
Priority Type
  • Priority Type
  • Client
  • I_MAINTORDERTECHOBJCUBE.MAINTPRIORITYTYPE == T356A.ARTPR
  • I_MAINTORDERTECHOBJCUBE.MANDT == T356A.MANDT
Object ID of the Work Center
  • Object Type of CIM Resources for Work Center
  • Object ID of the Work Center
  • Client
  • I_MAINTORDERTECHOBJCUBE.WORKCENTERTYPECODE == CRID.OBJTY
  • I_MAINTORDERTECHOBJCUBE.MAINWORKCENTERINTERNALID == CRID.OBJID
  • I_MAINTORDERTECHOBJCUBE.MANDT == CRID.MANDT
Plant associated with main work center
  • Plant
  • Plant associated with main work center
  • Client
  • I_MAINTORDERTECHOBJCUBE.WORKCENTERPLANT == T001W.WERKS
  • I_MAINTORDERTECHOBJCUBE.MAINWORKCENTERPLANT == T001W.WERKS
  • I_MAINTORDERTECHOBJCUBE.MANDT == T001W.MANDT
Material Number
  • Material Number
  • Client
  • I_MAINTORDERTECHOBJCUBE.MATERIAL == MARA.MATNR
  • I_MAINTORDERTECHOBJCUBE.MANDT == MARA.MANDT
System Condition
  • System Condition
  • Client
  • I_MAINTORDERTECHOBJCUBE.OPERATIONSYSTEMCONDITION == T357M.ANLZU
  • I_MAINTORDERTECHOBJCUBE.MANDT == T357M.MANDT
Plant Section
  • Plant Section
  • Client
  • Maintenance Plant
  • I_MAINTORDERTECHOBJCUBE.PLANTSECTION == T357.BEBER
  • I_MAINTORDERTECHOBJCUBE.MANDT == T357.MANDT
  • I_MAINTORDERTECHOBJCUBE.MAINTENANCEPLANT == T357.WERKS
Settlement order
  • Order Number
  • Settlement order
  • Client
  • I_MAINTORDERTECHOBJCUBE.MAINTENANCEORDER == AUFK.AUFNR
  • I_MAINTORDERTECHOBJCUBE.SETTLEMENTORDER == AUFK.AUFNR
  • I_MAINTORDERTECHOBJCUBE.MANDT == AUFK.MANDT
Object ID of PP work center
  • ?
  • Object ID of PP work center
  • Client
  • I_MAINTORDERTECHOBJCUBE.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_MAINTORDERTECHOBJCUBE.WORKCENTERINTERNALID == CRID.OBJID
  • I_MAINTORDERTECHOBJCUBE.MANDT == CRID.MANDT
Plant
  • Plant
  • Plant associated with main work center
  • Client
  • I_MAINTORDERTECHOBJCUBE.WORKCENTERPLANT == T001W.WERKS
  • I_MAINTORDERTECHOBJCUBE.MAINWORKCENTERPLANT == T001W.WERKS
  • I_MAINTORDERTECHOBJCUBE.MANDT == T001W.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Planner Group for Customer Service and Plant Maintenance
  • Client
  • I_MAINTORDERTECHOBJCUBE.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_MAINTORDERTECHOBJCUBE.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • I_MAINTORDERTECHOBJCUBE.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • I_MAINTORDERTECHOBJCUBE.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • I_MAINTORDERTECHOBJCUBE.MANDT == T399I.MANDT