I_DeliveryDocumentItem

Delivery Document Item | view: ILEDELIVDOCITEM | ATTR | Extraction: Full or Incremental | Component: Basic Functions
Tables used: LIKP, LIPS
Column Name Description
DeliveryDocument FK Delivery
DeliveryDocumentItem Delivery Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
CostInDocumentCurrency Cost in Document Currency
Subtotal1Amount Subtotal 1 from Pricing Procedure for Price Element
Subtotal2Amount Subtotal 2 from Pricing Procedure for Price Element
Subtotal3Amount Subtotal 3 from Pricing Procedure for Price Element
Subtotal4Amount Subtotal 4 from Pricing Procedure for Price Element
Subtotal5Amount Subtotal 5 from Pricing Procedure for Price Element
Subtotal6Amount Subtotal 6 from Pricing Procedure for Price Element
NetPriceAmount Net Price
TotalNetAmount Net Value in Document Currency
CreditRelatedPriceAmount Item credit price
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
CumulativeBatchQtyInBaseUnit Cumulative batch quantity of all split items (in StckUnit)
QtyInPurchaseOrderPriceUnit Quantity in Purchase Order Price Unit
📏 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)
StatisticsDate Statistics date
Column Name Description
SDDocumentCategory SD Document Category Show values
SalesDocumentItemType Item Type Show values
MaterialIsIntBatchManaged Batch management indicator (internal) Show values
MaterialIsBatchManaged Batch Management Requirement Indicator Show values
QuantityIsFixed Quantity is fixed Show values
PartialDeliveryIsAllowed Partial delivery at item level Show values
UnlimitedOverdeliveryIsAllowed Unlimited Overdelivery Allowed Show values
WarehouseStockCategory Stock Category in the Warehouse Management System Show values
IssgOrRcvgStockCategory Stock Category in the Warehouse Management System Show values
PrimaryPostingSwitch Indicator: UNMAT in main posting Show values
StockType Stock Type Show values
IsNotGoodsMovementsRelevant Indicator: Item Not Relevant for Goods Movements Show values
IsCompletelyDelivered "Delivery Completed" Indicator 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
SchedulingAgreementReleaseType Release type 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
EU_DeliveryItemARCStatus Excise Tax ARC Status Show values
ItemHasValueAddedService VAS Relevant Show values
SalesSDDocumentCategory SD Document Category Show values
IsReturnsItem Returns Item Show values
ReturnsDeliveryItemCode Returns Item Show values
ChmlCmplncStatus Product Marketability Check Status Show values
DangerousGoodsStatus Dangerous Goods Check Status Show values
SafetyDataSheetStatus Safety Data Sheet Check Status Show values
TrdCmplncEmbargoSts Embargo Status (Item) Show values
TrdCmplncSnctndListChkSts Screening Status (Item) Show values
TrdCmplncLegalControlSts Legal Control Check Status Show values
HigherLevelItemUsage ID for higher-level item usage Show values
FldLogsStatus Field Logistics Indicator Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
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
DeliveryItemResourceID Resource Name (Stock Identifier) NSDM_RESOURCENAME
LoadingPointForDelivery Loading/Unloading Point
NumberOfSerialNumbers Number of serial numbers INT4
ProductConfiguration Configuration CUOBJ
DeliveryDocumentItemText Short text for sales order item TEXT40
DeliveryToBaseQuantityDnmntr Denominator (divisor) for conversion of sales Qty into SKU UMBSN
DeliveryToBaseQuantityNmrtr Numerator (factor) for conversion of sales quantity into SKU UMBSZ
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
CustEngineeringChgStatus Customer Engineering Change Status AESKD
IssgOrRcvgMaterial Receiving/Issuing Material MATNR
IssuingOrReceivingPlant Receiving plant/issuing plant WERKS
IssuingOrReceivingStorageLoc Receiving/issuing storage location LGORT
IssgOrRcvgBatch Receiving/Issuing Batch CHARG
IssgOrRcvgValuationType Valuation Type of Transfer Batch BWTAR
IssgOrRcvgSpclStockInd Special stock indicator for physical stock transfer SOBKZ
IssgOrRcvgResourceID Resource Name (Stock Identifier Complement) NSDM_RESOURCENAME
GLAccount G/L Account Number SAKNR
GoodsMovementReasonCode Reason for goods movment NUMC4
SubsequentMovementType Subsequent movement type BWART
AlternateProductNumber Alternate Product Number /SPE/DE_ALTERNATE_PART_NR
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
ProfitabilitySegment_2 Profitability Segment RKEOBJNR_CHAR
ProfitCenter Profit Center PRCTR
OrderItem Order item number CO_POSNR
DeliveryDocumentItemBySupplier External item number POSNR
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
RequirementSegment Requirement Segment SGT_SRCA
StockSegment Stock Segment SGT_SRCA
ProductSeasonYear Season Year FSH_CJAHR
ProductSeason Season RFM_SAISO
ProductCollection Fashion Collection FSH_COLLECTION
ProductTheme Fashion Theme FSH_THEME
ProductCharacteristic1 Characteristic Value 1 WRF_CHARSTC
ProductCharacteristic2 Characteristic Value 2 WRF_CHARSTC
ProductCharacteristic3 Characteristic Value 3 WRF_CHARSTC
ValAddedSrvcParentItmNumber Delivery Item POSNR
ValAddedSrvcTransactionNumber Transaction Number FSH_TRANSACTION
ValAddedSrvcItemGroup Item Group FSH_ITEM_GROUP
ValAddedSrvcItemNumber Item Number FSH_ITEM
OriginSDDocument Originating Document VBELN
SDDocumentItem Originating Item POSNR
OrderDocument Sales Order Number VBELN
ConversionFactor Conversion factor: quantities FLTP
CreditRelatedPrice Item Credit Price FLTP
DeliveryToBaseUnitCnvrsnFctr Conversion Factor of Delivery Quantity VRKME for MEINS FLTP
FunctionalArea Functional Area FKBER
RFMReservation Number of reservation/dependent requirements RSNUM
RFMReservationItem Item Number of Reservation / Dependent Requirements RSPOS
Reservation Number of reservation/dependent requirements RSNUM
ReservationItem Item Number of Reservation / Dependent Requirements RSPOS
ReservationRecordType Record type RSART
BatchSearchStrategy Number of condition record from batch determination KNUMB
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • I_DELIVERYDOCUMENTITEM.MANDT == TVV1.MANDT
  • I_DELIVERYDOCUMENTITEM.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Customer Group 2
  • Client
  • I_DELIVERYDOCUMENTITEM.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • I_DELIVERYDOCUMENTITEM.MANDT == TVV2.MANDT
