I_Aps_Com_Data_Element_Text

DDL: I_APS_COM_DATA_ELEMENT_TEXT SQL: I_DATA_EL_TEXT Type: view Package: SR_APS_COM_COMMON

Descriptions of field labels of DDIC Data Elements

I_Aps_Com_Data_Element_Text is a CDS View that provides data about "Descriptions of field labels of DDIC Data Elements" in SAP S/4HANA. It reads from 2 data sources (dd04l, dd04t) and exposes 7 fields with key field Name. Part of development package SR_APS_COM_COMMON.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
dd04l DataElement from
dd04t DataElementText left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName I_DATA_EL_TEXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Descriptions of field labels of DDIC Data Elements view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Name dd04l rollname
LongDescription dd04t scrtext_l
MediumDescription dd04t scrtext_m
ShortDescription dd04t scrtext_s
DataElementLength
IsCaseSensitive dd04l lowercase
DomainName dd04l domname 
@AbapCatalog.sqlViewName: 'I_DATA_EL_TEXT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Descriptions of field labels of DDIC Data Elements'
define view I_Aps_Com_Data_Element_Text
  as select from    dd04l as DataElement
    left outer join dd04t as DataElementText on  DataElementText.rollname   = DataElement.rollname
                                             and DataElementText.as4local   = DataElement.as4local
                                             and DataElementText.as4vers    = DataElement.as4vers
                                             and DataElementText.ddlanguage = $session.system_language

{
  key DataElement.rollname                 as Name,
      DataElementText.scrtext_l            as LongDescription,
      DataElementText.scrtext_m            as MediumDescription,
      DataElementText.scrtext_s            as ShortDescription,
      cast (DataElement.leng as abap.int4) as DataElementLength,
      DataElement.lowercase                as IsCaseSensitive,
      DataElement.domname                  as DomainName
}
where
      DataElement.as4local = 'A'
  and DataElement.as4vers  = '0000'

Learn More