C_RSHMaintSchedFrozenOp

Operations to be displayed in frozen schedule | view: CRSHSCHFRZNOP | Extraction: Not supported | Component: Resource Scheduling for Enterprise Asset Managem.
Tables used: OBJK, QMEL, AFIH, AFKO, OPROL, AFVV, AFVC, QMIH, AFAB, RSH_D_MNTSCHDOP, RSH_D_MNTSCHDSIM, RSH_D_MNTSCHDSIM, RSH_D_MNTSCHDWC, JEST, JSTO, JEST, AFRU, AFVC, BUT000, EQUI, EQKT, EQUZ, IFLOS, IFLOT, IFLOTX, ILOA, T353I, T353I_T, AUFK, T357M, T357M_T, EAM_MOPEXCPHASEA, EAM_MOPEXCPHASET, T001W, T356, T356_T, RSH_D_MNTSCHDCLB, T482, T482T, T006, T006A, CRHD, ITOBCUST, IFLOUSR
Column Name Description
MaintOrderRoutingNumber Routing number of operations in the order
MaintOrderOperationCounter General counter for order
MaintOrderConfirmation Completion confirmation number for the operation
MaintenanceOrder FK Order Number
MaintenanceOrderOperation Operation
MaintSchedSimlnUUID UUID in X form (binary)
Column Name Description
Column Name Description
📏 Unit for work (OperationPlannedWorkUnit):
PlndWrkQtyInTargetWeek Work Planned in Schedule
TotPlndWorkQty Total Planned Work
CompletedWorkQuantity Work Completed in Schedule
ForecastedWorkQty Total Forecasted Work
ConfirmationTotalQuantity Total Completed Work
📏 Normal duration/unit (OperationDurationUnit):
OperationDuration Normal duration of the activity
Column Name Description
MaintOrdBasicStartDate Basic Start Date
MaintOrdBasicEndDate Basic finish 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)
MaintSchedCompletionDate Completed On
MaintSchedCompletionTime Completion Time
PlannedStartDate Planned Start Date
PlannedStartTime Planned Start Time
PlannedEndDate Planned End Date
PlannedEndTime Planned End Time
LatestAcceptableCompletionDate Final Due Date
OpActualExecutionStartDate Actual Start Date and Time
OpActualExecutionStartTime Actual Start Time
OpActualExecutionEndDate Actual End Date and Time
OpActualExecutionEndTime Actual End Time
Column Name Description
TechObjIsEquipOrFuncnlLoc Technical Object Type (Order) Show values
OpTechObjEquipOrFuncnlLoc Technical Object Type (Operation) Show values
SchedulingIsPerformedBackward Backward scheduling Show values
HasCrossOrderRelationship Operation Has Cross-Order Relationship Show values
Column Name Description Domain name
MaintenanceOrderDesc Order Description TEXT40
MaintenanceActivityTypeName Activity Type Name TXT30
MaintPriorityDesc Priority TEXT20
OperationHasLongText Long text available indicator
OperationHasLongTextDesc Short Text for Fixed Values DDTEXT
NotificationText Notification Description TEXT40
EquipmentName Equipment Description TEXT40
FunctionalLocationName Functional Location Name TEXT40
TechnicalObjectLabel Technical Object (Order) EAMS_TECH_OBJ_CONV
TechnicalObjectDescription null
TechObjIsEquipOrFuncnlLocDesc Description of Technical Object Type /PLMB/GOS_OTYPE_DESC
OrderSystemConditionText Operation System Condition Text TEXT40
OperationEquipment Equipment Number (Operation) EQUNR
OperationEquipmentName Description of technical object TEXT40
RelevantOperationFuncLocation Functional Location TPLNR
OperationFunctionalLocation Functional Location (Operation) ILOM_STRNO
OpFunctionalLocationName Description of functional location TEXT40
OperationTechnicalObject Technical Object EAMS_TEC_OBJ
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
TechObjProductionWorkCenter Production Work Center ARBPL
OperationDescription Maintenance Operation Description
OperationPersonResponsible Person Responsible ID (Personnel Number) PERNR
OperationPersonRespName Person Responsible Name TEXT80
WorkCenter Performing Work Center ARBPL
WorkCenterInternalID Work center object ID CR_OBJID
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
MaintSchedCompletionStatus Completion in Schedule INT1
MaintSchedCompletionStatusText Completion in Schedule 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
Master Data Relations | to Other Relations ↓ Join Conditions
Location of maintenance object
  • Location of maintenance object
  • Client
  • Maintenance Plant
  • C_RSHMAINTSCHEDFROZENOP.ASSETLOCATION == T499S.STAND
  • C_RSHMAINTSCHEDFROZENOP.MANDT == T499S.MANDT
  • C_RSHMAINTSCHEDFROZENOP.MAINTENANCEPLANT == T499S.WERKS
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • C_RSHMAINTSCHEDFROZENOP.AUTHORIZATIONGROUP == T370B.BEGRU
  • C_RSHMAINTSCHEDFROZENOP.MANDT == T370B.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_RSHMAINTSCHEDFROZENOP.CONTROLLINGAREA == TKA01.KOKRS
  • C_RSHMAINTSCHEDFROZENOP.MANDT == TKA01.MANDT
