P_Cfd_Registry_Cds

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_Registry_Cds.
-- 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_RGSTRY_CDS

CREATE VIEW P_Cfd_Registry_Cds AS
SELECT
  RegistryContext.cds_view_name AS CDSViewName,
  RegistryContext.business_context AS BusinessContext,
  RegistryContext.union_suffix AS UnionSuffix,
  RegistryContext.direct_union_suffix AS DirectUnionSuffix,
  RegistryContext.role_suffix AS RoleSuffix,
  RegistryContext.extension_incl_view_name AS ExtensionIncludeViewName,
  RegistryContext.underlying_view_name AS UnderlyingViewName,
  RegistryContext.release_status AS ReleaseStatus,
  RegistryContext.mandatory_field_enabled AS MandatoryFieldEnabled,
  RegistryContext.read_only_field_enabled AS ReadOnlyFieldEnabled,
  Registry.availability AS Availability,
  Registry.usage_ui_report AS ScreenUsage,
  Registry.usage_email_template AS EmailUsage,
  Registry.usage_invisible AS IsInvisible,
  Registry.usage_api AS IsApiUsage,
  Registry.usage_analytics AS IsAnalyticalUsage,
  Registry.basic_search_support AS SearchSupported,
  Registry.view_type AS ViewType,
  Registry.badi_definition_for_hidden AS BadiDefinitionForHidden,
  RegistryContext.add_field_automatically AS AddAutomatically,
  RegistryContext.cds_view_is_always_enabled AS ViewIsAlwaysEnabled,
  _Successor.cds_view_name AS Successor
FROM cfd_w_cds_cxt AS RegistryContext
INNER JOIN cfd_w_cds AS Registry ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Cfd_Reg_Cds_Text AS _Text ON _Text.CdsViewName = CDSViewName  -- association [*]
LEFT OUTER JOIN I_CFD_Release_Status AS _ReleaseStatus ON _ReleaseStatus.Code = ReleaseStatus  -- association [1]
LEFT OUTER JOIN cfd_w_cds_suc AS _Successor ON _Successor.cds_view_name = CDSViewName AND _Successor.business_context = BusinessContext  -- association [0..1]
LEFT OUTER JOIN P_Cfd_Reg_Cds_Text AS _SuccessorText ON _SuccessorText.CdsViewName = Successor  -- association [*]
;