C_SalesOrderItemUnconfdQtyQ

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