DHADM_MON_AccessPlanSummary

DDL: DHADM_MON_ACCESSPLANSUMMARY Type: view_entity Package: SADI_ADM_MON

Data for access plan summary tab

DHADM_MON_AccessPlanSummary is a CDS View that provides data about "Data for access plan summary tab" in SAP S/4HANA. It reads from 1 data source (dhcdc_rtobjcalc) and exposes 30 fields with key fields SubscriberId, Objtype, Objname. Part of development package SADI_ADM_MON.

1 data source(s) 30 fields

Data Sources (1)

SourceAliasJoin Type
dhcdc_rtobjcalc objinfo from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Data for access plan summary tab view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY SubscriberId dhcdc_rtobjcalc subscriber_id
KEY Objtype dhcdc_rtobjcalc objtype
KEY Objname dhcdc_rtobjcalc objname
MaxAcdJobs dhcdc_rtobjcalc max_delim_jobs
MaxAcpJobs dhcdc_rtobjcalc max_acp_jobs
MaxAcpRecords dhcdc_rtobjcalc max_acp_records
MinAcps dhcdc_rtobjcalc min_acp
MaxBlockSizeBytes dhcdc_rtobjcalc max_block_size
MaxPortionRows dhcdc_rtobjcalc max_portion_rows
TablePartitons status TablePartitons
CalculationStatus status CalculationStatus
CalculationStatusText calcText Text
TransferStatus status TransferStatus
TransferStatusText transfertext Text
AccessPlanTotal status AccessPlanTotal
AccessPlanCalcuated status AccessPlanCalcuated
AccessPlanFailed status AccessPlanFailed
AccessPlanInTransfer status AccessPlanInTransfer
AccessPlanTransferred status AccessPlanTransferred
CalculationInSec status CalculationInSec
TransferInSec status TransferInSec
TotalRuntimeInSec status TotalRuntimeInSec
CalculatedRows status CalculatedRows
CalculatedBytes status CalculatedBytes
PortionsTotal status PortionsTotal
PortionsFinished status PortionsFinished
PortionsInTransfer status PortionsInTransfer
PortionsError status PortionsError
Filter objfilter expression
ReadingTypeText readTypeText Text 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Data for access plan summary tab'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity DHADM_MON_AccessPlanSummary
  as select from           dhcdc_rtobjcalc                as objinfo
    left outer to one join DHADM_MON_AcsPlanSummaryStatus as status       on status.acd_id = objinfo.acd_id
    left outer to one join dhcdc_objfilter                as objfilter    on  objfilter.subscriber_id = objinfo.subscriber_id
                                                                          and objfilter.objname       = objinfo.objname
                                                                          and objfilter.objtype       = objinfo.objtype
    left outer to one join DHADM_MON_TransferStatusText   as transfertext on  status.TransferStatus = transfertext.Status
                                                                          and transfertext.Language = $session.system_language
    left outer to one join DHADM_MON_ACPCalcStatusText    as calcText     on  status.CalculationStatus = calcText.Status
                                                                          and calcText.Language        = $session.system_language
    left outer to one join dhcdc_objperfstg               as perf         on  perf.subscriber_id = objinfo.subscriber_id
                                                                          and perf.objname       = objinfo.objname
                                                                          and perf.objtype       = objinfo.objtype
    left outer to one join DHADM_MON_READING_TYPE         as readTypeText on  readTypeText.Status   = perf.calculation_mode
                                                                          and readTypeText.Language = $session.system_language
{
  key objinfo.subscriber_id    as SubscriberId,
  key objinfo.objtype          as Objtype,
  key objinfo.objname          as Objname,
      objinfo.max_delim_jobs   as MaxAcdJobs,
      objinfo.max_acp_jobs     as MaxAcpJobs,
      objinfo.max_acp_records  as MaxAcpRecords,
      objinfo.min_acp          as MinAcps,
      objinfo.max_block_size   as MaxBlockSizeBytes,
      objinfo.max_portion_rows as MaxPortionRows,
      status.TablePartitons,
      status.CalculationStatus,
      calcText.Text            as CalculationStatusText,
      status.TransferStatus,
      transfertext.Text        as TransferStatusText,
      status.AccessPlanTotal,
      status.AccessPlanCalcuated,
      status.AccessPlanFailed,
      status.AccessPlanInTransfer,
      status.AccessPlanTransferred,
      status.CalculationInSec,
      status.TransferInSec,
      status.TotalRuntimeInSec,
      status.CalculatedRows,
      status.CalculatedBytes,
      status.PortionsTotal,
      status.PortionsFinished,
      status.PortionsInTransfer,
      status.PortionsError,
      objfilter.expression     as Filter,
      perf.calculation_mode,
      readTypeText.Text        as ReadingTypeText
}

Learn More