Customer Group 3
  • Client
  • Customer Group 3
  • I_DELIVERYDOCUMENTITEM.MANDT == TVV3.MANDT
  • I_DELIVERYDOCUMENTITEM.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Customer Group 4
  • Client
  • I_DELIVERYDOCUMENTITEM.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • I_DELIVERYDOCUMENTITEM.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • I_DELIVERYDOCUMENTITEM.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • I_DELIVERYDOCUMENTITEM.MANDT == TVV5.MANDT
Material Group 1
  • Client
  • Material Group 1
  • I_DELIVERYDOCUMENTITEM.MANDT == TVM1.MANDT
  • I_DELIVERYDOCUMENTITEM.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • I_DELIVERYDOCUMENTITEM.MANDT == TVM2.MANDT
  • I_DELIVERYDOCUMENTITEM.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Material Group 3
  • Client
  • I_DELIVERYDOCUMENTITEM.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
  • I_DELIVERYDOCUMENTITEM.MANDT == TVM3.MANDT
Material Group 4
  • Client
  • Material Group 4
  • I_DELIVERYDOCUMENTITEM.MANDT == TVM4.MANDT
  • I_DELIVERYDOCUMENTITEM.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Material Group 5
  • Client
  • I_DELIVERYDOCUMENTITEM.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
  • I_DELIVERYDOCUMENTITEM.MANDT == TVM5.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_DELIVERYDOCUMENTITEM.MANDT == T006.MANDT
  • I_DELIVERYDOCUMENTITEM.BASEUNIT == T006.MSEHI
