S_SCRL_LIBRARY_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_LIBRARY_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_LIBRARY_C AS
SELECT
  LibraryID,
  VersionNumber,
  Name,
  PublishState,
  _PublishState.Description AS PublishState_Text,
  _LifecycleStatus.Transported AS Transported,
  OriginalLanguage,
  OriginalRelease,
  CreatedBy,
  CreatedOn,
  LastChangedBy,
  LastChangedOn,
  ImplementationClass,
  _DraftStatus.IsDraftAvailable AS IsDraftAvailable,
  ETag
FROM I_SCRL_LIBRARY_TP
LEFT OUTER JOIN S_SCRL_User AS _CreateUser ON _CreateUser.Name = CreatedBy  -- association [1..1]
LEFT OUTER JOIN S_SCRL_User AS _ChangeUser ON _ChangeUser.Name = LastChangedBy  -- association [1..1]
LEFT OUTER JOIN S_SCRL_Publish_State AS _PublishState ON _PublishState.Code = PublishState AND _PublishState.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN S_SCRL_METHOD_C AS _Method ON _Method.LibraryID = LibraryID AND _Method.VersionNumber = VersionNumber  -- association [0..*]
LEFT OUTER JOIN S_SCRL_STRUCTURE_C AS _Structure ON _Structure.LibraryID = LibraryID AND _Structure.VersionNumber = VersionNumber  -- association [0..*]
LEFT OUTER JOIN S_SCRL_TABLE_C AS _Table ON _Table.LibraryID = LibraryID AND _Table.VersionNumber = VersionNumber  -- association [0..*]
LEFT OUTER JOIN S_SCRL_DATA_C AS _Data ON _Data.LibraryID = LibraryID AND _Data.VersionNumber = VersionNumber  -- association [0..*]
LEFT OUTER JOIN p_scrl_library_transported AS _LifecycleStatus ON _LifecycleStatus.LibraryID = LibraryID  -- association [1]
LEFT OUTER JOIN P_SCRL_LBRY_RGSTRY_DRFT_AVAIL AS _DraftStatus ON _DraftStatus.LibraryID = LibraryID  -- association [1]
;