I_SalesOrderItemUnconfdQty

SOFM Sales Order Item With Unconfirmed Quantity | view: ISLSORDITEMSO06 | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, VBKD, VEDA, VBAK, 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
Column Name Description
Column Name Description
Column Name Description Domain name
DueDays Next Action in Days DUE_DAYS
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
  • Sales Organization
  • Distribution Channel
  • Client
  • I_SALESORDERITEMUNCONFDQTY.SALESORGANIZATION == TVKOV.VKORG
  • I_SALESORDERITEMUNCONFDQTY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_SALESORDERITEMUNCONFDQTY.MANDT == TVKOV.MANDT
Material: order item
  • Material Number
  • Client
  • I_SALESORDERITEMUNCONFDQTY.MATERIAL == MARA.MATNR
  • I_SALESORDERITEMUNCONFDQTY.MANDT == MARA.MANDT
Sales unit
  • Client
  • Sales unit
  • I_SALESORDERITEMUNCONFDQTY.MANDT == T006.MANDT
  • I_SALESORDERITEMUNCONFDQTY.ORDERQUANTITYUNIT == T006.MSEHI
Division in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • Division
  • I_SALESORDERITEMUNCONFDQTY.SALESORGANIZATION == TVTA.VKORG
  • I_SALESORDERITEMUNCONFDQTY.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_SALESORDERITEMUNCONFDQTY.MANDT == TVTA.MANDT
  • I_SALESORDERITEMUNCONFDQTY.ORGANIZATIONDIVISION == TVTA.SPART
Sales document item category
  • Sales document item category
  • Client
  • I_SALESORDERITEMUNCONFDQTY.SALESORDERITEMCATEGORY == TVPT.PSTYV
  • I_SALESORDERITEMUNCONFDQTY.MANDT == TVPT.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • I_SALESORDERITEMUNCONFDQTY.SALESORDERTYPE == TVAK.AUART
  • I_SALESORDERITEMUNCONFDQTY.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • I_SALESORDERITEMUNCONFDQTY.SALESORGANIZATION == TVKO.VKORG
  • I_SALESORDERITEMUNCONFDQTY.MANDT == TVKO.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • I_SALESORDERITEMUNCONFDQTY.SHIPPINGPOINT == TVST.VSTEL
  • I_SALESORDERITEMUNCONFDQTY.MANDT == TVST.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • I_SALESORDERITEMUNCONFDQTY.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_SALESORDERITEMUNCONFDQTY.MANDT == TCURC.MANDT