Equipment Number
  • Equipment Number (Operation)
  • Equipment Number
  • Client
  • C_RSHMAINTSCHEDFROZENOP.OPERATIONEQUIPMENT == EQUI.EQUNR
  • C_RSHMAINTSCHEDFROZENOP.EQUIPMENT == EQUI.EQUNR
  • C_RSHMAINTSCHEDFROZENOP.MANDT == EQUI.MANDT
Functional Location (Order)
  • Client
  • Functional Location (Order)
  • Functional Location
  • C_RSHMAINTSCHEDFROZENOP.MANDT == IFLOT.MANDT
  • C_RSHMAINTSCHEDFROZENOP.FUNCTIONALLOCATION == IFLOT.TPLNR
  • C_RSHMAINTSCHEDFROZENOP.RELEVANTOPERATIONFUNCLOCATION == IFLOT.TPLNR
Maintenance Activity Type
  • Maintenance Activity Type
  • Client
  • C_RSHMAINTSCHEDFROZENOP.MAINTENANCEACTIVITYTYPE == T353I.ILART
  • C_RSHMAINTSCHEDFROZENOP.MANDT == T353I.MANDT
Order Number
  • Client
  • Order Number
  • C_RSHMAINTSCHEDFROZENOP.MANDT == AUFK.MANDT
  • C_RSHMAINTSCHEDFROZENOP.MAINTENANCEORDER == AUFK.AUFNR
Order Type
  • Order Type
  • Client
  • C_RSHMAINTSCHEDFROZENOP.MAINTENANCEORDERTYPE == T003O.AUART
  • C_RSHMAINTSCHEDFROZENOP.MANDT == T003O.CLIENT
Maintenance Plan
  • Client
  • Maintenance Plan
  • C_RSHMAINTSCHEDFROZENOP.MANDT == MPLA.MANDT
  • C_RSHMAINTSCHEDFROZENOP.MAINTENANCEPLAN == MPLA.WARPL
Maintenance Plant
  • Client
  • Maintenance Plant
  • C_RSHMAINTSCHEDFROZENOP.MANDT == T001W.MANDT
  • C_RSHMAINTSCHEDFROZENOP.MAINTENANCEPLANT == T001W.WERKS
Maintenance Event
  • Maintenance Planning Plant
  • Maintenance Event
  • Client
  • C_RSHMAINTSCHEDFROZENOP.MAINTENANCEPLANNINGPLANT == T352R.IWERK
  • C_RSHMAINTSCHEDFROZENOP.MAINTENANCEREVISION == T352R.REVNR
  • C_RSHMAINTSCHEDFROZENOP.MANDT == T352R.MANDT
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • C_RSHMAINTSCHEDFROZENOP.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • C_RSHMAINTSCHEDFROZENOP.MANDT == ILOA.MANDT
Priority Key
  • Priority Type
  • Client
  • Priority Key
  • C_RSHMAINTSCHEDFROZENOP.MAINTPRIORITYTYPE == T356.ARTPR
  • C_RSHMAINTSCHEDFROZENOP.MANDT == T356.MANDT
  • C_RSHMAINTSCHEDFROZENOP.MAINTPRIORITY == T356.PRIOK
