I_DelivDocumentItemIncomplete

SOFM Incomplete Delivery Document Item | view: IDLVDOCITMDE03 | Extraction: Not supported | Component: Sales Analytics
Tables used: LIKP, LIPS, VBAK
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)
Column Name Description
Column Name Description
ItemGeneralIncompletionStatus Incompletion Status (Item) Show values
ItemBillingIncompletionStatus Billing Incompletion Status (Item) Show values
ItemDeliveryIncompletionStatus Delivery Incompletion Status (Item) Show values
ItemPickingIncompletionStatus Picking/Putaway Incompletion Status (Item) Show values
ItemPackingIncompletionStatus Packing Incompletion Status (Item) Show values
ItemGdsMvtIncompletionSts Goods Movement Incompletion Status (Item) Show values
Column Name Description Domain name
DueDays Next Action in Days DUE_DAYS
DeliveryDocumentItemText Short text for sales order item TEXT40
SalesOrder Sales Order VBELN
Master Data Relations Join Conditions
Delivery item category
  • Delivery item category
  • Client
  • I_DELIVDOCUMENTITEMINCOMPLETE.DELIVERYDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • I_DELIVDOCUMENTITEMINCOMPLETE.MANDT == TVPT.MANDT
Delivery Type
  • Delivery Type
  • Client
  • I_DELIVDOCUMENTITEMINCOMPLETE.DELIVERYDOCUMENTTYPE == TVLK.LFART
  • I_DELIVDOCUMENTITEMINCOMPLETE.MANDT == TVLK.MANDT
Sales unit
  • Sales unit
  • Client
  • I_DELIVDOCUMENTITEMINCOMPLETE.DELIVERYQUANTITYUNIT == T006.MSEHI
  • I_DELIVDOCUMENTITEMINCOMPLETE.MANDT == T006.MANDT
Distribution channel in order header
  • Distribution Channel
  • Sales Organization
  • Client
  • I_DELIVDOCUMENTITEMINCOMPLETE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_DELIVDOCUMENTITEMINCOMPLETE.SALESORGANIZATION == TVKOV.VKORG
  • I_DELIVDOCUMENTITEMINCOMPLETE.MANDT == TVKOV.MANDT
Material Number
  • Material Number
  • Client
  • I_DELIVDOCUMENTITEMINCOMPLETE.MATERIAL == MARA.MATNR
  • I_DELIVDOCUMENTITEMINCOMPLETE.MANDT == MARA.MANDT
Division in order header
  • Division
  • Distribution Channel
  • Sales Organization
  • Client
  • I_DELIVDOCUMENTITEMINCOMPLETE.ORGANIZATIONDIVISION == TVTA.SPART
  • I_DELIVDOCUMENTITEMINCOMPLETE.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_DELIVDOCUMENTITEMINCOMPLETE.SALESORGANIZATION == TVTA.VKORG
  • I_DELIVDOCUMENTITEMINCOMPLETE.MANDT == TVTA.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • I_DELIVDOCUMENTITEMINCOMPLETE.SALESORDERTYPE == TVAK.AUART
  • I_DELIVDOCUMENTITEMINCOMPLETE.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • I_DELIVDOCUMENTITEMINCOMPLETE.SALESORGANIZATION == TVKO.VKORG
  • I_DELIVDOCUMENTITEMINCOMPLETE.MANDT == TVKO.MANDT