S_SCRL_LIBRARY_OVERVIEW_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_OVERVIEW_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_OVERVIEW_C AS
SELECT
  LibraryID,
  VersionNumber,
  Name,
  PublishState,
  _PublishState.Description AS PublishState_Text,
  _LifecycleStatus.Transported AS Transported,
  OriginalLanguage,
  OriginalRelease,
  CreatedBy,
  CreatedOn,
  LastChangedBy,
  LastChangedOn,
  _DraftStatus.IsDraftAvailable AS IsDraftAvailable,
  _AtovReworkDemand.Priority_Text AS ReworkPriorityText,
  _AtovReworkDemand.Rework_Category_Text AS ReworkCategory,
  _AtovReworkDemand.Highest_Priority_Sort_Order AS ReworkPrioritySorter
FROM I_SCRL_LIBRARY_TP AS CurrentVersionLibrary
INNER JOIN S_SCRL_LIBRARY_REGISTRY_C AS LibraryRegistry ON /* join condition not captured in parsed metadata */
INNER JOIN I_SCRL_LIBRARY_TP AS PublishedLibrary ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN S_SCRL_User AS _CreateUser ON _CreateUser.Name = CurrentVersionLibrary.CreatedBy  -- association [1..1]
LEFT OUTER JOIN S_SCRL_User AS _ChangeUser ON _ChangeUser.Name = CurrentVersionLibrary.LastChangedBy  -- association [1..1]
LEFT OUTER JOIN S_SCRL_Publish_State AS _PublishState ON _PublishState.Code = CurrentVersionLibrary.PublishState AND _PublishState.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN p_scrl_library_transported AS _LifecycleStatus ON _LifecycleStatus.LibraryID = CurrentVersionLibrary.LibraryID  -- association [1]
LEFT OUTER JOIN P_SCRL_LBRY_RGSTRY_DRFT_AVAIL AS _DraftStatus ON _DraftStatus.LibraryID = CurrentVersionLibrary.LibraryID  -- association [1]
LEFT OUTER JOIN ATOV_REWORK_DEMAND AS _AtovReworkDemand ON _AtovReworkDemand.Item_Id = LibraryID AND _AtovReworkDemand.Item_Type = 'SCRL'  -- association [0..1]
-- UNION with additional select branch(es): I_SCRL_LIBRARY_TP
;