P_Cfd_Domain_Value_Text

DDL: P_CFD_DOMAIN_VALUE_TEXT SQL: P_CFD_DOM_VAL_T Type: view

Descriptions of fixed values of a DDIC domain

P_Cfd_Domain_Value_Text is a CDS View that provides data about "Descriptions of fixed values of a DDIC domain" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 5 fields with key fields Name, Code, Language.

Data Sources (1)

SourceAliasJoin Type
dd07t Value from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName P_CFD_DOM_VAL_T view
EndUserText.label Descriptions of fixed values of a DDIC domain view
VDM.private true view
AccessControl.authorizationCheck #NOT_ALLOWED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Name dd07t domname
KEY Code dd07t domvalue_l
KEY Language dd07t ddlanguage
Description dd07t ddtext
_Language _Language
@AbapCatalog.sqlViewName: 'P_CFD_DOM_VAL_T'
@EndUserText.label: 'Descriptions of fixed values of a DDIC domain'
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
define view P_Cfd_Domain_Value_Text 
  as select from dd07t as Value
    association to I_Language as _Language
      on $projection.Language = _Language.Language   
  {
    key Value.domname as Name,
    key Value.domvalue_l as Code,
    key Value.ddlanguage as Language,
    Value.ddtext as Description,
    
    _Language
  } where Value.as4local = 'A'
  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/