C_DelivDocItemIncomplete

Delivery Doc Item Incomplete Data | view: CDELIVDOCITMDE03 | 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
ItemGeneralIncompletionStatus Incompletion Status (Item) Show values
ItemDeliveryIncompletionStatus Delivery Incompletion Status (Item) Show values
ItemPickingIncompletionStatus Picking/Putaway Incompletion Status (Item) Show values
ItemPackingIncompletionStatus Packaging Incompletion Status (Item) Show values
ItemBillingIncompletionStatus Billing Incompletion Status (Item) Show values
ItemGdsMvtIncompletionSts Goods Movement Incompletion 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
ItmGenIncompltnStsCriticality null
ItmDelivIncompltnStsCritlty null
ItmPickingIncompltnStsCritlty null
ItmPackgIncompltnStsCritlty null
ItmGdsMvtIncompltnStsCritlty null
ItmBillingIncompltnStsCritlty null
Master Data Relations Join Conditions
Batch Number
  • Plant
  • Batch Number
  • Client
  • Product Number
  • C_DELIVDOCITEMINCOMPLETE.PLANT == MCHA.WERKS
  • C_DELIVDOCITEMINCOMPLETE.BATCH == MCHA.CHARG
  • C_DELIVDOCITEMINCOMPLETE.MANDT == MCHA.MANDT
  • C_DELIVDOCITEMINCOMPLETE.MATERIAL == MCHA.MATNR
Delivery item category
  • Client
  • Delivery item category
  • C_DELIVDOCITEMINCOMPLETE.MANDT == TVPT.MANDT
  • C_DELIVDOCITEMINCOMPLETE.DELIVERYDOCUMENTITEMCATEGORY == TVPT.PSTYV
Sales unit
  • Client
  • Sales unit
  • C_DELIVDOCITEMINCOMPLETE.MANDT == T006.MANDT
  • C_DELIVDOCITEMINCOMPLETE.DELIVERYQUANTITYUNIT == T006.MSEHI
Movement type (inventory management)
  • Movement type (inventory management)
  • Client
  • C_DELIVDOCITEMINCOMPLETE.GOODSMOVEMENTTYPE == T156.BWART
  • C_DELIVDOCITEMINCOMPLETE.MANDT == T156.MANDT
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • C_DELIVDOCITEMINCOMPLETE.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • C_DELIVDOCITEMINCOMPLETE.MANDT == T148.MANDT
Billing Block
  • Client
  • Billing Block
  • C_DELIVDOCITEMINCOMPLETE.MANDT == TVFS.MANDT
  • C_DELIVDOCITEMINCOMPLETE.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
Volume unit
  • Client
  • Volume unit
  • C_DELIVDOCITEMINCOMPLETE.MANDT == T006.MANDT
  • C_DELIVDOCITEMINCOMPLETE.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Weight Unit
  • Client
  • C_DELIVDOCITEMINCOMPLETE.ITEMWEIGHTUNIT == T006.MSEHI
  • C_DELIVDOCITEMINCOMPLETE.MANDT == T006.MANDT
Loading Group
  • Client
  • Loading Group
  • C_DELIVDOCITEMINCOMPLETE.MANDT == TLGR.MANDT
  • C_DELIVDOCITEMINCOMPLETE.LOADINGGROUP == TLGR.LADGR
Product Number
  • Client
  • Product Number
  • C_DELIVDOCITEMINCOMPLETE.MANDT == MARA.MANDT
  • C_DELIVDOCITEMINCOMPLETE.MATERIAL == MARA.MATNR
Product Group
  • Product Group
  • Client
  • C_DELIVDOCITEMINCOMPLETE.MATERIALGROUP == T023.MATKL
  • C_DELIVDOCITEMINCOMPLETE.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • C_DELIVDOCITEMINCOMPLETE.PLANT == T001W.WERKS
  • C_DELIVDOCITEMINCOMPLETE.MANDT == T001W.MANDT
Storage location
  • Plant
  • Client
  • Storage location
  • C_DELIVDOCITEMINCOMPLETE.PLANT == T001L.WERKS
  • C_DELIVDOCITEMINCOMPLETE.MANDT == T001L.MANDT
  • C_DELIVDOCITEMINCOMPLETE.STORAGELOCATION == T001L.LGORT
Transportation Group
  • Transportation Group
  • Client
  • C_DELIVDOCITEMINCOMPLETE.TRANSPORTATIONGROUP == TTGR.TRAGR
  • C_DELIVDOCITEMINCOMPLETE.MANDT == TTGR.MANDT
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • C_DELIVDOCITEMINCOMPLETE.WAREHOUSE == T300.LGNUM
  • C_DELIVDOCITEMINCOMPLETE.MANDT == T300.MANDT
Staging Area in Warehouse
  • Warehouse Number / Warehouse Complex
  • Client
  • Staging Area for Warehouse Complex
  • C_DELIVDOCITEMINCOMPLETE.WAREHOUSE == T30C.LGNUM
  • C_DELIVDOCITEMINCOMPLETE.MANDT == T30C.MANDT
  • C_DELIVDOCITEMINCOMPLETE.WAREHOUSESTAGINGAREA == T30C.LGBZO