C_SalesOrderItemIncompleteQ

SOFM Incomplete Sales Order Item Query | view: CSLSORDITEMSO01Q | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, LIKP, LIPS, VBKD, VEDA, VBAK, FPLT, VBAK, VBAP, VBKD, VEDA, VBAP, VBEP, VBPA, VBPA, CVI_CUST_CT_LINK, BUT000, KNA1, CVI_CUST_LINK, MARA, MAKT, T001W, TVRO, TVROT, TVAP, TVAPT, TVST, TVSTT, CVI_VEND_LINK, TVBST, TVBST, TVBST, TVBST
Column Name Description
SalesOrder FK Sales Order
SalesOrderItem Sales Order Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Sales unit (OrderQuantityUnit):
OrderQuantity Cumulative order quantity in sales units
📏 Target Quantity UoM (TargetQuantityUnit):
TargetQuantity Target Quantity in Sales Units
Column Name Description
Column Name Description
ItemGeneralIncompletionStatus Incompletion Status (Item) Show values
ItemBillingIncompletionStatus Billing Incompletion Status (Item) Show values
PricingIncompletionStatus Pricing Incompletion Status (Item) Show values
ItemDeliveryIncompletionStatus Delivery Incompletion Status (Item) Show values
Column Name Description Domain name
DueDays null
SalesOrderItemCategoryName Description TEXT20
MaterialName Material Description TEXT40
ProductionPlant Plant (Own or External) WERKS
PlantName Plant Name TEXT30
SalesOrderItemText Short text for sales order item TEXT40
ShippingPointName Description TEXT30
RouteName Route Description TEXT40
ItemGenIncompletionStatusDesc Status Description TEXT20
ItemBillingIncompletionStsDesc Status Description TEXT20
PricingIncompletionStatusDesc Status Description TEXT20
ItemDelivIncompletionStsDesc Status Description TEXT20
ShipToParty Ship-to Party KUNNR
ShipToPartyName Name of Ship-to Party TEXT80
Master Data Relations Join Conditions
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • C_SALESORDERITEMINCOMPLETEQ.MANDT == TVKOV.MANDT
  • C_SALESORDERITEMINCOMPLETEQ.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_SALESORDERITEMINCOMPLETEQ.SALESORGANIZATION == TVKOV.VKORG
Material: order item
  • Material Number
  • Client
  • C_SALESORDERITEMINCOMPLETEQ.MATERIAL == MARA.MATNR
  • C_SALESORDERITEMINCOMPLETEQ.MANDT == MARA.MANDT
Sales unit
  • Sales unit
  • Client
  • C_SALESORDERITEMINCOMPLETEQ.ORDERQUANTITYUNIT == T006.MSEHI
  • C_SALESORDERITEMINCOMPLETEQ.MANDT == T006.MANDT
Division in order header
  • Division
  • Client
  • Distribution Channel
  • Sales Organization
  • C_SALESORDERITEMINCOMPLETEQ.ORGANIZATIONDIVISION == TVTA.SPART
  • C_SALESORDERITEMINCOMPLETEQ.MANDT == TVTA.MANDT
  • C_SALESORDERITEMINCOMPLETEQ.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_SALESORDERITEMINCOMPLETEQ.SALESORGANIZATION == TVTA.VKORG
Route
  • Route
  • Client
  • C_SALESORDERITEMINCOMPLETEQ.ROUTE == TVRO.ROUTE
  • C_SALESORDERITEMINCOMPLETEQ.MANDT == TVRO.MANDT
Sales document item category
  • Sales document item category
  • Client
  • C_SALESORDERITEMINCOMPLETEQ.SALESORDERITEMCATEGORY == TVPT.PSTYV
  • C_SALESORDERITEMINCOMPLETEQ.MANDT == TVPT.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • C_SALESORDERITEMINCOMPLETEQ.SALESORDERTYPE == TVAK.AUART
  • C_SALESORDERITEMINCOMPLETEQ.MANDT == TVAK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • C_SALESORDERITEMINCOMPLETEQ.MANDT == TVKO.MANDT
  • C_SALESORDERITEMINCOMPLETEQ.SALESORGANIZATION == TVKO.VKORG
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_SALESORDERITEMINCOMPLETEQ.MANDT == TVST.MANDT
  • C_SALESORDERITEMINCOMPLETEQ.SHIPPINGPOINT == TVST.VSTEL
Target Quantity UoM
  • Client
  • Target Quantity UoM
  • C_SALESORDERITEMINCOMPLETEQ.MANDT == T006.MANDT
  • C_SALESORDERITEMINCOMPLETEQ.TARGETQUANTITYUNIT == T006.MSEHI
SD Document Currency
  • Client
  • SD Document Currency
  • C_SALESORDERITEMINCOMPLETEQ.MANDT == TCURC.MANDT
  • C_SALESORDERITEMINCOMPLETEQ.TRANSACTIONCURRENCY == TCURC.WAERS