I_SVTExclusionReason

DDL: I_SVTEXCLUSIONREASON SQL: ISVTEXCLSNRSN Type: view BASIC Package: EHPMA_SVT_COMN

Domain for SVT Exclusion Reason

I_SVTExclusionReason is a Basic CDS View that provides data about "Domain for SVT Exclusion Reason" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field SVTExclusionReason. It has 1 association to related views. Part of development package EHPMA_SVT_COMN.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_SVTExclusionReasonText _Text $projection.SVTExclusionReason = _Text.SVTExclusionReason

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISVTEXCLSNRSN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Domain for SVT Exclusion Reason view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.representativeKey SVTExclusionReason view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #META view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY SVTExclusionReason
_Text _Text 
@AbapCatalog.sqlViewName: 'ISVTEXCLSNRSN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Domain for SVT Exclusion Reason'
@ObjectModel.resultSet.sizeCategory: #XS
@ObjectModel.representativeKey: 'SVTExclusionReason'
@ObjectModel.usageType:{ serviceQuality: #A,        // < 1 msec

                         sizeCategory:   #S,         // < 1.000

                         dataClass:      #META }
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_SVTExclusionReason
  as select from dd07l
  association [0..*] to I_SVTExclusionReasonText as _Text on $projection.SVTExclusionReason = _Text.SVTExclusionReason
{
      @ObjectModel.text.association: '_Text'
  key cast(dd07l.domvalue_l as ehpma_svt_exclude_reason ) as SVTExclusionReason,
      _Text
}
where
      dd07l.domname  = 'EHPMA_SVT_EXCLUDE_REASON'
  and dd07l.as4local = 'A'

Learn More