P_Cfd_Reg_Cds_Text_Source

DDL: P_CFD_REG_CDS_TEXT_SOURCE SQL: P_CFD_REG_CDS_TS Type: view

Determine Source of Texts

P_Cfd_Reg_Cds_Text_Source is a CDS View that provides data about "Determine Source of Texts" in SAP S/4HANA. It reads from 3 data sources (cfd_w_cds, tadir, cfd_w_cds_t) and exposes 1 field.

3 data source(s) 1 fields

Data Sources (3)

SourceAliasJoin Type
cfd_w_cds cds from
tadir MasterRecord inner
cfd_w_cds_t Text left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName P_CFD_REG_CDS_TS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Determine Source of Texts view

Fields (1)

KeyFieldSource TableSource FieldDescription
UseRegistryTranslation 
@AbapCatalog.sqlViewName: 'P_CFD_REG_CDS_TS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Determine Source of Texts'
define view P_Cfd_Reg_Cds_Text_Source as 
  select from cfd_w_cds as cds
  inner join tadir as MasterRecord
    on MasterRecord.obj_name = cds.cds_view_name
   and MasterRecord.object   = 'CFDC'
  left outer join cfd_w_cds_t as Text
    on Text.cds_view_name = cds.cds_view_name
   and Text.language      = MasterRecord.masterlang
 {
  key cds.cds_view_name,
  
  case when Text.language <> '' and Text.description <> '' then 'X' else ' ' end as UseRegistryTranslation
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CFD_W_CDS",
"CFD_W_CDS_T",
"TADIR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More