I_RSHMaintSchedSimulationTP

DDL: I_RSHMAINTSCHEDSIMULATIONTP SQL: IRSHMNTSCHSIMTP Type: view TRANSACTIONAL
26 Fields 1 Data Sources 5 Associations

Maint Scheduling Simulation Root TP

I_RSHMaintSchedSimulationTP is a Transactional CDS View that provides data about "Maint Scheduling Simulation Root TP" in SAP S/4HANA. It reads from 1 data source (I_RSHMaintSchedSimulation) and exposes 26 fields with key field MaintSchedSimlnUUID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_RSHMaintSchedSimulation I_RSHMaintSchedSimulation from

Associations (5)

CardinalityTargetAliasCondition
[0..*] I_RSHMaintSchedSmltdOpTP _MaintSchedSmltdOp _MaintSchedSmltdOp.MaintSchedSimlnUUID = $projection.MaintSchedSimlnUUID
[0..*] I_RSHMaintSchedWrkCtrCapTP _MaintSchedWrkCtrCap _MaintSchedWrkCtrCap.MaintSchedSimlnUUID = $projection.MaintSchedSimlnUUID
[0..*] I_RSHMaintSchedCollaboratorsTP _MaintSchedCollaborators _MaintSchedCollaborators.MaintSchedSimlnUUID = $projection.MaintSchedSimlnUUID
[0..*] I_RSHMaintSchedActivityLogTP _MaintSchedActivityLog _MaintSchedActivityLog.MaintSchedSimlnUUID = $projection.MaintSchedSimlnUUID
[0..*] I_RSHMaintSchedRescheduledOpTP _MaintRescheduledOp _MaintRescheduledOp.MaintSchedSimlnUUID = $projection.MaintSchedSimlnUUID

Annotations (20)

NameValueLevelField
AbapCatalog.sqlViewName IRSHMNTSCHSIMTP view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Maint Scheduling Simulation Root TP view
Search.searchable false view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeActivePersistence RSH_D_MNTSCHDSIM view
ObjectModel.lifecycle.enqueue.expiryBehavior #RELATIVE_TO_LAST_CHANGE view
ObjectModel.lifecycle.enqueue.expiryInterval PT1M view
ObjectModel.entityChangeStateId LastChangeDateTime view
ObjectModel.draftEnabled false view
ObjectModel.compositionRoot true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.semanticKey MaintSchedSimlnUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #TRANSACTIONAL view

Fields (26)

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
MaintSchedCacheIsActive MaintSchedCacheIsActive Optimize Data Access
MaintSchedJobName MaintSchedJobName Job Name
MaintSchedJobID MaintSchedJobID Job No.
PreviousMaintSchedSimlnUUID PreviousMaintSchedSimlnUUID UUID
NextMaintSchedSimlnUUID NextMaintSchedSimlnUUID UUID
MaintSchedSimStartDateTime MaintSchedSimStartDateTime
MaintSchedSimEndDateTime MaintSchedSimEndDateTime
MaintSchedSimulationStartTime MaintSchedSimulationStartTime Field of type TIMS
MaintSchedSimulationEndTime MaintSchedSimulationEndTime Field of type TIMS
MaintSchedSimulationTimeZone MaintSchedSimulationTimeZone Time Zone
_MaintSchedSmltdOp _MaintSchedSmltdOp
_MaintSchedWrkCtrCap _MaintSchedWrkCtrCap
_MaintSchedCollaborators _MaintSchedCollaborators
_MaintSchedActivityLog _MaintSchedActivityLog
_MaintRescheduledOp _MaintRescheduledOp

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_RSHMaintSchedSimulationTP.
-- 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: IRSHMNTSCHSIMTP

CREATE VIEW I_RSHMaintSchedSimulationTP AS
SELECT
  MaintSchedSimlnUUID,
  MaintSchedSimulationStartDate,
  MaintSchedSimulationEndDate,
  MaintSchedSimlnDescription,
  MaintSchedSimlnLongText,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  SimulationSessionState,
  coalesce( SessionStateLastChangeDateTime, CreationDateTime) AS SessionStateLastChangeDateTime,
  MaintSchedCacheIsActive,
  MaintSchedJobName,
  MaintSchedJobID,
  PreviousMaintSchedSimlnUUID,
  NextMaintSchedSimlnUUID,
  MaintSchedSimStartDateTime,
  MaintSchedSimEndDateTime,
  MaintSchedSimulationStartTime,
  MaintSchedSimulationEndTime,
  MaintSchedSimulationTimeZone
FROM I_RSHMaintSchedSimulation
LEFT OUTER JOIN I_RSHMaintSchedSmltdOpTP AS _MaintSchedSmltdOp ON _MaintSchedSmltdOp.MaintSchedSimlnUUID = MaintSchedSimlnUUID  -- association [0..*]
LEFT OUTER JOIN I_RSHMaintSchedWrkCtrCapTP AS _MaintSchedWrkCtrCap ON _MaintSchedWrkCtrCap.MaintSchedSimlnUUID = MaintSchedSimlnUUID  -- association [0..*]
LEFT OUTER JOIN I_RSHMaintSchedCollaboratorsTP AS _MaintSchedCollaborators ON _MaintSchedCollaborators.MaintSchedSimlnUUID = MaintSchedSimlnUUID  -- association [0..*]
LEFT OUTER JOIN I_RSHMaintSchedActivityLogTP AS _MaintSchedActivityLog ON _MaintSchedActivityLog.MaintSchedSimlnUUID = MaintSchedSimlnUUID  -- association [0..*]
LEFT OUTER JOIN I_RSHMaintSchedRescheduledOpTP AS _MaintRescheduledOp ON _MaintRescheduledOp.MaintSchedSimlnUUID = MaintSchedSimlnUUID  -- association [0..*]
;

Learn More