C_ObjPgMaintOrderAndOperation

Maintenance Order and Operation | view: COPORDOP | Extraction: Not supported | Component: Plant Maintenance

Tables used: EAM_OSTOBJSTS, AFKO, OBJK, QMEL, AFIH, AFVC, AFVV, OPROL, QMIH, JSTO, JEST, T370C, T370C_T, TGSB, TGSBT, BUT000, TKA01, CSKS, CSKT, EQUI, EQKT, EQUZ, IFLOS, IFLOT, T370S, IFLOTX, T499S, ILOA, AUFK, T353I, T353I_T, MPOS, MPLA, T399W, T357M, T357M_T, EAM_MOPEXCPHASEA, EAM_MOPEXCPHASET, MARA, MAKT, T430, T430T, T003O, T003P, T001W, T357, T356, T356_T, T356A, NRIV, TQ80, T356A_T, CRTX, T000, LFA1, USR21, CRHD, EAM_MOPEXCPHASE, EAM_MOPEXCPHASEC, ITOBCUST, IFLOUSR, T024I, T350, TPAER

🔑 Keys (3)
💰 Amounts (1)
∑ Quantities (5)
📅 Dates (22)
☰ Categorical (6)
Other (86)
🔗 Relations (42)

Column Name	Description
MaintenanceOrder FK	Order Number
MaintenanceOrderOperation	Operation/Activity Number
MaintenanceOrderSubOperation	Operation/Activity Number

Column Name	Description
💲 Currency Key (OpExternalProcessingCurrency):
OpExternalProcessingPrice	Price

Column Name	Description
📏 Unit for work (OperationPlannedWorkUnit):
OperationPlannedWork	Work involved in the activity
ConfirmationTotalQuantity	Actual work
📏 Normal duration/unit (OperationDurationUnit):
OperationDuration	Normal duration of the activity
📏 Base Unit of Measure (OperationQuantityUnit):
OperationQuantity	Operation Quantity in Unit of Measure of Order
ForecastedWorkQty	Forecasted work (actual + remaining)

Column Name	Description
OpErlstSchedldExecStrtDte	Earliest scheduled start: Execution (date)
OpErlstSchedldExecStrtTme	Earliest scheduled start: Execution (time)
OpErlstSchedldExecEndDte	Earliest scheduled finish: Execution (date)
OpErlstSchedldExecEndTme	Earliest scheduled finish: Execution (time)
OpLtstSchedldExecStrtDte	Latest scheduled start: Execution (date)
OpLtstSchedldExecStrtTme	Latest scheduled start: Execution (time)
OpLtstSchedldExecEndDte	Latest scheduled finish: Execution (date)
OpLtstSchedldExecEndTme	Latest scheduled finish: Execution (time)
OpActualExecutionStartDate	Actual Execution Start Date
OpActualExecutionStartTime	Actual Execution Start Time
OpActualExecutionEndDate	Actual Execution End Date
OpActualExecutionEndTime	Actual Execution End Time
LatestAcceptableCompletionDate	Final Due Date
MaintOrdBasicStartDate	Basic Start Date
MaintOrdBasicEndDate	Basic finish date
MaintOrderReferenceDate	PM Order: Reference Date
ScheduledBasicStartDate	Scheduled start
ScheduledBasicStartTime	Scheduled Start (Time)
ScheduledBasicEndDate	Scheduled finish
ScheduledBasicEndTime	Scheduled finish time
CreationDate	Created On
LastChangeDate	Change Date for Order Master

Column Name	Description
OperationCalculationControl	Key for calculation	Show values
MaintOrdOpProcessPhaseCode	Maintenance Order Operation Processing Phase Code	Show values
MaintOrdProcessPhaseCode	Maintenance Order Processing Phase Code	Show values
IsFinallyConfirmed	Finally Confirmed	Show values
IsOverdue	Checkbox	Show values
WorkCenterTypeCode	Object Type of CIM Resources for Work Center	Show values

