P_RAPerfOblgnTotalFaceValue

DDL: P_RAPERFOBLGNTOTALFACEVALUE Type: view_entity COMPOSITE Package: ODATA_FARR_CONTRACT_OVERVIEW

Total Face Value of Performance Obligation

P_RAPerfOblgnTotalFaceValue is a Composite CDS View that provides data about "Total Face Value of Performance Obligation" in SAP S/4HANA. It reads from 1 data source (I_RevnAcctgDeferralItem) and exposes 5 fields with key field PerformanceObligation. Part of development package ODATA_FARR_CONTRACT_OVERVIEW.

Data Sources (1)

SourceAliasJoin Type
I_RevnAcctgDeferralItem _RevnAcctgDeferralItem from

Annotations (3)

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

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation I_RevnAcctgDeferralItem PerformanceObligation Performance Obligation
RevenueAccountingContract
RAFulfillmentIsValueBased
PerfOblgnFaceAmtInSlsDocCrcy
SalesDocumentCurrency I_RevnAcctgDeferralItem SalesDocumentCurrency Currency

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_RAPerfOblgnTotalFaceValue.
-- 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_RAPerfOblgnTotalFaceValue AS
SELECT
  _RevnAcctgDeferralItem.PerformanceObligation AS PerformanceObligation,
  _RevnAcctgDeferralItem._RAPerformanceObligation.RevenueAccountingContract AS RevenueAccountingContract,
  _RevnAcctgDeferralItem._RAPerformanceObligation.RAFulfillmentIsValueBased AS RAFulfillmentIsValueBased,
  sum(_RevnAcctgDeferralItem.DeltaEffectiveAmtInSlsDocCrcy) AS PerfOblgnFaceAmtInSlsDocCrcy,
  _RevnAcctgDeferralItem.SalesDocumentCurrency AS SalesDocumentCurrency
FROM I_RevnAcctgDeferralItem AS _RevnAcctgDeferralItem
;