I_SalesOrderCube

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

CREATE VIEW I_SalesOrderCube AS
SELECT
  cast(SDH.SalesDocument as vdm_sales_order preserving type) AS SalesOrder,
  SDH.SalesDocumentType AS SalesOrderType,
  SDH.CreatedByUser AS CreatedByUser,
  SDH._CreatedByUser AS _CreatedByUser,
  cast(SDH._CreatedByUser.UserDescription as created_by_user_name) AS CreatedByUserName,
  SDH.CreationDate AS CreationDate,
  SDH.CreationTime AS CreationTime,
  SDH.LastChangeDate AS LastChangeDate,
  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,
  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,
  SDH.SalesOrganization AS SalesOrganization,
  SDH._SalesOrganization AS _SalesOrganization,
  SDH.DistributionChannel AS DistributionChannel,
  SDH._DistributionChannel AS _DistributionChannel,
  cast(SDH.OrganizationDivision as organization_division preserving type) AS OrganizationDivision,
  SDH._OrganizationDivision AS _OrganizationDivision,
  SDH.SalesGroup AS SalesGroup,
  SDH._SalesGroup AS _SalesGroup,
  SDH.SalesOffice AS SalesOffice,
  SDH._SalesOffice AS _SalesOffice,
  SDH._SoldToParty.TradingPartner AS PartnerCompany,
  SDH._SoldToParty._GlobalCompany AS _GlobalCompany,
  SDH.SoldToParty AS SoldToParty,
  SDH._SoldToParty AS _SoldToParty,
  SDH._SoldToParty.CustomerClassification AS SoldToPartyClassification,
  cast(StandardPartner.ShipToParty as kunwe) AS ShipToParty,
  cast(StandardPartner.PayerParty as kunrg) AS PayerParty,
  cast(StandardPartner.BillToParty as kunre) AS BillToParty,
  SDH.CustomerGroup AS CustomerGroup,
  SDH._CustomerGroup AS _CustomerGroup,
  SDH.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  SDH._AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1,
  SDH.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  SDH._AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2,
  SDH.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  SDH._AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3,
  SDH.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  SDH._AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4,
  SDH.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  SDH._AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5,
  cast(SDH.CustomerRebateAgreement as customer_rebate_agreement) AS CustomerRebateAgreement,
  SDH.SalesDocumentDate AS SalesOrderDate,
  SDH.SDDocumentReason AS SDDocumentReason,
  SDH._SDDocumentReason AS _SDDocumentReason,
  SDH.SDDocumentCollectiveNumber AS SDDocumentCollectiveNumber,
  SDH.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  SDH.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
  SDH.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  SDH.CustomerPurchaseOrderSuplmnt AS CustomerPurchaseOrderSuplmnt,
  SDH.SalesDistrict AS SalesDistrict,
  SDH._SalesDistrict AS _SalesDistrict,
  cast(SDH.ProductCatalog as product_catalog) AS ProductCatalog,
  SDH.ServicesRenderedDate AS ServicesRenderedDate,
  SDH.TransactionCurrency AS TransactionCurrency,
  SDH._TransactionCurrency AS _TransactionCurrency,
  cast(:P_DisplayCurrency as vdm_v_display_currency) AS DisplayCurrency,
  SDH.PricingDate AS PricingDate,
  cast(SDH.RetailPromotion as retail_promotion) AS RetailPromotion,
  cast(SDH.SalesDocumentCondition as sales_order_condition) AS SalesOrderCondition,
  cast(1 as nmbr_of_incg_sls_ords) AS NumberOfIncomingSalesOrders,
  cast(SDH.TotalNetAmount as incg_sls_ords_net_amt) AS IncomingSalesOrdersNetAmount,
  cast(OpnSOForOrdReltdInvcsNetAmtDC as opn_ords_for_ordrelinv_amt_idc) AS OpnSOForOrdReltdInvcsNetAmtDC,
  cast(OpnSlsOrdsForDelivAmtInDspCrcy as opn_ord_for_del_amt_idc) AS OpnSlsOrdsForDelivAmtInDspCrcy,
  cast(OpnSlsOrdsForInvcPlansNetAmtDC as opn_ord_for_iplan_amt_idc) AS OpnSlsOrdsForInvcPlansNetAmtDC,
  SDH.RequestedDeliveryDate AS RequestedDeliveryDate,
  SDH.ShippingType AS ShippingType,
  SDH._ShippingType AS _ShippingType,
  SDH.ShippingCondition AS ShippingCondition,
  SDH._ShippingCondition AS _ShippingCondition,
  SDH.IncotermsClassification AS IncotermsClassification,
  SDH._IncotermsClassification AS _IncotermsClassification,
  SDH.IncotermsTransferLocation AS IncotermsTransferLocation,
  SDH.IncotermsLocation1 AS IncotermsLocation1,
  SDH.IncotermsLocation2 AS IncotermsLocation2,
  SDH.IncotermsVersion AS IncotermsVersion,
  SDH._IncotermsVersion AS _IncotermsVersion,
  SDH.CompleteDeliveryIsDefined AS CompleteDeliveryIsDefined,
  SDH.DeliveryBlockReason AS DeliveryBlockReason,
  SDH._DeliveryBlockReason AS _DeliveryBlockReason,
  SDH.BillingDocumentDate AS BillingDocumentDate,
  SDH.BillingCompanyCode AS BillingCompanyCode,
  SDH._BillingCompanyCode AS _BillingCompanyCode,
  SDH.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  SDH._HeaderBillingBlockReason AS _HeaderBillingBlockReason,
  SDH.CustomerPaymentTerms AS CustomerPaymentTerms,
  SDH._CustomerPaymentTerms AS _CustomerPaymentTerms,
  SDH.PaymentMethod AS PaymentMethod,
  SDH.FixedValueDate AS FixedValueDate,
  CustomerProjectItem.EngagementProject AS CustomerProject,
  SDH.FiscalYear AS FiscalYear,
  SDH.FiscalPeriod AS FiscalPeriod,
  SDH.ExchangeRateType AS ExchangeRateType,
  SDH._ExchangeRateType AS _ExchangeRateType,
  SDH.BusinessArea AS BusinessArea,
  SDH._BusinessArea AS _BusinessArea,
  SDH.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
  SDH._CustomerAccountAssgmtGroup AS _CustomerAccountAssgmtGroup,
  cast(SDH.CostCenterBusinessArea as business_area_cost_center preserving type) AS CostCenterBusinessArea,
  SDH._CostCenterBusinessArea AS _CostCenterBusinessArea,
  SDH.CostCenter AS CostCenter,
  SDH._CostCenter AS _CostCenter,
  SDH.ControllingArea AS ControllingArea,
  SDH._ControllingArea AS _ControllingArea,
  SDH.OrderID AS OrderID,
  cast(SDH.ControllingObject as controlling_object) AS ControllingObject,
  SDH.ReferenceSDDocument AS ReferenceSDDocument,
  SDH.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  SDH._ReferenceSDDocumentCategory AS _ReferenceSDDocumentCategory,
  SDH.BusinessSolutionOrder AS BusinessSolutionOrder,
  cast(SDH.OverallSDProcessStatus as overall_sd_process_status preserving type) AS OverallSDProcessStatus,
  SDH._OverallSDProcessStatus AS _OverallSDProcessStatus,
  cast(SDH.OverallPurchaseConfStatus as overall_purchase_conf_status preserving type) AS OverallPurchaseConfStatus,
  SDH._OverallPurchaseConfStatus AS _OverallPurchaseConfStatus,
  cast(SDH.OverallSDDocumentRejectionSts as ovrl_sd_doc_rejection_status preserving type) AS OverallSDDocumentRejectionSts,
  SDH._OverallSDDocumentRejectionSts AS _OverallSDDocumentRejectionSts,
  SDH.TotalBlockStatus AS TotalBlockStatus,
  SDH._TotalBlockStatus AS _TotalBlockStatus,
  cast(SDH.OverallDelivConfStatus as overall_delivery_conf_status preserving type) AS OverallDelivConfStatus,
  SDH._OverallDelivConfStatus AS _OverallDelivConfStatus,
  cast(SDH.OverallTotalDeliveryStatus as itms_ovrl_delivery_status preserving type) AS OverallTotalDeliveryStatus,
  SDH._OverallTotalDeliveryStatus AS _OverallTotalDeliveryStatus,
  cast(SDH.OverallDeliveryStatus as overall_delivery_status preserving type) AS OverallDeliveryStatus,
  SDH._OverallDeliveryStatus AS _OverallDeliveryStatus,
  cast(SDH.OverallDeliveryBlockStatus as overall_delivery_block_status preserving type) AS OverallDeliveryBlockStatus,
  SDH._OverallDeliveryBlockStatus AS _OverallDeliveryBlockStatus,
  cast(SDH.OverallOrdReltdBillgStatus as ovrl_ord_rel_billg_status preserving type) AS OverallOrdReltdBillgStatus,
  SDH._OverallOrdReltdBillgStatus AS _OverallOrdReltdBillgStatus,
  cast(SDH.OverallBillingBlockStatus as overall_billing_block_status preserving type) AS OverallBillingBlockStatus,
  SDH._OverallBillingBlockStatus AS _OverallBillingBlockStatus,
  cast(SDH.OverallTotalSDDocRefStatus as ovrl_reference_status preserving type) AS OverallTotalSDDocRefStatus,
  SDH._OverallTotalSDDocRefStatus AS _OverallTotalSDDocRefStatus,
  cast(SDH.OverallSDDocReferenceStatus as ovrl_sd_doc_reference_status preserving type) AS OverallSDDocReferenceStatus,
  SDH._OverallSDDocReferenceStatus AS _OverallSDDocReferenceStatus,
  SDH.TotalCreditCheckStatus AS TotalCreditCheckStatus,
  SDH._TotalCreditCheckStatus AS _TotalCreditCheckStatus,
  SDH.MaxDocValueCreditCheckStatus AS MaxDocValueCreditCheckStatus,
  SDH._MaxDocValueCreditCheckStatus AS _MaxDocValueCreditCheckStatus,
  cast(SDH.PaymentTermCreditCheckStatus as payt_terms_credit_check_status preserving type) AS PaymentTermCreditCheckStatus,
  SDH._PaymentTermCreditCheckStatus AS _PaymentTermCreditCheckStatus,
  SDH.FinDocCreditCheckStatus AS FinDocCreditCheckStatus,
  SDH._FinDocCreditCheckStatus AS _FinDocCreditCheckStatus,
  SDH.ExprtInsurCreditCheckStatus AS ExprtInsurCreditCheckStatus,
  SDH._ExprtInsurCreditCheckStatus AS _ExprtInsurCreditCheckStatus,
  SDH.PaytAuthsnCreditCheckSts AS PaytAuthsnCreditCheckSts,
  SDH._PaytAuthsnCreditCheckSts AS _PaytAuthsnCreditCheckSts,
  cast(SDH.CentralCreditCheckStatus as central_credit_check_status preserving type) AS CentralCreditCheckStatus,
  SDH._CentralCreditCheckStatus AS _CentralCreditCheckStatus,
  cast(SDH.CentralCreditChkTechErrSts as centrl_crdt_chck_tech_err_sts preserving type) AS CentralCreditChkTechErrSts,
  SDH._CentralCreditChkTechErrSts AS _CentralCreditChkTechErrSts,
  cast(SDH.HdrGeneralIncompletionStatus as hdr_general_incompltn_status preserving type) AS HdrGeneralIncompletionStatus,
  SDH._HdrGeneralIncompletionStatus AS _HdrGeneralIncompletionStatus,
  cast(SDH.OverallPricingIncompletionSts as ovrl_pricing_incompletion_sts preserving type) AS OverallPricingIncompletionSts,
  SDH._OverallPricingIncompletionSts AS _OverallPricingIncompletionSts,
  cast(SDH.HeaderDelivIncompletionStatus as hdrdelivincompletionstatus preserving type) AS HeaderDelivIncompletionStatus,
  SDH._HeaderDelivIncompletionStatus AS _HeaderDelivIncompletionStatus,
  cast(SDH.HeaderBillgIncompletionStatus as hdrbillgincompletionstatus preserving type) AS HeaderBillgIncompletionStatus,
  SDH._HeaderBillgIncompletionStatus AS _HeaderBillgIncompletionStatus,
  cast(SDH.OvrlItmGeneralIncompletionSts as itms_ovrl_incompletion_status preserving type) AS OvrlItmGeneralIncompletionSts,
  SDH._OvrlItmGeneralIncompletionSts AS _OvrlItmGeneralIncompletionSts,
  cast(SDH.OvrlItmBillingIncompletionSts as ovrl_itms_incompltn_sts_billg preserving type) AS OvrlItmBillingIncompletionSts,
  SDH._OvrlItmBillingIncompletionSts AS _OvrlItmBillingIncompletionSts,
  cast(SDH.OvrlItmDelivIncompletionSts as ovrl_items_dlv_incompltn_sts preserving type) AS OvrlItmDelivIncompletionSts,
  SDH._OvrlItmDelivIncompletionSts AS _OvrlItmDelivIncompletionSts
FROM I_SalesDocument AS SDH
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_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 E_SalesDocumentBasic AS _Extension ON SDH.SalesDocument = _Extension.SalesDocument  -- association [0..1]
;