Batch Number
  • Material Number
  • Product Number
  • Plant
  • Client
  • Batch Number
  • I_DELIVERYDOCUMENTITEM.MATERIAL == MCHA.MATNR
  • I_DELIVERYDOCUMENTITEM.PRODUCT == MCHA.MATNR
  • I_DELIVERYDOCUMENTITEM.PLANT == MCHA.WERKS
  • I_DELIVERYDOCUMENTITEM.MANDT == MCHA.MANDT
  • I_DELIVERYDOCUMENTITEM.BATCH == MCHA.CHARG
BOM explosion number
  • Client
  • BOM explosion number
  • I_DELIVERYDOCUMENTITEM.MANDT == SNUM.MANDT
  • I_DELIVERYDOCUMENTITEM.BOMEXPLOSION == SNUM.SERNR
Business Area
  • Business Area
  • Client
  • I_DELIVERYDOCUMENTITEM.BUSINESSAREA == TGSB.GSBER
  • I_DELIVERYDOCUMENTITEM.MANDT == TGSB.MANDT
Condition Unit
  • Condition Unit
  • Client
  • I_DELIVERYDOCUMENTITEM.CONDITIONUNIT == T006.MSEHI
  • I_DELIVERYDOCUMENTITEM.MANDT == T006.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_DELIVERYDOCUMENTITEM.CONTROLLINGAREA == TKA01.KOKRS
  • I_DELIVERYDOCUMENTITEM.MANDT == TKA01.MANDT
Cost Center
  • Last Changed On
  • Controlling Area
  • Cost Center
  • Client
  • I_DELIVERYDOCUMENTITEM.LASTCHANGEDATE == CSKS.DATBI
  • I_DELIVERYDOCUMENTITEM.CONTROLLINGAREA == CSKS.KOKRS
  • I_DELIVERYDOCUMENTITEM.COSTCENTER == CSKS.KOSTL
  • I_DELIVERYDOCUMENTITEM.MANDT == CSKS.MANDT
Delivery item category
  • Delivery item category
  • Client
  • I_DELIVERYDOCUMENTITEM.DELIVERYDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • I_DELIVERYDOCUMENTITEM.MANDT == TVPT.MANDT
Sales unit
  • Client
  • Sales unit
  • I_DELIVERYDOCUMENTITEM.MANDT == T006.MANDT
  • I_DELIVERYDOCUMENTITEM.DELIVERYQUANTITYUNIT == T006.MSEHI
Department
  • Department number
  • Client
  • I_DELIVERYDOCUMENTITEM.DEPARTMENTCLASSIFICATIONBYCUST == TSAB.ABTNR
  • I_DELIVERYDOCUMENTITEM.MANDT == TSAB.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • I_DELIVERYDOCUMENTITEM.MANDT == TVTW.MANDT
  • I_DELIVERYDOCUMENTITEM.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Division
  • Client
  • I_DELIVERYDOCUMENTITEM.DIVISION == TSPA.SPART
  • I_DELIVERYDOCUMENTITEM.MANDT == TSPA.MANDT
Movement type (inventory management)
  • Client
  • Movement type (inventory management)
  • I_DELIVERYDOCUMENTITEM.MANDT == T156.MANDT
  • I_DELIVERYDOCUMENTITEM.GOODSMOVEMENTTYPE == T156.BWART
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • I_DELIVERYDOCUMENTITEM.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • I_DELIVERYDOCUMENTITEM.MANDT == T148.MANDT
Valuation Type
  • Valuation Type
  • Client
  • I_DELIVERYDOCUMENTITEM.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • I_DELIVERYDOCUMENTITEM.MANDT == T149D.MANDT
