I_MaintOrderTP

Maintenance Order w/ Technical Object | view: IMAINTORDERTP | TRAN | Extraction: Not supported | Component: Plant Maintenance
Tables used: AFIH, AFKO, AFKO, AFVC, JSTO, JEST, ILOA, AUFK, AUFK, EAM_MOPEXCPHASE, EAM_MOPEXCPHASEC
Column Name Description
MaintenanceOrder FK Order Number
Column Name Description
Column Name Description
Column Name Description
MaintOrdBasicStartDate Basic Start Date
MaintOrdBasicEndDate Basic finish date
LatestAcceptableCompletionDate Final Due Date
ScheduledBasicStartDate Scheduled start
ScheduledBasicStartTime Scheduled Start (Time)
ScheduledBasicEndDate Scheduled finish
ScheduledBasicEndTime Scheduled finish time
MaintOrderReferenceDate PM Order: Reference Date
CreationDate Created On
Column Name Description
TechObjIsEquipOrFuncnlLoc Technical Object Type Show values
MaintenanceProcessingPhase Maintenance Processing Phase Show values
MaintenanceOrderCategory Order category Show values
OrdIsNotSchedldAutomatically Indicator: Do not schedule automatically Show values
WorkCenterTypeCode Object Type of CIM Resources for Work Center Show values
MaintenanceOrderPlanningCode Maintenance order planning indicator Show values
ControllingObjectClass Controlling Object Class Show values
MaintOrderSourceApplication Source Application Show values
OrderHasLongText Order Has Long Text Show values
MaintOrderIsFinallyConfirmed Checkbox Show values
MaintOrdProcessPhaseCode Process Phase Show values
Column Name Description Domain name
TechnicalObject Technical Object EAMS_TEC_OBJ
MaintenanceItem Maintenance item POSNU
MaintenancePlanItemIntID Maintenance item POSNU
SerialNumber Serial Number GERNR
MaintOrderRoutingNumber Routing number of operations in the order AUFPL
MaintenanceOrderDesc Description TEXT40
MaintOrdMainWorkCenter Main work center for maintenance tasks ARBPL
MaintOrdMainWorkCenterPlant Plant associated with main work center WERKS
MaintOrdPersonResponsible Person Responsible ID I_PARNR
ReferenceElement Reference Element PM/PS ADDCOMPARE_CORE
AuthorizationGroup Technical Object Authorization Group IAUTG
CreatedByUser Entered By USNAM
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
MaintOrdHasOpenMainWork null
TaskListGroup Bill of Operations ID PLNNR
TaskListType Bill of Operations Type PLNTY
TaskListGroupCounter Bill of Operations Variant ALTNR
MaintOrdProcessSubPhaseCode Process Subphase EAM_OSTAT_SPHASE
Master Data Relations | to Other Relations ↓ Join Conditions
Assembly
  • Assembly
  • Client
  • I_MAINTORDERTP.ASSEMBLY == MARA.MATNR
  • I_MAINTORDERTP.MANDT == MARA.MANDT
Scheduling type
  • Scheduling type
  • Client
  • I_MAINTORDERTP.BASICSCHEDULINGTYPE == T482.TERMKZ
  • I_MAINTORDERTP.MANDT == T482.MANDT
Business Area
  • Business Area
  • Client
  • I_MAINTORDERTP.BUSINESSAREA == TGSB.GSBER
  • I_MAINTORDERTP.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • I_MAINTORDERTP.COMPANYCODE == T001.BUKRS
  • I_MAINTORDERTP.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_MAINTORDERTP.CONTROLLINGAREA == TKA01.KOKRS
  • I_MAINTORDERTP.MANDT == TKA01.MANDT
Order Currency
  • Order Currency
  • Client
  • I_MAINTORDERTP.CURRENCY == TCURC.WAERS
  • I_MAINTORDERTP.MANDT == TCURC.MANDT
Equipment Number
  • Equipment Number
  • Client
  • I_MAINTORDERTP.EQUIPMENT == EQUI.EQUNR
  • I_MAINTORDERTP.MANDT == EQUI.MANDT
Functional Location
  • Functional Location
  • Client
  • I_MAINTORDERTP.FUNCTIONALLOCATION == IFLOT.TPLNR
  • I_MAINTORDERTP.MANDT == IFLOT.MANDT
Maintenance Activity Type
  • Maintenance Activity Type
  • Client
  • I_MAINTORDERTP.MAINTENANCEACTIVITYTYPE == T353I.ILART
  • I_MAINTORDERTP.MANDT == T353I.MANDT
