DHADM_MON_PortionOverview

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_PortionOverview.
-- 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_PortionOverview AS
SELECT
  t1.acp_id AS AcpId,
  t1.subscriber_id AS SubscriberId,
  t1.objtype AS ObjectType,
  t1.objname AS ObjectName,
  t1.storage_ptr AS StoragePointer,
  t2.storage_id AS StorageId,
  cast(right(t2.storage_id, 6) as dhcdc_rt_acp_portion_id) AS PortionId,
  t2.total_records AS TotalRecords,
  t2.total_bytes AS TotalBytes,
  t2.status AS Status,
  p_text.Text AS StatusText,
  t2.status_timestamp AS StatusTimestamp,
  utcl_seconds_between(t2.transfer_start, t2.transfer_end) AS TransferTime,
  t2.transfer_start AS TransferStart,
  t2.transfer_end AS TransferEnd
FROM DHADM_MON_ObjStoragePointer AS t1
LEFT OUTER JOIN DHADM_MON_ObjStorageStatistics AS t2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_MON_PortionStatusText AS p_text ON /* join condition not captured in parsed metadata */
;