P_RU_StRpRepRunTask

DDL: P_RU_STRPREPRUNTASK SQL: PRUSTRPRTSK Type: view COMPOSITE

P_RU_StRpRepRunTask is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_StRpTaskDetails) and exposes 15 fields with key fields StatryRptTaskUUID, StatryRptRunUUID.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_StRpTaskDetails I_StRpTaskDetails from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PRUSTRPRTSK view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY StatryRptTaskUUID I_StRpTaskDetails StatryRptTaskUUID
KEY StatryRptRunUUID I_StRpRepRun StatryRptRunUUID
StatryRptgEntity I_StRpTaskDetails StatryRptgEntity
StatryRptCategory I_StRpTaskDetails StatryRptCategory
StatryRptTaskPeriod I_StRpTaskDetails StatryRptTaskPeriod
Country I_StRpTaskDetails Country
StatryRptTaskDueDate I_StRpTaskDetails StatryRptTaskDueDate
StatryRptTaskStatus I_StRpTaskDetails StatryRptTaskStatus
StatryRptTaskPeriodStartDate I_StRpTaskDetails StatryRptTaskPeriodStartDate
StatryRptTaskPeriodEndDate I_StRpTaskDetails StatryRptTaskPeriodEndDate
ReportingYear I_StRpTaskDetails ReportingYear
StatryRptRunID I_StRpRepRun StatryRptRunID
StatryRptRunStatus I_StRpRepRun StatryRptRunStatus
StatryRptRunType I_StRpRepRun StatryRptRunType
StatryRptSubmittedDateTime I_StRpRepRun StatryRptSubmittedDateTime 
@AbapCatalog.sqlViewName: 'PRUSTRPRTSK'
@AbapCatalog.preserveKey: true
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RU_StRpRepRunTask
  as select from I_StRpTaskDetails
    join         I_StRpRepRun on  I_StRpRepRun.StatryRptgEntity  = I_StRpTaskDetails.StatryRptgEntity
                              and I_StRpRepRun.StatryRptCategory = I_StRpTaskDetails.StatryRptCategory
                              and I_StRpRepRun.StatryRptTaskUUID = I_StRpTaskDetails.StatryRptTaskUUID

{
  key I_StRpTaskDetails.StatryRptTaskUUID,
  key I_StRpRepRun.StatryRptRunUUID,
      //I_StRpTaskDetails

      I_StRpTaskDetails.StatryRptgEntity,
      I_StRpTaskDetails.StatryRptCategory,
      I_StRpTaskDetails.StatryRptTaskPeriod,
      I_StRpTaskDetails.Country,
      I_StRpTaskDetails.StatryRptTaskDueDate,
      I_StRpTaskDetails.StatryRptTaskStatus,
      I_StRpTaskDetails.StatryRptTaskPeriodStartDate,
      I_StRpTaskDetails.StatryRptTaskPeriodEndDate,
      I_StRpTaskDetails.ReportingYear,
      //I_StRpRepRun

      I_StRpRepRun.StatryRptRunID,
      I_StRpRepRun.StatryRptRunStatus,
      I_StRpRepRun.StatryRptRunType,
      I_StRpRepRun.StatryRptSubmittedDateTime
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STRPREPRUN",
"I_STRPTASKDETAILS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More