Order Number
  • Order Number
  • Order Number
  • Client
  • I_MAINTORDERTP.MAINTENANCEORDER == AUFK.AUFNR
  • I_MAINTORDERTP.MAINTENANCEORDERFOREDIT == AUFK.AUFNR
  • I_MAINTORDERTP.MANDT == AUFK.MANDT
Order Number
  • Order Number
  • Order Number
  • Client
  • I_MAINTORDERTP.MAINTENANCEORDER == AUFK.AUFNR
  • I_MAINTORDERTP.MAINTENANCEORDERFOREDIT == AUFK.AUFNR
  • I_MAINTORDERTP.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • I_MAINTORDERTP.MAINTENANCEORDERTYPE == T003O.AUART
  • I_MAINTORDERTP.MANDT == T003O.CLIENT
Maintenance Plan
  • Maintenance Plan
  • Client
  • I_MAINTORDERTP.MAINTENANCEPLAN == MPLA.WARPL
  • I_MAINTORDERTP.MANDT == MPLA.MANDT
Maintenance Plant
  • Maintenance Plant
  • Client
  • I_MAINTORDERTP.MAINTENANCEPLANT == T001W.WERKS
  • I_MAINTORDERTP.MANDT == T001W.MANDT
Revision for Plant Maintenance and Customer Service
  • Maintenance Planning Plant
  • Revision for Plant Maintenance and Customer Service
  • Client
  • I_MAINTORDERTP.MAINTENANCEPLANNINGPLANT == T352R.IWERK
  • I_MAINTORDERTP.MAINTENANCEREVISION == T352R.REVNR
  • I_MAINTORDERTP.MANDT == T352R.MANDT
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • I_MAINTORDERTP.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • I_MAINTORDERTP.MANDT == ILOA.MANDT
Priority
  • Priority Type
  • Priority
  • Client
  • I_MAINTORDERTP.MAINTPRIORITYTYPE == T356.ARTPR
  • I_MAINTORDERTP.MAINTPRIORITY == T356.PRIOK
  • I_MAINTORDERTP.MANDT == T356.MANDT
Priority Type
  • Priority Type
  • Client
  • I_MAINTORDERTP.MAINTPRIORITYTYPE == T356A.ARTPR
  • I_MAINTORDERTP.MANDT == T356A.MANDT
System Condition
  • System Condition
  • Client
  • I_MAINTORDERTP.OPERATIONSYSTEMCONDITION == T357M.ANLZU
  • I_MAINTORDERTP.MANDT == T357M.MANDT
Processing group
  • Controlling Area
  • Processing group
  • Client
  • I_MAINTORDERTP.CONTROLLINGAREA == TKO08.KOKRS
  • I_MAINTORDERTP.ORDERPROCESSINGGROUP == TKO08.ABKRS
  • I_MAINTORDERTP.MANDT == TKO08.CLIENT
Profit Center
  • Controlling Area
  • Profit Center
  • ?
  • Client
  • I_MAINTORDERTP.CONTROLLINGAREA == CEPC.KOKRS
  • I_MAINTORDERTP.PROFITCENTER == CEPC.PRCTR
  • I_MAINTORDERTP.[column in domain "DATBI"] == CEPC.DATBI
  • I_MAINTORDERTP.MANDT == CEPC.MANDT
Project definition
  • Project definition
  • Client
  • I_MAINTORDERTP.PROJECTINTERNALID == PROJ.PSPNR
  • I_MAINTORDERTP.MANDT == PROJ.MANDT
Responsible Cost Center
  • Controlling Area
  • ?
  • Responsible Cost Center
  • Client
  • I_MAINTORDERTP.CONTROLLINGAREA == CSKS.KOKRS
  • I_MAINTORDERTP.[column in domain "DATBI"] == CSKS.DATBI
  • I_MAINTORDERTP.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • I_MAINTORDERTP.MANDT == CSKS.MANDT
Object ID of the Work Center
  • Object ID of the Work Center
  • Client
  • Object Type of CIM Resources for Work Center
  • I_MAINTORDERTP.WORKCENTERINTERNALID == CRID.OBJID
  • I_MAINTORDERTP.MANDT == CRID.MANDT
  • I_MAINTORDERTP.WORKCENTERTYPECODE == CRID.OBJTY
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_MAINTORDERTP.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_MAINTORDERTP.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • I_MAINTORDERTP.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • I_MAINTORDERTP.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • I_MAINTORDERTP.MANDT == T399I.MANDT