I_CAMassRunJob

DDL: I_CAMASSRUNJOB Type: view_entity COMPOSITE Package: FKK_MASSACT

Mass Run Job Overview

I_CAMassRunJob is a Composite CDS View that provides data about "Mass Run Job Overview" in SAP S/4HANA. It reads from 2 data sources (I_CAMassRunIntvlDistrJob, tbtco) and exposes 14 fields with key fields ApplicationJobName, BackgroundJob. Part of development package FKK_MASSACT.

Data Sources (2)

SourceAliasJoin Type
I_CAMassRunIntvlDistrJob _Activity inner
tbtco _ApplicationJob from

Annotations (7)

NameValueLevelField
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Mass Run Job Overview view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ApplicationJobName tbtco jobname
KEY BackgroundJob tbtco jobcount
ABAPProgramName tbtco intreport
ScheduledStartDate tbtco sdlstrtdt
ScheduledStartTime tbtco sdlstrttm
ScheduledByUser tbtco sdluname
ProcessingStartDate tbtco strtdate
ProcessingStartTime tbtco strttime
ProcessingEndDate tbtco enddate
ProcessingEndTime tbtco endtime
JobStatusValue tbtco status
CAWorkProcessNumber tbtco wpnumber
CATargetSystem tbtco btcsysreax
CAServerName tbtco reaxserver
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Mass Run Job Overview'
define view entity I_CAMassRunJob

  as select from tbtco                    as _ApplicationJob
    inner join   I_CAMassRunIntvlDistrJob as _Activity on  _Activity.BackgroundJobName = _ApplicationJob.jobname
                                                       and _Activity.BackgroundJob     = _ApplicationJob.jobcount
{
  key _ApplicationJob.jobname    as ApplicationJobName,
  key _ApplicationJob.jobcount   as BackgroundJob,
      _ApplicationJob.intreport  as ABAPProgramName,
      _ApplicationJob.sdlstrtdt  as ScheduledStartDate,
      _ApplicationJob.sdlstrttm  as ScheduledStartTime,
      _ApplicationJob.sdluname   as ScheduledByUser,
      _ApplicationJob.strtdate   as ProcessingStartDate,
      _ApplicationJob.strttime   as ProcessingStartTime,
      _ApplicationJob.enddate    as ProcessingEndDate,
      _ApplicationJob.endtime    as ProcessingEndTime,
      _ApplicationJob.status     as JobStatusValue,
      _ApplicationJob.wpnumber   as CAWorkProcessNumber,
      _ApplicationJob.btcsysreax as CATargetSystem,
      _ApplicationJob.reaxserver as CAServerName
}