I_SalesAnalyticsCube

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_SalesAnalyticsCube.
-- 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: ISDSLSANACUBE
-- Parameters: P_ExchangeRateType : kurst, P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW I_SalesAnalyticsCube AS
SELECT
  SalesDocument,
  SalesDocumentItem,
  ScheduleLine,
  BillingPlan,
  BillingPlanItem,
  DeliveryDocument,
  DeliveryDocumentItem,
  BillingDocument,
  BillingDocumentItem,
  SoldToParty,
  SoldToPartyName,
  CustomerGroup,
  cast (SoldToParty as kunnr) AS Customer,
  SDDocumentCategory,
  SDDocumentObject,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesDistrict,
  Material,
  OriginallyRequestedMaterial,
  InternationalArticleNumber,
  ProductHierarchyNode,
  MaterialGroup,
  ProfitCenter,
  cast(Period.CalendarYear as billing_document_date_year) AS BillingDocumentDateYear,
  cast(Period.YearQuarter as billing_doc_date_year_quarter) AS BillingDocDateYearQuarter,
  cast(Period.YearMonth as billing_doc_date_year_month) AS BillingDocDateYearMonth,
  SalesDocumentType,
  OpnSOForOrdReltdInvcsNetAmount,
  OpnSOForOrdReltdInvcsNetAmtDC,
  OpnSlsOrdsForOrdReltdInvcsQty,
  OpnRetsForOrdReltdInvcsNetAmt,
  OpnRetsOrdReltdInvcsNetAmtInDC,
  OpnRetsForOrdReltdInvcsQty,
  OpenSlsOrdersForDelivNetAmount,
  OpnSlsOrdsForDelivAmtInDspCrcy,
  OpnSlsOrdrsForDelivQuantity,
  OpnSlsOrdsForInvcPlansNetAmt,
  OpnSlsOrdsForInvcPlansNetAmtDC,
  OpnOutbDelivsForInvcNetAmt,
  OpnOutbDelivsForInvcNetAmtInDC,
  OpnOutbDelivsForInvcQty,
  ShpdNotInvcdDelivsNetAmount,
  SlsVolumeNetAmtInDspCrcy,
  SalesVolumeQuantity,
  SalesProfitMarginNetAmount,
  SlsProfitMargNetAmtInDspCrcy,
  CustomerCreditMemoNetAmount,
  CustCrdtMemoNetAmtInDspCrcy,
  CustCreditMemoQuantity,
  cast(:P_DisplayCurrency as vdm_v_display_currency) AS DisplayCurrency,
  TransactionCurrency,
  StatisticsCurrency,
  BaseUnit
FROM P_SalesAnalytics
LEFT OUTER JOIN I_Currency AS _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_ShippingPoint AS _ShippingPoint ON ShippingPoint = _ShippingPoint.ShippingPoint  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentType AS _BillingDocumentType ON BillingDocumentType = _BillingDocumentType.BillingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentObject AS _SDDocumentObject ON SDDocumentObject = _SDDocumentObject.SDDocumentObject  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SalesDocument = _Extension.SalesDocument AND SalesDocumentItem = _Extension.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_DeliveryDocumentItem AS _DelivDocItemExtension ON DeliveryDocument = _DelivDocItemExtension.DeliveryDocument AND DeliveryDocumentItem = _DelivDocItemExtension.DeliveryDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_BillingDocumentItem AS _BillgDocItemExtension ON BillingDocument = _BillgDocItemExtension.BillingDocument AND BillingDocumentItem = _BillgDocItemExtension.BillingDocumentItem  -- association [0..1]
;