DHADM_MON_Observer_Job

DDL: DHADM_MON_OBSERVER_JOB Type: view_entity Package: SADI_ADM_MON

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 1 data source (tbtco) and exposes 13 fields with key field JobCount. Part of development package SADI_ADM_MON.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
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 (13)

KeyFieldSource TableSource FieldDescription
KEY JobCount tbtco jobcount
JobName tbtco jobname
JobClient tbtco authckman
JobStartDate tbtco strtdate
JobStartTime tbtco strttime
JobEndDate tbtco enddate
JobEndTime tbtco endtime
JobStatus tbtco status
JobStatusText s Text
reaxserverendasJobServerName
JobWpNumber tbtco wpnumber
AppltabName c appltab_name
MstrLogtabName c 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 to one join DHADM_MON_JobStatusText as s on s.Language = $session.system_language
                                                       and t.status = s.JobStatus 
    left outer to one join dhcdc_observeex  as o        on t.jobcount = o.jobcount 
    left outer to one 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,
      t.enddate          as JobEndDate,
      t.endtime          as JobEndTime,
      t.status           as JobStatus,
      s.Text             as JobStatusText,
      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'

Learn More