I_SCRL_LIBRARY_TP

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 I_SCRL_LIBRARY_TP.
-- 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 I_SCRL_LIBRARY_TP AS
SELECT
  library_id AS LibraryID,
  version_number AS VersionNumber,
  Name,
  publish_state AS PublishState,
  original_language AS OriginalLanguage,
  original_release AS OriginalRelease,
  created_by AS CreatedBy,
  created_on AS CreatedOn,
  last_changed_by AS LastChangedBy,
  last_changed_on AS LastChangedOn,
  implementation_class AS ImplementationClass,
  cast ( last_changed_on as abap.char(40) ) AS ETag
FROM scrl_library
LEFT OUTER JOIN I_SCRL_METHOD_TP AS _Method ON _Method.LibraryID = LibraryID AND _Method.VersionNumber = VersionNumber  -- association [0..*]
LEFT OUTER JOIN I_SCRL_STRUCTURE_TP AS _Structure ON _Structure.LibraryID = LibraryID AND _Structure.VersionNumber = VersionNumber  -- association [0..*]
LEFT OUTER JOIN I_SCRL_TABLE_TP AS _Table ON _Table.LibraryID = LibraryID AND _Table.VersionNumber = VersionNumber  -- association [0..*]
LEFT OUTER JOIN I_SCRL_DATA_TP AS _Data ON _Data.LibraryID = LibraryID AND _Data.VersionNumber = VersionNumber  -- association [0..*]
;