DHADM_RDB_Overview

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_Overview.
-- 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_Overview AS
SELECT
  tab.objname AS ObjectName,
  tab.objtype AS ObjectType,
  objtypetext.Text AS ObjectTypeText,
  tab.name AS TableName,
  tab.buffer_id AS BufferId,
  tab.producer_id AS ProducerId,
  tab.producer_type AS ProducerType,
  prodtypetext.Text AS ProducerTypeText,
  tab.consumer_type AS ConsumerType,
  constypetext.Text AS ConsumerTypeText,
  tab.status AS Status,
  stattext.Text AS StatusText,
  tab.last_action_ts AS LastActionTs,
  tab.last_write_ts AS LastWriteTs,
  tab.phase AS Phase,
  phtext.Text AS PhaseText
FROM DHADM_RDB_BufferTables AS tab
LEFT OUTER JOIN DHADM_REC_ObjectTypeText AS objtypetext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_RDB_ProducerTypeText AS prodtypetext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_RDB_ConsumerTypeText AS constypetext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_RDB_BufferTableStatText AS stattext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_RDB_BufferPhase AS phtext ON /* join condition not captured in parsed metadata */
;