I_RevenueVarianceBenchmark

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_RevenueVarianceBenchmark.
-- 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: IREVVARB
-- Parameters: P_KeyDate : datum, P_DisplayCurrency : vdm_v_display_currency, P_Interval1Year : fis_gjahr, P_Interval2Year : fis_gjahr, P_Interval1FromFiscalPeriod : fis_period_from, P_Interval2FromFiscalPeriod : fis_period_from, P_Interval1ToFiscalPeriod : fis_period_to, P_Interval2ToFiscalPeriod : fis_period_to, P_Interval1Type : fac_revvar_interval_type, P_Interval2Type : fac_revvar_interval_type, P_PlanningCategory : fac_revvar_pln_category, P_QuantityType : fac_revvar_quantity_type

CREATE VIEW I_RevenueVarianceBenchmark AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  FinancialPlanningEntryItem,
  GLAccountHierarchy,
  FiscalPeriod,
  cast(PlanningCategory as fac_revvar_pln_category) AS PlanningCategory,
  cast('' 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,
  CompanyCodeCurrency,
  cast('%' as msehi) AS RatioUnit,
  BaseUnit,
  BaseUnitName,
  LedgerName,
  CompanyCodeName,
  Country,
  CountryName,
  SalesOrganization,
  SalesOrganizationName,
  Division,
  DivisionName,
  DistributionChannel,
  DistributionChannelName,
  Customer,
  CustomerName,
  Material,
  MaterialName,
  MaterialGroup,
  MaterialGroupName,
  CustomerGroup,
  GLAccount,
  ProfitCenter,
  GlobalCurrency,
  FinancialAccountType,
  FunctionalArea,
  BusinessArea,
  Segment,
  ControllingArea,
  CostCenter,
  Plant,
  ValuationArea,
  OrganizationDivision,
  AssetClass,
  PostingDate,
  Supplier,
  SalesDocument,
  OrderID,
  AccountingDocumentType,
  ServiceDocument,
  ServiceDocumentType
FROM I_RevenueVariance
;