DHADM_RDB_PackagesOverview

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 DHADM_RDB_PackagesOverview.
-- 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 DHADM_RDB_PackagesOverview AS
SELECT
  pkg.buffer_id AS BufferId,
  pkg.package_id AS PackageId,
  pkg.status AS Status,
  sttext.Text AS StatusText,
  pkg.status_ts AS StatusTs,
  pkg.phase AS Phase,
  phtext.Text AS PhaseText,
  pkg.partition_id AS PartitionId
FROM DHADM_RDB_Packages AS pkg
LEFT OUTER JOIN DHADM_RDB_PackageStatusText AS sttext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_REC_PhaseText AS phtext ON /* join condition not captured in parsed metadata */
;