P_RACarryForwardPostingQtrA

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_RACarryForwardPostingQtrA.
-- 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_RACarryForwardPostingQtrA AS
SELECT
  RACarryForwardPosting.CompanyCode AS CompanyCode,
  RACarryForwardPosting.AccountingPrinciple AS AccountingPrinciple,
  RACarryForwardPosting.RevenueAccountingContract AS RevenueAccountingContract,
  RACarryForwardPosting.RevnAcctgPostingCategory AS RevnAcctgPostingCategory,
  RACarryForwardPosting.PerformanceObligation AS PerformanceObligation,
  cast('0000' as fis_gjahr preserving type) AS FiscalYear,
  cast('0' as fins_fscalquarter preserving type) AS FiscalQuarter,
  RACarryForwardPosting.SalesDocumentCurrency AS SalesDocumentCurrency,
  RACarryForwardPosting.CompanyCodeCurrency AS CompanyCodeCurrency,
  RACarryForwardPosting.AdditionalCurrency1 AS AdditionalCurrency1,
  RACarryForwardPosting.AdditionalCurrency2 AS AdditionalCurrency2,
  sum(RACarryForwardPosting.RevnAcctgPostgAmtInSlsDocCrcy) AS RevnAcctgPostgAmtInSlsDocCrcy,
  sum(RACarryForwardPosting.RevnAcctgPostgAmtInCoCodeCrcy) AS RevnAcctgPostgAmtInCoCodeCrcy,
  sum(RACarryForwardPosting.RevnAcctgPostgAmtInAddlCrcy1) AS RevnAcctgPostgAmtInAddlCrcy1,
  sum(RACarryForwardPosting.RevnAcctgPostgAmtInAddlCrcy2) as RevnAcctgPostgAmtInAddlCrcy2 AS P_FiscalYearFrom,
  P_FiscalPeriodFrom: $parameters.P_FiscalPeriodFrom AS P_FiscalPeriodFrom,
  P_FiscalYearTo: $parameters.P_FiscalYearTo AS P_FiscalYearTo,
  sum(RADeltaPosting.RevnAcctgPostgAmtInAddlCrcy2) AS RevnAcctgPostgAmtInAddlCrcy2
FROM I_RevenueAccountingPosting AS RACarryForwardPosting
INNER JOIN P_RAContrBalFiscalPeriodSel ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_RevenueAccountingPosting, I_RevenueAccountingPosting
;