P_Cfd_Data_Element_Text

DDL: P_CFD_DATA_ELEMENT_TEXT SQL: P_CFD_DTEL_T Type: view

Custom Fields: Text for data element

P_Cfd_Data_Element_Text is a CDS View that provides data about "Custom Fields: Text for data element" in SAP S/4HANA. It reads from 2 data sources (dd04t, tadir) and exposes 8 fields with key fields DataElement, Language.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
dd04t DataElementText from
tadir ObjectDirectory inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName P_CFD_DTEL_T view
AccessControl.authorizationCheck #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Custom Fields: Text for data element view
VDM.private true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY DataElement dd04t rollname
KEY Language dd04t ddlanguage
Tooltip dd04t ddtext
Heading dd04t reptext
ShortLabel dd04t scrtext_s
MediumLabel dd04t scrtext_m
LongLabel dd04t scrtext_l
MasterLanguage tadir masterlang 
@AbapCatalog.sqlViewName: 'P_CFD_DTEL_T'
@AccessControl.authorizationCheck: #NOT_ALLOWED
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Custom Fields: Text for data element'
@VDM.private: true
define view P_Cfd_Data_Element_Text
  as select from dd04t as DataElementText
    inner join   tadir as ObjectDirectory on  ObjectDirectory.pgmid    = 'R3TR'
                                          and ObjectDirectory.object   = 'DTEL'
                                          and ObjectDirectory.obj_name = DataElementText.rollname
{
  key DataElementText.rollname   as DataElement,
  key DataElementText.ddlanguage as Language,
      DataElementText.ddtext     as Tooltip,
      DataElementText.reptext    as Heading,
      DataElementText.scrtext_s  as ShortLabel,
      DataElementText.scrtext_m  as MediumLabel,
      DataElementText.scrtext_l  as LongLabel,
      ObjectDirectory.masterlang as MasterLanguage
}
where
      DataElementText.as4local = 'A'
  and DataElementText.as4vers  = '0000'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD04T",
"TADIR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More