P_RADeferralItemAggrgdRevn

DDL: P_RADEFERRALITEMAGGRGDREVN Type: view_entity COMPOSITE
7 Fields

P_RADeferralItemAggrgdRevn is a Composite CDS View in SAP S/4HANA.

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 (7)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation PerformanceObligation Performance Obligation
KEY RevenueAccountingContract RevenueAccountingContract Revenue Contract
KEY FiscalYear _RevnAcctgReconciliationKey FiscalYear G/L Fiscal Year
KEY FiscalPeriod _RevnAcctgReconciliationKey FiscalPeriod Tax period
DeltaRecognizedAmtInSlsDocCrcy
RecgdCatchUpAmtInSlsDocCrcy
SalesDocumentCurrency 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_RADeferralItemAggrgdRevn.
-- 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_RADeferralItemAggrgdRevn AS
SELECT
  PerformanceObligation,
  RevenueAccountingContract,
  _RevnAcctgReconciliationKey.FiscalYear AS FiscalYear,
  _RevnAcctgReconciliationKey.FiscalPeriod AS FiscalPeriod,
  sum(DeltaRecognizedAmtInSlsDocCrcy) AS DeltaRecognizedAmtInSlsDocCrcy,
  sum(RecgdCatchUpAmtInSlsDocCrcy) AS RecgdCatchUpAmtInSlsDocCrcy,
  SalesDocumentCurrency
;

Learn More