DHADM_MON_Observer_Job

DDL: DHADM_MON_OBSERVER_JOB Type: view_entity

Observer Queue View Entity

DHADM_MON_Observer_Job is a CDS View that provides data about "Observer Queue View Entity" in SAP S/4HANA. It reads from 3 data sources (dhcdc_reccontrol, dhcdc_observeex, tbtco) and exposes 9 fields with key field JobCount.

3 data source(s) 9 fields

Data Sources (3)

SourceAliasJoin Type
dhcdc_reccontrol c left_outer
dhcdc_observeex o left_outer
tbtco t from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Observer Queue View Entity view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY JobCount tbtco jobcount
JobName tbtco jobname
JobClient tbtco authckman
JobStartDate tbtco strtdate
JobStartTime tbtco strttime
reaxserverendasJobServerName
JobWpNumber tbtco wpnumber
AppltabName dhcdc_reccontrol appltab_name
MstrLogtabName dhcdc_reccontrol mstr_logtab_name 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Observer Queue View Entity'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}

define view entity DHADM_MON_Observer_Job
  as select from    tbtco            as t
    left outer join dhcdc_observeex  as o on t.jobcount = o.jobcount
    left outer join dhcdc_reccontrol as c on o.mstr_logtab_name = c.mstr_logtab_name
{
  key t.jobcount         as JobCount,
      t.jobname          as JobName,
      t.authckman        as JobClient,
      t.strtdate         as JobStartDate,
      t.strttime         as JobStartTime,
      case when t.execserver <> '' then t.execserver
        else t.reaxserver
      end                as JobServerName,
      t.wpnumber         as JobWpNumber,
      c.appltab_name     as AppltabName,
      c.mstr_logtab_name as MstrLogtabName
}
where
      t.jobname = '/1DH/OBSERVE_LOGTAB'
  and t.status  = 'R'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DHCDC_OBSERVEEX",
"DHCDC_RECCONTROL",
"TBTCO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More