P_RATotalOpenRevnTimeBased

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_RATotalOpenRevnTimeBased.
-- 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_FiscalYear : fis_gjahr, P_FiscalPeriod : fins_fiscalperiod

CREATE VIEW P_RATotalOpenRevnTimeBased AS
SELECT
  PerformObligation.PerformanceObligation AS PerformanceObligation,
  PerformObligation.CompanyCode AS CompanyCode,
  PerformObligation.AccountingPrinciple AS AccountingPrinciple,
  PerformObligation.RevenueAccountingContract AS RevenueAccountingContract,
  PerformObligation.SalesDocumentCurrency AS SalesDocumentCurrency,
  cast(0 as farr_open_revenue) AS EventBasedTotalOpenRevenue,
  PerformObligation.RAPerformanceObligationType AS RAPerformanceObligationType,
  PerformObligation.BusinessPartner AS BusinessPartner,
  PerformObligation.Customer AS Customer,
  PerformObligation.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  PerformObligation.PerfOblgnEventType AS PerfOblgnEventType,
  PerformObligation.RevnAcctgSalesOrganization AS RevnAcctgSalesOrganization,
  PerformObligation.FunctionalArea AS FunctionalArea,
  PerformObligation.BusinessArea AS BusinessArea,
  PerformObligation.Segment AS Segment,
  PerformObligation.ProfitCenter AS ProfitCenter,
  PerformObligation.CostCenter AS CostCenter,
  PerformObligation.OrderID AS OrderID,
  PerformObligation.SalesOrder AS SalesOrder,
  PerformObligation.WBSElementExternalID AS WBSElementExternalID,
  PerformObligation.RevnAcctgPerfOblgnStatus AS RevnAcctgPerfOblgnStatus,
  PerformObligation.ControllingArea AS ControllingArea,
  PerformObligation.PerformanceObligationClass AS PerformanceObligationClass,
  PerformObligation.RAInitialEffectiveDate AS RAInitialEffectiveDate,
  PerformObligation._AccountingPrinciple AS _AccountingPrinciple,
  PerformObligation._BusinessArea AS _BusinessArea,
  PerformObligation._BusinessPartner AS _BusinessPartner,
  PerformObligation._CompanyCode AS _CompanyCode,
  PerformObligation._Customer AS _Customer,
  PerformObligation._FulfillmentType AS _FulfillmentType,
  PerformObligation._FunctionalArea AS _FunctionalArea,
  PerformObligation._Order AS _Order,
  PerformObligation._PerfObligationEventType AS _PerfObligationEventType,
  PerformObligation._RAPerfOblgnStatus AS _RAPerfOblgnStatus,
  PerformObligation._SalesOrder AS _SalesOrder,
  PerformObligation._Segment AS _Segment,
  PerformObligation._WBSElement AS _WBSElement,
  PerformObligation._CostCenter AS _CostCenter,
  PerformObligation._ProfitCenter AS _ProfitCenter,
  PerformObligation._ControllingArea AS _ControllingArea,
  PerformObligation._SalesOrganization AS _SalesOrganization,
  PerformObligation._RevenueAccountingContract AS _RevenueAccountingContract
FROM I_RAPerformanceObligation AS PerformObligation
;