I_StRpTaskCube

DDL: I_STRPTASKCUBE SQL: ISTRPTASKCUBE Type: view BASIC

Reporting Task Virtual - Cube

I_StRpTaskCube is a Basic CDS View (Cube) that provides data about "Reporting Task Virtual - Cube" in SAP S/4HANA. It reads from 1 data source (I_StRpTaskDetails) and exposes 17 fields with key field StatryRptTaskUUID. It has 2 associations to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_StRpTaskDetails I_StRpTaskDetails from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_StRpEntityText _SrfEntText _SrfEntText.StatryRptgEntity = $projection.StatryRptgEntity and _SrfEntText.Language = $session.system_language
[0..1] I_StRpCategoryText _SrfCatText _SrfCatText.StatryRptCategory = $projection.StatryRptCategory and _SrfCatText.StatryRptCatVersion = 'ACT' and _SrfCatText.Language = $session.system_language

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ISTRPTASKCUBE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.readClassName CL_SRF_RPG_TASK_CDS_READCLASS view
EndUserText.label Reporting Task Virtual - Cube view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY StatryRptTaskUUID StatryRptTaskUUID
StatryRptgEntity StatryRptgEntity
StatryRptgEntityName _SrfEntText StatryRptgEntityName
StatryRptCategory StatryRptCategory
StatryRptCategoryName _SrfCatText StatryRptCategoryName
Country Country
StatryRptTaskPeriod StatryRptTaskPeriod
ReportingYear ReportingYear
StatryRptTaskPeriodStartDate StatryRptTaskPeriodStartDate
StatryRptTaskPeriodEndDate StatryRptTaskPeriodEndDate
StatryRptTaskStatus StatryRptTaskStatus
StatryRptTaskDueDate StatryRptTaskDueDate
StatryRptTaskPeriodEndYearMnth
StatryRptNmbrOfCmpltdActy
StatryRptNmbrOfTotalActivity
StatryRptDueDateStatus
StatryRptNumberOfTasks 
@AbapCatalog.sqlViewName: 'ISTRPTASKCUBE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #BASIC
@Analytics: { dataCategory: #CUBE}
@Analytics.internalName:#LOCAL  
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.authorizationCheck : #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Analytics.readClassName: 'CL_SRF_RPG_TASK_CDS_READCLASS'
@EndUserText.label: 'Reporting Task Virtual - Cube'
define view I_StRpTaskCube as select from I_StRpTaskDetails
association [0..1] to I_StRpEntityText  as _SrfEntText on  _SrfEntText.StatryRptgEntity = $projection.StatryRptgEntity
                                                                 and _SrfEntText.Language         = $session.system_language
 association [0..1] to I_StRpCategoryText as _SrfCatText on  _SrfCatText.StatryRptCategory = $projection.StatryRptCategory
                                                                 and _SrfCatText.StatryRptCatVersion = 'ACT'
                                                                 and _SrfCatText.Language          = $session.system_language
 {
  key StatryRptTaskUUID,
      StatryRptgEntity,
      _SrfEntText.StatryRptgEntityName  as StatryRptgEntityName,
      StatryRptCategory,
      _SrfCatText.StatryRptCategoryName as StatryRptCategoryName,
      Country,
      StatryRptTaskPeriod,
      ReportingYear,
      StatryRptTaskPeriodStartDate,
      StatryRptTaskPeriodEndDate,
      StatryRptTaskStatus,
      StatryRptTaskDueDate,
      cast('000000' as srf_rpg_period_end_yearmonth) as StatryRptTaskPeriodEndYearMnth,
      cast('0' as srf_rpg_progress_done) as StatryRptNmbrOfCmpltdActy,
      cast('0' as srf_rpg_progress_total) as StatryRptNmbrOfTotalActivity,
      cast('' as srf_due_date_status) as StatryRptDueDateStatus,  
      @Aggregation.default: #SUM
      cast('1' as abap.int4) as StatryRptNumberOfTasks
  
} 

where StatryRptgEntity = ''

Learn More