P_RAEffectiveQtyPerPeriod

DDL: P_RAEFFECTIVEQTYPERPERIOD Type: view_entity COMPOSITE Package: ODATA_FARR_REVENUESCHEDULE
6 Fields 2 Data Sources

Effective Quantity Per Period

P_RAEffectiveQtyPerPeriod is a Composite CDS View that provides data about "Effective Quantity Per Period" in SAP S/4HANA. It reads from 2 data sources (I_RAPerformanceObligation, I_RevnAcctgDeferralItem) and exposes 6 fields with key fields FiscalYearPeriod, PerformanceObligation, RevenueAccountingContract, ConditionType. Part of development package ODATA_FARR_REVENUESCHEDULE.

Data Sources (2)

SourceAliasJoin Type
I_RAPerformanceObligation _RAPerformanceObligation inner
I_RevnAcctgDeferralItem RevnAcctgDeferralItem from

Annotations (3)

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

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY FiscalYearPeriod I_RevnAcctgDeferralItem FiscalYearPeriod Period/Year
KEY PerformanceObligation I_RevnAcctgDeferralItem PerformanceObligation Performance Obligation
KEY RevenueAccountingContract I_RAPerformanceObligation RevenueAccountingContract Revenue Contract
KEY ConditionType I_RevnAcctgDeferralItem ConditionType Condition type
PerfOblgnEffectiveQuantityUnit I_RevnAcctgDeferralItem PerfOblgnEffectiveQuantityUnit Unit of Measure
DeltaEffectiveQuantity

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_RAEffectiveQtyPerPeriod.
-- 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_RAEffectiveQtyPerPeriod AS
SELECT
  RevnAcctgDeferralItem.FiscalYearPeriod AS FiscalYearPeriod,
  RevnAcctgDeferralItem.PerformanceObligation AS PerformanceObligation,
  _RAPerformanceObligation.RevenueAccountingContract AS RevenueAccountingContract,
  RevnAcctgDeferralItem.ConditionType AS ConditionType,
  RevnAcctgDeferralItem.PerfOblgnEffectiveQuantityUnit AS PerfOblgnEffectiveQuantityUnit,
  sum(RevnAcctgDeferralItem.DeltaEffectiveQuantity) AS DeltaEffectiveQuantity
FROM I_RevnAcctgDeferralItem AS RevnAcctgDeferralItem
INNER JOIN I_RAPerformanceObligation AS _RAPerformanceObligation ON /* join condition not captured in parsed metadata */
;

Learn More