P_RAMnlRevnSprdgByPeriodTP

DDL: P_RAMNLREVNSPRDGBYPERIODTP Type: view_entity COMPOSITE
12 Fields 1 Data Sources 4 Associations

P_RAMnlRevnSprdgByPeriodTP is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_RAPerfOblignAllPeriods) and exposes 12 fields with key fields PerformanceObligation, FiscalYear, FiscalPeriod. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_RAPerfOblignAllPeriods P_RAPerfOblignAllPeriods from

Associations (4)

CardinalityTargetAliasCondition
[0..1] P_RADeferralItemAggrgdRevn _aggregatedRevenue $projection.PerformanceObligation = _aggregatedRevenue.PerformanceObligation and $projection.RevenueAccountingContract = _aggregatedRevenue.RevenueAccountingContract and $projection.FiscalYear = _aggregatedRevenue.FiscalYear and $projection.FiscalPeriod = _aggregatedRevenue.FiscalPeriod
[0..1] P_RAFlfmtAggrgdMnlSprdgAmt _aggregatedMnlSprdgAmt $projection.PerformanceObligation = _aggregatedMnlSprdgAmt.PerformanceObligation and $projection.RevenueAccountingContract = _aggregatedMnlSprdgAmt.RevenueAccountingContract and $projection.FiscalYear = _aggregatedMnlSprdgAmt.FiscalYear and $projection.FiscalPeriod = _aggregatedMnlSprdgAmt.FiscalPeriod
[0..1] P_RAContrLastSplitFull _lastSplit $projection.RevenueAccountingContract = _lastSplit.RevenueAccountingContract
[0..1] I_RAPeriodSetting _periodSetting $projection.AccountingPrinciple = _periodSetting.AccountingPrinciple and $projection.CompanyCode = _periodSetting.CompanyCode

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation PerformanceObligation Performance Obligation
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
RevenueAccountingContract RevenueAccountingContract Revenue Contract
CompanyCode CompanyCode Receiver Company Code
AccountingPrinciple AccountingPrinciple AP Ledger/CoCode
DeltaRecognizedAmtInSlsDocCrcy _aggregatedRevenue DeltaRecognizedAmtInSlsDocCrcy
RecgdCatchUpAmtInSlsDocCrcy _aggregatedRevenue RecgdCatchUpAmtInSlsDocCrcy
FulfilledAmountInSlsDocCrcy _aggregatedMnlSprdgAmt FulfilledAmountInSlsDocCrcy
SalesDocumentCurrency _aggregatedRevenue SalesDocumentCurrency Currency
ReportedFulfilledQuantity _aggregatedMnlSprdgAmt ReportedFulfilledQuantity
FulfilledQuantityUnit _aggregatedMnlSprdgAmt FulfilledQuantityUnit

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_RAMnlRevnSprdgByPeriodTP.
-- 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_RAMnlRevnSprdgByPeriodTP AS
SELECT
  PerformanceObligation,
  FiscalYear,
  FiscalPeriod,
  RevenueAccountingContract,
  CompanyCode,
  AccountingPrinciple,
  _aggregatedRevenue.DeltaRecognizedAmtInSlsDocCrcy AS DeltaRecognizedAmtInSlsDocCrcy,
  _aggregatedRevenue.RecgdCatchUpAmtInSlsDocCrcy AS RecgdCatchUpAmtInSlsDocCrcy,
  _aggregatedMnlSprdgAmt.FulfilledAmountInSlsDocCrcy AS FulfilledAmountInSlsDocCrcy,
  _aggregatedRevenue.SalesDocumentCurrency AS SalesDocumentCurrency,
  _aggregatedMnlSprdgAmt.ReportedFulfilledQuantity AS ReportedFulfilledQuantity,
  _aggregatedMnlSprdgAmt.FulfilledQuantityUnit AS FulfilledQuantityUnit
FROM P_RAPerfOblignAllPeriods
LEFT OUTER JOIN P_RADeferralItemAggrgdRevn AS _aggregatedRevenue ON PerformanceObligation = _aggregatedRevenue.PerformanceObligation AND RevenueAccountingContract = _aggregatedRevenue.RevenueAccountingContract AND FiscalYear = _aggregatedRevenue.FiscalYear AND FiscalPeriod = _aggregatedRevenue.FiscalPeriod  -- association [0..1]
LEFT OUTER JOIN P_RAFlfmtAggrgdMnlSprdgAmt AS _aggregatedMnlSprdgAmt ON PerformanceObligation = _aggregatedMnlSprdgAmt.PerformanceObligation AND RevenueAccountingContract = _aggregatedMnlSprdgAmt.RevenueAccountingContract AND FiscalYear = _aggregatedMnlSprdgAmt.FiscalYear AND FiscalPeriod = _aggregatedMnlSprdgAmt.FiscalPeriod  -- association [0..1]
LEFT OUTER JOIN P_RAContrLastSplitFull AS _lastSplit ON RevenueAccountingContract = _lastSplit.RevenueAccountingContract  -- association [0..1]
LEFT OUTER JOIN I_RAPeriodSetting AS _periodSetting ON AccountingPrinciple = _periodSetting.AccountingPrinciple AND CompanyCode = _periodSetting.CompanyCode  -- association [0..1]
;

Learn More