P_Cfd_Domain_Value

DDL: P_CFD_DOMAIN_VALUE SQL: P_CFD_DOM_VAL Type: view

Fixed values of a DDIC domain

P_Cfd_Domain_Value is a CDS View that provides data about "Fixed values of a DDIC domain" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 3 fields with key fields Name, Code.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
dd07l Value from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName P_CFD_DOM_VAL view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Fixed values of a DDIC domain view
VDM.private true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Name dd07l domname
KEY Code dd07l domvalue_l
_Text _Text 
@AbapCatalog.sqlViewName: 'P_CFD_DOM_VAL'
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Fixed values of a DDIC domain'
@VDM.private: true
define view P_Cfd_Domain_Value 
  as select from dd07l as Value
    association[1..*] to P_Cfd_Domain_Value_Text as _Text
      on  $projection.Name = _Text.Name
      and $projection.Code = _Text.Code
{
  key Value.domname as Name,
  key Value.domvalue_l as Code,
  
  _Text
} where Value.as4local = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L"
],
"ASSOCIATED":
[
"P_CFD_DOMAIN_VALUE_TEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More