I_StRpRepRun

DDL: I_STRPREPRUN SQL: ISRREPRUN Type: view BASIC

General Information about Report Run

I_StRpRepRun is a Basic CDS View that provides data about "General Information about Report Run" in SAP S/4HANA. It reads from 4 data sources (I_StRpActivity, I_StRpPhase, I_StRpTaskDetails, srf_rep_run) and exposes 19 fields with key field StatryRptRunUUID.

4 data source(s) 19 fields

Data Sources (4)

SourceAliasJoin Type
I_StRpActivity I_StRpActivity inner
I_StRpPhase I_StRpPhase inner
I_StRpTaskDetails I_StRpTaskDetails inner
srf_rep_run srf_rep_run from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ISRREPRUN view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label General Information about Report Run view
AbapCatalog.preserveKey true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY StatryRptRunUUID srf_rep_run db_key
StatryRptActivityUUID srf_rep_run parent_key
StatryRptTaskUUID srf_rep_run root_key
StatryRptgEntity srf_rep_run reporting_entity
StatryRptCategory srf_rep_run rep_cat_id
StatryRptRunID srf_rep_run report_run_id
StatryRptRunStatus srf_rep_run report_run_status
StatryRptRunType srf_rep_run report_run_type
StatryRptSubmittedDateTime srf_rep_run submitted_on
StatryRptRunCreatedByUser srf_rep_run created_by
StatryRptRunCreatedOnDate srf_rep_run created_on
StatryRptCatPhase I_StRpPhase StatryRptCatPhase
StatryRptDef srf_rep_run report_id
Country I_StRpTaskDetails Country
ReportingYear I_StRpTaskDetails ReportingYear
StatryRptTaskPeriodStartDate I_StRpTaskDetails StatryRptTaskPeriodStartDate
StatryRptTaskPeriodEndDate I_StRpTaskDetails StatryRptTaskPeriodEndDate
StatryRptTaskDueDate I_StRpTaskDetails StatryRptTaskDueDate
ApplicationJobName srf_rep_run job_name 
@AbapCatalog.sqlViewName: 'ISRREPRUN'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality:#B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass:#MIXED

@EndUserText.label: 'General Information about Report Run'
@AbapCatalog.preserveKey:true // Added for ATC check prio 2 error


define view I_StRpRepRun

  as select from srf_rep_run

    inner join   I_StRpActivity    on srf_rep_run.parent_key = I_StRpActivity.StatryRptActivityUUID
    inner join   I_StRpPhase       on I_StRpActivity.StatryRptPhaseUUID = I_StRpPhase.StatryRptPhaseUUID
    inner join   I_StRpTaskDetails on I_StRpPhase.StatryRptTaskUUID = I_StRpTaskDetails.StatryRptTaskUUID

{
  key srf_rep_run.db_key                             as StatryRptRunUUID,
      srf_rep_run.parent_key                         as StatryRptActivityUUID,
      srf_rep_run.root_key                           as StatryRptTaskUUID,
      srf_rep_run.reporting_entity                   as StatryRptgEntity,
      srf_rep_run.rep_cat_id                         as StatryRptCategory,
      srf_rep_run.report_run_id                      as StatryRptRunID,
      srf_rep_run.report_run_status                  as StatryRptRunStatus,
      srf_rep_run.report_run_type                    as StatryRptRunType,
      srf_rep_run.submitted_on                       as StatryRptSubmittedDateTime,
      srf_rep_run.created_by                         as StatryRptRunCreatedByUser,
      srf_rep_run.created_on                         as StatryRptRunCreatedOnDate,
      I_StRpPhase.StatryRptCatPhase                  as StatryRptCatPhase,
      srf_rep_run.report_id                          as StatryRptDef,
      I_StRpTaskDetails.Country                      as Country,
      I_StRpTaskDetails.ReportingYear                as ReportingYear,
      I_StRpTaskDetails.StatryRptTaskPeriodStartDate as StatryRptTaskPeriodStartDate,
      I_StRpTaskDetails.StatryRptTaskPeriodEndDate   as StatryRptTaskPeriodEndDate,
      I_StRpTaskDetails.StatryRptTaskDueDate         as StatryRptTaskDueDate,
      srf_rep_run.job_name                           as ApplicationJobName
}

Learn More