P_RSHMaintSchedOpUserTimeZone

DDL: P_RSHMAINTSCHEDOPUSERTIMEZONE Type: view_entity CONSUMPTION Package: RSH_CDS_MAINT_SCHED_SIM
57 Fields 1 Data Sources

Maintenance Schedule Simulation Operations in user timezone

P_RSHMaintSchedOpUserTimeZone is a Consumption CDS View that provides data about "Maintenance Schedule Simulation Operations in user timezone" in SAP S/4HANA. It reads from 1 data source (I_RSHMaintSchedSmltdOp) and exposes 57 fields with key field MaintSchedSimlnOperationUUID. Part of development package RSH_CDS_MAINT_SCHED_SIM.

Data Sources (1)

SourceAliasJoin Type
I_RSHMaintSchedSmltdOp I_RSHMaintSchedSmltdOp from

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY MaintSchedSimlnOperationUUID MaintSchedSimlnOperationUUID UUID
MaintSchedSimlnUUID MaintSchedSimlnUUID UUID
MaintOrderRoutingNumber MaintOrderRoutingNumber Plan No.f.Oper.
MaintOrderOperationCounter MaintOrderOperationCounter Counter
MaintOrderConfirmation MaintOrderConfirmation Confirmation
MaintOrdOpSimStartDateTime MaintOrdOpSimStartDateTime
MaintOrdOpSimEndDateTime MaintOrdOpSimEndDateTime
SimulatedWorkCenterInternalID SimulatedWorkCenterInternalID Object ID
SimulatedWorkCenterTypeCode SimulatedWorkCenterTypeCode Object Type
SimulatedWorkCenter SimulatedWorkCenter Work Center
MaintOrdOpSimulationStatus MaintOrdOpSimulationStatus Technical Status
MaintOrdOpSchedSimulationMode MaintOrdOpSchedSimulationMode Simulation Mode
MaintOrdOpSchedWork MaintOrdOpSchedWork Scheduled Work
ProcessingStatus ProcessingStatus Worklist Status
WorkCenterInternalID WorkCenterInternalID Work Center
WorkCenterTypeCode WorkCenterTypeCode Object Type
NumberOfCapacities NumberOfCapacities Number
NumberOfResources NumberOfResources
OperationDuration OperationDuration
OperationDurationUnit OperationDurationUnit
OperationPlannedWork OperationPlannedWork
OperationPlannedWorkUnit OperationPlannedWorkUnit
MaintOrderOperationInternalID MaintOrderOperationInternalID Object number
TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
MaintSchedSimStartDateTime MaintSchedSimStartDateTime
MaintSchedSimEndDateTime MaintSchedSimEndDateTime
UserIsAssignedToOpWrkCtr UserIsAssignedToOpWrkCtr
UserIsAssignedToOpSimWrkCtr UserIsAssignedToOpSimWrkCtr
MaintSchedCollaboratorType MaintSchedCollaboratorType Collaborator Type
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
MaintenanceOrderInternalID MaintenanceOrderInternalID Object number
MaintPriority MaintPriority Priority
MaintPriorityType MaintPriorityType PriorityType
MaintPriorityColorCode MaintPriorityColorCode
OrderType OrderType Order Type
ActivityType ActivityType Activity Type
MaintOrdOpProcessPhaseCode MaintOrdOpProcessPhaseCode Process Phase
MaintOrdOpProcessSubPhaseCode MaintOrdOpProcessSubPhaseCode Process Subphase
OperationTechnicalObject OperationTechnicalObject
OpTechObjEquipOrFuncnlLoc OpTechObjEquipOrFuncnlLoc
Equipment Equipment Equipment check
RelevantOperationFuncLocation RelevantOperationFuncLocation
MaintSchedSimulationStartDate
MaintSchedSimulationStartTime
MaintSchedSimulationEndDate
MaintSchedSimulationEndTime
MaintOrdOpSimulatedStartDate
MaintOrdOpSimulatedStartTime
_AssignedWorkCenter _AssignedWorkCenter
_ExclStatusObj _ExclStatusObj
_MaintenanceOrder _MaintenanceOrder
_MaintSchedSimulation _MaintSchedSimulation
_MaterialStatus _MaterialStatus
_Operation _Operation
_OperationPlanningValues _OperationPlanningValues
_SimWorkCenter _SimWorkCenter

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_RSHMaintSchedOpUserTimeZone.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_RSHMaintSchedOpUserTimeZone AS
SELECT
  MaintSchedSimlnOperationUUID,
  MaintSchedSimlnUUID,
  MaintOrderRoutingNumber,
  MaintOrderOperationCounter,
  MaintOrderConfirmation,
  MaintOrdOpSimStartDateTime,
  MaintOrdOpSimEndDateTime,
  SimulatedWorkCenterInternalID,
  SimulatedWorkCenterTypeCode,
  SimulatedWorkCenter,
  MaintOrdOpSimulationStatus,
  MaintOrdOpSchedSimulationMode,
  MaintOrdOpSchedWork,
  ProcessingStatus,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  NumberOfCapacities,
  NumberOfResources,
  OperationDuration,
  OperationDurationUnit,
  OperationPlannedWork,
  OperationPlannedWorkUnit,
  MaintOrderOperationInternalID,
  TechObjIsEquipOrFuncnlLoc,
  MaintSchedSimStartDateTime,
  MaintSchedSimEndDateTime,
  UserIsAssignedToOpWrkCtr,
  UserIsAssignedToOpSimWrkCtr,
  MaintSchedCollaboratorType,
  LastChangedByUser,
  LastChangeDateTime,
  MaintenanceOrderInternalID,
  MaintPriority,
  MaintPriorityType,
  MaintPriorityColorCode,
  OrderType,
  ActivityType,
  MaintOrdOpProcessPhaseCode,
  MaintOrdOpProcessSubPhaseCode,
  OperationTechnicalObject,
  OpTechObjEquipOrFuncnlLoc,
  Equipment,
  RelevantOperationFuncLocation,
  tstmp_to_dats( MaintSchedSimStartDateTime, abap_user_timezone( $session.user,$session.client,'NULL' ),$session.client,'NULL' ) AS MaintSchedSimulationStartDate,
  tstmp_to_tims( MaintSchedSimStartDateTime, abap_user_timezone( $session.user,$session.client,'NULL' ),$session.client,'NULL' ) AS MaintSchedSimulationStartTime,
  tstmp_to_dats( MaintSchedSimEndDateTime, abap_user_timezone( $session.user,$session.client,'NULL' ),$session.client,'NULL' ) AS MaintSchedSimulationEndDate,
  tstmp_to_tims( MaintSchedSimEndDateTime, abap_user_timezone( $session.user,$session.client,'NULL' ),$session.client,'NULL' ) AS MaintSchedSimulationEndTime,
  tstmp_to_dats( MaintOrdOpSimStartDateTime, abap_user_timezone( $session.user,$session.client,'NULL' ),$session.client,'NULL' ) AS MaintOrdOpSimulatedStartDate,
  tstmp_to_tims( MaintOrdOpSimStartDateTime, abap_user_timezone( $session.user,$session.client,'NULL' ),$session.client,'NULL' ) AS MaintOrdOpSimulatedStartTime
FROM I_RSHMaintSchedSmltdOp
;

Learn More