I_RAOpenRevenuePerPeriodCube

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 I_RAOpenRevenuePerPeriodCube.
-- 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: IRAOPNRVNPRDCB
-- Parameters: P_FromFiscalYear : fis_gjahr, P_FromFiscalPeriod : fins_fiscalperiod, P_ToFiscalYear : fis_gjahr, P_ToFiscalPeriod : fins_fiscalperiod

CREATE VIEW I_RAOpenRevenuePerPeriodCube AS
SELECT
  PeriodicOpenRevenue.PerformanceObligation AS PerformanceObligation,
  RAReportingPeriodOperatorCode,
  FiscalYearPeriod,
  RevnAcctgConditionCategory,
  BandFiscalYearPeriodText,
  PeriodicOpenRevenue.CompanyCode AS CompanyCode,
  PeriodicOpenRevenue.AccountingPrinciple AS AccountingPrinciple,
  OpenRevenueInPeriod AS RAPerPerdOpenRevnInSlsDocCrcy,
  OpenCostInPeriod AS RAOpenCostInCoCodeCrcy,
  BandFiscalYearText,
  BandFiscalQuarterText,
  BandFiscalYearQuarterText,
  BandFiscalPeriodText,
  cast(PeriodicOpenRevenue.SalesDocumentCurrency as farp_document_currency) AS SalesDocumentCurrency,
  PeriodicOpenRevenue.RevenueAccountingContract AS RevenueAccountingContract,
  _RevenueAccountingContract.RevnAcctgContractCreationDate AS RevnAcctgContractCreationDate,
  PeriodicOpenRevenue.PerformanceObligationClass AS PerformanceObligationClass,
  PeriodicOpenRevenue.BusinessPartner AS BusinessPartner,
  PeriodicOpenRevenue.Customer AS Customer,
  PeriodicOpenRevenue.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  PeriodicOpenRevenue.PerfOblgnEventType AS PerfOblgnEventType,
  PeriodicOpenRevenue.RevnAcctgSalesOrganization AS RevnAcctgSalesOrganization,
  PeriodicOpenRevenue.FunctionalArea AS FunctionalArea,
  PeriodicOpenRevenue.BusinessArea AS BusinessArea,
  PeriodicOpenRevenue.Segment AS Segment,
  PeriodicOpenRevenue.ProfitCenter AS ProfitCenter,
  PeriodicOpenRevenue._RAPerformanceObligation.ProfitabilitySegment_2 AS ProfitabilitySegment_2,
  PeriodicOpenRevenue.CostCenter AS CostCenter,
  PeriodicOpenRevenue.OrderID AS OrderID,
  PeriodicOpenRevenue.SalesOrder AS SalesOrder,
  PeriodicOpenRevenue.WBSElementExternalID AS WBSElementExternalID,
  PeriodicOpenRevenue.RevnAcctgPerfOblgnStatus AS RevnAcctgPerfOblgnStatus,
  PeriodicOpenRevenue.ControllingArea AS ControllingArea,
  PeriodicOpenRevenue.RAPerformanceObligationType AS RAPerformanceObligationType,
  PeriodicOpenRevenue.RAInitialEffectiveDate AS RAInitialEffectiveDate,
  _RAPerformanceObligation._RevenueAccountingContract.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM P_RAOpenRevenuePerPeriod
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_AccountingPrinciple AS _AccountingPrinciple ON AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple  -- association [1..1]
LEFT OUTER JOIN E_RAPerformanceObligation AS _E_RAPerformanceObligation ON PerformanceObligation = _E_RAPerformanceObligation.PerformanceObligation  -- association [1..1]
LEFT OUTER JOIN E_RevenueAccountingContract AS _E_RevenueAccountingContract ON PeriodicOpenRevenue.RevenueAccountingContract = _E_RevenueAccountingContract.RevenueAccountingContract  -- association [1..1]
;