DHADM_MON_ACCESSPLANDETAILBASE

CDS View

Access Plans Details Base

DHADM_MON_ACCESSPLANDETAILBASE is a CDS View in S/4HANA. Access Plans Details Base. It contains 23 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
DHADM_MON_AccessPlanDetail view_entity from Access Plans Details
DHADM_MON_CalcAccessPlanStatus view_entity from Access plan status calculation

Fields (23)

KeyField CDS FieldsUsed in Views
KEY acd_id acd_id,AcdId 2
KEY acp_id AcpId 1
KEY partition_id PartitionId 1
acd_job_end ACDJobEnd 1
acd_job_start ACDJobStart 1
acp_job_end ACPJobEnd 1
acp_job_start ACPJobStart 1
calc_time_acd ACDCalculationTimeInSec 1
calc_time_acp ACPCalculationTimeInSec 1
data_client DataClient 1
filter Filter 1
portion_error PortionsErrorCount 1
portion_finished PortionsFinishedCount 1
portion_in_process PortionsInProcessCount 1
portions PortionsCount 1
process_status_acp ProcessStatusAcp 1
range_condition RangeCondition 1
selstring SelectionString 1
status_acd StatusAcd 1
status_acp StatusAcp 1
total_bytes TotalBytes 1
total_rows TotalRows 1
transfer_time ACPTransferTimeInSec 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Access Plans Details Base
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DHADM_MON_ACCESSPLANDETAILBASE (
    ACD_ID,
    ACP_ID,
    PARTITION_ID,
    ACD_JOB_END,
    ACD_JOB_START,
    ACP_JOB_END,
    ACP_JOB_START,
    CALC_TIME_ACD,
    CALC_TIME_ACP,
    DATA_CLIENT,
    FILTER,
    PORTION_ERROR,
    PORTION_FINISHED,
    PORTION_IN_PROCESS,
    PORTIONS,
    PROCESS_STATUS_ACP,
    RANGE_CONDITION,
    SELSTRING,
    STATUS_ACD,
    STATUS_ACP,
    TOTAL_BYTES,
    TOTAL_ROWS,
    TRANSFER_TIME,
    PRIMARY KEY (ACD_ID, ACP_ID, PARTITION_ID)
);