S_SCRL_METHOD_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_SCRL_METHOD_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_SCRL_METHOD_C AS
SELECT
  I_SCRL_METHOD_TP.LibraryID AS LibraryID,
  I_SCRL_METHOD_TP.VersionNumber AS VersionNumber,
  I_SCRL_METHOD_TP.MethodID AS MethodID,
  MethodIDForEdit,
  Description,
  _LifecycleStatus.Transported AS Transported
FROM I_SCRL_METHOD_TP
LEFT OUTER JOIN S_SCRL_LIBRARY_C AS _Library ON _Library.LibraryID = LibraryID AND _Library.VersionNumber = VersionNumber  -- association [1]
LEFT OUTER JOIN S_SCRL_PARAMETER_C AS _Parameter ON _Parameter.LibraryID = LibraryID AND _Parameter.VersionNumber = VersionNumber AND _Parameter.MethodID = MethodID  -- association [0..*]
LEFT OUTER JOIN P_SCRL_METHOD_TRANSPORTED AS _LifecycleStatus ON _LifecycleStatus.LibraryID = LibraryID AND _LifecycleStatus.MethodID = MethodID  -- association [1]
LEFT OUTER JOIN S_SCRL_METHOD_LOGIC_C AS _Logic ON _Logic.LibraryID = LibraryID AND _Logic.MethodID = MethodID AND _Logic.VersionNumber = VersionNumber  -- association [0..1]
;