Column Name	Description	Domain name
MaintenanceOrderDesc	Description	TEXT40
MaintenanceProcessingPhase	Maintenance Processing Phase
MaintenanceOrderTypeName	Name of an Order Type	TEXT40
TechnicalObjectLabel	Technical Object Identifier	EAMS_TECH_OBJ_CONV
TechnicalObjectDescription	Technical Object Description
TechObjIsEquipOrFuncnlLoc	Technical Object Type
TechObjIsEquipOrFuncnlLocDesc	Description of Technical Object Type
OperationDescription	Operation Short Text
OperationTechnicalObjectLabel	Technical Object Identifier
OperationTechnicalObjectDesc	Technical Object Description
OperationTechObjIsEquip	Technical Object Type
OperationTechObjIsEquipDesc	Description of Technical Object Type
OperationMaintNotificationText	Short Text
OperationControlProfileName	Operation Control Profile Name
WorkCenter	Work Center
WorkCenterText	Work Center Text
OperationHasLongText	Checkbox
OperationPurgInfoRecdSearchTxt	Sort Term for Non-Stock Info Records	CHAR10
PlantName	Plant Name
PurchaseRequisition	Purchase Requisition Number
OperationRequisitionerName	Name of requisitioner/requester	AFNAM
OperationGoodsRecipientName	Goods Recipient
OpExternalProcessingPriceUnit	Price unit
OperationTrackingNumber	Requirement Tracking Number
OperationUnloadingPointName	Unloading Point	TEXT25
OperationSupplierName	Name of Supplier
OperationPersonResponsible	Person Responsible
Personnel	Personnel number	PERNR
OperationPersonRespName	Full Name
AssemblyName	Material Description
OperationSystemConditionText	Text on Operating Condition
OperationCalcControlDesc	Calculation Key Description
OperationWorkPercent	Work percentage
MaintOrdOpProcessSubPhaseCode	Maintenance Order Operation Processing Subphase Code	EAM_OSTAT_SPHASE
MaintOrdProcessSubPhaseCode	Maintenance Order Processing Subphase Code	EAM_OSTAT_SPHASE
OpPlndDeliveryDurationInDays	Planned Delivery Time in Days
OpPlannedProcessingDurn	null
OrderHasLongText	Order Has Long Text
MaintPriorityTypeDesc	Priority Type Text
MaintPriorityDesc	Priority Text
MaintPriorityColorCode	null
MaintenanceNotificationText	Short Text
MaintenanceItem	Maintenance item	POSNU
MaintenanceItemDescription	Item Short Text
SerialNumber	Serial Number	GERNR
MaintenancePlanningPlantName	Plant Name
MaintenancePlannerGroupName	Name of the Maintenance Planner Group
MaintenancePlanDesc	Maintenance Plan Text
BusinessAreaName	Business Area Description
MaintOrdMainWorkCenter	Main work center for maintenance tasks
MainWorkCenterText	Work Center Text
MaintOrdMainWorkCenterPlant	Plant associated with main work center
MainWorkCenterPlantName	Plant Name
MaintOrdPersonResponsible_H	Person Responsible ID	I_PARNR
MaintOrdPersonResponsible	Person Responsible
PersonResponsibleName	Person Responsible Name
MaintenanceOrderPlanningCode	Maintenance order planning indicator
MaintOrderPlanningCodeName	Short Text for Fixed Values
MaintenanceActivityTypeName	Description of maintenance activity type
ResponsibleCostCenterName	Cost Center Name
MaintenancePlantName	Plant Name
AssetLocationName	Location Name	TEXT40
SortField	Sort Field
ABCIndicatorDesc	Description of ABC Indicator of Technical Object
PlantSectionPersonRespName	Group of Employees Responsible for Company Area
PlantSectionPersonRespPhone	Phone Number of Employee Group Responsible for Company Area
CostCenterName	Cost Center Name
ControllingAreaName	Controlling Area Name
CreatedByUser	Entered By
CreatedByUserDescription	User Description
LastChangedByUser	Last Changed By
LastChangedByUserName	User Description
MaintOrderOperationLongText	null
MaintOrdCnctntdActvSystSts	Concatenated System Status
MaintOrdCnctntdActvUserSts	Concatenated User Status
ConcatenatedOrderPhaseCtrlText	Phase control codes for maintenance order
ConcatenatedOrdOpPhaseCtrlText	Phase control codes for maintenance operation	CHAR1000
MaintOpExecutionStageName	Short Name of Maintenance Operation Execution Stage	TEXT10
MaintOpExecStageShortText	Description of Maintenance Operation Execution Stage	TEXT30
MaintOrderOperationCounter	General counter for order	CO_APLZL
MaintOrderRoutingNumber	Routing number of operations in the order	AUFPL
AuthorizationGroup	Technical Object Authorization Group	IAUTG
FunctionalLocationLabelName	Functional Location Label	ILOM_STRNO
MaintOrderConfirmation	Completion confirmation number for the operation	CO_RUECK
MaintOperationExecStageCode	PRE MAIN POST	EAM_PREMAINPOST_CDS
MaintOperationTechnicalObject	Technical Object	EAMS_TEC_OBJ

