P_RAFinCmplncTransPriceForAud

DDL: P_RAFINCMPLNCTRANSPRICEFORAUD Type: view_entity COMPOSITE

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

4 data source(s) 29 fields

Data Sources (4)

SourceAliasJoin Type
I_RAPerfOblgnChangeTypeItem _RAPerfOblgnChangeTypeItem inner
I_RAPerfOblgnChangeTypeItem _RAPerfOblgnChangeTypeItem inner
I_RAPerformanceObligation _RAPerformanceObligation from
I_RAPerformanceObligation _RAPerformanceObligation union

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY RevenueAccountingContract I_RAPerformanceObligation RevenueAccountingContract
KEY PerformanceObligation I_RAPerformanceObligation PerformanceObligation
KEY PerformanceObligationClass I_RAPerformanceObligation PerformanceObligationClass
RAInitialEffectiveDate I_RAPerformanceObligation RAInitialEffectiveDate
RAPerfOblgnInceptionDate I_RAPerformanceObligation RAPerfOblgnInceptionDate
CompanyCode I_RAPerformanceObligation CompanyCode
AccountingPrinciple I_RAPerformanceObligation AccountingPrinciple
PerfOblgnFulfillmentType I_RAPerformanceObligation PerfOblgnFulfillmentType
SalesDocumentCurrency I_RAPerfOblgnChangeTypeItem SalesDocumentCurrency
ContractualPrcInSlsDocCrcy
SSPriceInSalesDocCrcy
PerfOblgnContractualQtyUnit I_RAPerfOblgnChangeTypeItem PerfOblgnContractualQtyUnit
PerfOblgnEffectiveQuantityUnit I_RAPerfOblgnChangeTypeItem PerfOblgnEffectiveQuantityUnit
PerfOblgnContractualQuantity
RevenueAccountingContract
KEY PerformanceObligation I_RAPerformanceObligation PerformanceObligation
KEY PerformanceObligationClass I_RAPerformanceObligation PerformanceObligationClass
RAInitialEffectiveDate I_RAPerformanceObligation RAInitialEffectiveDate
RAPerfOblgnInceptionDate I_RAPerformanceObligation PerfOblgnCreationDate
CompanyCode I_RAPerformanceObligation CompanyCode
AccountingPrinciple I_RAPerformanceObligation AccountingPrinciple
PerfOblgnFulfillmentType I_RAPerformanceObligation PerfOblgnFulfillmentType
SalesDocumentCurrency I_RAPerfOblgnChangeTypeItem SalesDocumentCurrency
ContractualPrcInSlsDocCrcy
SSPriceInSalesDocCrcy
PerfOblgnContractualQtyUnit I_RAPerfOblgnChangeTypeItem PerfOblgnContractualQtyUnit
PerfOblgnEffectiveQuantityUnit I_RAPerfOblgnChangeTypeItem PerfOblgnEffectiveQuantityUnit
PerfOblgnContractualQuantity
PerfOblgnEffectiveQuantity 
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
@Metadata.ignorePropagatedAnnotations: true
//@EndUserText.label: 'Financial Compliance: Creation Price of POB'

define view entity P_RAFinCmplncTransPriceForAud 
as select from I_RAPerformanceObligation as _RAPerformanceObligation
inner join I_RAPerfOblgnChangeTypeItem as _RAPerfOblgnChangeTypeItem
  on _RAPerfOblgnChangeTypeItem.RevenueAccountingContract = _RAPerformanceObligation.RevenueAccountingContract
  and _RAPerfOblgnChangeTypeItem.PerformanceObligation = _RAPerformanceObligation.PerformanceObligation   
{
  key _RAPerformanceObligation.RevenueAccountingContract,
  key _RAPerformanceObligation.PerformanceObligation,
  key _RAPerformanceObligation.PerformanceObligationClass,
  
  _RAPerformanceObligation.RAInitialEffectiveDate,
  _RAPerformanceObligation.RAPerfOblgnInceptionDate,
  _RAPerformanceObligation.CompanyCode,
  _RAPerformanceObligation.AccountingPrinciple,
  _RAPerformanceObligation.PerfOblgnFulfillmentType,
  
  _RAPerfOblgnChangeTypeItem.SalesDocumentCurrency,
  cast(GET_NUMERIC_VALUE(_RAPerfOblgnChangeTypeItem.ContractualPrcInSlsDocCrcy) as abap.dec(23,6)) as ContractualPrcInSlsDocCrcy,
  cast(GET_NUMERIC_VALUE(_RAPerfOblgnChangeTypeItem.SSPriceInSalesDocCrcy) as abap.dec(23,6)) as SSPriceInSalesDocCrcy,  
  
  _RAPerfOblgnChangeTypeItem.PerfOblgnContractualQtyUnit as PerfOblgnContractualQtyUnit,
  _RAPerfOblgnChangeTypeItem.PerfOblgnEffectiveQuantityUnit as PerfOblgnEffectiveQuantityUnit,
  cast(GET_NUMERIC_VALUE(_RAPerfOblgnChangeTypeItem.PerfOblgnContractualQuantity) as abap.dec(23,6)) as PerfOblgnContractualQuantity,
  cast(GET_NUMERIC_VALUE(_RAPerfOblgnChangeTypeItem.PerfOblgnEffectiveQuantity) as abap.dec(23,6)) as PerfOblgnEffectiveQuantity
}
where _RAPerformanceObligation.RAPerfOblgnCategory is initial and _RAPerformanceObligation.RAPerfOblgnDistinctType = 'D'
and ( _RAPerformanceObligation.RAPerfOblgnInceptionDate is not initial and _RAPerformanceObligation.RAPerfOblgnInceptionDate <> '00000000' )
and _RAPerformanceObligation.PerfOblgnIsExclFromPriceAlloc <> 'X'
and _RAPerformanceObligation.PerfOblgnIsSoftDeleted <> 'X'
and _RAPerformanceObligation.RAPerfOblgnIsManuallyCreated <> 'X'
and _RAPerformanceObligation.PerformanceObligationRole <> 'A'
and _RAPerfOblgnChangeTypeItem.RevnAcctgContrChangeEffctvDate < _RAPerformanceObligation.RAInitialEffectiveDate   