Billing Block
  • Billing Block
  • Client
  • I_DELIVERYDOCUMENTITEM.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • I_DELIVERYDOCUMENTITEM.MANDT == TVFS.MANDT
Volume unit
  • Client
  • Volume unit
  • I_DELIVERYDOCUMENTITEM.MANDT == T006.MANDT
  • I_DELIVERYDOCUMENTITEM.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Weight Unit
  • Client
  • I_DELIVERYDOCUMENTITEM.ITEMWEIGHTUNIT == T006.MSEHI
  • I_DELIVERYDOCUMENTITEM.MANDT == T006.MANDT
Loading Group
  • Loading Group
  • Client
  • I_DELIVERYDOCUMENTITEM.LOADINGGROUP == TLGR.LADGR
  • I_DELIVERYDOCUMENTITEM.MANDT == TLGR.MANDT
Material Number
  • Material Number
  • Product Number
  • Client
  • I_DELIVERYDOCUMENTITEM.MATERIAL == MARA.MATNR
  • I_DELIVERYDOCUMENTITEM.PRODUCT == MARA.MATNR
  • I_DELIVERYDOCUMENTITEM.MANDT == MARA.MANDT
Material freight group
  • Material freight group
  • Client
  • I_DELIVERYDOCUMENTITEM.MATERIALFREIGHTGROUP == TMFG.MFRGR
  • I_DELIVERYDOCUMENTITEM.MANDT == TMFG.MANDT
Material Group
  • Product Group
  • Material Group
  • Client
  • I_DELIVERYDOCUMENTITEM.PRODUCTGROUP == T023.MATKL
  • I_DELIVERYDOCUMENTITEM.MATERIALGROUP == T023.MATKL
  • I_DELIVERYDOCUMENTITEM.MANDT == T023.MANDT
Material type
  • Material type
  • Client
  • I_DELIVERYDOCUMENTITEM.MATERIALTYPEPRIMARY == T134.MTART
  • I_DELIVERYDOCUMENTITEM.MANDT == T134.MANDT
Order Number
  • Order Number
  • Client
  • I_DELIVERYDOCUMENTITEM.ORDERID == AUFK.AUFNR
  • I_DELIVERYDOCUMENTITEM.MANDT == AUFK.MANDT
Material Entered
  • Client
  • Material Entered
  • I_DELIVERYDOCUMENTITEM.MANDT == MARA.MANDT
  • I_DELIVERYDOCUMENTITEM.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Form of payment guarantee
  • Form of payment guarantee
  • Client
  • I_DELIVERYDOCUMENTITEM.PAYMENTGUARANTEEFORM == T691K.ABSFO
  • I_DELIVERYDOCUMENTITEM.MANDT == T691K.MANDT
Planning material
  • Planning material
  • Client
  • I_DELIVERYDOCUMENTITEM.PLANNINGMATERIAL == MARA.MATNR
  • I_DELIVERYDOCUMENTITEM.MANDT == MARA.MANDT
Planning plant
  • Planning plant
  • Client
  • I_DELIVERYDOCUMENTITEM.PLANNINGPLANT == T001W.WERKS
  • I_DELIVERYDOCUMENTITEM.MANDT == T001W.MANDT
Plant
  • Plant
  • Client
  • I_DELIVERYDOCUMENTITEM.PLANT == T001W.WERKS
  • I_DELIVERYDOCUMENTITEM.MANDT == T001W.MANDT
Product Number
  • Material Number
  • Product Number
  • Client
  • I_DELIVERYDOCUMENTITEM.MATERIAL == MARA.MATNR
  • I_DELIVERYDOCUMENTITEM.PRODUCT == MARA.MATNR
  • I_DELIVERYDOCUMENTITEM.MANDT == MARA.MANDT
