I_EntityElementDetail

DDL: I_ENTITYELEMENTDETAIL Type: view_entity Package: S_ESH_APPS_COMMON

Metadata of CDS Elements

I_EntityElementDetail is a CDS View that provides data about "Metadata of CDS Elements" in SAP S/4HANA. It reads from 2 data sources (DDCDS_ENTITY_ELEMENTS, dd04t) and exposes 10 fields with key fields DDLSourceName, FieldName. Part of development package S_ESH_APPS_COMMON.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
DDCDS_ENTITY_ELEMENTS CDS_Elements from
dd04t Data_Element_Text left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Metadata of CDS Elements view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY DDLSourceName DDCDS_ENTITY_ELEMENTS entity_name
KEY FieldName DDCDS_ENTITY_ELEMENTS element_name
FieldNameText DDCDS_ENTITY_ELEMENTS element_name_raw
CDSName DDCDS_ENTITY_ELEMENTS entity_name
DataElement DDCDS_ENTITY_ELEMENTS data_element
DataType DDCDS_ENTITY_ELEMENTS data_type
FieldPosition DDCDS_ENTITY_ELEMENTS element_position
Length DDCDS_ENTITY_ELEMENTS length
DataElementText dd04t ddtext
DataElementText_Medium DDCDS_ENTITY_ELEMENTS data_element_label_m 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Metadata of CDS Elements'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity I_EntityElementDetail as select from DDCDS_ENTITY_ELEMENTS as CDS_Elements
  left outer join dd04t as Data_Element_Text on CDS_Elements.data_element = Data_Element_Text.rollname and Data_Element_Text.ddlanguage = $session.system_language
{
  key CDS_Elements.entity_name as DDLSourceName,
  key CDS_Elements.element_name as FieldName,
  CDS_Elements.element_name_raw as FieldNameText,
  CDS_Elements.entity_name as CDSName,
  CDS_Elements.data_element as DataElement,
  CDS_Elements.data_type as DataType,
  CDS_Elements.element_position as FieldPosition,
  CDS_Elements.length as Length,
  Data_Element_Text.ddtext as DataElementText,
  CDS_Elements.data_element_label_m as DataElementText_Medium 
}

Learn More