P_SLT_MaxMasterJobReleaseDate

DDL: P_SLT_MAXMASTERJOBRELEASEDATE SQL: PSLTMAXMJBRELDAT Type: view BASIC

P_SLT_MaxMasterJobReleaseDate is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (tbtco) and exposes 2 fields with key field ReplicationMasterJobName.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
tbtco tbtco from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PSLTMAXMJBRELDAT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ReplicationMasterJobName jobname
RplctnMasterJobReleaseDate 
@AbapCatalog.sqlViewName: 'PSLTMAXMJBRELDAT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM: {
    private: true,
    viewType: #BASIC
}

@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_SLT_MaxMasterJobReleaseDate
  as select from tbtco
{

  key jobname         as ReplicationMasterJobName,
      max(reldate)    as RplctnMasterJobReleaseDate

}
where
  jobname = '/1LT/IUC_REP_MSTR'
group by
  jobname
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TBTCO"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More