DHADM_MON_AccessPlanDetail

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_AccessPlanDetail.
-- 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_AccessPlanDetail AS
SELECT
  acplan.acd_id AS AcdId,
  acplan.partition_id AS PartitionId,
  acplan.acp_id AS AcpId,
  acplan.status_acd AS StatusAcd,
  acd_text.Text AS StatusAcdText,
  acplan.status_acp AS StatusAcp,
  case when acplan.status_acp = '' then '' else acp_text.Text end as StatusAcpText AS TextendasStatusAcpText,
  acplan.process_status_acp AS ProcessStatusAcp,
  acp_calctext.Text AS ProcessCalcText,
  acplan.data_client AS DataClient,
  acplan.filter AS Filter,
  acplan.range_condition AS RangeCondition,
  acplan.selstring AS SelectionString,
  acplan.calc_time_acd AS ACDCalculationTimeInSec,
  acplan.calc_time_acp AS ACPCalculationTimeInSec,
  acplan.transfer_time AS ACPTransferTimeInSec,
  acplan.acd_job_start AS ACDJobStart,
  acplan.acd_job_end AS ACDJobEnd,
  acplan.acp_job_start AS ACPJobStart,
  acplan.acp_job_end AS ACPJobEnd,
  acplan.portions AS PortionsCount,
  acplan.total_rows AS TotalRows,
  acplan.total_bytes AS TotalBytes,
  acplan.portion_finished AS PortionsFinishedCount,
  acplan.portion_in_process AS PortionsInProcessCount,
  acplan.portion_error AS PortionsErrorCount
FROM DHADM_MON_AccessPlanDetailBase AS acplan
;