P_RASchedNonDistinctPerdExtend

DDL: P_RASCHEDNONDISTINCTPERDEXTEND Type: view_entity Package: ODATA_FARR_REVENUESCHEDULE

Extend Fiscal Period of Non-distinct POB

P_RASchedNonDistinctPerdExtend is a CDS View that provides data about "Extend Fiscal Period of Non-distinct POB" in SAP S/4HANA. It reads from 1 data source (I_RAPerformanceObligation) and exposes 6 fields with key fields PerformanceObligation, FiscalYear, FiscalPeriod, RevenueAccountingContract. Part of development package ODATA_FARR_REVENUESCHEDULE.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_RAPerformanceObligation _RAPerformanceObligation inner

Annotations (1)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation _RADeferralItemPeriod PerformanceObligation
KEY FiscalYear _RADeferralItemPeriod FiscalYear
KEY FiscalPeriod _RADeferralItemPeriod FiscalPeriod
KEY RevenueAccountingContract _RADeferralItemPeriod RevenueAccountingContract
RAHigherLevelPerfOblgn _RADeferralItemPeriod RAHigherLevelPerfOblgn
NPerformanceObligation I_RAPerformanceObligation PerformanceObligation 
@AccessControl.authorizationCheck: #NOT_REQUIRED

// @EndUserText.label: 'Extend Fiscal Period of Non-distinct POB'


@VDM.private: true
@VDM.viewType: #COMPOSITE

// Extend Fiscal Periods so that non-distinct POBs of one group have same period


/*
Before Join
  POB1  FiscalPeriod01  Group1
  POB1  FiscalPeriod02  Group1

  POB2  FiscalPeriod01  Group1
  POB2  FiscalPeriod03  Group1

After Join
  POB1 FiscalPeriod01 POB1
  POB1 FiscalPeriod01 POB2
  POB1 FiscalPeriod02 POB1
  POB1 FiscalPeriod02 POB2

  POB2 FiscalPeriod01 POB1
  POB2 FiscalPeriod01 POB2
  POB2 FiscalPeriod03 POB1
  POB2 FiscalPeriod03 POB2
*/

define view entity P_RASchedNonDistinctPerdExtend
  as select distinct from P_RAPerfOblgnPeriod as _RADeferralItemPeriod

    inner join I_RAPerformanceObligation as _RAPerformanceObligation
      on _RADeferralItemPeriod.RAHigherLevelPerfOblgn = _RAPerformanceObligation.RAHigherLevelPerfOblgn

{
  key _RADeferralItemPeriod.PerformanceObligation,
  key _RADeferralItemPeriod.FiscalYear,
  key _RADeferralItemPeriod.FiscalPeriod,
  key _RADeferralItemPeriod.RevenueAccountingContract,

      _RADeferralItemPeriod.RAHigherLevelPerfOblgn,
      _RAPerformanceObligation.PerformanceObligation as NPerformanceObligation

}
where _RADeferralItemPeriod.RAPerfOblgnDistinctType = 'N'
  and _RADeferralItemPeriod.RAHigherLevelPerfOblgn is not initial

Learn More