R_Sitn2DomainText

DDL: R_SITN2DOMAINTEXT SQL: RSITN2DOMAINTXT Type: view BASIC

Fixed Domain Values - Text

R_Sitn2DomainText is a Basic CDS View that provides data about "Fixed Domain Values - Text" in SAP S/4HANA. It reads from 2 data sources (dd07l, dd07t) and exposes 5 fields with key fields SAPDataDictionaryDomain, Language, DomainValue. It has 1 association to related views.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
dd07l _dd07l inner
dd07t _dd07t from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language _dd07t.ddlanguage = _Language.Language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName RSITN2DOMAINTXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Fixed Domain Values - Text view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #TEXT view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SAPDataDictionaryDomain dd07t domname
KEY Language dd07t ddlanguage
KEY DomainValue dd07t domvalue_l
DomainText dd07t ddtext
_Language _Language 
@AbapCatalog.sqlViewName:               'RSITN2DOMAINTXT'
@AbapCatalog.compiler.compareFilter:    true
@AbapCatalog.preserveKey:               true
@AccessControl.authorizationCheck:      #NOT_REQUIRED
@EndUserText.label: 'Fixed Domain Values - Text'

@VDM.viewType:                          #BASIC
@ObjectModel.usageType.serviceQuality:  #C
@ObjectModel.usageType.sizeCategory:    #M
@ObjectModel.usageType.dataClass:       #MIXED
//@ObjectModel.representativeKey:         'DomainValue'

@ObjectModel.dataCategory:              #TEXT

@ClientHandling.algorithm:              #SESSION_VARIABLE
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API

define view R_Sitn2DomainText as select from dd07t as _dd07t

inner join dd07l as _dd07l on  _dd07t.as4local  = _dd07l.as4local
                           and _dd07t.as4vers   = _dd07l.as4vers
                           and _dd07t.domname   = _dd07l.domname
                           and _dd07t.valpos    = _dd07l.valpos

association [0..1] to I_Language as _Language on _dd07t.ddlanguage = _Language.Language

{
    
//@ObjectModel.foreignKey.association: '_Domain' 

  key _dd07t.domname       as SAPDataDictionaryDomain,
  
  @ObjectModel.foreignKey.association: '_Language'
  @Semantics.language: true
  key _dd07t.ddlanguage    as Language,
//  key _dd07t.valpos  as DomainValuePosition,

//  key _dd07t.as4vers as DomainVersion,

  
  //old annotation style: @ObjectModel.text: { element: 'DomainText' }

  @ObjectModel.text.element: [ 'DomainText' ]
  key _dd07t.domvalue_l    as DomainValue,
  
  @Semantics.text: true
  _dd07t.ddtext            as DomainText,
  
  _Language
}
where
        _dd07t.as4local = 'A' 
    and _dd07t.ddlanguage = $session.system_language 
    and ( _dd07t.domname  = 'SIT2_DO_INST_STAT' )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L",
"DD07T"
],
"ASSOCIATED":
[
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More