I_ExposureScenario

DDL: I_EXPOSURESCENARIO Type: view BASIC

Exposure Scenario

I_ExposureScenario is a Basic CDS View that provides data about "Exposure Scenario" in SAP S/4HANA. It reads from 1 data source (ehsdsv_es) and exposes 10 fields with key field PCESScenarioUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
ehsdsv_es ehsdsv_es from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID -- Admin data - Last changed by
[0..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IEXPSC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Exposure Scenario view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PCESScenarioUUID pcesscenariouuid
PCESScenarioType pcesscenariotype
PCESExposureScenarioType pcesexposurescenariotype
ComplianceRequirement compliancerequirement
CreationDateTime creationdatetime
CreatedByUser createdbyuser
LastChangeDateTime lastchangedatetime
LastChangedByUser lastchangedbyuser
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
@AbapCatalog: {
  sqlViewName: 'IEXPSC',
  compiler.compareFilter: true }

@AccessControl.authorizationCheck: #MANDATORY

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Exposure Scenario'

@ObjectModel.usageType: {
  serviceQuality: #A,
  sizeCategory:  #L,
  dataClass: #MASTER }

@VDM.viewType: #BASIC
define view I_ExposureScenario
  as select from ehsdsv_es

  -- Admin data - Created by
  association [0..1] to I_User as _CreatedByUser     on $projection.CreatedByUser = _CreatedByUser.UserID
  -- Admin data - Last changed by
  association [0..1] to I_User as _LastChangedByUser on $projection.LastChangedByUser = _LastChangedByUser.UserID

{

  key  pcesscenariouuid         as PCESScenarioUUID,
       pcesscenariotype         as PCESScenarioType,
       pcesexposurescenariotype as PCESExposureScenarioType,
       compliancerequirement    as ComplianceRequirement,

       /**** Admin Fields ****/

       @Semantics.systemDateTime.createdAt: true
       creationdatetime         as CreationDateTime,
       @Semantics.user.createdBy: true
       createdbyuser            as CreatedByUser,
       @Semantics.systemDateTime.lastChangedAt: true
       lastchangedatetime       as LastChangeDateTime,
       @Semantics.user.lastChangedBy: true
       lastchangedbyuser        as LastChangedByUser,

       /**** Associations ****/
       _CreatedByUser,
       _LastChangedByUser

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHSDSV_ES"
],
"ASSOCIATED":
[
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/