S_SCME_EXTENSION_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_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_C AS
SELECT
  ExtensionID,
  VersionNumber,
  Name,
  ConsumerDomain,
  SourceView,
  PublishState,
  OriginalLanguage,
  OriginalRelease,
  CreatedBy,
  CreatedOn,
  LastChangedBy,
  LastChangedOn,
  ETag
FROM I_SCME_EXTENSION_TP
LEFT OUTER JOIN S_SCME_USER AS _CreateUser ON _CreateUser.Name = CreatedBy  -- association [1..1]
LEFT OUTER JOIN S_SCME_USER AS _ChangeUser ON _ChangeUser.Name = LastChangedBy  -- association [1..1]
LEFT OUTER JOIN S_SCME_PUBLISH_STATE_TEXT AS _PublishState ON _PublishState.Code = PublishState AND _PublishState.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN S_SCME_LANGUAGE_TEXT AS _OriginalLanguage ON _OriginalLanguage.LanguageKey = OriginalLanguage AND _OriginalLanguage.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN S_SCME_ANNOTATION_C AS _Annotation ON _Annotation.ExtensionID = ExtensionID AND _Annotation.VersionNumber = VersionNumber  -- association [0..*]
LEFT OUTER JOIN S_SCME_ANNOTATION_C AS _ViewAnnotation ON _ViewAnnotation.ExtensionID = ExtensionID AND _ViewAnnotation.VersionNumber = VersionNumber AND _ViewAnnotation.ScopeForEdit = 'VIEW'  -- association [0..*]
LEFT OUTER JOIN S_SCME_ANNOTATION_C AS _ParameterAnnotation ON _ParameterAnnotation.ExtensionID = ExtensionID AND _ParameterAnnotation.VersionNumber = VersionNumber AND _ParameterAnnotation.ScopeForEdit = 'PARAMETER'  -- association [0..*]
LEFT OUTER JOIN S_SCME_ANNOTATION_C AS _FieldAnnotation ON _FieldAnnotation.ExtensionID = ExtensionID AND _FieldAnnotation.VersionNumber = VersionNumber AND _FieldAnnotation.ScopeForEdit = 'FIELD'  -- association [0..*]
;