P_RSHOperations

Maintenance Operations | view: PRSHOPERATIONS | Extraction: Not supported | Component: Resource Scheduling for Enterprise Asset Managem.
Tables used: OBJK, AFIH, AFKO, OPROL, AFVV, AFVC, QMIH, AFAB, JEST, JSTO, JEST, BUT000, EQUI, EQKT, EQUZ, IFLOS, IFLOT, IFLOTX, ILOA, AUFK, T430, T001W, T482, CRHD, ITOBCUST, IFLOUSR, RSH_D_USR_DEF, RSH_D_USR_WC
Column Name Description
MaintenanceOrder FK Order Number
MaintenanceOrderOperation Key for the Order Operation
MaintenanceOrderSubOperation Operation/Activity Number
Column Name Description
Column Name Description
📏 Unit for work (OperationPlannedWorkUnit):
OperationPlannedWork Work involved in the activity
📏 Normal duration/unit (OperationDurationUnit):
OperationDuration Normal duration of the activity
Column Name Description
MaintOrdBasicStartDate Basic Start Date
MaintOrdBasicStartTime Basic Start (Time)
MaintOrdBasicEndDate Basic finish date
MaintOrdBasicEndTime Basic Finish (Time)
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)
ConstraintDateForBscStartDate Constraint for activity start (Basic)
ConstraintTimeForBscStartTime Constraint for activity start time (Basic)
ConstraintDateForBscFinishDate Constraint for Finish of Activity (Basic)
ConstraintTimeForBscFinishTime Basic finish time of the activity
ScheduledBasicStartDate Scheduled start
ScheduledBasicStartTime Scheduled Start (Time)
ScheduledBasicEndDate Scheduled finish
ScheduledBasicEndTime Scheduled finish time
LatestAcceptableCompletionDate Final Due Date
PlannedStartDate Latest scheduled start: Execution (date)
PlannedStartTime Latest scheduled start: Execution (time)
PlannedEndDate Latest scheduled finish: Execution (date)
PlannedEndTime Latest scheduled finish: Execution (time)
Column Name Description
OrderHasLongText Order Has Long Text Show values
OpBscStartDateConstraintType Constraint on the basic start date for the activity Show values
OpBscEndDateConstraintType Constraint on the finish date of the activity Show values
SchedulingIsPerformedBackward Backward scheduling Show values
HasCrossOrderRelationship Operation Has Cross-Order Relationship Show values
HasError Additional Information Available Show values
IsInProcess Is in Process Show values
OperationIsOnCriticalPath On Critical Path Show values
MaintOrdProcessPhaseCode Process Phase Show values
MaintOrdOpProcessPhaseCode Process Phase Show values
OpTechObjEquipOrFuncnlLoc Technical Object Type (Operation) Show values
TechObjIsEquipOrFuncnlLoc Technical Object Type (Order) Show values
Column Name Description Domain name
MaintOrderRoutingNumber Routing number of operations in the order AUFPL
MaintOrderOperationCounter General counter for order CO_APLZL
MaintOrderConfirmation Completion confirmation number for the operation CO_RUECK
OperationDescription Operation Short Text TEXT40
OperationPersonResponsible Personnel number PERNR
PersonFullName Full Name TEXT80
WorkCenterTypeCode null
WorkCenter Work Center ARBPL
NumberOfCapacities Number of capacities required INT1
SuperiorProjectNetwork Number of superior network AUFNR
MainWorkCenter Work Center ARBPL
MainWorkCenterPlant Plant associated with main work center WERKS
OperationHasLongText Long text available indicator
MaintenanceOrderDesc Description TEXT40
EquipmentName null
FunctionalLocationName null
AssetRoom Room CHAR8
SchedulingType Scheduling Type TERART
MaintOperationExecStageCode PRE MAIN POST EAM_PREMAINPOST_CDS
ProcessingStatus null
MaterialStatus null
MaterialStatusCode null
OperationHasSubOperations null
MaintOrdProcessSubPhaseCode Process Subphase EAM_OSTAT_SPHASE
MaintOrdOpProcessSubPhaseCode Process Subphase EAM_OSTAT_SPHASE
OperationTechnicalObject Technical Object EAMS_TEC_OBJ
OperationEquipment Equipment Number (Operation) EQUNR
RelevantOperationFuncLocation Functional Location TPLNR
OperationFunctionalLocation Functional Location (Operation) ILOM_STRNO
Master Data Relations | to Other Relations ↓ Join Conditions
Location of maintenance object
  • Client
  • Maintenance Plant
  • Location of maintenance object
  • P_RSHOPERATIONS.MANDT == T499S.MANDT
  • P_RSHOPERATIONS.MAINTENANCEPLANT == T499S.WERKS
  • P_RSHOPERATIONS.ASSETLOCATION == T499S.STAND
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • P_RSHOPERATIONS.AUTHORIZATIONGROUP == T370B.BEGRU
  • P_RSHOPERATIONS.MANDT == T370B.MANDT
Scheduling type
  • Client
  • Scheduling type
  • P_RSHOPERATIONS.MANDT == T482.MANDT
  • P_RSHOPERATIONS.BASICSCHEDULINGTYPE == T482.TERMKZ
Controlling Area
  • Controlling Area
  • Client
  • P_RSHOPERATIONS.CONTROLLINGAREA == TKA01.KOKRS
  • P_RSHOPERATIONS.MANDT == TKA01.MANDT
Equipment Number
  • Client
  • Equipment Number
  • P_RSHOPERATIONS.MANDT == EQUI.MANDT
  • P_RSHOPERATIONS.EQUIPMENT == EQUI.EQUNR
