C_DelivDocumentItemIncompleteQ

SOFM Incomplete Delivery Document Item Query | view: CDLVDOCITMDE03Q | Extraction: Not supported | Component: Sales Analytics
Tables used: LIKP, LIPS, VBAK, TVAP, TVAPT, TVBST, TVBST, TVBST, TVBST, TVBST, TVBST
Column Name Description
DeliveryDocument FK Outbound Delivery
DeliveryDocumentItem Outbound 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
DeliveryDocumentItemCatName Description TEXT20
DeliveryDocumentItemText Short text for sales order item TEXT40
SalesOrder Sales Order VBELN
ItemGenIncompletionStatusDesc Status Description TEXT20
ItemBillingIncompletionStsDesc Status Description TEXT20
ItemDelivIncompletionStsDesc Status Description TEXT20
ItemPickingIncompletionStsDesc Status Description TEXT20
ItemPackingIncompletionStsDesc Status Description TEXT20
ItemGdsMvtIncompletionStsDesc Status Description TEXT20
Master Data Relations Join Conditions
Delivery item category
  • Delivery item category
  • Client
  • C_DELIVDOCUMENTITEMINCOMPLETEQ.DELIVERYDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • C_DELIVDOCUMENTITEMINCOMPLETEQ.MANDT == TVPT.MANDT
Delivery Type
  • Delivery Type
  • Client
  • C_DELIVDOCUMENTITEMINCOMPLETEQ.DELIVERYDOCUMENTTYPE == TVLK.LFART
  • C_DELIVDOCUMENTITEMINCOMPLETEQ.MANDT == TVLK.MANDT
Sales unit
  • Client
  • Sales unit
  • C_DELIVDOCUMENTITEMINCOMPLETEQ.MANDT == T006.MANDT
  • C_DELIVDOCUMENTITEMINCOMPLETEQ.DELIVERYQUANTITYUNIT == T006.MSEHI
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • C_DELIVDOCUMENTITEMINCOMPLETEQ.SALESORGANIZATION == TVKOV.VKORG
  • C_DELIVDOCUMENTITEMINCOMPLETEQ.MANDT == TVKOV.MANDT
  • C_DELIVDOCUMENTITEMINCOMPLETEQ.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Material Number
  • Material Number
  • Client
  • C_DELIVDOCUMENTITEMINCOMPLETEQ.MATERIAL == MARA.MATNR
  • C_DELIVDOCUMENTITEMINCOMPLETEQ.MANDT == MARA.MANDT
Division in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • Division
  • C_DELIVDOCUMENTITEMINCOMPLETEQ.SALESORGANIZATION == TVTA.VKORG
  • C_DELIVDOCUMENTITEMINCOMPLETEQ.MANDT == TVTA.MANDT
  • C_DELIVDOCUMENTITEMINCOMPLETEQ.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_DELIVDOCUMENTITEMINCOMPLETEQ.ORGANIZATIONDIVISION == TVTA.SPART
Order type in order header
  • Sales Document Type
  • Client
  • C_DELIVDOCUMENTITEMINCOMPLETEQ.SALESORDERTYPE == TVAK.AUART
  • C_DELIVDOCUMENTITEMINCOMPLETEQ.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • C_DELIVDOCUMENTITEMINCOMPLETEQ.SALESORGANIZATION == TVKO.VKORG
  • C_DELIVDOCUMENTITEMINCOMPLETEQ.MANDT == TVKO.MANDT