P_RU_StRpRepRun

DDL: P_RU_STRPREPRUN SQL: PRUSRREPRUN Type: view COMPOSITE Package: GLO_FIN_IS_VAT_RU

RU General Information about Report Run

P_RU_StRpRepRun is a Composite CDS View that provides data about "RU General Information about Report Run" in SAP S/4HANA. It reads from 1 data source (I_StRpRepRun) and exposes 14 fields with key field StatryRptRunUUID. Part of development package GLO_FIN_IS_VAT_RU.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_StRpRepRun I_StRpRepRun from

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName PRUSRREPRUN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY StatryRptRunUUID StatryRptRunUUID
StatryRptActivityUUID StatryRptActivityUUID
StatryRptTaskUUID StatryRptTaskUUID
StatryRptgEntity StatryRptgEntity
StatryRptCategory StatryRptCategory
StatryRptRunID StatryRptRunID
StatryRptRunStatus StatryRptRunStatus
StatryRptRunCreatedByUser StatryRptRunCreatedByUser
StatryRptRunCreatedOnDate StatryRptRunCreatedOnDate
clientNULLasGeneratedOn
clientNULLasGeneratedAt
StatryRptCatPhase StatryRptCatPhase
StatryRptDef StatryRptDef
StatryRptTaskPeriodEndDate StatryRptTaskPeriodEndDate 
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'PRUSRREPRUN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RU_StRpRepRun
  as select from I_StRpRepRun

{
  key StatryRptRunUUID,
      StatryRptActivityUUID,
      StatryRptTaskUUID,
      StatryRptgEntity,
      StatryRptCategory,
      StatryRptRunID,
      StatryRptRunStatus,
      StatryRptRunCreatedByUser,
      StatryRptRunCreatedOnDate,
      tstmp_to_dats( StatryRptRunCreatedOnDate,
                     abap_system_timezone( $session.client,'NULL' ),
                     $session.client, 'NULL' ) as GeneratedOn,
      tstmp_to_tims( StatryRptRunCreatedOnDate,
                     abap_system_timezone( $session.client,'NULL' ),
                     $session.client, 'NULL' ) as GeneratedAt,

      StatryRptCatPhase,
      StatryRptDef,
      StatryRptTaskPeriodEndDate,
      case substring(StatryRptTaskPeriodEndDate, 5, 2)
           when '03' then concat_with_space(substring(StatryRptTaskPeriodEndDate, 1, 4), 'Q1', 1)
           when '06' then concat_with_space(substring(StatryRptTaskPeriodEndDate, 1, 4), 'Q2', 1)
           when '09' then concat_with_space(substring(StatryRptTaskPeriodEndDate, 1, 4), 'Q3', 1)
           when '12' then concat_with_space(substring(StatryRptTaskPeriodEndDate, 1, 4), 'Q4', 1)
           else StatryRptTaskPeriodEndDate
      end                                      as Period
}

Learn More