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.

4 data source(s) 15 fields

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
KEY objname DHCDC_RT_ObjStoragePointer objname
KEY acd_id dhcdc_rtcalcstat acd_id
KEY acp_id DHCDC_RT_ObjStoragePointer acp_id
KEY storage_ptr DHCDC_RT_ObjStoragePointer storage_ptr
KEY storage_id DHCDC_RT_ObjStorageStatistics storage_id
data_client dhcdc_rtcalcstat data_client
selstring dhcdc_rtcalcstat selstring
status_acp dhcdc_rtcalcstat status_acp
job_id dhcdc_rtcalcstat job_id
partition_id dhcdc_rtcalcstat partition_id
status_acd dhcdc_rtobjcalc status_acd
query dhcdc_rtobjcalc query
total_bytes DHCDC_RT_ObjStorageStatistics total_bytes
status DHCDC_RT_ObjStorageStatistics status 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Portion Information per Access Plan'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity dhcdc_rt_accessplanportion as select 
      from dhcdc_rtobjcalc as acd
      inner join dhcdc_rtcalcstat as acp
        on acp.acd_id = acd.acd_id
      inner join DHCDC_RT_ObjStoragePointer as ptr
          on acd.subscriber_id = ptr.subscriber_id
         and acd.objtype       = ptr.objtype
         and acd.objname       = ptr.objname
         and acp.acp_id        = ptr.acp_id
      inner join DHCDC_RT_ObjStorageStatistics as portn
          on ptr.storage_ptr = portn.storage_ptr
{
  key ptr.subscriber_id,
  key ptr.objtype,
  key ptr.objname,
  key acp.acd_id, 
  key ptr.acp_id,
  key ptr.storage_ptr,
  key portn.storage_id,
  acp.data_client,
  acp.selstring,
  acp.status_acp,
  acp.job_id,
  acp.partition_id,
  acd.status_acd,
  acd.query,
  portn.total_records,
  portn.total_bytes,
  portn.status,
  portn.status_timestamp
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DHCDC_RT_OBJSTORAGEPOINTER",
"DHCDC_RT_OBJSTORAGESTATISTICS",
"DHCDC_RTCALCSTAT",
"DHCDC_RTOBJCALC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More