DHADM_MON_ACCESSPLANDETAILBASE
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| DHADM_MON_AccessPlanDetail | view_entity | from | Access Plans Details | |
| DHADM_MON_CalcAccessPlanStatus | view_entity | from | Access plan status calculation |
Fields (23)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA