I_SCME_EXTENSION_TP

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 I_SCME_EXTENSION_TP.
-- 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 I_SCME_EXTENSION_TP AS
SELECT
  extension_id AS ExtensionID,
  version_number AS VersionNumber,
  Name,
  consumer_domain AS ConsumerDomain,
  source_view AS SourceView,
  publish_state AS PublishState,
  original_language AS OriginalLanguage,
  original_release AS OriginalRelease,
  created_by AS CreatedBy,
  created_on AS CreatedOn,
  last_changed_by AS LastChangedBy,
  last_changed_on AS LastChangedOn,
  cast ( last_changed_on as scme_etag ) AS ETag
FROM scme_extension
LEFT OUTER JOIN I_SCME_ANNOTATION_TP AS _Annotation ON _Annotation.ExtensionID = ExtensionID AND _Annotation.VersionNumber = VersionNumber  -- association [0..*]
LEFT OUTER JOIN I_SCME_ANNOTATION_TP AS _ViewAnnotation ON _ViewAnnotation.ExtensionID = ExtensionID AND _ViewAnnotation.VersionNumber = VersionNumber  -- association [0..*]
LEFT OUTER JOIN I_SCME_ANNOTATION_TP AS _FieldAnnotation ON _FieldAnnotation.ExtensionID = ExtensionID AND _FieldAnnotation.VersionNumber = VersionNumber  -- association [0..*]
;