Functional Location
  • Client
  • Functional Location
  • P_RSHOPERATIONS.MANDT == IFLOT.MANDT
  • P_RSHOPERATIONS.FUNCTIONALLOCATION == IFLOT.TPLNR
Maintenance Activity Type
  • Client
  • Maintenance Activity Type
  • P_RSHOPERATIONS.MANDT == T353I.MANDT
  • P_RSHOPERATIONS.MAINTENANCEACTIVITYTYPE == T353I.ILART
Order Number
  • Client
  • Order Number
  • P_RSHOPERATIONS.MANDT == AUFK.MANDT
  • P_RSHOPERATIONS.MAINTENANCEORDER == AUFK.AUFNR
Order Type
  • Order Type
  • Client
  • P_RSHOPERATIONS.MAINTENANCEORDERTYPE == T003O.AUART
  • P_RSHOPERATIONS.MANDT == T003O.CLIENT
Maintenance Plan
  • Client
  • Maintenance Plan
  • P_RSHOPERATIONS.MANDT == MPLA.MANDT
  • P_RSHOPERATIONS.MAINTENANCEPLAN == MPLA.WARPL
Maintenance Plant
  • Client
  • Maintenance Plant
  • P_RSHOPERATIONS.MANDT == T001W.MANDT
  • P_RSHOPERATIONS.MAINTENANCEPLANT == T001W.WERKS
Maintenance Event
  • Client
  • Maintenance Planning Plant
  • Maintenance Event
  • P_RSHOPERATIONS.MANDT == T352R.MANDT
  • P_RSHOPERATIONS.MAINTENANCEPLANNINGPLANT == T352R.IWERK
  • P_RSHOPERATIONS.MAINTENANCEREVISION == T352R.REVNR
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • P_RSHOPERATIONS.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • P_RSHOPERATIONS.MANDT == ILOA.MANDT
Priority
  • Priority Type
  • Client
  • Priority
  • P_RSHOPERATIONS.MAINTPRIORITYTYPE == T356.ARTPR
  • P_RSHOPERATIONS.MANDT == T356.MANDT
  • P_RSHOPERATIONS.MAINTPRIORITY == T356.PRIOK
Priority Type
  • Priority Type
  • Client
  • P_RSHOPERATIONS.MAINTPRIORITYTYPE == T356A.ARTPR
  • P_RSHOPERATIONS.MANDT == T356A.MANDT
Control key
  • Client
  • Control key
  • ?
  • P_RSHOPERATIONS.MANDT == T430.MANDT
  • P_RSHOPERATIONS.OPERATIONCONTROLKEY == T430.STEUS
  • P_RSHOPERATIONS.[column in domain "PLNAW"] == T430.PLNAW
Normal duration/unit
  • Client
  • Normal duration/unit
  • P_RSHOPERATIONS.MANDT == T006.MANDT
  • P_RSHOPERATIONS.OPERATIONDURATIONUNIT == T006.MSEHI
Unit for work
  • Client
  • Unit for work
  • P_RSHOPERATIONS.MANDT == T006.MANDT
  • P_RSHOPERATIONS.OPERATIONPLANNEDWORKUNIT == T006.MSEHI
System Condition
  • System Condition
  • System Condition
  • Client
  • P_RSHOPERATIONS.OPERATIONSYSTEMCONDITION == T357M.ANLZU
  • P_RSHOPERATIONS.ORDERSYSTEMCONDITION == T357M.ANLZU
  • P_RSHOPERATIONS.MANDT == T357M.MANDT
System Condition
  • System Condition
  • System Condition
  • Client
  • P_RSHOPERATIONS.OPERATIONSYSTEMCONDITION == T357M.ANLZU
  • P_RSHOPERATIONS.ORDERSYSTEMCONDITION == T357M.ANLZU
  • P_RSHOPERATIONS.MANDT == T357M.MANDT
Plant
  • Plant
  • Client
  • P_RSHOPERATIONS.PLANT == T001W.WERKS
  • P_RSHOPERATIONS.MANDT == T001W.MANDT
Plant Section
  • Plant Section
  • Client
  • Maintenance Plant
  • P_RSHOPERATIONS.PLANTSECTION == T357.BEBER
  • P_RSHOPERATIONS.MANDT == T357.MANDT
  • P_RSHOPERATIONS.MAINTENANCEPLANT == T357.WERKS
Responsible Cost Center
  • ?
  • Controlling Area
  • Responsible Cost Center
  • Client
  • P_RSHOPERATIONS.[column in domain "DATBI"] == CSKS.DATBI
  • P_RSHOPERATIONS.CONTROLLINGAREA == CSKS.KOKRS
  • P_RSHOPERATIONS.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • P_RSHOPERATIONS.MANDT == CSKS.MANDT
Object ID of the resource
  • Client
  • ?
  • Object ID of the resource
  • P_RSHOPERATIONS.MANDT == CRID.MANDT
  • P_RSHOPERATIONS.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • P_RSHOPERATIONS.WORKCENTERINTERNALID == CRID.OBJID
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
  • P_RSHOPERATIONS.MANDT == T024I.MANDT
  • P_RSHOPERATIONS.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • P_RSHOPERATIONS.MAINTENANCEPLANNINGPLANT == T024I.IWERK
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • P_RSHOPERATIONS.MANDT == T399I.MANDT
  • P_RSHOPERATIONS.MAINTENANCEPLANNINGPLANT == T399I.IWERK