I_DomainFixedValueText

DDL: I_DOMAINFIXEDVALUETEXT Type: view BASIC Package: VDM_TM_BASIC

Domain Fixed Value Text

I_DomainFixedValueText is a Basic CDS View that provides data about "Domain Fixed Value Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 10 fields with key fields SAPDataDictionaryDomain, DomainValue, Language, DomainActivationState, DomainValuePosition. It has 3 associations to related views. Part of development package VDM_TM_BASIC.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Domain _Domain $projection.SAPDataDictionaryDomain = _Domain.SAPDataDictionaryDomain and $projection.DomainActivationState = _Domain.DomainActivationState and $projection.DomainVersion = _Domain.DomainVersion
[1..1] I_DomainFixedValue _DomainFixedValue $projection.SAPDataDictionaryDomain = _DomainFixedValue.SAPDataDictionaryDomain and $projection.DomainValue = _DomainFixedValue.DomainValue and $projection.DomainActivationState = _DomainFixedValue.DomainActivationState and $projection.DomainValuePosition = _DomainFixedValue.DomainValuePosition and $projection.DomainVersion = _DomainFixedValue.DomainVersion
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (14)

NameValueLevelField
EndUserText.label Domain Fixed Value Text view
ObjectModel.representativeKey DomainValue view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IDOMFIXVALTEXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor NONE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SAPDataDictionaryDomain domname
KEY DomainValue domvalue_l
KEY Language ddlanguage
KEY DomainActivationState as4local
KEY DomainValuePosition valpos
KEY DomainVersion as4vers
DomainText ddtext
_Domain _Domain
_DomainFixedValue _DomainFixedValue
_Language _Language 
@EndUserText:   {label:              'Domain Fixed Value Text'}
@ObjectModel:   {representativeKey:  'DomainValue',
                 dataCategory:       #TEXT,
                 usageType:          {serviceQuality: #B,
                                      sizeCategory:   #XL,
                                      dataClass:      #CUSTOMIZING}}
@VDM:           {viewType:           #BASIC}
@AbapCatalog:   {sqlViewName:        'IDOMFIXVALTEXT',
                 compiler:           {compareFilter:  true}}
@AccessControl: {authorizationCheck: #NOT_REQUIRED}
@ClientHandling.algorithm:           #SESSION_VARIABLE

// views deprecated for Cloud 1808/ OP 1809

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'NONE'


define view I_DomainFixedValueText
  as select from dd07t
  association [1..1] to I_Domain           as _Domain           on  $projection.SAPDataDictionaryDomain = _Domain.SAPDataDictionaryDomain
                                                                and $projection.DomainActivationState   = _Domain.DomainActivationState
                                                                and $projection.DomainVersion           = _Domain.DomainVersion
  association [1..1] to I_DomainFixedValue as _DomainFixedValue on  $projection.SAPDataDictionaryDomain = _DomainFixedValue.SAPDataDictionaryDomain
                                                                and $projection.DomainValue             = _DomainFixedValue.DomainValue
                                                                and $projection.DomainActivationState   = _DomainFixedValue.DomainActivationState
                                                                and $projection.DomainValuePosition     = _DomainFixedValue.DomainValuePosition
                                                                and $projection.DomainVersion           = _DomainFixedValue.DomainVersion
  association [0..1] to I_Language         as _Language         on  $projection.Language = _Language.Language
{
      @ObjectModel.foreignKey.association: '_Domain'
  key domname     as  SAPDataDictionaryDomain,
  key domvalue_l  as  DomainValue,
      @Semantics.language: true
  key ddlanguage  as  Language,
  key as4local    as  DomainActivationState,
  key valpos      as  DomainValuePosition,
  key as4vers     as  DomainVersion,

      @Semantics.text: true
      ddtext      as  DomainText,

      /* Associations */
      _Domain,
      _DomainFixedValue,
      _Language
}
where
  as4local = 'A';

Learn More