P_RACumltvReceivableAmountSeld

DDL: P_RACUMLTVRECEIVABLEAMOUNTSELD SQL: PRACULVRBLAMTS Type: view COMPOSITE
15 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 15 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 (11)

NameValueLevelField
AbapCatalog.sqlViewName PRACULVRBLAMTS view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (15)

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
RevnAcctgEndAmtInAddlCrcy1
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.
-- SQL view name: PRACULVRBLAMTS
-- 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(_RAPostingRVPerPerd.RevnAcctgDeltaAmtInAddlCrcy1) AS RevnAcctgEndAmtInAddlCrcy1,
  sum(_RAPostingRVPerPerd.RevnAcctgDeltaAmtInAddlCrcy2) AS RevnAcctgEndAmtInAddlCrcy2
FROM P_RAContrBalFiscalPeriodSel
INNER JOIN P_RADeltaRevenueAmountAll ON /* join condition not captured in parsed metadata */
;

Learn More