DHADM_MON_AccessPlanOverview

DDL: DHADM_MON_ACCESSPLANOVERVIEW Type: view_entity
14 Fields 1 Data Sources

Access Plan Calculation Overview

DHADM_MON_AccessPlanOverview is a CDS View that provides data about "Access Plan Calculation Overview" in SAP S/4HANA. It reads from 1 data source (DHADM_MON_AccessPlanOvwBase) and exposes 14 fields with key fields SubscriberId, SubscriberType, ObjectType, ObjectName.

Data Sources (1)

SourceAliasJoin Type
DHADM_MON_AccessPlanOvwBase ap from

Annotations (6)

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

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SubscriberId DHADM_MON_AccessPlanOvwBase SubscriberId Subscriber ID
KEY SubscriberType DHADM_MON_AccessPlanOvwBase SubscriberType Worklist Type
KEY ObjectType DHADM_MON_AccessPlanOvwBase Objtype Translation OType
KEY ObjectName DHADM_MON_AccessPlanOvwBase Objname Table Name
SubscriberTypeText substypeText Text User Group
ObjectTypeText objtypeText Text User Group
PushPull DHADM_MON_AccessPlanOvwBase PushPull
PushPullText pushpullText Text User Group
ProcessOption DHADM_MON_AccessPlanOvwBase ProcessOption ProcessOption
ProcessOptionText procoptText Text User Group
CalculationStatus DHADM_MON_AccessPlanOvwBase CalculationStatus SVT Calculation Status
CalculationStatusText calcText Text User Group
TransferStatus DHADM_MON_AccessPlanOvwBase TransferStatus
TransferStatusText transfertext Text User Group

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_AccessPlanOverview.
-- 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_AccessPlanOverview AS
SELECT
  ap.SubscriberId AS SubscriberId,
  ap.SubscriberType AS SubscriberType,
  ap.Objtype AS ObjectType,
  ap.Objname AS ObjectName,
  substypeText.Text AS SubscriberTypeText,
  objtypeText.Text AS ObjectTypeText,
  ap.PushPull AS PushPull,
  pushpullText.Text AS PushPullText,
  ap.ProcessOption AS ProcessOption,
  procoptText.Text AS ProcessOptionText,
  ap.CalculationStatus AS CalculationStatus,
  calcText.Text AS CalculationStatusText,
  ap.TransferStatus AS TransferStatus,
  transfertext.Text AS TransferStatusText
FROM DHADM_MON_AccessPlanOvwBase AS ap
;

Learn More