Priority Type
  • Priority Type
  • Client
  • C_RSHMAINTSCHEDFROZENOP.MAINTPRIORITYTYPE == T356A.ARTPR
  • C_RSHMAINTSCHEDFROZENOP.MANDT == T356A.MANDT
Control key
  • Client
  • ?
  • Control key
  • C_RSHMAINTSCHEDFROZENOP.MANDT == T430.MANDT
  • C_RSHMAINTSCHEDFROZENOP.[column in domain "PLNAW"] == T430.PLNAW
  • C_RSHMAINTSCHEDFROZENOP.OPERATIONCONTROLKEY == T430.STEUS
Normal duration/unit
  • Normal duration/unit
  • Client
  • C_RSHMAINTSCHEDFROZENOP.OPERATIONDURATIONUNIT == T006.MSEHI
  • C_RSHMAINTSCHEDFROZENOP.MANDT == T006.MANDT
Unit for work
  • Unit for work
  • Client
  • C_RSHMAINTSCHEDFROZENOP.OPERATIONPLANNEDWORKUNIT == T006.MSEHI
  • C_RSHMAINTSCHEDFROZENOP.MANDT == T006.MANDT
System Condition (Operation)
  • System Condition (Operation)
  • System Condition (Order)
  • Client
  • C_RSHMAINTSCHEDFROZENOP.OPERATIONSYSTEMCONDITION == T357M.ANLZU
  • C_RSHMAINTSCHEDFROZENOP.ORDERSYSTEMCONDITION == T357M.ANLZU
  • C_RSHMAINTSCHEDFROZENOP.MANDT == T357M.MANDT
System Condition (Order)
  • System Condition (Operation)
  • System Condition (Order)
  • Client
  • C_RSHMAINTSCHEDFROZENOP.OPERATIONSYSTEMCONDITION == T357M.ANLZU
  • C_RSHMAINTSCHEDFROZENOP.ORDERSYSTEMCONDITION == T357M.ANLZU
  • C_RSHMAINTSCHEDFROZENOP.MANDT == T357M.MANDT
Plant
  • Client
  • Plant
  • C_RSHMAINTSCHEDFROZENOP.MANDT == T001W.MANDT
  • C_RSHMAINTSCHEDFROZENOP.PLANT == T001W.WERKS
Plant Section
  • Plant Section
  • Client
  • Maintenance Plant
  • C_RSHMAINTSCHEDFROZENOP.PLANTSECTION == T357.BEBER
  • C_RSHMAINTSCHEDFROZENOP.MANDT == T357.MANDT
  • C_RSHMAINTSCHEDFROZENOP.MAINTENANCEPLANT == T357.WERKS
Responsible Cost Center
  • Controlling Area
  • ?
  • Responsible Cost Center
  • Client
  • C_RSHMAINTSCHEDFROZENOP.CONTROLLINGAREA == CSKS.KOKRS
  • C_RSHMAINTSCHEDFROZENOP.[column in domain "DATBI"] == CSKS.DATBI
  • C_RSHMAINTSCHEDFROZENOP.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • C_RSHMAINTSCHEDFROZENOP.MANDT == CSKS.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Maintenance Planner Group
  • Maintenance Planning Plant
  • Maintenance Planner Group
  • Client
  • C_RSHMAINTSCHEDFROZENOP.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • C_RSHMAINTSCHEDFROZENOP.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • C_RSHMAINTSCHEDFROZENOP.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • C_RSHMAINTSCHEDFROZENOP.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • C_RSHMAINTSCHEDFROZENOP.MANDT == T399I.MANDT