P_Cfd_Registry_Odata

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_Odata.
-- 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_ODT

CREATE VIEW P_Cfd_Registry_Odata AS
SELECT
  RegistryContext.model_name AS ModelName,
  RegistryContext.business_context AS BusinessContext,
  RegistryContext.entity_name AS EntityName,
  RegistryContext.union_suffix AS UnionSuffix,
  Registry.availability AS Availability,
  Registry.usage_form_template AS FormUsage,
  Registry.usage_ui_report AS ScreenUsage,
  RegistryContext.release_status AS ReleaseStatus,
  RegistryContext.basic_search_support AS SearchSupported,
  RegistryContext.cds_view_name AS CdsViewName,
  RegistryContext.implementation_type AS EntityImplementationType,
  rtrim(cast( RegistryContext.model_name as /iwbep/med_mdl_technical_name ), ' ') AS ModelNameWOVersion,
  cast( cast( substring(RegistryContext.model_name, 33, 36) as abap.numc( 4 ) ) as /iwbep/med_mdl_version ) AS ModelVersion,
  _Successor.successor AS Successor
FROM cfd_w_odata_ctxt AS RegistryContext
LEFT OUTER JOIN cfd_w_odata_t AS _ModelText ON _ModelText.model_name = ModelName  -- association [0..*]
LEFT OUTER JOIN cfd_w_odata_ct_t AS _EntityText ON _EntityText.model_name = ModelName AND _EntityText.entity_name = EntityName AND _EntityText.business_context = BusinessContext  -- association [0..*]
LEFT OUTER JOIN I_CFD_Release_Status AS _ReleaseStatus ON _ReleaseStatus.Code = ReleaseStatus  -- association [1]
LEFT OUTER JOIN cfd_w_odata_suc AS _Successor ON _Successor.model_name = ModelName AND _Successor.business_context = BusinessContext  -- association [0..1]
LEFT OUTER JOIN P_Cfd_Reg_Cds_Text AS _SuccessorCDSText ON _SuccessorCDSText.CdsViewName = Successor  -- association [*]
LEFT OUTER JOIN cfd_w_odata_t AS _SuccessorModelText ON _SuccessorModelText.model_name = Successor  -- association [*]
;