P_RASchedPerfOblgn

DDL: P_RASCHEDPERFOBLGN SQL: PRASCHEDPOB Type: view COMPOSITE

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

2 data source(s) 31 fields

Data Sources (2)

SourceAliasJoin Type
P_RAPerfOblgnPerPerd PerfOblgnDeff from
I_RAPerformanceObligation PerformanceObligation inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PRASCHEDPOB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation I_RAPerformanceObligation PerformanceObligation
KEY FiscalYearPeriod P_RAPerfOblgnPerPerd FiscalYearPeriod
KEY RevenueAccountingContract I_RAPerformanceObligation RevenueAccountingContract
RAHigherLevelPerfOblgn I_RAPerformanceObligation RAHigherLevelPerfOblgn
PerformanceObligationClass I_RAPerformanceObligation PerformanceObligationClass
PerformanceObligationStartDate I_RAPerformanceObligation PerformanceObligationStartDate
PerformanceObligationEndDate I_RAPerformanceObligation PerformanceObligationEndDate
PerfObligationDeferralMethod I_RAPerformanceObligation PerfObligationDeferralMethod
PerfOblgnStartDateType I_RAPerformanceObligation PerfOblgnStartDateType
PerfOblgnIsFullyFulfilled I_RAPerformanceObligation PerfOblgnIsFullyFulfilled
PerfOblgnIsFinallyInvoiced I_RAPerformanceObligation PerfOblgnIsFinallyInvoiced
PerfOblgnEventType I_RAPerformanceObligation PerfOblgnEventType
PerfOblgnFulfillmentType I_RAPerformanceObligation PerfOblgnFulfillmentType
Customer I_RAPerformanceObligation Customer
RAPerfOblgnDistinctType I_RAPerformanceObligation RAPerfOblgnDistinctType
PerfOblgnIsSoftDeleted I_RAPerformanceObligation PerfOblgnIsSoftDeleted
SalesDocumentCurrency I_RAPerformanceObligation SalesDocumentCurrency
PerfOblgnEffectiveQuantityUnit I_RAPerformanceObligation PerfOblgnEffectiveQuantityUnit
PerfOblgnContractualQtyUnit I_RAPerformanceObligation PerfOblgnContractualQtyUnit
PerUnitSSPriceInSlsDocCrcy I_RAPerformanceObligation PerUnitSSPriceInSlsDocCrcy
SSPriceInSalesDocCrcy I_RAPerformanceObligation SSPriceInSalesDocCrcy
PerfOblgnContractualQuantity I_RAPerformanceObligation PerfOblgnContractualQuantity
_RevenueAccountingContract I_RAPerformanceObligation _RevenueAccountingContract
_PerfOblgnStartDateType I_RAPerformanceObligation _PerfOblgnStartDateType
_PerfObligationEventType I_RAPerformanceObligation _PerfObligationEventType
_FulfillmentType I_RAPerformanceObligation _FulfillmentType
_Customer I_RAPerformanceObligation _Customer
_PerfOblgnDistinctType I_RAPerformanceObligation _PerfOblgnDistinctType
_Currency I_RAPerformanceObligation _Currency
_PerfOblgnContractualQtyUnit I_RAPerformanceObligation _PerfOblgnContractualQtyUnit
_PerfOblgnEffectiveQtyUnit I_RAPerformanceObligation _PerfOblgnEffectiveQtyUnit 
@AbapCatalog.sqlViewName: 'PRASCHEDPOB'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true

//@EndUserText.label: 'Revenue Schedule: Compound Performance Obligation'

define view P_RASchedPerfOblgn
as select from P_RAPerfOblgnPerPerd as PerfOblgnDeff
  inner join I_RAPerformanceObligation as PerformanceObligation
  on PerfOblgnDeff.PerformanceObligation = PerformanceObligation.PerformanceObligation 
  and PerfOblgnDeff.RevenueAccountingContract = PerformanceObligation.RevenueAccountingContract
{
/*======Key===============================================*/  
  key PerformanceObligation.PerformanceObligation,
  key PerfOblgnDeff.FiscalYearPeriod,
  key PerformanceObligation.RevenueAccountingContract,
  
/*======Associated Key====================================*/  
  PerformanceObligation.RAHigherLevelPerfOblgn,
  
/*======POB Data==========================================*/
  PerformanceObligation.PerformanceObligationClass,
  PerformanceObligation.PerformanceObligationStartDate,
  PerformanceObligation.PerformanceObligationEndDate,
  PerformanceObligation.PerfObligationDeferralMethod,
  PerformanceObligation.PerfOblgnStartDateType,
  PerformanceObligation.PerfOblgnIsFullyFulfilled,
  PerformanceObligation.PerfOblgnIsFinallyInvoiced,
  PerformanceObligation.PerfOblgnEventType,
  PerformanceObligation.PerfOblgnFulfillmentType,
  PerformanceObligation.Customer,
  PerformanceObligation.RAPerfOblgnDistinctType,
  PerformanceObligation.PerfOblgnIsSoftDeleted,

//UoM  

  @Semantics.currencyCode: true
  PerformanceObligation.SalesDocumentCurrency, 
  @Semantics.unitOfMeasure: true
  PerformanceObligation.PerfOblgnEffectiveQuantityUnit,    
  @Semantics.unitOfMeasure: true
  PerformanceObligation.PerfOblgnContractualQtyUnit,  
  
//Price and Quantity  

  @Semantics.amount.currencyCode : 'SalesDocumentCurrency'
  PerformanceObligation.PerUnitSSPriceInSlsDocCrcy,
  @Semantics.amount.currencyCode : 'SalesDocumentCurrency'
  PerformanceObligation.SSPriceInSalesDocCrcy,  
  @Semantics.quantity.unitOfMeasure: 'PerfOblgnContractualQtyUnit'
  PerformanceObligation.PerfOblgnContractualQuantity,
  
/*======Associated View=====================================*/
  PerformanceObligation._RevenueAccountingContract,  
  PerformanceObligation._PerfOblgnStartDateType,
  PerformanceObligation._PerfObligationEventType,
  PerformanceObligation._FulfillmentType,
  PerformanceObligation._Customer,  
  PerformanceObligation._PerfOblgnDistinctType,
  PerformanceObligation._Currency,  
  PerformanceObligation._PerfOblgnContractualQtyUnit,
  PerformanceObligation._PerfOblgnEffectiveQtyUnit
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RAPERFORMANCEOBLIGATION",
"P_RAPERFOBLGNPERPERD"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_CUSTOMER",
"I_RAPERFOBLGNDISTINCTTYPE",
"I_RAPERFOBLGNFLFMTTYPE",
"I_RAPERFOBLGNSTARTDATETYPE",
"I_RAPERFOBLIGATIONEVENTTYPE",
"I_REVENUEACCOUNTINGCONTRACT",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_RAPERFORMANCEOBLIGATION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More