P_RU_UTNZeroGroupSubmdCurPerd

DDL: P_RU_UTNZEROGROUPSUBMDCURPERD SQL: PRUUTNPZGRPSBMCP Type: view COMPOSITE Package: GLO_FIN_IS_RU_UTNP

UTNP Submd Zero Grp for Current Period

P_RU_UTNZeroGroupSubmdCurPerd is a Composite CDS View that provides data about "UTNP Submd Zero Grp for Current Period" in SAP S/4HANA. It reads from 3 data sources (I_StRpTaskDetails, I_RU_UnifiedTxNtcPaytRptgGrp, I_StRpRepRun) and exposes 12 fields. Part of development package GLO_FIN_IS_RU_UTNP.

3 data source(s) 12 fields

Data Sources (3)

SourceAliasJoin Type
I_StRpTaskDetails _sbmRunDetails inner
I_RU_UnifiedTxNtcPaytRptgGrp _submittedGrp inner
I_StRpRepRun _submittedRun from

Parameters (4)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_ReportingYear srf_reporting_year
P_StatryRptTaskPeriod srf_reporting_period_num

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PRUUTNPZGRPSBMCP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view
EndUserText.label UTNP Submd Zero Grp for Current Period view

Fields (12)

KeyFieldSource TableSource FieldDescription
StatryRptgEntity I_StRpRepRun StatryRptgEntity
StatryRptCategory I_StRpRepRun StatryRptCategory
StatryRptRunID I_StRpRepRun StatryRptRunID
StatryRptRunStatus I_StRpRepRun StatryRptRunStatus
RU_BudgetClassificationCode I_RU_UnifiedTxNtcPaytRptgGrp RU_BudgetClassificationCode
RU_SupplierKPP I_RU_UnifiedTxNtcPaytRptgGrp RU_SupplierKPP
RU_TerritoryClassfctnOKTMO I_RU_UnifiedTxNtcPaytRptgGrp RU_TerritoryClassfctnOKTMO
RU_UnifiedTaxNoticePeriodCode I_RU_UnifiedTxNtcPaytRptgGrp RU_UnifiedTaxNoticePeriodCode
RU_UnifiedTxNoticePeriodNumber I_RU_UnifiedTxNtcPaytRptgGrp RU_UnifiedTxNoticePeriodNumber
InputFiscalYear I_RU_UnifiedTxNtcPaytRptgGrp InputFiscalYear
ReportingYear I_StRpTaskDetails ReportingYear
StatryRptTaskPeriod I_StRpTaskDetails StatryRptTaskPeriod 
@AbapCatalog.sqlViewName: 'PRUUTNPZGRPSBMCP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
 }
@VDM.viewType: #COMPOSITE
@VDM.private: true
@EndUserText.label: 'UTNP Submd Zero Grp for Current Period'

define view P_RU_UTNZeroGroupSubmdCurPerd
 with parameters
      P_StatryRptgEntity         : srf_reporting_entity,
      P_StatryRptCategory        : srf_rep_cat_id,
      P_ReportingYear            : srf_reporting_year,
      P_StatryRptTaskPeriod      : srf_reporting_period_num

  as select from I_StRpRepRun             as _submittedRun 
  
    inner join   I_StRpTaskDetails as _sbmRunDetails on _submittedRun.StatryRptTaskUUID = _sbmRunDetails.StatryRptTaskUUID

    inner join    I_RU_UnifiedTxNtcPaytRptgGrp as _submittedGrp  on _submittedGrp.StatryRptgEntity  = _submittedRun.StatryRptgEntity
                                                                and _submittedGrp.StatryRptCategory = _submittedRun.StatryRptCategory
                                                                and _submittedGrp.StatryRptRunID    = _submittedRun.StatryRptRunID
    
   
{
 
  _submittedRun.StatryRptgEntity,
  _submittedRun.StatryRptCategory,
  _submittedRun.StatryRptRunID,
  _submittedRun.StatryRptRunStatus,
  
  _submittedGrp.RU_BudgetClassificationCode,
  _submittedGrp.RU_SupplierKPP,
  _submittedGrp.RU_TerritoryClassfctnOKTMO,  
  _submittedGrp.RU_UnifiedTaxNoticePeriodCode,
  _submittedGrp.RU_UnifiedTxNoticePeriodNumber,
  _submittedGrp.InputFiscalYear,
  
  _sbmRunDetails.ReportingYear,
  _sbmRunDetails.StatryRptTaskPeriod
  
} 
where
    _submittedRun.StatryRptgEntity   = :P_StatryRptgEntity
and _submittedRun.StatryRptCategory  = :P_StatryRptCategory
and _submittedRun.StatryRptRunStatus = 'SOK'
and _sbmRunDetails.ReportingYear       = :P_ReportingYear 
and _sbmRunDetails.StatryRptTaskPeriod = :P_StatryRptTaskPeriod

Learn More