I_SLT_MasterJobStatus

DDL: I_SLT_MASTERJOBSTATUS SQL: ISLTMSTRJOBSTS Type: view BASIC

SLT Master Job Status

I_SLT_MasterJobStatus is a Basic CDS View that provides data about "SLT Master Job Status" in SAP S/4HANA. It reads from 1 data source (tbtco) and exposes 3 fields with key field ReplicationMasterJobName. It has 1 association to related views.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
tbtco tbtco from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_SLT_MasterJobStatusText _RplctnMstrJobStatusText tbtco.status = _RplctnMstrJobStatusText.ReplicationMasterJobStatus

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ISLTMSTRJOBSTS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label SLT Master Job Status view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ReplicationMasterJobName tbtco jobname
ReplicationMasterJobStatus tbtco status
_RplctnMstrJobStatusText _RplctnMstrJobStatusText 
@AbapCatalog.sqlViewName: 'ISLTMSTRJOBSTS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'SLT Master Job Status'
@ObjectModel.usageType: {
    serviceQuality: #C,
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L
}
@VDM.viewType: #BASIC

@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_SLT_MasterJobStatus
  as select from tbtco
    join         P_SLT_MaxMasterJobReleaseTime as _LastJobReleaseTime on  tbtco.jobname = _LastJobReleaseTime.ReplicationMasterJobName
                                                                      and tbtco.reldate = _LastJobReleaseTime.RplctnMasterJobReleaseDate
                                                                      and tbtco.reltime = _LastJobReleaseTime.RplctnMasterJobReleaseTime

  association [0..*] to I_SLT_MasterJobStatusText as _RplctnMstrJobStatusText on tbtco.status = _RplctnMstrJobStatusText.ReplicationMasterJobStatus
{

  key tbtco.jobname       as ReplicationMasterJobName,
      @ObjectModel.text.association: '_RplctnMstrJobStatusText'
      tbtco.status        as ReplicationMasterJobStatus,

      _RplctnMstrJobStatusText
}
where
  tbtco.jobname = '/1LT/IUC_REP_MSTR'

Learn More