I_RSHMaintSchedSimulation

DDL: I_RSHMAINTSCHEDSIMULATION SQL: IRSHMNTSCHDSIM Type: view BASIC Package: RSH_CDS_MAINT_SCHED_SIM

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. Part of development package RSH_CDS_MAINT_SCHED_SIM.

1 data source(s) 23 fields

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
MaintSchedSimulationStartDate maintschedsimulationstartdate
MaintSchedSimulationEndDate maintschedsimulationenddate
MaintSchedSimlnDescription maintschedsimlndescription
MaintSchedSimlnLongText maintschedsimlnlongtext
CreatedByUser createdbyuser
CreationDateTime creationdatetime
LastChangedByUser lastchangedbyuser
LastChangeDateTime lastchangedatetime
SimulationSessionState simulationsessionstate
SessionStateLastChangeDateTime sessionstatelastchangedatetime
MaintSchedCacheIsActive maintschedcacheisactive
MaintSchedJobName maintschedjobname
MaintSchedJobID maintschedjobid
PreviousMaintSchedSimlnUUID previousmaintschedsimlnuuid
NextMaintSchedSimlnUUID nextmaintschedsimlnuuid
MaintSchedSimulationStartTime maintschedsimulationstarttime
MaintSchedSimulationEndTime maintschedsimulationendtime
MaintSchedSimulationTimeZone maintschedsimulationtimezone
MaintSchedSimStartDateTime
MaintSchedSimEndDateTime
_MaintSchedSmltdOp _MaintSchedSmltdOp
_MaintSchedCollaborators _MaintSchedCollaborators 
@AbapCatalog.sqlViewName: 'IRSHMNTSCHDSIM'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Maintenance Scheduling Simulation Root'

@Metadata.ignorePropagatedAnnotations:true
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API

@Search.searchable: false
@ObjectModel.compositionRoot: true
@ObjectModel.entityChangeStateId: 'LastChangeDateTime'

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE


/*
CONTRACT*************************************************************************************************************************
Name:                       Maintenance Scheduling Simulation
Specification:              This view will return the Maintenance Scheduling Simulations belonging created by the user
Requires:                   NA
Ensures:                    Roots of Maintenance Scheduling Simulations are returned
Owners:                     CF
Contributors:
Unit Test required Y/N:     Y
Additional comments         None

END OF CONTRACT******************************************************************************************************************
*/

define view I_RSHMaintSchedSimulation
  as select from rsh_d_mntschdsim

  association [0..*] to I_RSHMaintSchedSmltdOp       as _MaintSchedSmltdOp       on _MaintSchedSmltdOp.MaintSchedSimlnUUID = $projection.MaintSchedSimlnUUID
  association [0..*] to I_RSHMaintSchedCollaborators as _MaintSchedCollaborators on _MaintSchedCollaborators.MaintSchedSimlnUUID = $projection.MaintSchedSimlnUUID

{
  key maintschedsimlnuuid                                                                                                                                                                         as MaintSchedSimlnUUID,
      maintschedsimulationstartdate                                                                                                                                                               as MaintSchedSimulationStartDate,
      maintschedsimulationenddate                                                                                                                                                                 as MaintSchedSimulationEndDate,
      maintschedsimlndescription                                                                                                                                                                  as MaintSchedSimlnDescription,
      maintschedsimlnlongtext                                                                                                                                                                     as MaintSchedSimlnLongText,
      createdbyuser                                                                                                                                                                               as CreatedByUser,
      creationdatetime                                                                                                                                                                            as CreationDateTime,
      lastchangedbyuser                                                                                                                                                                           as LastChangedByUser,
      lastchangedatetime                                                                                                                                                                          as LastChangeDateTime,
      simulationsessionstate                                                                                                                                                                      as SimulationSessionState,
      sessionstatelastchangedatetime                                                                                                                                                              as SessionStateLastChangeDateTime,

      @Semantics.booleanIndicator:true
      maintschedcacheisactive                                                                                                                                                                     as MaintSchedCacheIsActive,

      maintschedjobname                                                                                                                                                                           as MaintSchedJobName,
      maintschedjobid                                                                                                                                                                             as MaintSchedJobID,
      previousmaintschedsimlnuuid                                                                                                                                                                 as PreviousMaintSchedSimlnUUID,
      nextmaintschedsimlnuuid                                                                                                                                                                     as NextMaintSchedSimlnUUID,
      maintschedsimulationstarttime                                                                                                                                                               as MaintSchedSimulationStartTime,
      maintschedsimulationendtime                                                                                                                                                                 as MaintSchedSimulationEndTime,
      maintschedsimulationtimezone                                                                                                                                                                as 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,

      // Associations

      @ObjectModel.association.type: #TO_COMPOSITION_CHILD
      _MaintSchedSmltdOp,

      // Associations

      @ObjectModel.association.type: #TO_COMPOSITION_CHILD
      _MaintSchedCollaborators
}

Learn More