DHCDC_RT_AccessPlanDetailBase

DDL: DHCDC_RT_ACCESSPLANDETAILBASE Type: view_entity
8 Fields 3 Data Sources

Access Plan Details

DHCDC_RT_AccessPlanDetailBase is a CDS View that provides data about "Access Plan Details" in SAP S/4HANA. It reads from 3 data sources (dhcdc_rtacdprttn, dhcdc_rtcalcstat, DHCDC_RT_PortionInformation) and exposes 8 fields with key fields objname, objtype, acd_id, partition_id, acp_id.

Data Sources (3)

SourceAliasJoin Type
dhcdc_rtacdprttn acd from
dhcdc_rtcalcstat acp left_outer
DHCDC_RT_PortionInformation t1 left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Access Plan Details view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY objname objinfo objname Table Name
KEY objtype objinfo objtype Translation OType
KEY acd_id dhcdc_rtacdprttn acd_id Access Plan Head. ID
KEY partition_id dhcdc_rtacdprttn partition_id UUID
KEY acp_id dhcdc_rtcalcstat acp_id Access Plan ID
status_acd dhcdc_rtacdprttn status_acd Job Status
status_acp dhcdc_rtcalcstat status_acp Job Status
portions DHCDC_RT_PortionInformation portions_count

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_AccessPlanDetailBase.
-- 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_AccessPlanDetailBase AS
SELECT
  objinfo.objname AS objname,
  objinfo.objtype AS objtype,
  acd.acd_id AS acd_id,
  acd.partition_id AS partition_id,
  acp.acp_id AS acp_id,
  acd.status_acd AS status_acd,
  acp.status_acp AS status_acp,
  t1.portions_count AS portions
FROM dhcdc_rtacdprttn AS acd
LEFT OUTER JOIN dhcdc_rtcalcstat AS acp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DHCDC_RT_PortionInformation AS t1 ON /* join condition not captured in parsed metadata */
;

Learn More