C_RSHMaintOperationAssignment

Maintenance Order Operations | view: CRSHOPERASG | TRAN | Extraction: Not supported | Component: Resource Scheduling for Enterprise Asset Managem.
Tables used: OBJK, QMEL, AFIH, AFKO, AFKO, AFVC, AFVV, OPROL, AFVV, AFVC, QMIH, AFAB, RSH_D_MNTSCHDSIM, RSH_D_MNTSCHDOP, JEST, JSTO, JEST, BUT000, EAM_OSTAT_SPH, EAM_OSTAT_SPH_T, EQUI, EQKT, EQUZ, IFLOS, IFLOT, IFLOTX, ILOA, T353I, T353I_T, AUFK, T357M, T357M_T, EAM_MOPEXCPHASEA, EAM_MOPEXCPHASET, AUFK, T430, T001W, T356, T356_T, RSH_D_MNTSCHDCLB, T482, T482T, CRHD, ITOBCUST, IFLOUSR, RSH_D_USR_DEF, RSH_D_USR_WC
Column Name Description
MaintOrderRoutingNumber Routing number of operations in the order
MaintOrderOperationCounter General counter for order
MaintOrderConfirmation Completion confirmation number for the operation
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
MaintOrdBasicEndDate Basic finish date
LatestAcceptableCompletionDate Final Due Date
OpErlstSchedldExecStrtDte Earliest scheduled start: Execution (date)
OpErlstSchedldExecEndDte Earliest scheduled finish: Execution (date)
OpLtstSchedldExecStrtDte Latest scheduled start: Execution (date)
OpLtstSchedldExecEndDte Latest scheduled finish: Execution (date)
PlannedStartDate Planned Start Date
PlannedStartTime Planned Start Time
PlannedEndDate Planned End Date
PlannedEndTime Planned End Time
PeriodType Time Period
Column Name Description
TechObjIsEquipOrFuncnlLoc Technical Object Type (Order) Show values
OpTechObjEquipOrFuncnlLoc Technical Object Type (Operation) Show values
SchedulingIsPerformedBackward Backward scheduling Show values
HasError Additional Information Available Show values
HasCrossOrderRelationship Operation Has Cross-Order Relationship Show values
MaintOrdProcessPhaseCode Maintenance Order Processing Phase Code Show values
MaintOrdOpProcessPhaseCode Maintenance Order Operation Processing Phase Code Show values
Column Name Description Domain name
MaintenanceOrderOperation Key for the Order Operation CHAR50
MaintenanceOrderSubOperation Suboperation VORNR
MaintenanceOrderDesc Order Description TEXT40
MaintenanceActivityTypeName Activity Type Name TXT30
MaintPriorityDesc Priority TEXT20
OperationHasLongText Long text available indicator
OperationHasLongTextDesc Short Text for Fixed Values DDTEXT
OperationHasSubOperations null
NotificationText Notification Description TEXT40
EquipmentName Equipment Description TEXT40
FunctionalLocation Functional Location (Order) ILOM_STRNO
FunctionalLocationName Functional Location Name TEXT40
TechnicalObjectLabel Technical Object (Order) EAMS_TECH_OBJ_CONV
TechnicalObjectDescription Technical Object (Order) EAMS_TECH_OBJ_CONV
TechObjIsEquipOrFuncnlLocDesc Description of Technical Object Type /PLMB/GOS_OTYPE_DESC
OrderSystemConditionText Text on Operating Condition TEXT40
OperationEquipment Equipment Number (Operation) EQUNR
OperationEquipmentName Description of technical object TEXT40
OperationFunctionalLocation Functional Location (Operation) ILOM_STRNO
OpFunctionalLocationName Description of functional location TEXT40
OperationTechnicalObjectLabel Technical Object Identifier (Operation) EAMS_TECH_OBJ_CONV
OperationTechnicalObjectDesc Technical Object Description TEXT40
OpTechObjEquipOrFuncnlLocDesc Description of Technical Object Type /PLMB/GOS_OTYPE_DESC
OperationSystemConditionText Operation System Condition Text TEXT40
AssetRoom Room CHAR8
SuperiorProjectNetwork Number of superior network AUFNR
MainWorkCenter Main Work Center ARBPL
MainWorkCenterPlant Maintenance Work Center Plant WERKS
OperationDescription Maintenance Operation Description
OperationPersonResponsibleID Personnel number
OperationPersonRespName Person Responsible Name TEXT80
WorkCenter Performing Work Center ARBPL
WorkCenterTypeCode Work center object type OTYPE
SchedulingType Scheduling Type TERART
SchedulingTypeName Scheduling Type Description TEXT30
NumberOfCapacities Number of Required Resources INT1
ProcessingStatus Processing Status INT1
ProcessingStatusText Processing Status CHAR60
MaterialStatus Material Availability Status (Order) INT1
MaterialStatusCode null
MaterialStatusText Material Status Description DDTEXT
HasErrorDescription Does the order or operation have errors?
MaintOperationAssignTechStatus Maintenance Operation Assignment Technical Status INT1
MaintOpAssignTechStatusText Maintenance Operation Assignment Technical Status CHAR60
MaintOperationAssignmentStatus Maintenance Operation Assignment Status INT1
MaintOpAssignmentStatusText Maintenance Operation Assignment Text CHAR60
MaintOperationExecStageCode PRE MAIN POST EAM_PREMAINPOST_CDS
MaintOpExecutionStageName Short Name of Maintenance Operation Execution Stage TEXT10
MaintOpExecStageShortText Description of Maintenance Operation Execution Stage TEXT30
MaintOrdProcessPhaseDesc Maintenance Order Processing Phase DDTEXT
MaintOrdProcessSubPhaseCode Maintenance Order Processing Subphase Code EAM_OSTAT_SPHASE
MaintOrdProcessSubPhaseDesc Maintenance Order Processing Subphase DDTEXT
MaintOrdOpProcessPhaseDesc Maintenance Order Operation Processing Phase DDTEXT
MaintOrdOpProcessSubPhaseCode Maintenance Order Operation Processing Subphase Code EAM_OSTAT_SPHASE
MaintOrdOpProcessSubPhaseDesc Maintenance Operation Processing Subphase DDTEXT
ConcatenatedOrderPhaseCtrlText Phase control codes for maintenance order
ConcatenatedOrdOpPhaseCtrlText Phase control codes for maintenance operation CHAR1000
Master Data Relations | to Other Relations ↓ Join Conditions
Location of maintenance object
  • Client
  • Location of maintenance object
  • Maintenance Plant
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == T499S.MANDT
  • C_RSHMAINTOPERATIONASSIGNMENT.ASSETLOCATION == T499S.STAND
  • C_RSHMAINTOPERATIONASSIGNMENT.MAINTENANCEPLANT == T499S.WERKS
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • C_RSHMAINTOPERATIONASSIGNMENT.AUTHORIZATIONGROUP == T370B.BEGRU
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == T370B.MANDT
Controlling Area
  • Client
  • Controlling Area
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == TKA01.MANDT
  • C_RSHMAINTOPERATIONASSIGNMENT.CONTROLLINGAREA == TKA01.KOKRS
