DD_DATA_ELEMENT_INFO

DDL: DD_DATA_ELEMENT_INFO Type: view_entity

Data Element Information

DD_DATA_ELEMENT_INFO is a CDS View that provides data about "Data Element Information" in SAP S/4HANA. It reads from 2 data sources (dd04l, tadir). It has 3 associations to related views.

2 data source(s)

Data Sources (2)

SourceAliasJoin Type
dd04l _data_element from
tadir tadir inner

Associations (3)

CardinalityTargetAliasCondition
[0..1] dd04t _text_active _data_element.rollname = _text_active.rollname and _data_element.as4local = _text_active.as4local and _data_element.as4vers = _text_active.as4vers and _text_active.ddlanguage = $session.system_language
[0..1] dd04t _text_english _data_element.rollname = _text_english.rollname and _data_element.as4local = _text_english.as4local and _data_element.as4vers = _text_english.as4vers and _text_english.ddlanguage = 'E'
[0..1] dd04t _text_original _data_element.rollname = _text_original.rollname and _data_element.as4local = _text_original.as4local and _data_element.as4vers = _text_original.as4vers and _text_original.ddlanguage = tadir.masterlang

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Data Element Information view 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Data Element Information'
define view entity DD_DATA_ELEMENT_INFO
  as select from dd04l as _data_element
  --tadir
    inner join   tadir as tadir on  tadir.pgmid    = 'R3TR'
                                and tadir.object   = 'DTEL'
                                and tadir.obj_name = _data_element.rollname

  association [0..1] to dd04t as _text_active   on  _data_element.rollname  = _text_active.rollname
                                                and _data_element.as4local  = _text_active.as4local
                                                and _data_element.as4vers   = _text_active.as4vers
                                                and _text_active.ddlanguage = $session.system_language

  association [0..1] to dd04t as _text_english  on  _data_element.rollname   = _text_english.rollname
                                                and _data_element.as4local   = _text_english.as4local
                                                and _data_element.as4vers    = _text_english.as4vers
                                                and _text_english.ddlanguage = 'E'

  association [0..1] to dd04t as _text_original on  _data_element.rollname    = _text_original.rollname
                                                and _data_element.as4local    = _text_original.as4local
                                                and _data_element.as4vers     = _text_original.as4vers
                                                and _text_original.ddlanguage = tadir.masterlang

{
        @EndUserText.label: 'Data Element Name'
  key   cast( _data_element.rollname as abap.char(30) )                                                                 as data_element_name,
        @EndUserText.label: 'Short Description'
        cast(coalesce( coalesce( _text_active.ddtext, _text_english.ddtext ), _text_original.ddtext ) as abap.char(60)) as short_description,
        @EndUserText.label: 'Language of Short Description'
        coalesce( coalesce( _text_active.ddlanguage, _text_english.ddlanguage ), _text_original.ddlanguage )            as short_description_language,
        cast( dats_tims_to_tstmp( _data_element.as4date, _data_element.as4time,
                                  abap_system_timezone( $session.client,'NULL' ),
                                  $session.client,
                                  'FAIL')
                                   
            as timestamp )                                                                                              as last_changed_at_utc

}
where
      _data_element.as4local = 'A'
  and _data_element.as4vers  = '0000'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD04L",
"DD04T",
"TADIR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More