I_RSHMaintSchedSimulation

DDL: I_RSHMAINTSCHEDSIMULATION SQL: IRSHMNTSCHDSIM Type: view BASIC

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 21 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 (21)

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
_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,

      // Associations

      @ObjectModel.association.type: #TO_COMPOSITION_CHILD
      _MaintSchedSmltdOp,

      // Associations

      @ObjectModel.association.type: #TO_COMPOSITION_CHILD
      _MaintSchedCollaborators
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"RSH_D_MNTSCHDSIM"
],
"ASSOCIATED":
[
"I_RSHMAINTSCHEDCOLLABORATORS",
"I_RSHMAINTSCHEDSMLTDOP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/