P_RASchedNonDistinctPerdExtend

DDL: P_RASCHEDNONDISTINCTPERDEXTEND SQL: PRASNONDSTCTPRDE Type: view COMPOSITE

P_RASchedNonDistinctPerdExtend is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_RAPerformanceObligation) and exposes 6 fields with key fields PerformanceObligation, FiscalYear, FiscalPeriod, RevenueAccountingContract.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_RAPerformanceObligation _RAPerformanceObligation inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PRASNONDSTCTPRDE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true 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 
@AbapCatalog.sqlViewName: 'PRASNONDSTCTPRDE'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true
//@EndUserText.label: 'Extend Fiscal Period of Non-distinct POB'


//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 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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RAPERFORMANCEOBLIGATION",
"P_RAPERFOBLGNPERIOD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More