DHADM_MON_SubscriberOverview

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_MON_SubscriberOverview.
-- 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_MON_SubscriberOverview AS
SELECT
  subsobj.subscriber_id AS SubscriberId,
  subsobj.subscriber_type AS SubscriberType,
  substypetext.Text AS SubscriberTypeText,
  subsobj.objname AS ObjectName,
  subsobj.objtype AS ObjectType,
  objtypetext.Text AS ObjectTypeText,
  subsobj.client_mode AS ClientMode,
  clientmodetext.Text AS ClientModeText,
  subsobj.sysid AS SystemId,
  sqlreg.sql_service_name AS SQLServiceName,
  sqlreg.exposed_alias_raw AS SQLServiceAliasName,
  subsobj.push_pull AS PushPull,
  pushpulltext.Text AS PushPullText,
  subsobj.push_target_type AS PushTargetType,
  pushtypetext.Text AS PushTargetTypeText,
  subsobj.process_option AS ProcessOption,
  procopttext.Text AS ProcessOptionText,
  phase.phase AS Phase,
  phasetext.Text AS PhaseText,
  buf.buffer_table_name AS BufferTableName,
  buf.buffer_table_ext_status AS BufferTableStatus,
  bufsttxt.Text AS BufferTableStatusText,
  subsobj.last_action_ts AS LastActionTs,
  subsobj.retention_in_days AS RetentionInDays,
  subsobj.archiving_enabled AS ArchivingEnabled,
  subsobj.deleted AS Deleted,
  perfstg.MaxAccessPlanJobs AS MaxAccessPlanJobs,
  perfstg.PrioCode AS PrioCode,
  perfstg.PrioCodeText AS PrioCodeText,
  perfstg.ReplParlznMode AS ReplParlznMode,
  perfstg.ReplParlznModeText AS ReplParlznModeText,
  perfstg.MaxRecdPortnRepl AS MaxRecdPortnRepl,
  cast( perfstg.Cdc_Hints_Upsert as abap.char(1333) ) AS Cdc_Hints_Upsert,
  cast( perfstg.Cdc_Hints_Delete as abap.char(1333) ) AS Cdc_Hints_Delete
FROM DHADM_REC_SubscriberObjects AS subsobj
LEFT OUTER JOIN DHADM_REC_SubscriberTypeText AS substypetext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_REC_ObjectTypeText AS objtypetext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_REC_ClientModeText AS clientmodetext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_REC_PushPullText AS pushpulltext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_REC_PushTargetTypeText AS pushtypetext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_REC_ProcessOptCodeText AS procopttext 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 */
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_SQLServiceObjects AS sqlreg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_MON_ObjectPerformanceStg AS perfstg ON /* join condition not captured in parsed metadata */
;