DHADM_MON_AccessPlanJobsBase

DDL: DHADM_MON_ACCESSPLANJOBSBASE Type: view_entity

Access Plan Jobs

DHADM_MON_AccessPlanJobsBase is a CDS View that provides data about "Access Plan Jobs" in SAP S/4HANA. It reads from 9 data sources and exposes 27 fields with key fields SubscriberId, Objtype, Objname, AcdId, PartitionId.

9 data source(s) 27 fields

Data Sources (9)

SourceAliasJoin Type
dhcdc_rtacdprttn acd from
dhcdc_rtacdprttn acd union_all
dhcdc_rtcalcstat acp inner
dhbas_jobcnt jobcnt inner
dhbas_jobcnt jobcnt inner
dhcdc_rtobjcalc objinfo inner
dhcdc_rtobjcalc objinfo inner
tbtco tbtco left_outer
tbtco tbtco left_outer

Annotations (6)

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

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY SubscriberId dhcdc_rtobjcalc subscriber_id
KEY Objtype dhcdc_rtobjcalc objtype
KEY Objname dhcdc_rtobjcalc objname
KEY AcdId dhcdc_rtacdprttn acd_id
KEY PartitionId dhcdc_rtacdprttn partition_id
KEY AcpId
JobId dhcdc_rtacdprttn job_id
JobCount dhbas_jobcnt job_count
JobName dhbas_jobcnt job_name
Status tbtco status
StartDate tbtco strtdate
StartTime tbtco strttime
EndDate tbtco enddate
subscriber_idasSubscriberId
KEY Objtype dhcdc_rtobjcalc objtype
KEY Objname dhcdc_rtobjcalc objname
KEY AcdId dhcdc_rtacdprttn acd_id
KEY PartitionId dhcdc_rtacdprttn partition_id
KEY AcpId dhcdc_rtcalcstat acp_id
JobId dhcdc_rtcalcstat job_id
JobCount dhbas_jobcnt job_count
JobName dhbas_jobcnt job_name
Status tbtco status
StartDate tbtco strtdate
StartTime tbtco strttime
EndDate tbtco enddate
EndTime tbtco endtime 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Access Plan Jobs'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity DHADM_MON_AccessPlanJobsBase as select from
    dhcdc_rtacdprttn as acd
  inner join
    dhcdc_rtobjcalc  as objinfo on  objinfo.acd_id   = acd.acd_id
  inner join
    dhbas_jobcnt     as jobcnt  on  jobcnt.job_id    = acd.job_id
  left outer join
    tbtco            as tbtco   on  tbtco.jobname     = jobcnt.job_name
                                and tbtco.jobcount    = jobcnt.job_count
{
  key objinfo.subscriber_id    as SubscriberId,
  key objinfo.objtype          as Objtype,
  key objinfo.objname          as Objname,
  key acd.acd_id               as AcdId,
  key acd.partition_id         as PartitionId,
  key cast( '00000' as dhcdc_rt_access_plan_id preserving type ) as AcpId,
  acd.job_id                   as JobId,
  jobcnt.job_count             as JobCount,
  jobcnt.job_name              as JobName,
  tbtco.status                 as Status,
  tbtco.strtdate               as StartDate,
  tbtco.strttime               as StartTime,
  tbtco.enddate                as EndDate,
  tbtco.endtime                as EndTime
}
union all select from
    dhcdc_rtacdprttn as acd
  inner join
    dhcdc_rtobjcalc  as objinfo on  objinfo.acd_id   = acd.acd_id
  inner join
    dhcdc_rtcalcstat as acp     on  acp.acd_id       = acd.acd_id
                                and acp.partition_id = acd.partition_id
  inner join
    dhbas_jobcnt     as jobcnt  on  jobcnt.job_id    = acp.job_id
  left outer join
    tbtco            as tbtco   on  tbtco.jobname     = jobcnt.job_name
                                and tbtco.jobcount    = jobcnt.job_count
{
  key objinfo.subscriber_id    as SubscriberId,
  key objinfo.objtype          as Objtype,
  key objinfo.objname          as Objname,
  key acd.acd_id               as AcdId,
  key acd.partition_id         as PartitionId,
  key acp.acp_id               as AcpId,
  acp.job_id                   as JobId,
  jobcnt.job_count             as JobCount,
  jobcnt.job_name              as JobName,
  tbtco.status                 as Status,
  tbtco.strtdate               as StartDate,
  tbtco.strttime               as StartTime,
  tbtco.enddate                as EndDate,
  tbtco.endtime                as EndTime
}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DHBAS_JOBCNT",
"DHCDC_RTACDPRTTN",
"DHCDC_RTCALCSTAT",
"DHCDC_RTOBJCALC",
"TBTCO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More