S_SCRL_PARAMETER_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_PARAMETER_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_PARAMETER_C AS
SELECT
  I_SCRL_PARAMETER_TP.LibraryID AS LibraryID,
  I_SCRL_PARAMETER_TP.VersionNumber AS VersionNumber,
  I_SCRL_PARAMETER_TP.MethodID AS MethodID,
  I_SCRL_PARAMETER_TP.ParameterID AS ParameterID,
  ParameterIDForEdit,
  Description,
  Kind,
  IsOptional,
  Type,
  Length,
  Scale,
  CodeList,
  DataSource,
  Structure,
  TableName,
  _LifecycleStatus.Transported AS Transported
FROM I_SCRL_PARAMETER_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_METHOD_C AS _Method ON _Method.LibraryID = LibraryID AND _Method.VersionNumber = VersionNumber AND _Method.MethodID = MethodID  -- association [1]
LEFT OUTER JOIN P_SCRL_PARAMETER_TRANSPORTED AS _LifecycleStatus ON _LifecycleStatus.LibraryID = LibraryID AND _LifecycleStatus.MethodID = MethodID AND _LifecycleStatus.ParameterID = ParameterID  -- association [1]
;