I_RSHMaintSchedSimulation

DDL: I_RSHMAINTSCHEDSIMULATION SQL: IRSHMNTSCHDSIM Type: view BASIC
23 Fields 1 Data Sources 2 Associations

Maintenance Scheduling Simulation Root

I_RSHMaintSchedSimulation is a Basic CDS View that provides data about "Maintenance Scheduling Simulation Root" in SAP S/4HANA. It reads from 1 data source (rsh_d_mntschdsim) and exposes 23 fields with key field MaintSchedSimlnUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
rsh_d_mntschdsim rsh_d_mntschdsim from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_RSHMaintSchedSmltdOp _MaintSchedSmltdOp _MaintSchedSmltdOp.MaintSchedSimlnUUID = $projection.MaintSchedSimlnUUID
[0..*] I_RSHMaintSchedCollaborators _MaintSchedCollaborators _MaintSchedCollaborators.MaintSchedSimlnUUID = $projection.MaintSchedSimlnUUID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IRSHMNTSCHDSIM view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Maintenance Scheduling Simulation Root view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Search.searchable false view
ObjectModel.compositionRoot true view
ObjectModel.entityChangeStateId LastChangeDateTime view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY MaintSchedSimlnUUID maintschedsimlnuuid UUID
MaintSchedSimulationStartDate maintschedsimulationstartdate Start Date
MaintSchedSimulationEndDate maintschedsimulationenddate End Date
MaintSchedSimlnDescription maintschedsimlndescription Schedule
MaintSchedSimlnLongText maintschedsimlnlongtext Schedule Description
CreatedByUser createdbyuser User Name
CreationDateTime creationdatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
LastChangeDateTime lastchangedatetime Timestamp
SimulationSessionState simulationsessionstate Simulation View
SessionStateLastChangeDateTime sessionstatelastchangedatetime Time Stamp
MaintSchedCacheIsActive maintschedcacheisactive Optimize Data Access
MaintSchedJobName maintschedjobname Job Name
MaintSchedJobID maintschedjobid Job No.
PreviousMaintSchedSimlnUUID previousmaintschedsimlnuuid UUID
NextMaintSchedSimlnUUID nextmaintschedsimlnuuid UUID
MaintSchedSimulationStartTime maintschedsimulationstarttime Field of type TIMS
MaintSchedSimulationEndTime maintschedsimulationendtime Field of type TIMS
MaintSchedSimulationTimeZone maintschedsimulationtimezone Time Zone
MaintSchedSimStartDateTime
MaintSchedSimEndDateTime
_MaintSchedSmltdOp _MaintSchedSmltdOp
_MaintSchedCollaborators _MaintSchedCollaborators

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 I_RSHMaintSchedSimulation.
-- 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.
-- SQL view name: IRSHMNTSCHDSIM

CREATE VIEW I_RSHMaintSchedSimulation AS
SELECT
  MaintSchedSimlnUUID,
  MaintSchedSimulationStartDate,
  MaintSchedSimulationEndDate,
  MaintSchedSimlnDescription,
  MaintSchedSimlnLongText,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  SimulationSessionState,
  SessionStateLastChangeDateTime,
  MaintSchedCacheIsActive,
  MaintSchedJobName,
  MaintSchedJobID,
  PreviousMaintSchedSimlnUUID,
  NextMaintSchedSimlnUUID,
  MaintSchedSimulationStartTime,
  MaintSchedSimulationEndTime,
  MaintSchedSimulationTimeZone,
  cast(dats_tims_to_tstmp( maintschedsimulationstartdate, maintschedsimulationstarttime, abap_system_timezone( $session.client,'NULL'), $session.client,'NULL') as timestamp preserving type) AS MaintSchedSimStartDateTime,
  cast(dats_tims_to_tstmp( maintschedsimulationenddate, maintschedsimulationendtime, abap_system_timezone( $session.client,'NULL'), $session.client,'NULL') as timestamp preserving type) AS MaintSchedSimEndDateTime
FROM rsh_d_mntschdsim
LEFT OUTER JOIN I_RSHMaintSchedSmltdOp AS _MaintSchedSmltdOp ON _MaintSchedSmltdOp.MaintSchedSimlnUUID = MaintSchedSimlnUUID  -- association [0..*]
LEFT OUTER JOIN I_RSHMaintSchedCollaborators AS _MaintSchedCollaborators ON _MaintSchedCollaborators.MaintSchedSimlnUUID = MaintSchedSimlnUUID  -- association [0..*]
;

Learn More