P_RASchedPerfOblgn

DDL: P_RASCHEDPERFOBLGN Type: view_entity COMPOSITE Package: ODATA_FARR_REVENUESCHEDULE

Revenue Schedule: Compound Performance Obligation

P_RASchedPerfOblgn is a Composite CDS View that provides data about "Revenue Schedule: Compound Performance Obligation" in SAP S/4HANA. It reads from 2 data sources (P_RAPerfOblgnPerPerd, I_RAPerformanceObligation) and exposes 31 fields with key fields PerformanceObligation, FiscalYearPeriod, RevenueAccountingContract. Part of development package ODATA_FARR_REVENUESCHEDULE.

Data Sources (2)

SourceAliasJoin Type
P_RAPerfOblgnPerPerd PerfOblgnDeff from
I_RAPerformanceObligation PerformanceObligation inner

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation I_RAPerformanceObligation PerformanceObligation Performance Obligation
KEY FiscalYearPeriod P_RAPerfOblgnPerPerd FiscalYearPeriod Period/Year
KEY RevenueAccountingContract I_RAPerformanceObligation RevenueAccountingContract Revenue Contract
RAHigherLevelPerfOblgn I_RAPerformanceObligation RAHigherLevelPerfOblgn Higher-Level POB
PerformanceObligationClass I_RAPerformanceObligation PerformanceObligationClass Performance Obligation Name
PerformanceObligationStartDate I_RAPerformanceObligation PerformanceObligationStartDate Start Date
PerformanceObligationEndDate I_RAPerformanceObligation PerformanceObligationEndDate End Date
PerfObligationDeferralMethod I_RAPerformanceObligation PerfObligationDeferralMethod Deferral Method
PerfOblgnStartDateType I_RAPerformanceObligation PerfOblgnStartDateType Start Date Type
PerfOblgnIsFullyFulfilled I_RAPerformanceObligation PerfOblgnIsFullyFulfilled Is Fully Fulfilled
PerfOblgnIsFinallyInvoiced I_RAPerformanceObligation PerfOblgnIsFinallyInvoiced Final Invoice
PerfOblgnEventType I_RAPerformanceObligation PerfOblgnEventType Event Type
PerfOblgnFulfillmentType I_RAPerformanceObligation PerfOblgnFulfillmentType Fulfillment Type
Customer I_RAPerformanceObligation Customer Sold-to Party
RAPerfOblgnDistinctType I_RAPerformanceObligation RAPerfOblgnDistinctType Composition
PerfOblgnIsSoftDeleted I_RAPerformanceObligation PerfOblgnIsSoftDeleted Soft Deleted
SalesDocumentCurrency I_RAPerformanceObligation SalesDocumentCurrency Currency
PerfOblgnEffectiveQuantityUnit I_RAPerformanceObligation PerfOblgnEffectiveQuantityUnit Unit of Measure
PerfOblgnContractualQtyUnit I_RAPerformanceObligation PerfOblgnContractualQtyUnit Unit of Measure
PerUnitSSPriceInSlsDocCrcy I_RAPerformanceObligation PerUnitSSPriceInSlsDocCrcy SSP per Unit
SSPriceInSalesDocCrcy I_RAPerformanceObligation SSPriceInSalesDocCrcy Standalone Selling Price
PerfOblgnContractualQuantity I_RAPerformanceObligation PerfOblgnContractualQuantity Quantity
_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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_RASchedPerfOblgn.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_RASchedPerfOblgn AS
SELECT
  PerformanceObligation.PerformanceObligation AS PerformanceObligation,
  PerfOblgnDeff.FiscalYearPeriod AS FiscalYearPeriod,
  PerformanceObligation.RevenueAccountingContract AS RevenueAccountingContract,
  PerformanceObligation.RAHigherLevelPerfOblgn AS RAHigherLevelPerfOblgn,
  PerformanceObligation.PerformanceObligationClass AS PerformanceObligationClass,
  PerformanceObligation.PerformanceObligationStartDate AS PerformanceObligationStartDate,
  PerformanceObligation.PerformanceObligationEndDate AS PerformanceObligationEndDate,
  PerformanceObligation.PerfObligationDeferralMethod AS PerfObligationDeferralMethod,
  PerformanceObligation.PerfOblgnStartDateType AS PerfOblgnStartDateType,
  PerformanceObligation.PerfOblgnIsFullyFulfilled AS PerfOblgnIsFullyFulfilled,
  PerformanceObligation.PerfOblgnIsFinallyInvoiced AS PerfOblgnIsFinallyInvoiced,
  PerformanceObligation.PerfOblgnEventType AS PerfOblgnEventType,
  PerformanceObligation.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  PerformanceObligation.Customer AS Customer,
  PerformanceObligation.RAPerfOblgnDistinctType AS RAPerfOblgnDistinctType,
  PerformanceObligation.PerfOblgnIsSoftDeleted AS PerfOblgnIsSoftDeleted,
  PerformanceObligation.SalesDocumentCurrency AS SalesDocumentCurrency,
  PerformanceObligation.PerfOblgnEffectiveQuantityUnit AS PerfOblgnEffectiveQuantityUnit,
  PerformanceObligation.PerfOblgnContractualQtyUnit AS PerfOblgnContractualQtyUnit,
  PerformanceObligation.PerUnitSSPriceInSlsDocCrcy AS PerUnitSSPriceInSlsDocCrcy,
  PerformanceObligation.SSPriceInSalesDocCrcy AS SSPriceInSalesDocCrcy,
  PerformanceObligation.PerfOblgnContractualQuantity AS PerfOblgnContractualQuantity,
  PerformanceObligation._RevenueAccountingContract AS _RevenueAccountingContract,
  PerformanceObligation._PerfOblgnStartDateType AS _PerfOblgnStartDateType,
  PerformanceObligation._PerfObligationEventType AS _PerfObligationEventType,
  PerformanceObligation._FulfillmentType AS _FulfillmentType,
  PerformanceObligation._Customer AS _Customer,
  PerformanceObligation._PerfOblgnDistinctType AS _PerfOblgnDistinctType,
  PerformanceObligation._Currency AS _Currency,
  PerformanceObligation._PerfOblgnContractualQtyUnit AS _PerfOblgnContractualQtyUnit,
  PerformanceObligation._PerfOblgnEffectiveQtyUnit AS _PerfOblgnEffectiveQtyUnit
FROM P_RAPerfOblgnPerPerd AS PerfOblgnDeff
INNER JOIN I_RAPerformanceObligation AS PerformanceObligation ON /* join condition not captured in parsed metadata */
;