SRFD_SubmDateByTaskPhase

DDL: SRFD_SUBMDATEBYTASKPHASE SQL: SRFV_SUBMDTTSKPH Type: view

Submission date by Task and Phase

SRFD_SubmDateByTaskPhase is a CDS View that provides data about "Submission date by Task and Phase" in SAP S/4HANA. It reads from 1 data source (srf_reporting) and exposes 1 field.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
srf_reporting task from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName SRFV_SUBMDTTSKPH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Submission date by Task and Phase view

Fields (1)

KeyFieldSource TableSource FieldDescription
db_key srf_reporting db_key 
@AbapCatalog.sqlViewName: 'SRFV_SUBMDTTSKPH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck : #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality:#D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass:#MIXED
@EndUserText.label: 'Submission date by Task and Phase'
define view SRFD_SubmDateByTaskPhase
  as select from srf_reporting   as task

    join         srf_rpg_phase   as phase               on task.db_key = phase.parent_key

    join         srf_rpg_act     as rpg_activity        on rpg_activity.parent_key = phase.db_key
    
    join         srf_rep_cat_act as activity_definition on(     activity_definition.rep_cat_id      = rpg_activity.rep_cat_id
                                                            and activity_definition.activity_id = rpg_activity.activity_id
    )
    
    join         srf_rep_run     as run                 on run.parent_key = rpg_activity.db_key
{
  task.db_key,
  phase.activity_phase,
  activity_definition.activity_group,  

  div ( run.submitted_on, 1000000 ) as submission_date

}
where
  run.report_run_status = 'SOK'

Learn More