DHADM_MON_AccessPlanOvwBase

DDL: DHADM_MON_ACCESSPLANOVWBASE Type: view_entity
8 Fields 1 Data Sources

Access Plan Calculation Overview Base

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

Data Sources (1)

SourceAliasJoin Type
dhcdc_rtobjcalc objinfo from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Access Plan Calculation Overview Base 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 SubscriberId dhcdc_rtobjcalc subscriber_id Subscriber ID
KEY SubscriberType subsreg type Worklist Type
KEY Objtype dhcdc_rtobjcalc objtype Translation OType
KEY Objname dhcdc_rtobjcalc objname Table Name
charXthenBelsePendasPushPull
ProcessOption osubsreg process_option ProcessOption
TransferStatus status TransferStatus
CalculationStatus status CalculationStatus SVT Calculation 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 DHADM_MON_AccessPlanOvwBase.
-- 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_AccessPlanOvwBase AS
SELECT
  objinfo.subscriber_id AS SubscriberId,
  subsreg.type AS SubscriberType,
  objinfo.objtype AS Objtype,
  objinfo.objname AS Objname,
  case when subsreg.type = 'ODP' or subsreg.use_data_buffer = abap.char'X' then 'B' else 'P' end as PushPull AS charXthenBelsePendasPushPull,
  osubsreg.process_option AS ProcessOption,
  status.TransferStatus AS TransferStatus,
  status.CalculationStatus AS CalculationStatus
FROM dhcdc_rtobjcalc AS objinfo
;

Learn More