dhcdc_rt_accessplanportion

DDL: DHCDC_RT_ACCESSPLANPORTION Type: view_entity

Portion Information per Access Plan

dhcdc_rt_accessplanportion is a CDS View that provides data about "Portion Information per Access Plan" in SAP S/4HANA. It reads from 4 data sources (dhcdc_rtobjcalc, dhcdc_rtcalcstat, DHCDC_RT_ObjStorageStatistics, DHCDC_RT_ObjStoragePointer) and exposes 15 fields with key fields objtype, objname, acd_id, acp_id, storage_ptr.

Data Sources (4)

SourceAliasJoin Type
dhcdc_rtobjcalc acd from
dhcdc_rtcalcstat acp inner
DHCDC_RT_ObjStorageStatistics portn inner
DHCDC_RT_ObjStoragePointer ptr inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Portion Information per Access Plan view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY objtype DHCDC_RT_ObjStoragePointer objtype Translation OType
KEY objname DHCDC_RT_ObjStoragePointer objname Table Name
KEY acd_id dhcdc_rtcalcstat acd_id Access Plan Head. ID
KEY acp_id DHCDC_RT_ObjStoragePointer acp_id Access Plan ID
KEY storage_ptr DHCDC_RT_ObjStoragePointer storage_ptr RT Storage Pointer
KEY storage_id DHCDC_RT_ObjStorageStatistics storage_id Storage ID
data_client dhcdc_rtcalcstat data_client Client
selstring dhcdc_rtcalcstat selstring Selection
status_acp dhcdc_rtcalcstat status_acp Job Status
job_id dhcdc_rtcalcstat job_id Package ID
partition_id dhcdc_rtcalcstat partition_id UUID
status_acd dhcdc_rtobjcalc status_acd Job Status
query dhcdc_rtobjcalc query Condition
total_bytes DHCDC_RT_ObjStorageStatistics total_bytes INT4
status DHCDC_RT_ObjStorageStatistics status Workflow Status

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 dhcdc_rt_accessplanportion.
-- 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 dhcdc_rt_accessplanportion AS
SELECT
  ptr.objtype AS objtype,
  ptr.objname AS objname,
  acp.acd_id AS acd_id,
  ptr.acp_id AS acp_id,
  ptr.storage_ptr AS storage_ptr,
  portn.storage_id AS storage_id,
  acp.data_client AS data_client,
  acp.selstring AS selstring,
  acp.status_acp AS status_acp,
  acp.job_id AS job_id,
  acp.partition_id AS partition_id,
  acd.status_acd AS status_acd,
  acd.query AS query,
  portn.total_bytes AS total_bytes,
  portn.status AS status
FROM dhcdc_rtobjcalc AS acd
INNER JOIN dhcdc_rtcalcstat AS acp ON /* join condition not captured in parsed metadata */
INNER JOIN DHCDC_RT_ObjStoragePointer AS ptr ON /* join condition not captured in parsed metadata */
INNER JOIN DHCDC_RT_ObjStorageStatistics AS portn ON /* join condition not captured in parsed metadata */
;