P_RACumltvPostedAmountSelected

DDL: P_RACUMLTVPOSTEDAMOUNTSELECTED Type: view_entity COMPOSITE Package: FARR_CDS_ANALYTICS
19 Fields 2 Data Sources

116A Contract Balance: Cumulative Ending Amount

P_RACumltvPostedAmountSelected is a Composite CDS View that provides data about "116A Contract Balance: Cumulative Ending Amount" in SAP S/4HANA. It reads from 2 data sources (P_RAContrBalFiscalPeriodSel, P_RAPostedDeltaAmountAll) and exposes 19 fields with key fields CompanyCode, AccountingPrinciple, RevenueAccountingContract, PerformanceObligation, FiscalYear. Part of development package FARR_CDS_ANALYTICS.

Data Sources (2)

SourceAliasJoin Type
P_RAContrBalFiscalPeriodSel P_RAContrBalFiscalPeriodSel from
P_RAPostedDeltaAmountAll P_RAPostedDeltaAmountAll inner

Parameters (4)

NameTypeDefault
P_FiscalYearFrom fis_gjahr
P_FiscalPeriodFrom fis_poper
P_FiscalYearTo fis_gjahr
P_FiscalPeriodTo fis_poper

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode _RAPostingCLCASeldPerd CompanyCode Receiver Company Code
KEY AccountingPrinciple _RAPostingCLCASeldPerd AccountingPrinciple AP Ledger/CoCode
KEY RevenueAccountingContract _RAPostingCLCAPerPerd RevenueAccountingContract Revenue Contract
KEY PerformanceObligation _RAPostingCLCAPerPerd PerformanceObligation Performance Obligation
KEY FiscalYear _RAPostingCLCASeldPerd FiscalYear G/L Fiscal Year
KEY FiscalPeriod _RAPostingCLCASeldPerd FiscalPeriod Tax period
KEY RevnAcctgPostingCategory _RAPostingCLCAPerPerd RevnAcctgPostingCategory
KEY GLAccount _RAPostingCLCAPerPerd GLAccount General Ledger
RevnAcctgReportCategory _RAPostingCLCAPerPerd RevnAcctgReportCategory
SalesDocumentCurrency _RAPostingCLCAPerPerd SalesDocumentCurrency Currency
CompanyCodeCurrency _RAPostingCLCAPerPerd CompanyCodeCurrency Local Currency
AdditionalCurrency1 _RAPostingCLCAPerPerd AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 _RAPostingCLCAPerPerd AdditionalCurrency2 Local curr. 3
RevnAcctgEndAmtInSlsDocCrcy
RevnAcctgEndAmtInCoCodeCrcy
curr232endasRevnAcctgDeltaAmtInAddlCrcy1
RevnAcctgEndAmtInAddlCrcy1
curr232endasRevnAcctgDeltaAmtInAddlCrcy2
RevnAcctgEndAmtInAddlCrcy2

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_RACumltvPostedAmountSelected.
-- 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.
-- Parameters: P_FiscalYearFrom : fis_gjahr, P_FiscalPeriodFrom : fis_poper, P_FiscalYearTo : fis_gjahr, P_FiscalPeriodTo : fis_poper

CREATE VIEW P_RACumltvPostedAmountSelected AS
SELECT
  _RAPostingCLCASeldPerd.CompanyCode AS CompanyCode,
  _RAPostingCLCASeldPerd.AccountingPrinciple AS AccountingPrinciple,
  _RAPostingCLCAPerPerd.RevenueAccountingContract AS RevenueAccountingContract,
  _RAPostingCLCAPerPerd.PerformanceObligation AS PerformanceObligation,
  _RAPostingCLCASeldPerd.FiscalYear AS FiscalYear,
  _RAPostingCLCASeldPerd.FiscalPeriod AS FiscalPeriod,
  _RAPostingCLCAPerPerd.RevnAcctgPostingCategory AS RevnAcctgPostingCategory,
  _RAPostingCLCAPerPerd.GLAccount AS GLAccount,
  _RAPostingCLCAPerPerd.RevnAcctgReportCategory AS RevnAcctgReportCategory,
  _RAPostingCLCAPerPerd.SalesDocumentCurrency AS SalesDocumentCurrency,
  _RAPostingCLCAPerPerd.CompanyCodeCurrency AS CompanyCodeCurrency,
  _RAPostingCLCAPerPerd.AdditionalCurrency1 AS AdditionalCurrency1,
  _RAPostingCLCAPerPerd.AdditionalCurrency2 AS AdditionalCurrency2,
  sum(_RAPostingCLCAPerPerd.RevnAcctgDeltaAmtInSlsDocCrcy) AS RevnAcctgEndAmtInSlsDocCrcy,
  sum(_RAPostingCLCAPerPerd.RevnAcctgDeltaAmtInCoCodeCrcy) AS RevnAcctgEndAmtInCoCodeCrcy,
  sum(case when _RAPostingCLCASeldPerd.FiscalYear = _RAPostingCLCAPerPerd.FiscalYear and _RAPostingCLCASeldPerd.FiscalPeriod = _RAPostingCLCAPerPerd.FiscalPeriod then _RAPostingCLCAPerPerd.RevnAcctgDeltaAmtInAddlCrcy1 else cast(0 as abap.curr(23,2)) end) as RevnAcctgDeltaAmtInAddlCrcy1 AS curr232endasRevnAcctgDeltaAmtInAddlCrcy1,
  sum(_RAPostingCLCAPerPerd.RevnAcctgDeltaAmtInAddlCrcy1) AS RevnAcctgEndAmtInAddlCrcy1,
  sum(case when _RAPostingCLCASeldPerd.FiscalYear = _RAPostingCLCAPerPerd.FiscalYear and _RAPostingCLCASeldPerd.FiscalPeriod = _RAPostingCLCAPerPerd.FiscalPeriod then _RAPostingCLCAPerPerd.RevnAcctgDeltaAmtInAddlCrcy2 else cast(0 as abap.curr(23,2)) end) as RevnAcctgDeltaAmtInAddlCrcy2 AS curr232endasRevnAcctgDeltaAmtInAddlCrcy2,
  sum(_RAPostingCLCAPerPerd.RevnAcctgDeltaAmtInAddlCrcy2) AS RevnAcctgEndAmtInAddlCrcy2
FROM P_RAContrBalFiscalPeriodSel
INNER JOIN P_RAPostedDeltaAmountAll ON /* join condition not captured in parsed metadata */
;

Learn More