P_Cfd_Reg_Cds_Text

DDL: P_CFD_REG_CDS_TEXT SQL: P_CFD_REG_CDS_T Type: view

Descriptions for CDS Views of Custom Fields

P_Cfd_Reg_Cds_Text is a CDS View that provides data about "Descriptions for CDS Views of Custom Fields" in SAP S/4HANA. It reads from 4 data sources (cfd_w_cds_t, ddddlsrc02bt_v, P_Cfd_Reg_Cds_Text_Source, P_Cfd_Reg_Cds_Text_Source) and exposes 7 fields with key fields CdsViewName, Language, Language.

Data Sources (4)

SourceAliasJoin Type
cfd_w_cds_t Text left_outer
ddddlsrc02bt_v Text left_outer
P_Cfd_Reg_Cds_Text_Source TextSource inner
P_Cfd_Reg_Cds_Text_Source TextSource inner

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName P_CFD_REG_CDS_T view
EndUserText.label Descriptions for CDS Views of Custom Fields view
VDM.private true view
AccessControl.authorizationCheck #NOT_ALLOWED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CdsViewName RegCds cds_view_name STOB Name
KEY Language ddddlsrc02bt_v language Lang.
Description ddddlsrc02bt_v description Short text
cds_view_nameasCdsViewName
KEY Language ddddlsrc02bt_v ddlanguage Lang.
Description ddddlsrc02bt_v ddtext Short text
TextSource

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.
-- 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_T

CREATE VIEW P_Cfd_Reg_Cds_Text AS
SELECT
  RegCds.cds_view_name AS CdsViewName,
  Text.language AS Language,
  Text.description AS Description,
  'REG' as TextSource AS cds_view_nameasCdsViewName,
  'CDS' AS TextSource
INNER JOIN P_Cfd_Reg_Cds_Text_Source AS TextSource 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 */
LEFT OUTER JOIN ddddlsrc02bt_v AS Text ON /* join condition not captured in parsed metadata */
;