C_SalesOrderItemDeliveryBlkdQ

SOFM Sales Order Item Delivery Blocked Query | view: CSLSORDITEMSO02Q | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBAP, VBEP, JEST, JSTO, VBPA, VBPA, CVI_CUST_CT_LINK, BUT000, KNA1, CVI_CUST_LINK, TVLS, TVLST, T001W, TVRO, TVROT, TVAP, TVAPT, TVST, TVSTT, CVI_VEND_LINK, TJ07, TJ31
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
CtrlgObjStatusIsDeliveryBlkd User Status Delivery Blocked Show values
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
RouteName Route Description TEXT40
ShipToParty Ship-to Party KUNNR
ShipToPartyName Name of Ship-to Party TEXT80
DeliveryBlockReasonText Description TEXT20
Master Data Relations Join Conditions
Schedule Line Blocked for Delivery
  • Schedule Line Blocked for Delivery
  • Client
  • C_SALESORDERITEMDELIVERYBLKDQ.DELIVERYBLOCKREASON == TVLS.LIFSP
  • C_SALESORDERITEMDELIVERYBLKDQ.MANDT == TVLS.MANDT
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • C_SALESORDERITEMDELIVERYBLKDQ.SALESORGANIZATION == TVKOV.VKORG
  • C_SALESORDERITEMDELIVERYBLKDQ.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_SALESORDERITEMDELIVERYBLKDQ.MANDT == TVKOV.MANDT
Material: order item
  • Client
  • Material Number
  • C_SALESORDERITEMDELIVERYBLKDQ.MANDT == MARA.MANDT
  • C_SALESORDERITEMDELIVERYBLKDQ.MATERIAL == MARA.MATNR
Sales unit
  • Sales unit
  • Client
  • C_SALESORDERITEMDELIVERYBLKDQ.ORDERQUANTITYUNIT == T006.MSEHI
  • C_SALESORDERITEMDELIVERYBLKDQ.MANDT == T006.MANDT
Division in order header
  • Sales Organization
  • Division
  • Distribution Channel
  • Client
  • C_SALESORDERITEMDELIVERYBLKDQ.SALESORGANIZATION == TVTA.VKORG
  • C_SALESORDERITEMDELIVERYBLKDQ.ORGANIZATIONDIVISION == TVTA.SPART
  • C_SALESORDERITEMDELIVERYBLKDQ.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_SALESORDERITEMDELIVERYBLKDQ.MANDT == TVTA.MANDT
Route
  • Client
  • Route
  • C_SALESORDERITEMDELIVERYBLKDQ.MANDT == TVRO.MANDT
  • C_SALESORDERITEMDELIVERYBLKDQ.ROUTE == TVRO.ROUTE
Sales document item category
  • Sales document item category
  • Client
  • C_SALESORDERITEMDELIVERYBLKDQ.SALESORDERITEMCATEGORY == TVPT.PSTYV
  • C_SALESORDERITEMDELIVERYBLKDQ.MANDT == TVPT.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • C_SALESORDERITEMDELIVERYBLKDQ.SALESORDERTYPE == TVAK.AUART
  • C_SALESORDERITEMDELIVERYBLKDQ.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • C_SALESORDERITEMDELIVERYBLKDQ.SALESORGANIZATION == TVKO.VKORG
  • C_SALESORDERITEMDELIVERYBLKDQ.MANDT == TVKO.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • C_SALESORDERITEMDELIVERYBLKDQ.SHIPPINGPOINT == TVST.VSTEL
  • C_SALESORDERITEMDELIVERYBLKDQ.MANDT == TVST.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • C_SALESORDERITEMDELIVERYBLKDQ.MANDT == TCURC.MANDT
  • C_SALESORDERITEMDELIVERYBLKDQ.TRANSACTIONCURRENCY == TCURC.WAERS