C_RevenueVariance

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 C_RevenueVariance.
-- 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: CREVVAR
-- Parameters: P_KeyDate : datum, P_DisplayCurrency : vdm_v_display_currency, P_RevenueComparisonVariant : fac_revvar_comprn_type, P_FiscalYear : fis_gjahr, P_PlanningCategory : fac_revvar_pln_category, P_QuantityType : fac_revvar_quantity_type, P_Interval1Year : fis_gjahr, P_Interval2Year : fis_gjahr, P_Interval1FromFiscalPeriod : fins_fiscalperiod, P_Interval2FromFiscalPeriod : fins_fiscalperiod, P_Interval1ToFiscalPeriod : fins_fiscalperiod, P_Interval2ToFiscalPeriod : fins_fiscalperiod, P_Interval1Type : fac_revvar_interval_type, P_Interval2Type : fac_revvar_interval_type

CREATE VIEW C_RevenueVariance AS
SELECT
  lookupEntity: 'P_RevenueVariance' AS lookupEntityP_RevenueVariance,
  resultElement: 'Interval1Year' AS resultElementInterval1Year,
  resultElement: 'Interval2Year' AS resultElementInterval2Year,
  resultElement: 'Interval1FromFiscalPeriod' AS resultElementInterval1FromFiscalPeriod,
  resultElement: 'Interval2FromFiscalPeriod' AS resultElementInterval2FromFiscalPeriod,
  resultElement: 'Interval1ToFiscalPeriod' AS resultElementInterval1ToFiscalPeriod,
  resultElement: 'Interval2ToFiscalPeriod' AS resultElementInterval2ToFiscalPeriod,
  resultElement: 'Interval1Type' AS resultElementInterval1Type,
  resultElement: 'Interval2Type' AS resultElementInterval2Type,
  cast('' as fac_revvar_kpi_name) AS RevenueVarianceKPIName,
  cast(0 as fac_revvar_revenue) AS RevenueVarianceKPIValue,
  cast('' as fac_revvar_kpi_type) AS RevenueVarianceKPIType,
  Material,
  cast(PlanningCategory as fac_revvar_pln_category preserving type) AS PlanningCategory,
  CompanyCode,
  Ledger,
  Customer,
  SalesOrganization,
  MaterialGroup,
  CompanyCodeCurrency,
  FiscalPeriod,
  SourceLedger,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  FinancialPlanningEntryItem,
  cast( GLAccountHierarchy as fis_fsv_hryid preserving type ) AS GLAccountHierarchy,
  cast(:P_QuantityType as fac_revvar_quantity_type) AS QuantityType,
  cast(:P_FiscalYear as fis_gjahr) AS InputFiscalYear,
  cast(:P_PlanningCategory as fac_revvar_pln_category) AS InputPlanningCategory,
  cast(:P_RevenueComparisonVariant as fac_revvar_comprn_type) AS RevenueComparisonVariant,
  cast(:P_Interval1Type as fac_revvar_interval_type) AS Interval1Type,
  cast(:P_Interval2Type as fac_revvar_interval_type) AS Interval2Type,
  cast(:P_DisplayCurrency as vdm_v_display_currency) AS DisplayCurrency,
  Interval1LineItemVolume,
  currency_conversion( amount => Interval1LineItemRevenue, source_currency => GlobalCurrency, target_currency => :P_DisplayCurrency, exchange_rate_date => :P_KeyDate, exchange_rate_type => 'M', round => #CDSBoolean.true, decimal_shift => #CDSBoolean.true, decimal_shift_back => #CDSBoolean.true ) as Interval1LineItemRevenue AS trueasInterval1LineItemRevenue,
  Interval2LineItemVolume,
  currency_conversion( amount => Interval2LineItemRevenue, source_currency => GlobalCurrency, target_currency => :P_DisplayCurrency, exchange_rate_date => :P_KeyDate, exchange_rate_type => 'M', round => #CDSBoolean.true, decimal_shift => #CDSBoolean.true, decimal_shift_back => #CDSBoolean.true ) as Interval2LineItemRevenue AS trueasInterval2LineItemRevenue,
  GlobalCurrency,
  Country,
  CustomerGroup,
  ProfitCenter,
  GLAccount,
  cast(CustomerSupplierCountry as fac_revvar_country_region preserving type ) AS CustomerSupplierCountry,
  CustomerSupplierIndustry,
  Division,
  DistributionChannel,
  FinancialAccountType,
  FunctionalArea,
  BusinessArea,
  Segment,
  ControllingArea,
  CostCenter,
  Plant,
  ValuationArea,
  OrganizationDivision,
  ServiceDocument,
  ServiceDocumentType,
  AssetClass,
  PostingDate,
  Supplier,
  SalesDocument,
  OrderID,
  AccountingDocumentType
FROM I_RevenueVariance
;