Equipment Number
  • Client
  • Equipment Number
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == EQUI.MANDT
  • C_RSHMAINTOPERATIONASSIGNMENT.EQUIPMENT == EQUI.EQUNR
Maintenance Activity Type
  • Client
  • Maintenance Activity Type
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == T353I.MANDT
  • C_RSHMAINTOPERATIONASSIGNMENT.MAINTENANCEACTIVITYTYPE == T353I.ILART
Order Number
  • Client
  • Order Number
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == AUFK.MANDT
  • C_RSHMAINTOPERATIONASSIGNMENT.MAINTENANCEORDER == AUFK.AUFNR
Order Type
  • Client
  • Order Type
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == T003O.CLIENT
  • C_RSHMAINTOPERATIONASSIGNMENT.MAINTENANCEORDERTYPE == T003O.AUART
Maintenance Plan
  • Client
  • Maintenance Plan
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == MPLA.MANDT
  • C_RSHMAINTOPERATIONASSIGNMENT.MAINTENANCEPLAN == MPLA.WARPL
Maintenance Plant
  • Client
  • Maintenance Plant
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == T001W.MANDT
  • C_RSHMAINTOPERATIONASSIGNMENT.MAINTENANCEPLANT == T001W.WERKS
Maintenance Event
  • Maintenance Planning Plant
  • Client
  • Maintenance Event
  • C_RSHMAINTOPERATIONASSIGNMENT.MAINTENANCEPLANNINGPLANT == T352R.IWERK
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == T352R.MANDT
  • C_RSHMAINTOPERATIONASSIGNMENT.MAINTENANCEREVISION == T352R.REVNR