Master Data Relations \| to Other Relations ↓	Join Conditions
ABC Indicator for Technical Object ABC Indicator for Technical Object Client	`C_OBJPGMAINTORDERANDOPERATION.ABCINDICATOR == T370C.ABCKZ` `C_OBJPGMAINTORDERANDOPERATION.MANDT == T370C.MANDT`
Assembly Assembly Client	`C_OBJPGMAINTORDERANDOPERATION.ASSEMBLY == MARA.MATNR` `C_OBJPGMAINTORDERANDOPERATION.MANDT == MARA.MANDT`
Location of maintenance object Client Location of maintenance object Maintenance Plant	`C_OBJPGMAINTORDERANDOPERATION.MANDT == T499S.MANDT` `C_OBJPGMAINTORDERANDOPERATION.ASSETLOCATION == T499S.STAND` `C_OBJPGMAINTORDERANDOPERATION.MAINTENANCEPLANT == T499S.WERKS`
Business Area Business Area Client	`C_OBJPGMAINTORDERANDOPERATION.BUSINESSAREA == TGSB.GSBER` `C_OBJPGMAINTORDERANDOPERATION.MANDT == TGSB.MANDT`
Controlling Area Controlling Area Client	`C_OBJPGMAINTORDERANDOPERATION.CONTROLLINGAREA == TKA01.KOKRS` `C_OBJPGMAINTORDERANDOPERATION.MANDT == TKA01.MANDT`
Cost Center ? Controlling Area Cost Center Client	`C_OBJPGMAINTORDERANDOPERATION.[column in domain "DATBI"] == CSKS.DATBI` `C_OBJPGMAINTORDERANDOPERATION.CONTROLLINGAREA == CSKS.KOKRS` `C_OBJPGMAINTORDERANDOPERATION.COSTCENTER == CSKS.KOSTL` `C_OBJPGMAINTORDERANDOPERATION.MANDT == CSKS.MANDT`
Activity Type ? Controlling area of the requesting cost center Activity Type Client	`C_OBJPGMAINTORDERANDOPERATION.[column in domain "DATBI"] == CSLA.DATBI` `C_OBJPGMAINTORDERANDOPERATION.REQGCOSTCENTERCONTROLLINGAREA == CSLA.KOKRS` `C_OBJPGMAINTORDERANDOPERATION.COSTCTRACTIVITYTYPE == CSLA.LSTAR` `C_OBJPGMAINTORDERANDOPERATION.MANDT == CSLA.MANDT`
Maintenance Activity Type Maintenance Activity Type Client	`C_OBJPGMAINTORDERANDOPERATION.MAINTENANCEACTIVITYTYPE == T353I.ILART` `C_OBJPGMAINTORDERANDOPERATION.MANDT == T353I.MANDT`
Order Number Client Order Number	`C_OBJPGMAINTORDERANDOPERATION.MANDT == AUFK.MANDT` `C_OBJPGMAINTORDERANDOPERATION.MAINTENANCEORDER == AUFK.AUFNR`
Order Type Order Type Client	`C_OBJPGMAINTORDERANDOPERATION.MAINTENANCEORDERTYPE == T003O.AUART` `C_OBJPGMAINTORDERANDOPERATION.MANDT == T003O.CLIENT`
Maintenance Plan Maintenance Plan Client	`C_OBJPGMAINTORDERANDOPERATION.MAINTENANCEPLAN == MPLA.WARPL` `C_OBJPGMAINTORDERANDOPERATION.MANDT == MPLA.MANDT`
Maintenance Plant Client Maintenance Plant	`C_OBJPGMAINTORDERANDOPERATION.MANDT == T001W.MANDT` `C_OBJPGMAINTORDERANDOPERATION.MAINTENANCEPLANT == T001W.WERKS`
Revision for Plant Maintenance and Customer Service Revision for Plant Maintenance and Customer Service Client Maintenance Planning Plant	`C_OBJPGMAINTORDERANDOPERATION.MAINTENANCEREVISION == T352R.REVNR` `C_OBJPGMAINTORDERANDOPERATION.MANDT == T352R.MANDT` `C_OBJPGMAINTORDERANDOPERATION.MAINTENANCEPLANNINGPLANT == T352R.IWERK`
Location and account assignment for technical object Location and account assignment for technical object Client	`C_OBJPGMAINTORDERANDOPERATION.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN` `C_OBJPGMAINTORDERANDOPERATION.MANDT == ILOA.MANDT`
Partner Function of Order Header Client Partner Function of Order Header	`C_OBJPGMAINTORDERANDOPERATION.MANDT == TPAR.MANDT` `C_OBJPGMAINTORDERANDOPERATION.MAINTORDERRESPPARTNERFUNCTION == TPAR.PARVW`
Priority Priority Priority Type Client	`C_OBJPGMAINTORDERANDOPERATION.MAINTPRIORITY == T356.PRIOK` `C_OBJPGMAINTORDERANDOPERATION.MAINTPRIORITYTYPE == T356.ARTPR` `C_OBJPGMAINTORDERANDOPERATION.MANDT == T356.MANDT`
Priority Type Priority Type Client	`C_OBJPGMAINTORDERANDOPERATION.MAINTPRIORITYTYPE == T356A.ARTPR` `C_OBJPGMAINTORDERANDOPERATION.MANDT == T356A.MANDT`
Control key Control key Client ?	`C_OBJPGMAINTORDERANDOPERATION.OPERATIONCONTROLKEY == T430.STEUS` `C_OBJPGMAINTORDERANDOPERATION.MANDT == T430.MANDT` `C_OBJPGMAINTORDERANDOPERATION.[column in domain "PLNAW"] == T430.PLNAW`
Normal duration/unit Normal duration/unit Client	`C_OBJPGMAINTORDERANDOPERATION.OPERATIONDURATIONUNIT == T006.MSEHI` `C_OBJPGMAINTORDERANDOPERATION.MANDT == T006.MANDT`
Unit for work Unit for work Client	`C_OBJPGMAINTORDERANDOPERATION.OPERATIONPLANNEDWORKUNIT == T006.MSEHI` `C_OBJPGMAINTORDERANDOPERATION.MANDT == T006.MANDT`
Number of purchasing info record Number of purchasing info record Client	`C_OBJPGMAINTORDERANDOPERATION.OPERATIONPURCHASINGINFORECORD == EINA.INFNR` `C_OBJPGMAINTORDERANDOPERATION.MANDT == EINA.MANDT`
Base Unit of Measure Base Unit of Measure Client	`C_OBJPGMAINTORDERANDOPERATION.OPERATIONQUANTITYUNIT == T006.MSEHI` `C_OBJPGMAINTORDERANDOPERATION.MANDT == T006.MANDT`
Account Number of Supplier Account Number of Supplier Client	`C_OBJPGMAINTORDERANDOPERATION.OPERATIONSUPPLIER == LFA1.LIFNR` `C_OBJPGMAINTORDERANDOPERATION.MANDT == LFA1.MANDT`
System Condition System Condition Client	`C_OBJPGMAINTORDERANDOPERATION.OPERATIONSYSTEMCONDITION == T357M.ANLZU` `C_OBJPGMAINTORDERANDOPERATION.MANDT == T357M.MANDT`
Object ID of the resource Client ? Object ID of the resource	`C_OBJPGMAINTORDERANDOPERATION.MANDT == CRID.MANDT` `C_OBJPGMAINTORDERANDOPERATION.[column in domain "CR_OBJTY"] == CRID.OBJTY` `C_OBJPGMAINTORDERANDOPERATION.OPERATIONWORKCENTERINTERNALID == CRID.OBJID`
Currency Key Client Currency Key	`C_OBJPGMAINTORDERANDOPERATION.MANDT == TCURC.MANDT` `C_OBJPGMAINTORDERANDOPERATION.OPEXTERNALPROCESSINGCURRENCY == TCURC.WAERS`
Plant Plant Plant Client	`C_OBJPGMAINTORDERANDOPERATION.PLANNEDPLANT == T001W.WERKS` `C_OBJPGMAINTORDERANDOPERATION.PLANT == T001W.WERKS` `C_OBJPGMAINTORDERANDOPERATION.MANDT == T001W.MANDT`
Plant Plant Plant Client	`C_OBJPGMAINTORDERANDOPERATION.PLANNEDPLANT == T001W.WERKS` `C_OBJPGMAINTORDERANDOPERATION.PLANT == T001W.WERKS` `C_OBJPGMAINTORDERANDOPERATION.MANDT == T001W.MANDT`
Plant Section Plant Section Client Maintenance Plant	`C_OBJPGMAINTORDERANDOPERATION.PLANTSECTION == T357.BEBER` `C_OBJPGMAINTORDERANDOPERATION.MANDT == T357.MANDT` `C_OBJPGMAINTORDERANDOPERATION.MAINTENANCEPLANT == T357.WERKS`
Controlling area of the requesting cost center Controlling area of the requesting cost center Client	`C_OBJPGMAINTORDERANDOPERATION.REQGCOSTCENTERCONTROLLINGAREA == TKA01.KOKRS` `C_OBJPGMAINTORDERANDOPERATION.MANDT == TKA01.MANDT`
Responsible Cost Center Controlling Area ? Responsible Cost Center Client	`C_OBJPGMAINTORDERANDOPERATION.CONTROLLINGAREA == CSKS.KOKRS` `C_OBJPGMAINTORDERANDOPERATION.[column in domain "DATBI"] == CSKS.DATBI` `C_OBJPGMAINTORDERANDOPERATION.RESPONSIBLECOSTCENTER == CSKS.KOSTL` `C_OBJPGMAINTORDERANDOPERATION.MANDT == CSKS.MANDT`
Technical Object Technical Object Client	`C_OBJPGMAINTORDERANDOPERATION.TECHNICALOBJECT == EQUI.EQUNR` `C_OBJPGMAINTORDERANDOPERATION.MANDT == EQUI.MANDT`
Object ID of the Work Center Object ID of the Work Center Client Object Type of CIM Resources for Work Center	`C_OBJPGMAINTORDERANDOPERATION.WORKCENTERINTERNALID == CRID.OBJID` `C_OBJPGMAINTORDERANDOPERATION.MANDT == CRID.MANDT` `C_OBJPGMAINTORDERANDOPERATION.WORKCENTERTYPECODE == CRID.OBJTY`

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	`C_OBJPGMAINTORDERANDOPERATION.MANDT == T024I.MANDT` `C_OBJPGMAINTORDERANDOPERATION.MAINTENANCEPLANNERGROUP == T024I.INGRP` `C_OBJPGMAINTORDERANDOPERATION.MAINTENANCEPLANNINGPLANT == T024I.IWERK`
Maintenance Planning Plant Client Maintenance Planning Plant	`C_OBJPGMAINTORDERANDOPERATION.MANDT == T399I.MANDT` `C_OBJPGMAINTORDERANDOPERATION.MAINTENANCEPLANNINGPLANT == T399I.IWERK`