union select from I_RAPerformanceObligation as _RAPerformanceObligation
inner join I_RAPerfOblgnChangeTypeItem as _RAPerfOblgnChangeTypeItem
  on _RAPerfOblgnChangeTypeItem.RevenueAccountingContract = _RAPerformanceObligation.RevenueAccountingContract
  and _RAPerfOblgnChangeTypeItem.PerformanceObligation = _RAPerformanceObligation.PerformanceObligation   
{
  key _RAPerformanceObligation.RevenueAccountingContract,
  key _RAPerformanceObligation.PerformanceObligation,
  key _RAPerformanceObligation.PerformanceObligationClass,
  
  _RAPerformanceObligation.RAInitialEffectiveDate,
  _RAPerformanceObligation.PerfOblgnCreationDate as RAPerfOblgnInceptionDate,
  _RAPerformanceObligation.CompanyCode,
  _RAPerformanceObligation.AccountingPrinciple,
  _RAPerformanceObligation.PerfOblgnFulfillmentType,
  
  _RAPerfOblgnChangeTypeItem.SalesDocumentCurrency,
  cast(GET_NUMERIC_VALUE(_RAPerfOblgnChangeTypeItem.ContractualPrcInSlsDocCrcy) as abap.dec(23,6)) as ContractualPrcInSlsDocCrcy,
  cast(GET_NUMERIC_VALUE(_RAPerfOblgnChangeTypeItem.SSPriceInSalesDocCrcy) as abap.dec(23,6)) as SSPriceInSalesDocCrcy,  
  
  _RAPerfOblgnChangeTypeItem.PerfOblgnContractualQtyUnit as PerfOblgnContractualQtyUnit,
  _RAPerfOblgnChangeTypeItem.PerfOblgnEffectiveQuantityUnit as PerfOblgnEffectiveQuantityUnit,
  cast(GET_NUMERIC_VALUE(_RAPerfOblgnChangeTypeItem.PerfOblgnContractualQuantity) as abap.dec(23,6)) as PerfOblgnContractualQuantity,
  cast(GET_NUMERIC_VALUE(_RAPerfOblgnChangeTypeItem.PerfOblgnEffectiveQuantity) as abap.dec(23,6)) as PerfOblgnEffectiveQuantity
}
where _RAPerformanceObligation.RAPerfOblgnCategory is initial and _RAPerformanceObligation.RAPerfOblgnDistinctType = 'D'
and ( _RAPerformanceObligation.RAPerfOblgnInceptionDate is initial or _RAPerformanceObligation.RAPerfOblgnInceptionDate = '00000000' )
and _RAPerformanceObligation.PerfOblgnIsExclFromPriceAlloc <> 'X'
and _RAPerformanceObligation.PerfOblgnIsSoftDeleted <> 'X'
and _RAPerformanceObligation.RAPerfOblgnIsManuallyCreated <> 'X'
and _RAPerformanceObligation.PerformanceObligationRole <> 'A'
and _RAPerfOblgnChangeTypeItem.RevnAcctgContrChangeEffctvDate < _RAPerformanceObligation.RAInitialEffectiveDate   
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RAPERFOBLGNCHANGETYPEITEM",
"I_RAPERFORMANCEOBLIGATION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More