I_SalesOrderItemDeliveryBlkd

SOFM Sales Order Item Delivery Blocked | view: ISLSORDITEMSO02 | 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, T001W, CVI_VEND_LINK, TJ07, TJ31

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities (1)
📅 Dates
☰ Categorical (1)
Other (6)
🔗 Relations (12)

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
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
Schedule Line Blocked for Delivery Schedule Line Blocked for Delivery Client	`I_SALESORDERITEMDELIVERYBLKD.DELIVERYBLOCKREASON == TVLS.LIFSP` `I_SALESORDERITEMDELIVERYBLKD.MANDT == TVLS.MANDT`
Distribution channel in order header Distribution Channel Client Sales Organization	`I_SALESORDERITEMDELIVERYBLKD.DISTRIBUTIONCHANNEL == TVKOV.VTWEG` `I_SALESORDERITEMDELIVERYBLKD.MANDT == TVKOV.MANDT` `I_SALESORDERITEMDELIVERYBLKD.SALESORGANIZATION == TVKOV.VKORG`
Material: order item Material Number Client	`I_SALESORDERITEMDELIVERYBLKD.MATERIAL == MARA.MATNR` `I_SALESORDERITEMDELIVERYBLKD.MANDT == MARA.MANDT`
Sales unit Client Sales unit	`I_SALESORDERITEMDELIVERYBLKD.MANDT == T006.MANDT` `I_SALESORDERITEMDELIVERYBLKD.ORDERQUANTITYUNIT == T006.MSEHI`
Division in order header Distribution Channel Client Division Sales Organization	`I_SALESORDERITEMDELIVERYBLKD.DISTRIBUTIONCHANNEL == TVTA.VTWEG` `I_SALESORDERITEMDELIVERYBLKD.MANDT == TVTA.MANDT` `I_SALESORDERITEMDELIVERYBLKD.ORGANIZATIONDIVISION == TVTA.SPART` `I_SALESORDERITEMDELIVERYBLKD.SALESORGANIZATION == TVTA.VKORG`
Route Route Client	`I_SALESORDERITEMDELIVERYBLKD.ROUTE == TVRO.ROUTE` `I_SALESORDERITEMDELIVERYBLKD.MANDT == TVRO.MANDT`
Sales document item category Client Sales document item category	`I_SALESORDERITEMDELIVERYBLKD.MANDT == TVPT.MANDT` `I_SALESORDERITEMDELIVERYBLKD.SALESORDERITEMCATEGORY == TVPT.PSTYV`
Order type in order header Client Sales Document Type	`I_SALESORDERITEMDELIVERYBLKD.MANDT == TVAK.MANDT` `I_SALESORDERITEMDELIVERYBLKD.SALESORDERTYPE == TVAK.AUART`
Sales organization in order header Client Sales Organization	`I_SALESORDERITEMDELIVERYBLKD.MANDT == TVKO.MANDT` `I_SALESORDERITEMDELIVERYBLKD.SALESORGANIZATION == TVKO.VKORG`
Shipping Point / Receiving Point Shipping Point / Receiving Point Client	`I_SALESORDERITEMDELIVERYBLKD.SHIPPINGPOINT == TVST.VSTEL` `I_SALESORDERITEMDELIVERYBLKD.MANDT == TVST.MANDT`
SD Document Currency Client SD Document Currency	`I_SALESORDERITEMDELIVERYBLKD.MANDT == TCURC.MANDT` `I_SALESORDERITEMDELIVERYBLKD.TRANSACTIONCURRENCY == TCURC.WAERS`