C_SalesDocumentItemDEX

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 C_SalesDocumentItemDEX.
-- 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: CSDSLSDOCITMDX

CREATE VIEW C_SalesDocumentItemDEX AS
SELECT
  SalesDocumentItem.SalesDocument AS SalesDocument,
  SalesDocumentItem.SalesDocumentItem AS SalesDocumentItem,
  SalesDocument.SDDocumentCategory AS SDDocumentCategory,
  SalesDocument.SalesDocumentType AS SalesDocumentType,
  SalesDocumentItem.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  SalesDocumentItem.IsReturnsItem AS IsReturnsItem,
  SalesDocumentItem.CreationDate AS CreationDate,
  SalesDocumentItem.CreationTime AS CreationTime,
  SalesDocumentItem.LastChangeDate AS LastChangeDate,
  SalesDocument.SalesOrganization AS SalesOrganization,
  SalesDocument.DistributionChannel AS DistributionChannel,
  SalesDocumentItem.Division AS Division,
  SalesDocument.SalesGroup AS SalesGroup,
  SalesDocument.SalesOffice AS SalesOffice,
  SalesDocumentItem.InternationalArticleNumber AS InternationalArticleNumber,
  SalesDocumentItem.Batch AS Batch,
  SalesDocumentItem.Material AS Material,
  SalesDocumentItem.Product AS Product,
  SalesDocumentItem.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  SalesDocumentItem.MaterialSubstitutionReason AS MaterialSubstitutionReason,
  SalesDocumentItem.MaterialGroup AS MaterialGroup,
  SalesDocumentItem.ProductGroup AS ProductGroup,
  SalesDocumentItem.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  SalesDocumentItem.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  SalesDocumentItem.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  SalesDocumentItem.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  SalesDocumentItem.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  SalesDocument.SoldToParty AS SoldToParty,
  SalesDocument.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  SalesDocument.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  SalesDocument.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  SalesDocument.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  SalesDocument.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  SalesDocumentItem.ShipToParty AS ShipToParty,
  SalesDocumentItem.PayerParty AS PayerParty,
  SalesDocumentItem.BillToParty AS BillToParty,
  SalesDocument.SDDocumentReason AS SDDocumentReason,
  SalesDocument.SalesDocumentDate AS SalesDocumentDate,
  SalesDocumentItem.OrderQuantity AS OrderQuantity,
  SalesDocumentItem.OrderQuantityUnit AS OrderQuantityUnit,
  SalesDocumentItem.TargetQuantity AS TargetQuantity,
  SalesDocumentItem.TargetQuantityUnit AS TargetQuantityUnit,
  SalesDocumentItem.TargetToBaseQuantityDnmntr AS TargetToBaseQuantityDnmntr,
  SalesDocumentItem.TargetToBaseQuantityNmrtr AS TargetToBaseQuantityNmrtr,
  SalesDocumentItem.OrderToBaseQuantityDnmntr AS OrderToBaseQuantityDnmntr,
  SalesDocumentItem.OrderToBaseQuantityNmrtr AS OrderToBaseQuantityNmrtr,
  SalesDocumentItem.ConfdDelivQtyInOrderQtyUnit AS ConfdDelivQtyInOrderQtyUnit,
  SalesDocumentItem.TargetDelivQtyInOrderQtyUnit AS TargetDelivQtyInOrderQtyUnit,
  SalesDocumentItem.ConfdDeliveryQtyInBaseUnit AS ConfdDeliveryQtyInBaseUnit,
  SalesDocumentItem.BaseUnit AS BaseUnit,
  SalesDocumentItem.ItemNetWeight AS ItemNetWeight,
  SalesDocumentItem.ItemWeightUnit AS ItemWeightUnit,
  SalesDocumentItem.ItemVolume AS ItemVolume,
  SalesDocumentItem.ItemVolumeUnit AS ItemVolumeUnit,
  SalesDocumentItem.ServicesRenderedDate AS ServicesRenderedDate,
  SalesDocumentItem.SalesDistrict AS SalesDistrict,
  SalesDocumentItem.CustomerGroup AS CustomerGroup,
  SalesDocument.HdrOrderProbabilityInPercent AS HdrOrderProbabilityInPercent,
  SalesDocumentItem.ItemOrderProbabilityInPercent AS ItemOrderProbabilityInPercent,
  SalesDocumentItem.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  SalesDocumentItem.PricingDate AS PricingDate,
  SalesDocumentItem.ExchangeRateDate AS ExchangeRateDate,
  SalesDocumentItem.PriceDetnExchangeRate AS PriceDetnExchangeRate,
  SalesDocumentItem.StatisticalValueControl AS StatisticalValueControl,
  SalesDocumentItem.NetAmount AS NetAmount,
  SalesDocumentItem.TransactionCurrency AS TransactionCurrency,
  SalesDocumentItem._SalesOrganization.SalesOrganizationCurrency AS SalesOrganizationCurrency,
  SalesDocumentItem.NetPriceAmount AS NetPriceAmount,
  SalesDocumentItem.NetPriceQuantity AS NetPriceQuantity,
  SalesDocumentItem.NetPriceQuantityUnit AS NetPriceQuantityUnit,
  SalesDocumentItem.TaxAmount AS TaxAmount,
  SalesDocumentItem.CostAmount AS CostAmount,
  SalesDocumentItem.Subtotal1Amount AS Subtotal1Amount,
  SalesDocumentItem.Subtotal2Amount AS Subtotal2Amount,
  SalesDocumentItem.Subtotal3Amount AS Subtotal3Amount,
  SalesDocumentItem.Subtotal4Amount AS Subtotal4Amount,
  SalesDocumentItem.Subtotal5Amount AS Subtotal5Amount,
  SalesDocumentItem.Subtotal6Amount AS Subtotal6Amount,
  SalesDocumentItem.ShippingPoint AS ShippingPoint,
  SalesDocumentItem.ShippingType AS ShippingType,
  SalesDocumentItem.DeliveryPriority AS DeliveryPriority,
  SalesDocumentItem.InventorySpecialStockType AS InventorySpecialStockType,
  SalesDocument.RequestedDeliveryDate AS RequestedDeliveryDate,
  SalesDocument.ShippingCondition AS ShippingCondition,
  SalesDocument.DeliveryBlockReason AS DeliveryBlockReason,
  SalesDocumentItem.Plant AS Plant,
  SalesDocumentItem.StorageLocation AS StorageLocation,
  SalesDocumentItem.Route AS Route,
  SalesDocumentItem.IncotermsClassification AS IncotermsClassification,
  SalesDocumentItem.IncotermsVersion AS IncotermsVersion,
  SalesDocumentItem.IncotermsTransferLocation AS IncotermsTransferLocation,
  SalesDocumentItem.IncotermsLocation1 AS IncotermsLocation1,
  SalesDocumentItem.IncotermsLocation2 AS IncotermsLocation2,
  SalesDocumentItem.MinDeliveryQtyInBaseUnit AS MinDeliveryQtyInBaseUnit,
  SalesDocumentItem.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  SalesDocumentItem.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  SalesDocumentItem.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  SalesDocumentItem.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
  SalesDocument.BindingPeriodValidityStartDate AS BindingPeriodValidityStartDate,
  SalesDocument.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  SalesDocumentItem.BillingDocumentDate AS BillingDocumentDate,
  SalesDocument.BillingCompanyCode AS BillingCompanyCode,
  SalesDocument.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  SalesDocumentItem.ItemBillingBlockReason AS ItemBillingBlockReason,
  SalesDocumentItem.FiscalPeriod AS FiscalPeriod,
  SalesDocumentItem.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
  SalesDocument.ExchangeRateType AS ExchangeRateType,
  CompanyCode.Currency AS Currency,
  CompanyCode.FiscalYearVariant AS FiscalYearVariant,
  SalesDocumentItem.BusinessArea AS BusinessArea,
  SalesDocumentItem.ProfitCenter AS ProfitCenter,
  SalesDocumentItem.OrderID AS OrderID,
  ProfitabilitySegment_2,
  SalesDocument.ControllingArea AS ControllingArea,
  SalesDocumentItem.ReferenceSDDocument AS ReferenceSDDocument,
  SalesDocumentItem.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  SalesDocumentItem.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  SalesDocumentItem.OriginSDDocument AS OriginSDDocument,
  SalesDocumentItem.OriginSDDocumentItem AS OriginSDDocumentItem,
  SalesDocument.OverallSDProcessStatus AS OverallSDProcessStatus,
  SalesDocument.OverallTotalDeliveryStatus AS OverallTotalDeliveryStatus,
  SalesDocument.OverallOrdReltdBillgStatus AS OverallOrdReltdBillgStatus,
  SalesDocument.TotalCreditCheckStatus AS TotalCreditCheckStatus,
  SalesDocument.OverallSDDocumentRejectionSts AS OverallSDDocumentRejectionSts,
  SalesDocument.OverallTotalSDDocRefStatus AS OverallTotalSDDocRefStatus,
  SalesDocument.OverallSDDocReferenceStatus AS OverallSDDocReferenceStatus,
  SalesDocument.OverallDeliveryStatus AS OverallDeliveryStatus,
  SalesDocumentItem.BillingBlockStatus AS BillingBlockStatus,
  SalesDocumentItem.TotalSDDocReferenceStatus AS TotalSDDocReferenceStatus,
  SalesDocumentItem.SDDocReferenceStatus AS SDDocReferenceStatus,
  SalesDocumentItem.SDDocumentRejectionStatus AS SDDocumentRejectionStatus,
  SalesDocumentItem.ItemGeneralIncompletionStatus AS ItemGeneralIncompletionStatus,
  SalesDocumentItem.ItemBillingIncompletionStatus AS ItemBillingIncompletionStatus,
  SalesDocumentItem.PricingIncompletionStatus AS PricingIncompletionStatus,
  SalesDocumentItem.ItemDeliveryIncompletionStatus AS ItemDeliveryIncompletionStatus,
  SalesDocumentItem.OrderRelatedBillingStatus AS OrderRelatedBillingStatus,
  SalesDocumentItem.SDProcessStatus AS SDProcessStatus,
  SalesDocumentItem.TotalDeliveryStatus AS TotalDeliveryStatus,
  SalesDocumentItem.DeliveryStatus AS DeliveryStatus
FROM I_SalesDocumentItem AS SalesDocumentItem
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _ExtensionItem ON SalesDocument = _ExtensionItem.SalesDocument AND SalesDocumentItem = _ExtensionItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _ExtensionHeader ON SalesDocument = _ExtensionHeader.SalesDocument  -- association [0..1]
;