C_SlsDocItemDeliveryBlkd

Sales Doc Item Delivery Blocked | view: CSLSDOCITEMSO02 | Extraction: Not supported | Component: Sales Analytics

Tables used: VBAP, VBAK, VBKD, VEDA, VBEP, JEST, JSTO, VBPA, MARA, ADCP, ADRC, CVI_CUST_CT_LINK, BUT000, T005, T005T, KNA1, KNMT, CVI_CUST_LINK, MAKT, T001W, MVKE, TVST, TVSTT, CVI_VEND_LINK, TJ07, TJ31

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

Column Name	Description
SalesDocument FK	Sales Document
SalesDocumentItem	Sales Document Item

Column Name	Description
💲 SD Document Currency (TransactionCurrency):
NetAmount	Net Value of the Order Item in Document Currency

Column Name	Description
📏 Unit of the Requested Quantity (RequestedQuantityUnit):
RequestedQuantity	Requested Quantity
📏 Sales unit (OrderQuantityUnit):
ConfdDelivQtyInOrderQtyUnit	Cumulative Confirmed Quantity in Sales Unit

Column Name	Description
RequestedDeliveryDate	Requested Delivery Date

Column Name	Description
CtrlgObjStatusIsDeliveryBlkd	User Status Delivery Blocked	Show values
DeliveryStatus	Delivery Status (Item)	Show values
SDProcessStatus	Overall Processing Status (Item)	Show values
OrderRelatedBillingStatus	Order-Related Billing Status (Item)	Show values
SDDocumentRejectionStatus	Rejection Status (Item)	Show values
ChmlCmplncStatus	Product Marketability Status (Item)	Show values
DangerousGoodsStatus	Dangerous Goods Status (Item)	Show values
SafetyDataSheetStatus	Safety Data Sheet Status (Item)	Show values

Column Name	Description	Domain name
DueDays	Next Action in Days	DUE_DAYS
MaterialName	Material Description	TEXT40
Plant	Plant (Own or External)	WERKS
MaterialByCustomer	Material Number Used by Customer	IDNEX
SalesDocumentItemText	Short text for sales order item	TEXT40
ShippingPointName	Description	TEXT30
ShippingPointCountry	Shipping Point Country or Region	LAND1
ShippingPointCountryName	Shipping Point Country or Region	TEXT50
ShipFromPartyCountryName	Ship-to Party Country or Region	TEXT50
ShipToParty	Ship-to Party	KUNNR
ShipToPartyName	Name of Ship-to Party	TEXT80
ShipToPartyCountry	Ship-to Party Country or Region	LAND1
ShipToPartyCountryName	Ship-to Party Country or Region	TEXT50
DeliveryBlockReasonCriticality	null
CtrlgObjStsIsDelivBlkdCritlty	null
ChmlCmplncStsCriticality	null
DngrsGdsStsCriticality	null

Master Data Relations	Join Conditions
Batch Number Product Number Batch Number Client Plant (Own or External)	`C_SLSDOCITEMDELIVERYBLKD.MATERIAL == MCHA.MATNR` `C_SLSDOCITEMDELIVERYBLKD.BATCH == MCHA.CHARG` `C_SLSDOCITEMDELIVERYBLKD.MANDT == MCHA.MANDT` `C_SLSDOCITEMDELIVERYBLKD.PLANT == MCHA.WERKS`
Schedule Line Blocked for Delivery Client Schedule Line Blocked for Delivery	`C_SLSDOCITEMDELIVERYBLKD.MANDT == TVLS.MANDT` `C_SLSDOCITEMDELIVERYBLKD.DELIVERYBLOCKREASON == TVLS.LIFSP`
Material: order item Product Number Client	`C_SLSDOCITEMDELIVERYBLKD.MATERIAL == MARA.MATNR` `C_SLSDOCITEMDELIVERYBLKD.MANDT == MARA.MANDT`
Product Group Client Product Group	`C_SLSDOCITEMDELIVERYBLKD.MANDT == T023.MANDT` `C_SLSDOCITEMDELIVERYBLKD.MATERIALGROUP == T023.MATKL`
Sales unit Client Sales unit	`C_SLSDOCITEMDELIVERYBLKD.MANDT == T006.MANDT` `C_SLSDOCITEMDELIVERYBLKD.ORDERQUANTITYUNIT == T006.MSEHI`
Sales document item category Sales document item category Client	`C_SLSDOCITEMDELIVERYBLKD.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV` `C_SLSDOCITEMDELIVERYBLKD.MANDT == TVPT.MANDT`
Country key Ship-from Party Country or Region Client	`C_SLSDOCITEMDELIVERYBLKD.SHIPFROMPARTYCOUNTRY == T005.LAND1` `C_SLSDOCITEMDELIVERYBLKD.MANDT == T005.MANDT`
Shipping Point / Receiving Point Client Shipping Point / Receiving Point	`C_SLSDOCITEMDELIVERYBLKD.MANDT == TVST.MANDT` `C_SLSDOCITEMDELIVERYBLKD.SHIPPINGPOINT == TVST.VSTEL`
Shipping Type Client Shipping Type	`C_SLSDOCITEMDELIVERYBLKD.MANDT == T173.MANDT` `C_SLSDOCITEMDELIVERYBLKD.SHIPPINGTYPE == T173.VSART`
Storage location Client Storage location Plant (Own or External)	`C_SLSDOCITEMDELIVERYBLKD.MANDT == T001L.MANDT` `C_SLSDOCITEMDELIVERYBLKD.STORAGELOCATION == T001L.LGORT` `C_SLSDOCITEMDELIVERYBLKD.PLANT == T001L.WERKS`
SD Document Currency Client SD Document Currency	`C_SLSDOCITEMDELIVERYBLKD.MANDT == TCURC.MANDT` `C_SLSDOCITEMDELIVERYBLKD.TRANSACTIONCURRENCY == TCURC.WAERS`