Product Group
  • Product Group
  • Material Group
  • Client
  • I_DELIVERYDOCUMENTITEM.PRODUCTGROUP == T023.MATKL
  • I_DELIVERYDOCUMENTITEM.MATERIALGROUP == T023.MATKL
  • I_DELIVERYDOCUMENTITEM.MANDT == T023.MANDT
Base unit of measure for product group
  • Base unit of measure for product group
  • Client
  • I_DELIVERYDOCUMENTITEM.PRODUCTGROUPBASEUNIT == T006.MSEHI
  • I_DELIVERYDOCUMENTITEM.MANDT == T006.MANDT
Product hierarchy
  • Product hierarchy
  • Client
  • I_DELIVERYDOCUMENTITEM.PRODUCTHIERARCHYNODE == T179.PRODH
  • I_DELIVERYDOCUMENTITEM.MANDT == T179.MANDT
Logical System in the Preceding Document I_DELIVERYDOCUMENTITEM.REFERENCEDOCUMENTLOGICALSYSTEM == TBDLS.LOGSYS
Promotion
  • Promotion
  • Client
  • I_DELIVERYDOCUMENTITEM.RETAILPROMOTION == WAKH.AKTNR
  • I_DELIVERYDOCUMENTITEM.MANDT == WAKH.MANDT
Sales group
  • Client
  • Sales group
  • I_DELIVERYDOCUMENTITEM.MANDT == TVKGR.MANDT
  • I_DELIVERYDOCUMENTITEM.SALESGROUP == TVKGR.VKGRP
Sales office
  • Sales office
  • Client
  • I_DELIVERYDOCUMENTITEM.SALESOFFICE == TVBUR.VKBUR
  • I_DELIVERYDOCUMENTITEM.MANDT == TVBUR.MANDT
Storage Bin
  • Warehouse Number / Warehouse Complex
  • Client
  • Storage Bin
  • Storage Type
  • I_DELIVERYDOCUMENTITEM.WAREHOUSE == LAGP.LGNUM
  • I_DELIVERYDOCUMENTITEM.MANDT == LAGP.MANDT
  • I_DELIVERYDOCUMENTITEM.STORAGEBIN == LAGP.LGPLA
  • I_DELIVERYDOCUMENTITEM.STORAGETYPE == LAGP.LGTYP
Storage location
  • Plant
  • Storage location
  • Client
  • I_DELIVERYDOCUMENTITEM.PLANT == T001L.WERKS
  • I_DELIVERYDOCUMENTITEM.STORAGELOCATION == T001L.LGORT
  • I_DELIVERYDOCUMENTITEM.MANDT == T001L.MANDT
Storage Type
  • Warehouse Number / Warehouse Complex
  • Client
  • Storage Type
  • I_DELIVERYDOCUMENTITEM.WAREHOUSE == T301.LGNUM
  • I_DELIVERYDOCUMENTITEM.MANDT == T301.MANDT
  • I_DELIVERYDOCUMENTITEM.STORAGETYPE == T301.LGTYP
SD Document Currency
  • Client
  • SD Document Currency
  • I_DELIVERYDOCUMENTITEM.MANDT == TCURC.MANDT
  • I_DELIVERYDOCUMENTITEM.TRANSACTIONCURRENCY == TCURC.WAERS
Transportation Group
  • Transportation Group
  • Client
  • I_DELIVERYDOCUMENTITEM.TRANSPORTATIONGROUP == TTGR.TRAGR
  • I_DELIVERYDOCUMENTITEM.MANDT == TTGR.MANDT
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • I_DELIVERYDOCUMENTITEM.WAREHOUSE == T300.LGNUM
  • I_DELIVERYDOCUMENTITEM.MANDT == T300.MANDT
Staging Area in Warehouse
  • Staging Area for Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • I_DELIVERYDOCUMENTITEM.WAREHOUSESTAGINGAREA == T30C.LGBZO
  • I_DELIVERYDOCUMENTITEM.WAREHOUSE == T30C.LGNUM
  • I_DELIVERYDOCUMENTITEM.MANDT == T30C.MANDT