I_SalesOrderItemIncomplete

SOFM Incomplete Sales Order Item | view: ISLSORDITEMSO01 | 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, T001W, CVI_VEND_LINK
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
Plant Plant (Own or External) WERKS
PlantName Plant Name TEXT30
SalesOrderItemText Short text for sales order item TEXT40
ShipToParty Ship-to Party KUNNR
ShipToPartyName Name of Ship-to Party TEXT80
Master Data Relations Join Conditions
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • I_SALESORDERITEMINCOMPLETE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_SALESORDERITEMINCOMPLETE.MANDT == TVKOV.MANDT
  • I_SALESORDERITEMINCOMPLETE.SALESORGANIZATION == TVKOV.VKORG
Material: order item
  • Material Number
  • Client
  • I_SALESORDERITEMINCOMPLETE.MATERIAL == MARA.MATNR
  • I_SALESORDERITEMINCOMPLETE.MANDT == MARA.MANDT
Sales unit
  • Client
  • Sales unit
  • I_SALESORDERITEMINCOMPLETE.MANDT == T006.MANDT
  • I_SALESORDERITEMINCOMPLETE.ORDERQUANTITYUNIT == T006.MSEHI
Division in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • Division
  • I_SALESORDERITEMINCOMPLETE.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_SALESORDERITEMINCOMPLETE.MANDT == TVTA.MANDT
  • I_SALESORDERITEMINCOMPLETE.SALESORGANIZATION == TVTA.VKORG
  • I_SALESORDERITEMINCOMPLETE.ORGANIZATIONDIVISION == TVTA.SPART
Route
  • Route
  • Client
  • I_SALESORDERITEMINCOMPLETE.ROUTE == TVRO.ROUTE
  • I_SALESORDERITEMINCOMPLETE.MANDT == TVRO.MANDT
Sales document item category
  • Client
  • Sales document item category
  • I_SALESORDERITEMINCOMPLETE.MANDT == TVPT.MANDT
  • I_SALESORDERITEMINCOMPLETE.SALESORDERITEMCATEGORY == TVPT.PSTYV
Order type in order header
  • Client
  • Sales Document Type
  • I_SALESORDERITEMINCOMPLETE.MANDT == TVAK.MANDT
  • I_SALESORDERITEMINCOMPLETE.SALESORDERTYPE == TVAK.AUART
Sales organization in order header
  • Client
  • Sales Organization
  • I_SALESORDERITEMINCOMPLETE.MANDT == TVKO.MANDT
  • I_SALESORDERITEMINCOMPLETE.SALESORGANIZATION == TVKO.VKORG
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • I_SALESORDERITEMINCOMPLETE.SHIPPINGPOINT == TVST.VSTEL
  • I_SALESORDERITEMINCOMPLETE.MANDT == TVST.MANDT
Target Quantity UoM
  • Client
  • Target Quantity UoM
  • I_SALESORDERITEMINCOMPLETE.MANDT == T006.MANDT
  • I_SALESORDERITEMINCOMPLETE.TARGETQUANTITYUNIT == T006.MSEHI
SD Document Currency
  • SD Document Currency
  • Client
  • I_SALESORDERITEMINCOMPLETE.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_SALESORDERITEMINCOMPLETE.MANDT == TCURC.MANDT