Location and account assignment for technical object
  • Client
  • Location and account assignment for technical object
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == ILOA.MANDT
  • C_RSHMAINTOPERATIONASSIGNMENT.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
Priority Key
  • Client
  • Priority Key
  • Priority Type
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == T356.MANDT
  • C_RSHMAINTOPERATIONASSIGNMENT.MAINTPRIORITY == T356.PRIOK
  • C_RSHMAINTOPERATIONASSIGNMENT.MAINTPRIORITYTYPE == T356.ARTPR
Priority Type
  • Client
  • Priority Type
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == T356A.MANDT
  • C_RSHMAINTOPERATIONASSIGNMENT.MAINTPRIORITYTYPE == T356A.ARTPR
Control key
  • Client
  • ?
  • Control key
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == T430.MANDT
  • C_RSHMAINTOPERATIONASSIGNMENT.[column in domain "PLNAW"] == T430.PLNAW
  • C_RSHMAINTOPERATIONASSIGNMENT.OPERATIONCONTROLKEY == T430.STEUS
Normal duration/unit
  • Normal duration/unit
  • Client
  • C_RSHMAINTOPERATIONASSIGNMENT.OPERATIONDURATIONUNIT == T006.MSEHI
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == T006.MANDT
Unit for work
  • Client
  • Unit for work
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == T006.MANDT
  • C_RSHMAINTOPERATIONASSIGNMENT.OPERATIONPLANNEDWORKUNIT == T006.MSEHI
System Condition (Operation)
  • Client
  • System Condition (Operation)
  • System Condition (Order)
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == T357M.MANDT
  • C_RSHMAINTOPERATIONASSIGNMENT.OPERATIONSYSTEMCONDITION == T357M.ANLZU
  • C_RSHMAINTOPERATIONASSIGNMENT.ORDERSYSTEMCONDITION == T357M.ANLZU
System Condition (Order)
  • Client
  • System Condition (Operation)
  • System Condition (Order)
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == T357M.MANDT
  • C_RSHMAINTOPERATIONASSIGNMENT.OPERATIONSYSTEMCONDITION == T357M.ANLZU
  • C_RSHMAINTOPERATIONASSIGNMENT.ORDERSYSTEMCONDITION == T357M.ANLZU
Plant
  • Client
  • Plant
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == T001W.MANDT
  • C_RSHMAINTOPERATIONASSIGNMENT.PLANT == T001W.WERKS
Plant Section
  • Client
  • Plant Section
  • Maintenance Plant
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == T357.MANDT
  • C_RSHMAINTOPERATIONASSIGNMENT.PLANTSECTION == T357.BEBER
  • C_RSHMAINTOPERATIONASSIGNMENT.MAINTENANCEPLANT == T357.WERKS
Responsible Cost Center
  • ?
  • Client
  • Controlling Area
  • Responsible Cost Center
  • C_RSHMAINTOPERATIONASSIGNMENT.[column in domain "DATBI"] == CSKS.DATBI
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == CSKS.MANDT
  • C_RSHMAINTOPERATIONASSIGNMENT.CONTROLLINGAREA == CSKS.KOKRS
  • C_RSHMAINTOPERATIONASSIGNMENT.RESPONSIBLECOSTCENTER == CSKS.KOSTL
Work center object ID
  • Client
  • Work center object ID
  • ?
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == CRID.MANDT
  • C_RSHMAINTOPERATIONASSIGNMENT.WORKCENTERINTERNALID == CRID.OBJID
  • C_RSHMAINTOPERATIONASSIGNMENT.[column in domain "CR_OBJTY"] == CRID.OBJTY
Other Relations | to Master Data Relations ↑ Join Conditions
Maintenance Planner Group
  • Maintenance Planning Plant
  • Client
  • Maintenance Planner Group
  • C_RSHMAINTOPERATIONASSIGNMENT.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == T024I.MANDT
  • C_RSHMAINTOPERATIONASSIGNMENT.MAINTENANCEPLANNERGROUP == T024I.INGRP
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • C_RSHMAINTOPERATIONASSIGNMENT.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • C_RSHMAINTOPERATIONASSIGNMENT.MANDT == T399I.MANDT