P_RAFinCmplncMaximumChangeDate

DDL: P_RAFINCMPLNCMAXIMUMCHANGEDATE Type: view_entity COMPOSITE

P_RAFinCmplncMaximumChangeDate is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_RAPerfOblgnChangeTypeItem, I_RAPerformanceObligation) and exposes 4 fields with key fields RevenueAccountingContract, PerformanceObligation, PerformanceObligationClass.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_RAPerfOblgnChangeTypeItem _RAPerfOblgnChangeTypeItem inner
I_RAPerformanceObligation _RAPerformanceObligation from

Parameters (2)

NameTypeDefault
P_StartDate farr_start_date
P_EndDate farr_start_date

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY RevenueAccountingContract I_RAPerformanceObligation RevenueAccountingContract
KEY PerformanceObligation I_RAPerformanceObligation PerformanceObligation
KEY PerformanceObligationClass I_RAPerformanceObligation PerformanceObligationClass
RevnAcctgContrChangeEffctvDate 
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.usageType: {sizeCategory: #XXL, serviceQuality: #D, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private:true
//@EndUserText.label: 'Financial Compliance: Maximum Change Date of POB'

define view entity P_RAFinCmplncMaximumChangeDate 
  with parameters
    P_StartDate: farr_start_date,
    P_EndDate: farr_start_date

as select from I_RAPerformanceObligation as _RAPerformanceObligation
  inner join I_RAPerfOblgnChangeTypeItem as _RAPerfOblgnChangeTypeItem
    on _RAPerformanceObligation.RevenueAccountingContract = _RAPerfOblgnChangeTypeItem.RevenueAccountingContract
    and _RAPerformanceObligation.PerformanceObligation = _RAPerfOblgnChangeTypeItem.PerformanceObligation
{
  key _RAPerformanceObligation.RevenueAccountingContract,
  key _RAPerformanceObligation.PerformanceObligation,
  key _RAPerformanceObligation.PerformanceObligationClass,

  max(_RAPerfOblgnChangeTypeItem.RevnAcctgContrChangeEffctvDate) as RevnAcctgContrChangeEffctvDate
}
where _RAPerformanceObligation.RAPerfOblgnCategory is initial
and _RAPerformanceObligation.RAPerfOblgnDistinctType = 'D'
and _RAPerformanceObligation.PerfOblgnCreationDate <= $parameters.P_EndDate
and _RAPerformanceObligation.PerfOblgnCreationDate >= $parameters.P_StartDate
and _RAPerformanceObligation.PerfOblgnIsExclFromPriceAlloc <> 'X'
and _RAPerformanceObligation.PerfOblgnIsSoftDeleted <> 'X'
and _RAPerfOblgnChangeTypeItem.RevnAcctgContrChangeEffctvDate <= $parameters.P_EndDate

group by 
_RAPerformanceObligation.RevenueAccountingContract,
_RAPerformanceObligation.PerformanceObligation,
_RAPerformanceObligation.PerformanceObligationClass
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RAPERFOBLGNCHANGETYPEITEM",
"I_RAPERFORMANCEOBLIGATION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More