S_SCME_EXTENSION_OVERVIEW_C

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

CREATE VIEW S_SCME_EXTENSION_OVERVIEW_C AS
SELECT
  CurrentVersionExtension.ExtensionID AS ExtensionID,
  VersionNumber,
  Name,
  ConsumerDomain,
  SourceView,
  PublishState,
  OriginalLanguage,
  OriginalRelease,
  CreatedBy,
  CreatedOn,
  LastChangedBy,
  LastChangedOn,
  RegistryEntry.IsDraftAvailable AS IsDraftAvailable
FROM I_SCME_EXTENSION_TP AS CurrentVersionExtension
INNER JOIN P_SCME_REGISTRY AS RegistryEntry ON /* join condition not captured in parsed metadata */
INNER JOIN I_SCME_EXTENSION_TP AS PublishedExtension ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_SCME_EXTENSION_TP
;