P_RACumltvReceivableAmountSeld

DDL: P_RACUMLTVRECEIVABLEAMOUNTSELD Type: view_entity COMPOSITE
17 Fields 2 Data Sources

P_RACumltvReceivableAmountSeld is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_RAContrBalFiscalPeriodSel, P_RADeltaRevenueAmountAll) and exposes 17 fields with key fields CompanyCode, AccountingPrinciple, RevenueAccountingContract, PerformanceObligation, FiscalYear.

Data Sources (2)

SourceAliasJoin Type
P_RAContrBalFiscalPeriodSel P_RAContrBalFiscalPeriodSel from
P_RADeltaRevenueAmountAll P_RADeltaRevenueAmountAll 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 (17)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode _RAPostingRVSeldPerd CompanyCode Receiver Company Code
KEY AccountingPrinciple _RAPostingRVSeldPerd AccountingPrinciple AP Ledger/CoCode
KEY RevenueAccountingContract _RAPostingRVPerPerd RevenueAccountingContract Revenue Contract
KEY PerformanceObligation _RAPostingRVPerPerd PerformanceObligation Performance Obligation
KEY FiscalYear _RAPostingRVSeldPerd FiscalYear G/L Fiscal Year
KEY FiscalPeriod _RAPostingRVSeldPerd FiscalPeriod Tax period
KEY GLAccount _RAPostingRVPerPerd GLAccount General Ledger
SalesDocumentCurrency _RAPostingRVPerPerd SalesDocumentCurrency Currency
CompanyCodeCurrency _RAPostingRVPerPerd CompanyCodeCurrency Local Currency
AdditionalCurrency1 _RAPostingRVPerPerd AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 _RAPostingRVPerPerd 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_RACumltvReceivableAmountSeld.
-- 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_RACumltvReceivableAmountSeld AS
SELECT
  _RAPostingRVSeldPerd.CompanyCode AS CompanyCode,
  _RAPostingRVSeldPerd.AccountingPrinciple AS AccountingPrinciple,
  _RAPostingRVPerPerd.RevenueAccountingContract AS RevenueAccountingContract,
  _RAPostingRVPerPerd.PerformanceObligation AS PerformanceObligation,
  _RAPostingRVSeldPerd.FiscalYear AS FiscalYear,
  _RAPostingRVSeldPerd.FiscalPeriod AS FiscalPeriod,
  _RAPostingRVPerPerd.GLAccount AS GLAccount,
  _RAPostingRVPerPerd.SalesDocumentCurrency AS SalesDocumentCurrency,
  _RAPostingRVPerPerd.CompanyCodeCurrency AS CompanyCodeCurrency,
  _RAPostingRVPerPerd.AdditionalCurrency1 AS AdditionalCurrency1,
  _RAPostingRVPerPerd.AdditionalCurrency2 AS AdditionalCurrency2,
  sum(_RAPostingRVPerPerd.RevnAcctgDeltaAmtInSlsDocCrcy) AS RevnAcctgEndAmtInSlsDocCrcy,
  sum(_RAPostingRVPerPerd.RevnAcctgDeltaAmtInCoCodeCrcy) AS RevnAcctgEndAmtInCoCodeCrcy,
  sum(case when _RAPostingRVSeldPerd.FiscalYear = _RAPostingRVPerPerd.FiscalYear and _RAPostingRVSeldPerd.FiscalPeriod = _RAPostingRVPerPerd.FiscalPeriod then _RAPostingRVPerPerd.RevnAcctgDeltaAmtInAddlCrcy1 else cast(0 as abap.curr(23,2)) end) as RevnAcctgDeltaAmtInAddlCrcy1 AS curr232endasRevnAcctgDeltaAmtInAddlCrcy1,
  sum(_RAPostingRVPerPerd.RevnAcctgDeltaAmtInAddlCrcy1) AS RevnAcctgEndAmtInAddlCrcy1,
  sum(case when _RAPostingRVSeldPerd.FiscalYear = _RAPostingRVPerPerd.FiscalYear and _RAPostingRVSeldPerd.FiscalPeriod = _RAPostingRVPerPerd.FiscalPeriod then _RAPostingRVPerPerd.RevnAcctgDeltaAmtInAddlCrcy2 else cast(0 as abap.curr(23,2)) end) as RevnAcctgDeltaAmtInAddlCrcy2 AS curr232endasRevnAcctgDeltaAmtInAddlCrcy2,
  sum(_RAPostingRVPerPerd.RevnAcctgDeltaAmtInAddlCrcy2) AS RevnAcctgEndAmtInAddlCrcy2
FROM P_RAContrBalFiscalPeriodSel
INNER JOIN P_RADeltaRevenueAmountAll ON /* join condition not captured in parsed metadata */
;

Learn More