I_SalesAnalyticsCube_1

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

CREATE VIEW I_SalesAnalyticsCube_1 AS
SELECT
  SalesDocumentItem,
  ScheduleLine,
  BillingPlan,
  BillingPlanItem,
  DeliveryDocument,
  DeliveryDocumentItem,
  BillingDocument,
  BillingDocumentItem,
  SoldToParty,
  SoldToPartyName,
  CustomerGroup,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  cast (SoldToParty as kunnr) AS Customer,
  SDDocumentCategory,
  SDDocumentObject,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesDistrict,
  OriginallyRequestedMaterial,
  InternationalArticleNumber,
  ProductGroup,
  AdditionalMaterialGroup2,
  AdditionalMaterialGroup3,
  AdditionalMaterialGroup4,
  AdditionalMaterialGroup5,
  ProfitCenter,
  cast(PSA.CalendarDate as billing_document_date) AS BillingDocumentDate,
  cast(Period.CalendarYear as billing_document_date_year) AS BillingDocumentDateYear,
  cast(Period.CalendarQuarter as billing_doc_date_cal_quarter ) AS BillingDocDateCalendarQuarter,
  cast(Period.YearMonth as billing_doc_date_year_month) AS BillingDocDateYearMonth,
  DeliveryDate,
  OpnSOForOrdReltdInvcsNetAmount,
  OpnSlsOrdsForOrdReltdInvcsQty,
  OpnRetsForOrdReltdInvcsNetAmt,
  OpnRetsForOrdReltdInvcsQty,
  OpenSlsOrdersForDelivNetAmount,
  OpnSlsOrdrsForDelivQuantity,
  OpnSlsOrdsForInvcPlansNetAmt,
  OpnOutbDelivsForInvcNetAmt,
  successor: 'ShpdNotInvcdDelivsNetAmount_2' AS 2022introductionofenlargedDec19,
  successor: 'CustomerCreditMemoNetAmount_2' AS 2020fkadded,
  _SoldToParty._GlobalCompany AS _GlobalCompany
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 I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup ON ProductGroup = _ProductGroup.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_CalendarMonth AS _BillingDocDateCalendarMonth ON BillingDocDateCalendarMonth = _BillingDocDateCalendarMonth.CalendarMonth  -- association [0..1]
LEFT OUTER JOIN I_CalendarQuarter AS _BillingDocDateCalendarQuarter ON BillingDocDateCalendarQuarter = _BillingDocDateCalendarQuarter.CalendarQuarter  -- association [0..1]
LEFT OUTER JOIN I_ProductHierarchyNode AS _ProductHierarchyNode ON ProductHierarchyNode = _ProductHierarchyNode.ProductHierarchyNode  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentType AS _SalesDocumentType ON SalesDocumentType = _SalesDocumentType.SalesDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [1..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]
;