P_RU_LastSubmittedRun

DDL: P_RU_LASTSUBMITTEDRUN SQL: PRULASTSUBMRUN Type: view CONSUMPTION

P_RU_LastSubmittedRun is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_StRpRepRun, I_StRpTaskDetails) and exposes 6 fields with key fields StatryRptCategory, StatryRptgEntity, StatryRptTaskUUID.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_StRpRepRun I_StRpRepRun from
I_StRpTaskDetails I_StRpTaskDetails inner

Annotations (5)

NameValueLevelField
VDM.private true view
AbapCatalog.sqlViewName PRULASTSUBMRUN view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY StatryRptCategory I_StRpRepRun StatryRptCategory
KEY StatryRptgEntity I_StRpRepRun StatryRptgEntity
KEY StatryRptTaskUUID I_StRpRepRun StatryRptTaskUUID
ReportingYear I_StRpTaskDetails ReportingYear
StatryRptTaskPeriod I_StRpTaskDetails StatryRptTaskPeriod
maxSubmittedRun 
@VDM.private: true
@AbapCatalog.sqlViewName: 'PRULASTSUBMRUN'
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_RU_LastSubmittedRun
  as select from I_StRpRepRun

    inner join   I_StRpTaskDetails on I_StRpRepRun.StatryRptTaskUUID = I_StRpTaskDetails.StatryRptTaskUUID

{
  key I_StRpRepRun.StatryRptCategory,
  key I_StRpRepRun.StatryRptgEntity,
  key I_StRpRepRun.StatryRptTaskUUID,
      I_StRpTaskDetails.ReportingYear,
      I_StRpTaskDetails.StatryRptTaskPeriod,
      max(StatryRptRunID) as maxSubmittedRun
}
where
  (
       StatryRptRunType   = 'STAND'
    or StatryRptRunType   = 'CORR'
  )
  and(
       StatryRptRunStatus = 'SOK'
    or StatryRptRunStatus = 'DNR'
  )

group by
  I_StRpRepRun.StatryRptCategory,
  I_StRpRepRun.StatryRptgEntity,
  I_StRpRepRun.StatryRptTaskUUID,
  I_StRpTaskDetails.ReportingYear,
  I_StRpTaskDetails.StatryRptTaskPeriod
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STRPREPRUN",
"I_STRPTASKDETAILS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More