I_DeliveryDocumentItemCube

Analytics - Delivery Cube | view: ILEDELIVDOCITEMC | TRAN | Extraction: Not supported | Component: Basic Functions
Tables used: VBAP, SCAL_TT_DATE, LIKP, LIPS, VBAK, VBKD, VEDA, KNA1, T001W, TVKO, T001L, USR21
Column Name Description
DeliveryDocument FK Delivery
DeliveryDocumentItem Delivery Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
OpnOutbDelivsForInvcNetAmt null
💲 Display Currency (DisplayCurrency):
OpnOutbDelivsForInvcNetAmtInDC Net Amount of Open Deliveries for Invoices(Display Currency)
Column Name Description
📏 Sales unit (DeliveryQuantityUnit):
ActualDeliveryQuantity Actual quantity delivered (in sales units)
OriginalDeliveryQuantity Original Quantity of Delivery Item
📏 Base Unit of Measure (BaseUnit):
ActualDeliveredQtyInBaseUnit Actual quantity delivered in stockkeeping units
OpnOutbDelivsForInvcQty Quantity of Deliveries Shipped But Not Invoiced (SKU)
📏 Weight Unit (ItemWeightUnit):
ItemGrossWeight Gross weight
ItemNetWeight Net weight
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume
Column Name Description
CreationDate Date on which the record was created
CreationTime Entry time
LastChangeDate Last Changed On
ShelfLifeExpirationDate Shelf Life Expiration or Best-Before Date
ManufactureDate Date of Manufacture
ProductAvailabilityDate Material Staging/Availability Date
ProductAvailabilityTime Material Staging Time (Local, Relating to a Plant)
DeliveryDate Delivery Date
PlannedGoodsIssueDate Planned Goods Movement Date
GoodsIssueTime Time of Goods Issue (Local, Relating to a Plant)
ActualGoodsMovementDate Actual Goods Movement Date
ActualGoodsMovementTime Time of Goods Issue (Local, Relating to a Plant)
Column Name Description
SalesDocumentItemType Item Type Show values
MaterialIsIntBatchManaged Batch management indicator (internal) Show values
MaterialIsBatchManaged Batch Management Requirement Indicator Show values
PartialDeliveryIsAllowed Partial delivery at item level Show values
UnlimitedOverdeliveryIsAllowed Unlimited Overdelivery Allowed Show values
PickingControl Indicator for picking control Show values
ProofOfDeliveryRelevanceCode POD Control (Proof of Delivery) Show values
ItemIsBillingRelevant Relevant for Billing Show values
IntercompanyBillingStatus Intercompany Billing Status (Item) Show values
IsSeparateValuation Indicator: Separate valuation Show values
ConsumptionPosting Consumption posting Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
SDProcessStatus Overall Processing Status (Item) Show values
PickingConfirmationStatus Confirmation Status of Picking/Putaway Show values
PickingStatus Picking Status/Putaway Status (Item) Show values
WarehouseActivityStatus Status of Warehouse Management Activities (Item) Show values
PackingStatus Packing Status (Item) Show values
GoodsMovementStatus Goods Movement Status (Item) Show values
DeliveryRelatedBillingStatus Delivery-Related Billing Status (Item) Show values
ProofOfDeliveryStatus POD status on item level Show values
ItemGeneralIncompletionStatus Incompletion Status (Item) Show values
ItemDeliveryIncompletionStatus Delivery Incompletion Status (Item) Show values
ItemPickingIncompletionStatus Picking/Putaway Incompletion Status (Item) Show values
ItemGdsMvtIncompletionSts Goods Movement Incompletion Status (Item) Show values
ItemPackingIncompletionStatus Packing Incompletion Status (Item) Show values
ItemBillingIncompletionStatus Billing Incompletion Status (Item) Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CreatedByUserName User Description SUIDTECHDESC
MaterialByCustomer Customer Material IDNEX
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
BatchClassification Internal object number of the batch classification CUOBJ
BatchBySupplier Supplier Batch Number LICHN
PlantName Plant Name TEXT30
StorageLocationName Storage Location Name TEXT16
NumberOfSerialNumbers Number of serial numbers INT4
ProductConfiguration Configuration CUOBJ
SoldToPartyName Name of Sold-to Party TEXT80
ShipToPartyName Name of Ship-to Party TEXT80
DeliveryDocumentItemText Short text for sales order item TEXT40
DeliveryGroup Delivery Group (Items are delivered together) GRKOR
InspectionPartialLot Partial Lot Number QTLOS
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
WarehouseStorageBin Storage Bin CHAR10
ReceivingPoint Receiving Point TEXT25
FixedShipgProcgDurationInDays Fixed shipping processing time in days (= setup time) DEC3_2
VarblShipgProcgDurationInDays Variable shipping processing time in days DEC3_2
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
ProfitCenter Profit Center PRCTR
OrderItem Order item number CO_POSNR
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == T006.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.BASEUNIT == T006.MSEHI
Batch Number
  • Client
  • Batch Number
  • Material Number
  • Plant
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == MCHA.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.BATCH == MCHA.CHARG
  • I_DELIVERYDOCUMENTITEMCUBE.MATERIAL == MCHA.MATNR
  • I_DELIVERYDOCUMENTITEMCUBE.PLANT == MCHA.WERKS
Business Area
  • Client
  • Business Area
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == TGSB.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.BUSINESSAREA == TGSB.GSBER
Controlling Area
  • Client
  • Controlling Area
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == TKA01.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Cost Center
  • Client
  • Last Changed On
  • Controlling Area
  • I_DELIVERYDOCUMENTITEMCUBE.COSTCENTER == CSKS.KOSTL
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == CSKS.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.LASTCHANGEDATE == CSKS.DATBI
  • I_DELIVERYDOCUMENTITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
