P_Cfd_Reg_Cds_Text_Source

DDL: P_CFD_REG_CDS_TEXT_SOURCE SQL: P_CFD_REG_CDS_TS Type: view
1 Fields 3 Data Sources

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.

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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_Cfd_Reg_Cds_Text_Source.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: P_CFD_REG_CDS_TS

CREATE VIEW P_Cfd_Reg_Cds_Text_Source AS
SELECT
  case when Text.language <> '' and Text.description <> '' then 'X' else ' ' end AS UseRegistryTranslation
FROM cfd_w_cds AS cds
INNER JOIN tadir AS MasterRecord ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cfd_w_cds_t AS Text ON /* join condition not captured in parsed metadata */
;

Learn More