C_DelivDocItemShippingBlkd

Delivery Doc Item Shipping Blocked | view: CDELIVDOCITMDE01 | Extraction: Not supported | Component: Sales Analytics
Tables used: LIKP, LIPS, VBAK, MARA, MAKT, T300, T30C, T30CT, T300T
Column Name Description
DeliveryDocument FK Delivery
DeliveryDocumentItem Delivery Item
Column Name Description
Column Name Description
📏 Sales unit (DeliveryQuantityUnit):
ActualDeliveryQuantity Actual quantity delivered (in sales units)
📏 Weight Unit (ItemWeightUnit):
ItemGrossWeight Gross weight
ItemNetWeight Net weight
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume
Column Name Description
Column Name Description
StockType Stock Type Show values
PickingStatus Picking Status/Putaway Status (Item) Show values
DeliveryRelatedBillingStatus Delivery-Related Billing Status (Item) Show values
PackingStatus Packing Status (Item) Show values
PickingConfirmationStatus Confirmation Status of Picking/Putaway Show values
WarehouseActivityStatus Status of Warehouse Management Activities (Item) Show values
GoodsMovementStatus Goods Movement 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
DeliveryDocumentItemText Short text for sales order item TEXT40
DueDays Next Action in Days DUE_DAYS
MaterialName Material Description TEXT40
MaterialByCustomer Customer Material IDNEX
WarehouseName Warehouse Number Description TEXT25
WarehouseStagingAreaName Text for matl staging area TEXT25
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
ChmlCmplncStsCriticality null
DngrsGdsStsCriticality null
SftyDataShtStatCriticality null
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Product Number
  • Client
  • Plant
  • C_DELIVDOCITEMSHIPPINGBLKD.BATCH == MCHA.CHARG
  • C_DELIVDOCITEMSHIPPINGBLKD.MATERIAL == MCHA.MATNR
  • C_DELIVDOCITEMSHIPPINGBLKD.MANDT == MCHA.MANDT
  • C_DELIVDOCITEMSHIPPINGBLKD.PLANT == MCHA.WERKS
Delivery item category
  • Client
  • Delivery item category
  • C_DELIVDOCITEMSHIPPINGBLKD.MANDT == TVPT.MANDT
  • C_DELIVDOCITEMSHIPPINGBLKD.DELIVERYDOCUMENTITEMCATEGORY == TVPT.PSTYV
Sales unit
  • Client
  • Sales unit
  • C_DELIVDOCITEMSHIPPINGBLKD.MANDT == T006.MANDT
  • C_DELIVDOCITEMSHIPPINGBLKD.DELIVERYQUANTITYUNIT == T006.MSEHI
Movement type (inventory management)
  • Client
  • Movement type (inventory management)
  • C_DELIVDOCITEMSHIPPINGBLKD.MANDT == T156.MANDT
  • C_DELIVDOCITEMSHIPPINGBLKD.GOODSMOVEMENTTYPE == T156.BWART
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • C_DELIVDOCITEMSHIPPINGBLKD.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • C_DELIVDOCITEMSHIPPINGBLKD.MANDT == T148.MANDT
Billing Block
  • Client
  • Billing Block
  • C_DELIVDOCITEMSHIPPINGBLKD.MANDT == TVFS.MANDT
  • C_DELIVDOCITEMSHIPPINGBLKD.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
Volume unit
  • Client
  • Volume unit
  • C_DELIVDOCITEMSHIPPINGBLKD.MANDT == T006.MANDT
  • C_DELIVDOCITEMSHIPPINGBLKD.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Weight Unit
  • Client
  • C_DELIVDOCITEMSHIPPINGBLKD.ITEMWEIGHTUNIT == T006.MSEHI
  • C_DELIVDOCITEMSHIPPINGBLKD.MANDT == T006.MANDT
Loading Group
  • Loading Group
  • Client
  • C_DELIVDOCITEMSHIPPINGBLKD.LOADINGGROUP == TLGR.LADGR
  • C_DELIVDOCITEMSHIPPINGBLKD.MANDT == TLGR.MANDT
Product Number
  • Product Number
  • Client
  • C_DELIVDOCITEMSHIPPINGBLKD.MATERIAL == MARA.MATNR
  • C_DELIVDOCITEMSHIPPINGBLKD.MANDT == MARA.MANDT
Product Group
  • Client
  • Product Group
  • C_DELIVDOCITEMSHIPPINGBLKD.MANDT == T023.MANDT
  • C_DELIVDOCITEMSHIPPINGBLKD.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_DELIVDOCITEMSHIPPINGBLKD.MANDT == T001W.MANDT
  • C_DELIVDOCITEMSHIPPINGBLKD.PLANT == T001W.WERKS
Storage location
  • Storage location
  • Client
  • Plant
  • C_DELIVDOCITEMSHIPPINGBLKD.STORAGELOCATION == T001L.LGORT
  • C_DELIVDOCITEMSHIPPINGBLKD.MANDT == T001L.MANDT
  • C_DELIVDOCITEMSHIPPINGBLKD.PLANT == T001L.WERKS
Transportation Group
  • Client
  • Transportation Group
  • C_DELIVDOCITEMSHIPPINGBLKD.MANDT == TTGR.MANDT
  • C_DELIVDOCITEMSHIPPINGBLKD.TRANSPORTATIONGROUP == TTGR.TRAGR
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • C_DELIVDOCITEMSHIPPINGBLKD.WAREHOUSE == T300.LGNUM
  • C_DELIVDOCITEMSHIPPINGBLKD.MANDT == T300.MANDT
Staging Area in Warehouse
  • Warehouse Number / Warehouse Complex
  • Client
  • Staging Area for Warehouse Complex
  • C_DELIVDOCITEMSHIPPINGBLKD.WAREHOUSE == T30C.LGNUM
  • C_DELIVDOCITEMSHIPPINGBLKD.MANDT == T30C.MANDT
  • C_DELIVDOCITEMSHIPPINGBLKD.WAREHOUSESTAGINGAREA == T30C.LGBZO