DHADM_SEARCH_ConsumersObj

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_SEARCH_ConsumersObj.
-- 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_SEARCH_ConsumersObj AS
SELECT
  sobj.subscriber_id AS SubscriberId,
  sobj.objname AS ObjectName,
  sobj.objtype AS ObjectType,
  sobj.subscriber_type AS SubscriberType,
  stext.Text AS SubscriberTypeText,
  otext.Text AS ObjectTypeText,
  sobj.push_pull AS PushPull,
  pp.Text AS PushPullText,
  sobj.process_option AS ProcessOption,
  pt.Text AS ProcessOptionText,
  sobj.use_data_buffer AS UsesBuffer,
  buf.buffer_table_name AS BufferTableName,
  buf.buffer_table_ext_status AS BufferTableStatus,
  bufsttxt.Text AS BufferTableStatusText,
  sobj.last_action_ts AS LastActionTS,
  phase.phase AS Phase,
  phasetext.Text AS PhaseText
FROM DHADM_REC_SubscriberObjects AS sobj
LEFT OUTER JOIN DHADM_REC_SubscriberTypeText AS stext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_REC_ObjectTypeText AS otext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_REC_PushPullText AS pp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_REC_ProcessOptCodeText AS pt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_REC_SubscriberBuffers AS buf ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_RDB_BufferTableStatText AS bufsttxt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_REC_SubscriberObjPhase AS phase ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_REC_PhaseText AS phasetext ON /* join condition not captured in parsed metadata */
;