P_IT_ReportRunParameter2

DDL: P_IT_REPORTRUNPARAMETER2 Type: view_entity BASIC

P_IT_ReportRunParameter2 is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (srf_rep_run, srf_rep_run_par) and exposes 10 fields with key fields StatryRptRunParamUUID, StatryRptRunUUID.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
srf_rep_run _RepRun inner
srf_rep_run_par RepRunPar from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY StatryRptRunParamUUID srf_rep_run_par db_key
KEY StatryRptRunUUID srf_rep_run_par parent_key
StatryRptgEntity srf_rep_run reporting_entity
StatryRptCategory srf_rep_run rep_cat_id
StatryRptRunID srf_rep_run report_run_id
StatryRptRunParamID srf_rep_run_par param_id
StatryRptRunParamRngeSign srf_rep_run_par sign
StatryRptRunParamRngeOption srf_rep_run_par selopt_option
StatryRptRunParamRngeLowValue srf_rep_run_par low
StatryRptRunParamRngeHighValue srf_rep_run_par high 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity P_IT_ReportRunParameter2
  as select from srf_rep_run_par as RepRunPar
    inner join   srf_rep_run     as _RepRun on _RepRun.db_key = RepRunPar.db_key
{
  key RepRunPar.db_key         as StatryRptRunParamUUID,
  key RepRunPar.parent_key     as StatryRptRunUUID,
      _RepRun.reporting_entity as StatryRptgEntity,
      _RepRun.rep_cat_id       as StatryRptCategory,
      _RepRun.report_run_id    as StatryRptRunID,
      RepRunPar.param_id       as StatryRptRunParamID,
      RepRunPar.sign           as StatryRptRunParamRngeSign,
      RepRunPar.selopt_option  as StatryRptRunParamRngeOption,
      RepRunPar.low            as StatryRptRunParamRngeLowValue,
      RepRunPar.high           as StatryRptRunParamRngeHighValue
}

Learn More