P_RATotalOpenAmount

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_RATotalOpenAmount.
-- 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_RATotalOpenAmount AS
SELECT
  CompanyCode,
  AccountingPrinciple,
  PerformanceObligation,
  RevnAcctgConditionCategory,
  RAPerformanceObligationType,
  cast(SalesDocumentCurrency as farp_document_currency preserving type) AS SalesDocumentCurrency,
  TotalOpenRevenue.RevenueAccountingContract AS RevenueAccountingContract,
  TotalOpenRevenue._RevenueAccountingContract.RevnAcctgContractCreationDate AS RevnAcctgContractCreationDate,
  BusinessPartner,
  Customer,
  PerfOblgnFulfillmentType,
  PerfOblgnEventType,
  RevnAcctgSalesOrganization,
  FunctionalArea,
  BusinessArea,
  Segment,
  ProfitCenter,
  ProfitabilitySegment_2,
  CostCenter,
  OrderID,
  SalesOrder,
  WBSElementExternalID,
  RevnAcctgPerfOblgnStatus,
  ControllingArea,
  PerformanceObligationClass,
  RAInitialEffectiveDate,
  TotalOpenRevenue._RevenueAccountingContract.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  TotalOpenRevenue.TotalOpenRevenue AS RATotalOpenRevnInSlsDocCrcy,
  cast(0 as farr_open_revenue) AS RAOpenCostInCoCodeCrcy,
  cast(0 as farr_open_revenue) AS RATimeBsdOpenCostInSlsDocCrcy,
  cast(0 as farr_open_revenue) AS RAEventBsdOpenCostInSlsDocCrcy,
  cast(0 as farr_open_revenue) AS RAEventBsdOpenRevnInSlsDocCrcy,
  cast(0 as farr_open_revenue) AS RATimeBsdOpenRevnInSlsDocCrcy
FROM P_RATotalOpenRevenue
-- UNION ALL with additional select branch(es): P_RATOTALOPENCOST
;