I_SlsOrdConfAnalyticsCube

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

CREATE VIEW I_SlsOrdConfAnalyticsCube AS
SELECT
  cast( SDIA.SalesDocument as vdm_sales_order preserving type ) AS SalesOrder,
  cast( SDIA.SalesDocumentItem as sales_order_item preserving type ) AS SalesOrderItem,
  SDDocumentCategory,
  SalesDocumentType AS SalesOrderType,
  cast(SalesDocumentItemCategory as sales_order_item_category preserving type) AS SalesOrderItemCategory,
  cast(SalesDocumentItemType as sales_order_item_type) AS SalesOrderItemType,
  cast(IsReturnsItem as returns_item_flag) AS IsReturnsItem,
  CreatedByUser,
  cast(_CreatedByUser.UserDescription as created_by_user_name preserving type ) AS CreatedByUserName,
  cast(CreationTime as creation_time) AS CreationTime,
  cast(CalendarDate.CalendarYear as creation_date_year) AS CreationDateYear,
  cast(CalendarDate.YearQuarter as creation_date_year_quarter) AS CreationDateYearQuarter,
  cast(CalendarDate.YearMonth as creation_date_year_month) AS CreationDateYearMonth,
  LastChangeDate,
  cast(CalendarDateSalesOrder.CalendarYear as sales_order_date_year) AS SalesOrderDateYear,
  cast(CalendarDateSalesOrder.YearQuarter as sales_order_date_year_quarter) AS SalesOrderDateYearQuarter,
  cast(CalendarDateSalesOrder.YearMonth as sales_order_date_year_month) AS SalesOrderDateYearMonth,
  cast(CalendarDateSalesOrder.YearWeek as sales_order_date_year_week) AS SalesOrderDateYearWeek,
  SalesOrganization,
  DistributionChannel,
  cast(OrganizationDivision as organization_division preserving type ) AS OrganizationDivision,
  SalesGroup,
  SalesOffice,
  Division,
  SDIA._SoldToParty._GlobalCompany AS _GlobalCompany,
  OriginallyRequestedMaterial,
  MaterialByCustomer,
  InternationalArticleNumber,
  cast(ProductCatalog as product_catalog) AS ProductCatalog,
  MaterialSubstitutionReason,
  MaterialGroup deprecated MaterialGroup AS MaterialGroupdeprecatedMaterialGroup,
  ProductGroup,
  AdditionalMaterialGroup1,
  AdditionalMaterialGroup2,
  AdditionalMaterialGroup3,
  AdditionalMaterialGroup4,
  AdditionalMaterialGroup5,
  Plant,
  _Plant.PlantName AS ProductionPlantName,
  StorageLocation,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  cast(ProductConfiguration as product_configuration) AS ProductConfiguration,
  MainItemPricingRefProduct,
  BillOfMaterial,
  PropagatePrftbltySgmt2BOM,
  CostDeterminationIsRequired,
  SDIA._SoldToParty AS _SoldToParty,
  SDIA._SoldToParty.CustomerClassification AS SoldToPartyClassification,
  cast(SDIA._SoldToParty.CustomerName as vdm_sold_to_name) AS SoldToPartyName,
  cast(coalesce(ItemStandardPartner.ShipToParty, StandardPartner.ShipToParty) as kunwe) AS ShipToParty,
  cast(coalesce(ItemStandardPartner._ShipToParty.CustomerName, StandardPartner._ShipToParty.CustomerName ) as ship_to_name) AS ShipToPartyName,
  cast(coalesce(ItemStandardPartner.PayerParty, StandardPartner.PayerParty) as kunrg) AS PayerParty,
  cast(coalesce(ItemStandardPartner._PayerParty.CustomerName, StandardPartner._PayerParty.CustomerName) as payer_name) AS PayerPartyName,
  cast(coalesce(ItemStandardPartner.BillToParty, StandardPartner.BillToParty) as kunre) AS BillToParty,
  cast(coalesce(ItemStandardPartner._BillToParty.CustomerName, StandardPartner._BillToParty.CustomerName) as bill_to_name) AS BillToPartyName,
  cast(coalesce(ItemStandardPartner.ResponsibleEmployeeWorkAgrmt, StandardPartner.ResponsibleEmployeeWorkAgrmt) as resp_empl) AS ResponsibleEmployee,
  cast(coalesce(ItemStandardPartner._ResponsibleEmployee.PersonFullName, StandardPartner._ResponsibleEmployee.PersonFullName) as resp_empl_name) AS ResponsibleEmployeeName,
  cast(coalesce(ItemStandardPartner.SalesEmployeeWorkAgreement, StandardPartner.SalesEmployeeWorkAgreement) as sales_empl) AS SalesEmployee,
  cast(coalesce(ItemStandardPartner._SalesEmployee.PersonFullName, StandardPartner._SalesEmployee.PersonFullName) as sales_empl_name) AS SalesEmployeeName,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  CreditControlArea,
  cast(CustomerRebateAgreement as customer_rebate_agreement) AS CustomerRebateAgreement,
  SalesDocumentDate AS SalesOrderDate,
  SDDocumentReason,
  SDDocumentCollectiveNumber,
  CustomerPurchaseOrderSuplmnt,
  cast(SalesDocumentItemText as sales_order_item_text) AS SalesOrderItemText,
  PurchaseOrderByCustomer,
  UnderlyingPurchaseOrderItem,
  OrderQuantity,
  ConfdDelivQtyInOrderQtyUnit,
  TargetDelivQtyInOrderQtyUnit,
  SDIA.OrderQuantityUnit AS OrderQuantityUnit,
  SDIA._OrderQuantityUnit AS _OrderQuantityUnit,
  ConfdDeliveryQtyInBaseUnit,
  SDIA.BaseUnit AS BaseUnit,
  SDIA._BaseUnit AS _BaseUnit,
  SDIA.OrderToBaseQuantityDnmntr AS OrderToBaseQuantityDnmntr,
  SDIA.OrderToBaseQuantityNmrtr AS OrderToBaseQuantityNmrtr,
  TargetQuantity,
  TargetQuantityUnit,
  TargetToBaseQuantityDnmntr,
  TargetToBaseQuantityNmrtr,
  ItemGrossWeight,
  ItemNetWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  ServicesRenderedDate,
  SalesDistrict,
  SalesDeal,
  cast(_SalesDeal.SalesDealDescription as sales_deal_description) AS SalesDealDescription,
  cast(SalesPromotion as sales_promotion) AS SalesPromotion,
  cast(RetailPromotion as retail_promotion) AS RetailPromotion,
  CustomerGroup,
  SalesDocumentRjcnReason,
  ItemOrderProbabilityInPercent,
  TotalNetAmount,
  cast(SalesDocumentCondition as sales_order_condition) AS SalesOrderCondition,
  NetAmount,
  SDIA.TransactionCurrency AS TransactionCurrency,
  SDIA._TransactionCurrency AS _TransactionCurrency,
  cast(:P_DisplayCurrency as vdm_v_display_currency) AS DisplayCurrency,
  PricingDate,
  ExchangeRateDate,
  NetPriceQuantity,
  NetPriceQuantityUnit,
  StatisticalValueControl,
  TaxAmount,
  CostAmount,
  Subtotal1Amount,
  Subtotal2Amount,
  Subtotal3Amount,
  Subtotal4Amount,
  Subtotal5Amount,
  Subtotal6Amount,
  SDIA.RequestedDeliveryDate AS RequestedDeliveryDate,
  ShippingCondition,
  CompleteDeliveryIsDefined,
  DeliveryBlockReason,
  ShippingPoint,
  ShippingType,
  InventorySpecialStockType,
  DeliveryPriority,
  Route,
  cast(DeliveryDateQuantityIsFixed as fixed_delivery_date_quantity) AS DeliveryDateQuantityIsFixed,
  UnlimitedOverdeliveryIsAllowed,
  MinDeliveryQtyInBaseUnit,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  IncotermsVersion,
  OpenDeliveryLeadingUnitCode,
  SDIA.ItemIsDeliveryRelevant AS ItemIsDeliveryRelevant,
  BillingCompanyCode,
  HeaderBillingBlockReason,
  BillingDocumentDate,
  ItemIsBillingRelevant,
  cast(ItemBillingBlockReason as billing_block_reason_item preserving type) AS ItemBillingBlockReason,
  BillingPlan,
  CustomerPaymentTerms,
  PaymentMethod,
  FixedValueDate,
  AdditionalValueDays,
  CustomerProjectItem.EngagementProject AS CustomerProject,
  cast(ExchangeRateType as doc_exchange_rate_type preserving type ) AS ExchangeRateType,
  cast(CostCenterBusinessArea as business_area_cost_center preserving type) AS CostCenterBusinessArea,
  CostCenter,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  FiscalYear,
  FiscalPeriod,
  CustomerAccountAssignmentGroup,
  BusinessArea,
  ProfitCenter,
  WBSElement,
  SDIA.OrderID AS OrderID,
  cast(ControllingObject as controlling_object) AS ControllingObject,
  ProfitabilitySegment_2,
  OriginSDDocument,
  cast(OriginSDDocumentItem as origin_sd_document_item) AS OriginSDDocumentItem,
  ReferenceSDDocumentCategory,
  HigherLevelItem,
  SDIA.BusinessSolutionOrder AS BusinessSolutionOrder,
  cast(OverallSDProcessStatus as overall_sd_process_status preserving type) AS OverallSDProcessStatus,
  cast(OverallPurchaseConfStatus as overall_purchase_conf_status preserving type) AS OverallPurchaseConfStatus,
  cast(OverallSDDocumentRejectionSts as ovrl_sd_doc_rejection_status preserving type) AS OverallSDDocumentRejectionSts,
  TotalBlockStatus,
  cast(OverallDelivConfStatus as overall_delivery_conf_status preserving type) AS OverallDelivConfStatus,
  cast(OverallTotalDeliveryStatus as itms_ovrl_delivery_status preserving type) AS OverallTotalDeliveryStatus,
  cast(OverallDeliveryStatus as overall_delivery_status preserving type) AS OverallDeliveryStatus,
  cast(OverallDeliveryBlockStatus as overall_delivery_block_status preserving type) AS OverallDeliveryBlockStatus,
  cast(OverallOrdReltdBillgStatus as ovrl_ord_rel_billg_status preserving type) AS OverallOrdReltdBillgStatus,
  cast(OverallBillingBlockStatus as overall_billing_block_status preserving type) AS OverallBillingBlockStatus,
  cast(OverallTotalSDDocRefStatus as ovrl_reference_status preserving type) AS OverallTotalSDDocRefStatus,
  cast(OverallSDDocReferenceStatus as ovrl_sd_doc_reference_status preserving type) AS OverallSDDocReferenceStatus,
  TotalCreditCheckStatus,
  MaxDocValueCreditCheckStatus,
  cast(PaymentTermCreditCheckStatus as payt_terms_credit_check_status preserving type) AS PaymentTermCreditCheckStatus,
  FinDocCreditCheckStatus,
  ExprtInsurCreditCheckStatus,
  PaytAuthsnCreditCheckSts,
  cast(CentralCreditCheckStatus as central_credit_check_status preserving type) AS CentralCreditCheckStatus,
  cast(CentralCreditChkTechErrSts as centrl_crdt_chck_tech_err_sts preserving type) AS CentralCreditChkTechErrSts,
  cast(HdrGeneralIncompletionStatus as hdr_general_incompltn_status preserving type) AS HdrGeneralIncompletionStatus,
  cast(OverallPricingIncompletionSts as ovrl_pricing_incompletion_sts preserving type) AS OverallPricingIncompletionSts,
  cast(HeaderDelivIncompletionStatus as hdrdelivincompletionstatus preserving type ) AS HeaderDelivIncompletionStatus,
  cast(HeaderBillgIncompletionStatus as hdrbillgincompletionstatus preserving type ) AS HeaderBillgIncompletionStatus,
  cast(OvrlItmGeneralIncompletionSts as itms_ovrl_incompletion_status preserving type) AS OvrlItmGeneralIncompletionSts,
  cast(OvrlItmBillingIncompletionSts as ovrl_itms_incompltn_sts_billg preserving type) AS OvrlItmBillingIncompletionSts,
  cast(OvrlItmDelivIncompletionSts as ovrl_items_dlv_incompltn_sts preserving type) AS OvrlItmDelivIncompletionSts,
  cast(SDProcessStatus as sd_doc_process_status preserving type) AS SDProcessStatus,
  cast(DeliveryConfirmationStatus as delivery_confirmation_status preserving type) AS DeliveryConfirmationStatus,
  cast(PurchaseConfirmationStatus as purchase_confirmation_status preserving type) AS PurchaseConfirmationStatus,
  TotalDeliveryStatus,
  DeliveryStatus,
  DeliveryBlockStatus,
  OrderRelatedBillingStatus,
  BillingBlockStatus,
  cast(ItemGeneralIncompletionStatus as item_general_incompletion_sts preserving type) AS ItemGeneralIncompletionStatus,
  cast(ItemBillingIncompletionStatus as itms_incompltn_sts_billg preserving type) AS ItemBillingIncompletionStatus,
  cast(PricingIncompletionStatus as pricing_incompletion_status preserving type) AS PricingIncompletionStatus,
  cast(ItemDeliveryIncompletionStatus as itm_deliv_incompletion_status preserving type) AS ItemDeliveryIncompletionStatus,
  cast(SDDocumentRejectionStatus as sd_doc_rejection_status preserving type) AS SDDocumentRejectionStatus,
  TotalSDDocReferenceStatus,
  TotDelayOfSchdLnConfdToReqdDte,
  MaxDelayOfSchdLnConfdToReqdDte,
  MinDelayOfSchdLnConfdToReqdDte
