I_SalesQuotationItemCube

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_SalesQuotationItemCube.
-- 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.

CREATE VIEW I_SalesQuotationItemCube AS
SELECT
  cast(SDIA.SalesDocument as sales_quotation preserving type) AS SalesQuotation,
  cast(SDIA.SalesDocumentItem as sales_quotation_item preserving type) AS SalesQuotationItem,
  SDIA.SalesDocumentType AS SalesQuotationType,
  SDIA.SalesDocumentItemType AS SalesQuotationItemType,
  SDIA.SalesDocumentItemCategory AS SalesQuotationItemCategory,
  SDIA._ItemCategory AS _ItemCategory,
  SDIA.CreatedByUser AS CreatedByUser,
  SDIA._CreatedByUser AS _CreatedByUser,
  SDIA.CreationDate AS CreationDate,
  SDIA.CreationTime AS CreationTime,
  SDIA.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(CalendarDateSalesQuotation.CalendarYear as sales_quotation_date_year) AS SalesQuotationDateYear,
  cast(CalendarDateSalesQuotation.YearQuarter as sales_qtan_date_year_quarter) AS SalesQuotationDateYearQuarter,
  cast(CalendarDateSalesQuotation.YearMonth as sales_qtan_date_year_month) AS SalesQuotationDateYearMonth,
  SDIA.BindingPeriodValidityStartDate AS BindingPeriodValidityStartDate,
  SDIA.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  SDIA.SalesOrganization AS SalesOrganization,
  SDIA._SalesOrganization AS _SalesOrganization,
  SDIA.DistributionChannel AS DistributionChannel,
  SDIA._DistributionChannel AS _DistributionChannel,
  cast(SDIA.OrganizationDivision as organization_division preserving type ) AS OrganizationDivision,
  SDIA._OrganizationDivision AS _OrganizationDivision,
  SDIA.Division AS Division,
  SDIA._Division AS _Division,
  SDIA.SalesOffice AS SalesOffice,
  SDIA._SalesOffice AS _SalesOffice,
  SDIA.SalesGroup AS SalesGroup,
  SDIA._SalesGroup AS _SalesGroup,
  SDIA.SoldToParty AS SoldToParty,
  SDIA._SoldToParty AS _SoldToParty,
  SDIA.ShipToParty AS ShipToParty,
  SDIA._ShipToParty AS _ShipToParty,
  SDIA.CustomerGroup AS CustomerGroup,
  SDIA._CustomerGroup AS _CustomerGroup,
  SDIA.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  SDIA._AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1,
  SDIA.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  SDIA._AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2,
  SDIA.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  SDIA._AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3,
  SDIA.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  SDIA._AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4,
  SDIA.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  SDIA._AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5,
  SalesDocumentDate AS SalesQuotationDate,
  SDIA.SDDocumentReason AS SDDocumentReason,
  SDIA._SDDocumentReason AS _SDDocumentReason,
  SDIA.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
  SDIA.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  SDIA.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  SDIA.RequestedDeliveryDate AS RequestedDeliveryDate,
  SDIA.SalesDocumentItemText AS SalesQuotationItemText,
  SDIA.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  SDIA._SalesDocumentRjcnReason AS _SalesDocumentRjcnReason,
  SDIA.SlsQtanToOrdProbltyInPercent AS SlsQtanToOrdProbltyInPercent,
  SDIA.ShippingCondition AS ShippingCondition,
  SDIA._ShippingCondition AS _ShippingCondition,
  SDIA.CompleteDeliveryIsDefined AS CompleteDeliveryIsDefined,
  SDIA.DeliveryBlockReason AS DeliveryBlockReason,
  SDIA._DeliveryBlockReason AS _DeliveryBlockReason,
  SDIA.ShippingPoint AS ShippingPoint,
  SDIA._ShippingPoint AS _ShippingPoint,
  SDIA.DeliveryPriority AS DeliveryPriority,
  SDIA._DeliveryPriority AS _DeliveryPriority,
  SDIA.ShippingType AS ShippingType,
  SDIA._ShippingType AS _ShippingType,
  SDIA.Route AS Route,
  SDIA.Product AS Product,
  SDIA.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  SDIA.MaterialByCustomer AS MaterialByCustomer,
  SDIA.MaterialGroup AS MaterialGroup,
  SDIA.ProductGroup AS ProductGroup,
  SDIA.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  SDIA._AdditionalMaterialGroup1 AS _AdditionalMaterialGroup1,
  SDIA.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  SDIA._AdditionalMaterialGroup2 AS _AdditionalMaterialGroup2,
  SDIA.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  SDIA._AdditionalMaterialGroup3 AS _AdditionalMaterialGroup3,
  SDIA.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  SDIA._AdditionalMaterialGroup4 AS _AdditionalMaterialGroup4,
  SDIA.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  SDIA._AdditionalMaterialGroup5 AS _AdditionalMaterialGroup5,
  SDIA.Plant AS Plant,
  SDIA._Plant AS _Plant,
  SDIA.StorageLocation AS StorageLocation,
  SDIA._StorageLocation AS _StorageLocation,
  SDIA.ItemWeightUnit AS ItemWeightUnit,
  SDIA._ItemWeightUnit AS _ItemWeightUnit,
  SDIA.ItemGrossWeight AS ItemGrossWeight,
  SDIA.ItemNetWeight AS ItemNetWeight,
  SDIA.ItemVolumeUnit AS ItemVolumeUnit,
  SDIA._ItemVolumeUnit AS _ItemVolumeUnit,
  SDIA.ItemVolume AS ItemVolume,
  SDIA.PricingDate AS PricingDate,
  SDIA.SalesDistrict AS SalesDistrict,
  SDIA._SalesDistrict AS _SalesDistrict,
  SDIA.ExchangeRateDate AS ExchangeRateDate,
  SDIA.PriceDetnExchangeRate AS PriceDetnExchangeRate,
  SDIA.TaxAmount AS TaxAmount,
  SDIA.CostAmount AS CostAmount,
  SDIA.Subtotal1Amount AS Subtotal1Amount,
  SDIA.Subtotal2Amount AS Subtotal2Amount,
  SDIA.Subtotal3Amount AS Subtotal3Amount,
  SDIA.Subtotal4Amount AS Subtotal4Amount,
  SDIA.Subtotal5Amount AS Subtotal5Amount,
  SDIA.Subtotal6Amount AS Subtotal6Amount,
  SDIA.BaseUnit AS BaseUnit,
  SDIA._BaseUnit AS _BaseUnit,
  SDIA.TransactionCurrency AS TransactionCurrency,
  SDIA._TransactionCurrency AS _TransactionCurrency,
  SDIA.IncotermsVersion AS IncotermsVersion,
  SDIA.IncotermsClassification AS IncotermsClassification,
  SDIA._IncotermsClassification AS _IncotermsClassification,
  SDIA.IncotermsTransferLocation AS IncotermsTransferLocation,
  SDIA.IncotermsLocation1 AS IncotermsLocation1,
  SDIA.IncotermsLocation2 AS IncotermsLocation2,
  SDIA.CustomerPaymentTerms AS CustomerPaymentTerms,
  SDIA._CustomerPaymentTerms AS _CustomerPaymentTerms,
  SDIA.PaymentMethod AS PaymentMethod,
  SDIA.FixedValueDate AS FixedValueDate,
  SDIA.AdditionalValueDays AS AdditionalValueDays,
  SDIA.BillingCompanyCode AS BillingCompanyCode,
  SDIA._BillingCompanyCode AS _BillingCompanyCode,
  SDIA.BillingDocumentDate AS BillingDocumentDate,
  SDIA.FiscalYear AS FiscalYear,
  SDIA.FiscalPeriod AS FiscalPeriod,
  SDIA.BusinessArea AS BusinessArea,
  SDIA._BusinessArea AS _BusinessArea,
  SDIA.ProfitCenter AS ProfitCenter,
  SDIA.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
  SDIA.SalesQuotationNetAmount AS SalesQuotationNetAmount,
  SDIA.SalesQuotationQuantity AS SalesQuotationQuantity,
  SDIA.ReferenceSDDocument AS ReferenceSDDocument,
  SDIA._ReferenceSDDocument AS _ReferenceSDDocument,
  SDIA.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  SDIA._ReferenceSDDocumentItem AS _ReferenceSDDocumentItem,
  SDIA.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  SDIA._ReferenceSDDocumentCategory AS _ReferenceSDDocumentCategory,
  cast(SDIA.OverallSDProcessStatus as overall_sd_process_status preserving type) AS OverallSDProcessStatus,
  SDIA._OverallSDProcessStatus AS _OverallSDProcessStatus,
  cast(SDIA.OverallSDDocumentRejectionSts as ovrl_sd_doc_rejection_status preserving type) AS OverallSDDocumentRejectionSts,
  SDIA._OverallSDDocumentRejectionSts AS _OverallSDDocumentRejectionSts,
  SDIA.TotalBlockStatus AS TotalBlockStatus,
  SDIA._TotalBlockStatus AS _TotalBlockStatus,
  cast(SDIA.OverallDelivConfStatus as overall_delivery_conf_status preserving type) AS OverallDelivConfStatus,
  SDIA._OverallDelivConfStatus AS _OverallDelivConfStatus,
  cast(SDIA.OverallTotalDeliveryStatus as itms_ovrl_delivery_status preserving type) AS OverallTotalDeliveryStatus,
  SDIA._OverallTotalDeliveryStatus AS _OverallTotalDeliveryStatus,
  cast(SDIA.OverallDeliveryStatus as overall_delivery_status preserving type) AS OverallDeliveryStatus,
  SDIA._OverallDeliveryStatus AS _OverallDeliveryStatus,
  cast(SDIA.OverallDeliveryBlockStatus as overall_delivery_block_status preserving type) AS OverallDeliveryBlockStatus,
  SDIA._OverallDeliveryBlockStatus AS _OverallDeliveryBlockStatus,
  SDIA.OverallOrdReltdBillgStatus AS OverallOrdReltdBillgStatus,
  SDIA._OverallOrdReltdBillgStatus AS _OverallOrdReltdBillgStatus,
  cast(SDIA.OverallBillingBlockStatus as overall_billing_block_status preserving type) AS OverallBillingBlockStatus,
  SDIA._OverallBillingBlockStatus AS _OverallBillingBlockStatus,
  SDIA.OverallTotalSDDocRefStatus AS OverallTotalSDDocRefStatus,
  SDIA._OverallTotalSDDocRefStatus AS _OverallTotalSDDocRefStatus,
  cast(SDIA.OverallSDDocReferenceStatus as ovrl_sd_doc_reference_status preserving type) AS OverallSDDocReferenceStatus,
  SDIA._OverallSDDocReferenceStatus AS _OverallSDDocReferenceStatus,
  cast(SDIA.HdrGeneralIncompletionStatus as hdr_general_incompltn_status preserving type) AS HdrGeneralIncompletionStatus,
  SDIA._HdrGeneralIncompletionStatus AS _HdrGeneralIncompletionStatus,
  SDIA.HeaderDelivIncompletionStatus AS HeaderDelivIncompletionStatus,
  SDIA._HeaderDelivIncompletionStatus AS _HeaderDelivIncompletionStatus,
  SDIA.HeaderBillgIncompletionStatus AS HeaderBillgIncompletionStatus,
  SDIA._HeaderBillgIncompletionStatus AS _HeaderBillgIncompletionStatus,
  cast(SDIA.OvrlItmGeneralIncompletionSts as itms_ovrl_incompletion_status preserving type) AS OvrlItmGeneralIncompletionSts,
  SDIA._OvrlItmGeneralIncompletionSts AS _OvrlItmGeneralIncompletionSts,
  cast(SDIA.OvrlItmBillingIncompletionSts as ovrl_itms_incompltn_sts_billg preserving type) AS OvrlItmBillingIncompletionSts,
  SDIA._OvrlItmBillingIncompletionSts AS _OvrlItmBillingIncompletionSts,
  cast(SDIA.OvrlItmDelivIncompletionSts as ovrl_items_dlv_incompltn_sts preserving type) AS OvrlItmDelivIncompletionSts,
  SDIA._OvrlItmDelivIncompletionSts AS _OvrlItmDelivIncompletionSts,
  cast(SDIA.SDProcessStatus as sd_doc_process_status preserving type) AS SDProcessStatus,
  SDIA._SDProcessStatus AS _SDProcessStatus,
  cast(SDIA.DeliveryConfirmationStatus as delivery_confirmation_status preserving type) AS DeliveryConfirmationStatus,
  SDIA._DeliveryConfirmationStatus AS _DeliveryConfirmationStatus,
  SDIA.TotalDeliveryStatus AS TotalDeliveryStatus,
  SDIA._TotalDeliveryStatus AS _TotalDeliveryStatus,
  SDIA.DeliveryStatus AS DeliveryStatus,
  SDIA._DeliveryStatus AS _DeliveryStatus,
  SDIA.DeliveryBlockStatus AS DeliveryBlockStatus,
  SDIA._DeliveryBlockStatus AS _DeliveryBlockStatus,
  SDIA.OrderRelatedBillingStatus AS OrderRelatedBillingStatus,
  SDIA._OrderRelatedBillingStatus AS _OrderRelatedBillingStatus,
  SDIA.BillingBlockStatus AS BillingBlockStatus,
  SDIA._BillingBlockStatus AS _BillingBlockStatus,
  cast(SDIA.ItemGeneralIncompletionStatus as item_general_incompletion_sts preserving type) AS ItemGeneralIncompletionStatus,
  SDIA._ItemGeneralIncompletionStatus AS _ItemGeneralIncompletionStatus,
  cast(SDIA.ItemBillingIncompletionStatus as itms_incompltn_sts_billg preserving type) AS ItemBillingIncompletionStatus,
  SDIA._ItemBillingIncompletionStatus AS _ItemBillingIncompletionStatus,
  cast(SDIA.ItemDeliveryIncompletionStatus as itm_deliv_incompletion_status preserving type) AS ItemDeliveryIncompletionStatus,
  SDIA._ItemDelivIncompletionSts AS _ItemDelivIncompletionSts,
  cast(SDIA.SDDocumentRejectionStatus as sd_doc_rejection_status preserving type) AS SDDocumentRejectionStatus,
  SDIA._SDDocumentRejectionStatus AS _SDDocumentRejectionStatus,
  SDIA.TotalSDDocReferenceStatus AS TotalSDDocReferenceStatus,
  SDIA._TotalSDDocReferenceStatus AS _TotalSDDocReferenceStatus,
  cast(SDIA.PurchaseConfirmationStatus as purchase_confirmation_status preserving type) AS PurchaseConfirmationStatus,
  SDIA._PurchaseConfirmationStatus AS _PurchaseConfirmationStatus,
  cast(SDIA.PricingIncompletionStatus as pricing_incompletion_status preserving type) AS PricingIncompletionStatus,
  SDIA._PricingIncompletionStatus AS _PricingIncompletionStatus
FROM I_SalesQuotationItemAnalytics AS SDIA
LEFT OUTER JOIN I_SalesQuotation AS _SalesQuotation ON SalesQuotation = _SalesQuotation.SalesQuotation  -- association [1..1]
LEFT OUTER JOIN I_SalesQuotationType AS _SalesQuotationType ON SalesQuotationType = _SalesQuotationType.SalesQuotationType  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SDIA.SalesDocument = _Extension.SalesDocument AND SDIA.SalesDocumentItem = _Extension.SalesDocumentItem  -- association [0..1]
;