DHADM_MON_AccessPlanSummary

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_AccessPlanSummary.
-- 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_AccessPlanSummary AS
SELECT
  objinfo.subscriber_id AS SubscriberId,
  objinfo.objtype AS Objtype,
  objinfo.objname AS Objname,
  objinfo.max_delim_jobs AS MaxAcdJobs,
  objinfo.max_acp_jobs AS MaxAcpJobs,
  objinfo.max_acp_records AS MaxAcpRecords,
  objinfo.min_acp AS MinAcps,
  objinfo.max_block_size AS MaxBlockSizeBytes,
  objinfo.max_portion_rows AS MaxPortionRows,
  status.TablePartitons AS TablePartitons,
  status.CalculationStatus AS CalculationStatus,
  calcText.Text AS CalculationStatusText,
  status.TransferStatus AS TransferStatus,
  transfertext.Text AS TransferStatusText,
  status.AccessPlanTotal AS AccessPlanTotal,
  status.AccessPlanCalcuated AS AccessPlanCalcuated,
  status.AccessPlanFailed AS AccessPlanFailed,
  status.AccessPlanInTransfer AS AccessPlanInTransfer,
  status.AccessPlanTransferred AS AccessPlanTransferred,
  status.CalculationInSec AS CalculationInSec,
  status.TransferInSec AS TransferInSec,
  status.TotalRuntimeInSec AS TotalRuntimeInSec,
  status.CalculatedRows AS CalculatedRows,
  status.CalculatedBytes AS CalculatedBytes,
  status.PortionsTotal AS PortionsTotal,
  status.PortionsFinished AS PortionsFinished,
  status.PortionsInTransfer AS PortionsInTransfer,
  status.PortionsError AS PortionsError,
  objfilter.expression AS Filter,
  readTypeText.Text AS ReadingTypeText
FROM dhcdc_rtobjcalc AS objinfo
LEFT OUTER JOIN dhcdc_objfilter AS objfilter ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_MON_TransferStatusText AS transfertext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_MON_ACPCalcStatusText AS calcText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHADM_MON_READING_TYPE AS readTypeText ON /* join condition not captured in parsed metadata */
;