C_DelivDocItemTrdCmplncIssue

Delivery Doc Item Trade Compliance Issue | view: CDELIVDOCITMDE07 | 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
TrdCmplncEmbargoSts Embargo Status (Item) Show values
TrdCmplncSnctndListChkSts Screening Status (Item) Show values
TrdCmplncLegalControlSts Legal Control Status 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
TrdCmplncEmbargoStsCritlty null
TrdCmplncSnctndListCritlty null
TrdCmplncLglCtrlStsCritlty null
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Client
  • Product Number
  • Plant
  • C_DELIVDOCITEMTRDCMPLNCISSUE.BATCH == MCHA.CHARG
  • C_DELIVDOCITEMTRDCMPLNCISSUE.MANDT == MCHA.MANDT
  • C_DELIVDOCITEMTRDCMPLNCISSUE.MATERIAL == MCHA.MATNR
  • C_DELIVDOCITEMTRDCMPLNCISSUE.PLANT == MCHA.WERKS
Delivery item category
  • Client
  • Delivery item category
  • C_DELIVDOCITEMTRDCMPLNCISSUE.MANDT == TVPT.MANDT
  • C_DELIVDOCITEMTRDCMPLNCISSUE.DELIVERYDOCUMENTITEMCATEGORY == TVPT.PSTYV
Delivery Type
  • Delivery Type
  • Client
  • C_DELIVDOCITEMTRDCMPLNCISSUE.DELIVERYDOCUMENTTYPE == TVLK.LFART
  • C_DELIVDOCITEMTRDCMPLNCISSUE.MANDT == TVLK.MANDT
Sales unit
  • Client
  • Sales unit
  • C_DELIVDOCITEMTRDCMPLNCISSUE.MANDT == T006.MANDT
  • C_DELIVDOCITEMTRDCMPLNCISSUE.DELIVERYQUANTITYUNIT == T006.MSEHI
Movement type (inventory management)
  • Movement type (inventory management)
  • Client
  • C_DELIVDOCITEMTRDCMPLNCISSUE.GOODSMOVEMENTTYPE == T156.BWART
  • C_DELIVDOCITEMTRDCMPLNCISSUE.MANDT == T156.MANDT
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • C_DELIVDOCITEMTRDCMPLNCISSUE.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • C_DELIVDOCITEMTRDCMPLNCISSUE.MANDT == T148.MANDT
Billing Block
  • Billing Block
  • Client
  • C_DELIVDOCITEMTRDCMPLNCISSUE.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • C_DELIVDOCITEMTRDCMPLNCISSUE.MANDT == TVFS.MANDT
Volume unit
  • Client
  • Volume unit
  • C_DELIVDOCITEMTRDCMPLNCISSUE.MANDT == T006.MANDT
  • C_DELIVDOCITEMTRDCMPLNCISSUE.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Weight Unit
  • Client
  • C_DELIVDOCITEMTRDCMPLNCISSUE.ITEMWEIGHTUNIT == T006.MSEHI
  • C_DELIVDOCITEMTRDCMPLNCISSUE.MANDT == T006.MANDT
Loading Group
  • Loading Group
  • Client
  • C_DELIVDOCITEMTRDCMPLNCISSUE.LOADINGGROUP == TLGR.LADGR
  • C_DELIVDOCITEMTRDCMPLNCISSUE.MANDT == TLGR.MANDT
Product Number
  • Client
  • Product Number
  • C_DELIVDOCITEMTRDCMPLNCISSUE.MANDT == MARA.MANDT
  • C_DELIVDOCITEMTRDCMPLNCISSUE.MATERIAL == MARA.MATNR
Product Group
  • Client
  • Product Group
  • C_DELIVDOCITEMTRDCMPLNCISSUE.MANDT == T023.MANDT
  • C_DELIVDOCITEMTRDCMPLNCISSUE.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_DELIVDOCITEMTRDCMPLNCISSUE.MANDT == T001W.MANDT
  • C_DELIVDOCITEMTRDCMPLNCISSUE.PLANT == T001W.WERKS
Storage location
  • Storage location
  • Client
  • Plant
  • C_DELIVDOCITEMTRDCMPLNCISSUE.STORAGELOCATION == T001L.LGORT
  • C_DELIVDOCITEMTRDCMPLNCISSUE.MANDT == T001L.MANDT
  • C_DELIVDOCITEMTRDCMPLNCISSUE.PLANT == T001L.WERKS
Transportation Group
  • Client
  • Transportation Group
  • C_DELIVDOCITEMTRDCMPLNCISSUE.MANDT == TTGR.MANDT
  • C_DELIVDOCITEMTRDCMPLNCISSUE.TRANSPORTATIONGROUP == TTGR.TRAGR
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • C_DELIVDOCITEMTRDCMPLNCISSUE.WAREHOUSE == T300.LGNUM
  • C_DELIVDOCITEMTRDCMPLNCISSUE.MANDT == T300.MANDT
Staging Area in Warehouse
  • Warehouse Number / Warehouse Complex
  • Client
  • Staging Area for Warehouse Complex
  • C_DELIVDOCITEMTRDCMPLNCISSUE.WAREHOUSE == T30C.LGNUM
  • C_DELIVDOCITEMTRDCMPLNCISSUE.MANDT == T30C.MANDT
  • C_DELIVDOCITEMTRDCMPLNCISSUE.WAREHOUSESTAGINGAREA == T30C.LGBZO