Customer Group
  • Client
  • Customer Group
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == T151.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.CUSTOMERGROUP == T151.KDGRP
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • I_DELIVERYDOCUMENTITEMCUBE.DELIVERYBLOCKREASON == TVLS.LIFSP
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == TVLS.MANDT
Delivery item category
  • Delivery item category
  • Client
  • I_DELIVERYDOCUMENTITEMCUBE.DELIVERYDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == TVPT.MANDT
Delivery Type
  • Delivery Type
  • Client
  • I_DELIVERYDOCUMENTITEMCUBE.DELIVERYDOCUMENTTYPE == TVLK.LFART
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == TVLK.MANDT
Sales unit
  • Client
  • Sales unit
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == T006.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.DELIVERYQUANTITYUNIT == T006.MSEHI
Distribution Channel
  • Client
  • Distribution Channel
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == TVTW.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Division
  • Client
  • I_DELIVERYDOCUMENTITEMCUBE.DIVISION == TSPA.SPART
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == TSPA.MANDT
Movement type (inventory management)
  • Movement type (inventory management)
  • Client
  • I_DELIVERYDOCUMENTITEMCUBE.GOODSMOVEMENTTYPE == T156.BWART
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == T156.MANDT
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • I_DELIVERYDOCUMENTITEMCUBE.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == T148.MANDT
Valuation Type
  • Valuation Type
  • Client
  • I_DELIVERYDOCUMENTITEMCUBE.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == T149D.MANDT
Billing Block Reason for Item
  • Billing Block Reason for Item
  • Client
  • I_DELIVERYDOCUMENTITEMCUBE.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == TVFS.MANDT
Volume unit
  • Client
  • Volume unit
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == T006.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Weight Unit
  • Client
  • I_DELIVERYDOCUMENTITEMCUBE.ITEMWEIGHTUNIT == T006.MSEHI
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == T006.MANDT
Loading Group
  • Client
  • Loading Group
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == TLGR.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.LOADINGGROUP == TLGR.LADGR
Material Number
  • Client
  • Material Number
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == MARA.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == T023.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.MATERIALGROUP == T023.MATKL
Order Number
  • Client
  • Order Number
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == AUFK.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.ORDERID == AUFK.AUFNR
Material Entered
  • Client
  • Material Entered
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == MARA.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Form of payment guarantee
  • Client
  • Form of payment guarantee
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == T691K.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.PAYMENTGUARANTEEFORM == T691K.ABSFO
Plant
  • Client
  • Plant
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == T001W.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.PLANT == T001W.WERKS
Product hierarchy
  • Product hierarchy
  • Client
  • I_DELIVERYDOCUMENTITEMCUBE.PRODUCTHIERARCHYNODE == T179.PRODH
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == T179.MANDT
Logical System in the Preceding Document I_DELIVERYDOCUMENTITEMCUBE.REFERENCEDOCUMENTLOGICALSYSTEM == TBDLS.LOGSYS
Sales group
  • Client
  • Sales group
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == TVKGR.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.SALESGROUP == TVKGR.VKGRP
Sales office
  • Sales office
  • Client
  • I_DELIVERYDOCUMENTITEMCUBE.SALESOFFICE == TVBUR.VKBUR
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == TVBUR.MANDT
Sales Organization
  • Sales Organization
  • Client
  • I_DELIVERYDOCUMENTITEMCUBE.SALESORGANIZATION == TVKO.VKORG
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == TVKO.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • I_DELIVERYDOCUMENTITEMCUBE.SHIPPINGPOINT == TVST.VSTEL
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == TVST.MANDT
Ship-to Party
  • Client
  • Ship-to Party
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == KNA1.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.SHIPTOPARTY == KNA1.KUNNR
Sold-to Party
  • Client
  • Sold-to Party
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == KNA1.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.SOLDTOPARTY == KNA1.KUNNR
Customer Classification
  • Client
  • Customer Classification
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == TKUKL.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.SOLDTOPARTYCLASSIFICATION == TKUKL.KUKLA
Storage Bin
  • Client
  • Warehouse Number / Warehouse Complex
  • Storage Type
  • Storage Bin
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == LAGP.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.WAREHOUSE == LAGP.LGNUM
  • I_DELIVERYDOCUMENTITEMCUBE.STORAGETYPE == LAGP.LGTYP
  • I_DELIVERYDOCUMENTITEMCUBE.STORAGEBIN == LAGP.LGPLA
Storage location
  • Client
  • Storage location
  • Plant
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == T001L.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.STORAGELOCATION == T001L.LGORT
  • I_DELIVERYDOCUMENTITEMCUBE.PLANT == T001L.WERKS
Storage Type
  • Client
  • Warehouse Number / Warehouse Complex
  • Storage Type
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == T301.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.WAREHOUSE == T301.LGNUM
  • I_DELIVERYDOCUMENTITEMCUBE.STORAGETYPE == T301.LGTYP
SD Document Currency
  • SD Document Currency
  • Client
  • I_DELIVERYDOCUMENTITEMCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == TCURC.MANDT
Transportation Group
  • Client
  • Transportation Group
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == TTGR.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.TRANSPORTATIONGROUP == TTGR.TRAGR
Warehouse Number / Warehouse Complex
  • Client
  • Warehouse Number / Warehouse Complex
  • I_DELIVERYDOCUMENTITEMCUBE.MANDT == T300.MANDT
  • I_DELIVERYDOCUMENTITEMCUBE.WAREHOUSE == T300.LGNUM