FROM I_SalesDocumentItemAnalytics AS SDIA
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [1..1]
LEFT OUTER JOIN I_SalesOrderType AS _SalesOrderType ON SalesOrderType = _SalesOrderType.SalesOrderType  -- association [0..1]
LEFT OUTER JOIN I_EngagementProject AS _CustomerProject ON CustomerProject = _CustomerProject.EngagementProject  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_CustomerClassification AS _SoldToPartyClassification ON SoldToPartyClassification = _SoldToPartyClassification.CustomerClassification  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _BillToParty ON BillToParty = _BillToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _PayerParty ON PayerParty = _PayerParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Employee AS _SalesEmployee ON SalesEmployee = _SalesEmployee.PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN I_Employee AS _ResponsibleEmployee ON ResponsibleEmployee = _ResponsibleEmployee.PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _SalesEmployee_2 ON SalesEmployee = _SalesEmployee_2.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _ResponsibleEmployee_2 ON ResponsibleEmployee = _ResponsibleEmployee_2.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_SlsDocItmReqdDelivConfSts AS _SlsDocItmReqdDelivConfSts ON SlsDocItmReqdDelivConfSts = _SlsDocItmReqdDelivConfSts.SlsDocItmReqdDelivConfSts  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SalesOrder = _Extension.SalesDocument AND SalesOrderItem = _Extension.SalesDocumentItem  -- association [0..1]
;