SAP Table BAPIOBDLVITEM

Outbound Delivery Item

BAPIOBDLVITEM (Outbound Delivery Item) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BAPIOBDLVITEM to other SAP tables.

BAPIOBDLVITEM table fields

Field Data element Checktable Datatype Length Decimals
DELIV_NUMB Delivery VBELN_VL VBUK CHAR 10 0
ITM_NUMBER Item number of the SD document POSNR VBUP NUMC 6 0
MATERIAL Material Number MATNR MARA CHAR 18 0
MAT_ENTRD Material entered MATWA MARA CHAR 18 0
SHORT_TEXT Short text for sales order item ARKTX CHAR 40 0
BATCH Batch Number CHARG_D MCH1 CHAR 10 0
CUST_MAT Material belonging to the customer KDMAT CHAR 35 0
DLV_QTY Actual quantity delivered (in sales units) LFIMG QUAN 13 3
SALES_UNIT_ISO ISO code for sales unit ISOCD_VRKME T006I CHAR 3 0
SALES_UNIT Sales unit VRKME T006 UNIT 3 0
DLV_QTY_STOCK Actual quantity delivered in stockkeeping units LGMNG QUAN 13 3
BASE_UOM Base Unit of Measure MEINS T006 UNIT 3 0
BASE_UOM_ISO Base unit of measure in ISO code MEINS_ISO T006I CHAR 3 0
NET_WEIGHT Net weight NTGEW_15 QUAN 15 3
GROSS_WT Gross weight BRGEW_15 QUAN 15 3
UNIT_OF_WT_ISO Unit of weight in ISO code GEWEI_ISO T006I CHAR 3 0
UNIT_OF_WT Weight Unit GEWEI T006 UNIT 3 0
VOLUME Volume VOLUM_15 QUAN 15 3
VOLUMEUNIT_ISO Volume unit in ISO code VOLEH_ISO T006I CHAR 3 0
VOLUMEUNIT Volume unit VOLEH T006 UNIT 3 0
STGE_BIN Storage Bin LGPBE CHAR 10 0
HIERARITEM Superior item in an item hierarchy HIPOS VBUP NUMC 6 0
USEHIERITM Use of Hierarchy Item HIEVW CHAR 1 0
1 Batch Subitem
2 BOM Subitem
3 Product Selection
4 Subitem (Automotive)
5 Free Goods (On-Top Bonus)
6 Complete Goods (Purchase Order)
NULL Main Item
7 Kit Component
8 Replacement Kit Component
S TPOP Supersession Subitem
9 Free Goods (Inclusive Bonus)
LOADINGGRP Loading Group LADGR TLGR CHAR 4 0
TRANS_GRP Transportation Group TRAGR TTGR CHAR 4 0
DLV_GROUP Delivery group (items are delivered together) GRKOR NUMC 3 0
EAN_UPC International Article Number (EAN/UPC) EAN11 CHAR 18 0
BOMEXPL_NO BOM explosion number SERNR SNUM CHAR 8 0
REC_POINT Receiving point EMPST CHAR 25 0
MATFRGTGRP Material freight group MFRGR TMFG CHAR 8 0
ITEM_CATEG Sales document item category PSTYV TVPT CHAR 4 0
PART_DLV Partial delivery at item level KZTLF CHAR 1 0
NULL Partial delivery allowed
A Create a delivery with qty greater than zero
B Create only one delivery (also with quantity = 0)
C Only complete delivery allowed
D No limit to subsequent deliveries
OVERDEL_UNLIM Indicator: Unlimited Overdelivery Allowed UEBTK CHAR 1 0
X Yes
NULL No
OVERDELTOL Overdelivery Tolerance Limit UEBTO DEC 3 1
UNDER_TOL Underdelivery Tolerance Limit UNTTO DEC 3 1
BTCH_SPLIT Batch split allowed CHSPL CHAR 1 0
X Yes
NULL No
BTCHEVALTYP Indicator for Batches / Evaluation Types XCHBW CHAR 1 0
NULL No batch / valuation type
1 Batch
2 Valuation type
ITEM_TYPE Item type POSAR CHAR 1 0
NULL Standard Item
A Value Item
B Text item
C Packing item (will be generated)
D Material not relevant
E Packaging Item (External)
SPEC_STOCK Special Stock Indicator SOBKZ T148 CHAR 1 0
PACKCNTRL Packing control PCKPF CHAR 1 0
NULL Can be packed
A Must be packed
B Cannot be packed
MAT_GRP_SM Material Group: Packaging Materials MAGRV TVEGR CHAR 4 0
DB_CR_IND Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
PROMOTION Promotion WAKTION WAKH CHAR 10 0
ENVT_RLVT Environmentally Relevant KZUMW CHAR 1 0
X Yes
NULL No
MOVE_TYPE Movement Type (Inventory Management) BWART T156 CHAR 3 0
MOVE_TYPE_WM Reference movement type for WM from material movements RBLVS NUMC 3 0
STOCK_TYPE Stock Type MB_INSMK CHAR 1 0
X Quality inspection
S Blocked
2 Quality inspection
3 Blocked
NULL Unrestricted-use
F Unrestricted-use
MVT_IND Movement Indicator KZBEW CHAR 1 0
NULL Goods movement w/o reference
B Goods movement for purchase order
F Goods movement for production order
L Goods movement for delivery note
K Goods movement for kanban requirement (WM - internal only)
O Subsequent adjustment of "material-provided" consumption
W Subsequent adjustment of proportion/product unit material
CUM_BTCH_QTY Cumulative batch quantity of all split items (in StckUnit) KCMENG QUAN 15 3
CUM_BTCH_GR_WT Cumulative gross weight of all batch split items KCBRGEW QUAN 15 3
CUM_BTCH_NT_WT Cumulative net weight of all batch split items KCNTGEW QUAN 15 3
CUM_BTCH_VOL Cumulative volume of all batch split items KCVOLUM QUAN 15 3
CUMBTCHWTUN Weight Unit GEWEI T006 UNIT 3 0
CUMBTCHWTUN_ISO Unit of weight in ISO code GEWEI_ISO T006I CHAR 3 0
CUMBTCHVOLUN Volume unit VOLEH T006 UNIT 3 0
CUMBTCHVOLUN_ISO Volume unit in ISO code VOLEH_ISO T006I CHAR 3 0
STOCK_CAT Stock Category in the Warehouse Management System BESTQ CHAR 1 0
NULL Available Stock
Q Stock in Quality Control
R Returns Stock
S Blocked Stock
SP_STCK_NO Special Stock Number LVS_SONUM CHAR 16 0
MATL_GROUP Material Group MATKL CHAR 9 0
MATL_TYPE Material Type MTART CHAR 4 0
PROD_HIER Product hierarchy PRODH_D CHAR 18 0
MATL_GRP_1 Material group 1 MVGR1 CHAR 3 0
MATL_GRP_2 Material group 2 MVGR2 CHAR 3 0
MATL_GRP_3 Material group 3 MVGR3 CHAR 3 0
MATL_GRP_4 Material group 4 MVGR4 CHAR 3 0
MATL_GRP_5 Material group 5 MVGR5 CHAR 3 0
CUST_GRP2 Customer group 2 KVGR2 CHAR 3 0
CUST_GRP3 Customer group 3 KVGR3 CHAR 3 0
CUST_GRP4 Customer group 4 KVGR4 CHAR 3 0
CUST_GRP5 Customer group 5 KVGR5 CHAR 3 0
CUST_GRP1 Customer group 1 KVGR1 CHAR 3 0
DEL_QTY_FLO Internal field/ Do not use / LFIMG in float / MUM LFIMG_FLO FLTP 16 16
CONV_FACT Conversion factor: quantities UMREFF FLTP 16 16
DLV_QTY_ST_FLO Internal field/ Do not use / LGMNG in float / MUM LGMNG_FLO FLTP 16 16
SALES_QTY_DENOM Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 0
SALES_QTY_NUM Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 0
FLG_LEAD_UNIT ID: Leading unit of measure for completing a transaction KZFME CHAR 1 0
NULL Base Unit of Measure has Priority
A Proportional Unit has Priority (Active Ingredient)
B Product Unit of Measure has Priority (Steel)
CUMBTCHQTYSU_FLO Cumulated batch split quantity in VRKME and float KCMENGVMEF FLTP 16 16
CUMBTCHQTYSU Cumulative batch quantity of all split items in sales units KCMENG_VME QUAN 15 3
VAL_TYPE Valuation Type BWTAR_D CHAR 10 0
MATERIAL_EXTERNAL Long Material Number for MATERIAL Field MGV_MATERIAL_EXTERNAL CHAR 40 0
MATERIAL_GUID External GUID for MATERIAL Field MGV_MATERIAL_GUID CHAR 32 0
MATERIAL_VERSION Version Number for MATERIAL Field MGV_MATERIAL_VERSION CHAR 10 0
MAT_ENTRD_EXTERNAL Long Material Number for MAT_ENTRD Field MGV_MAT_ENTRD_EXTERNAL CHAR 40 0
MAT_ENTRD_GUID External GUID for MAT_ENTRD Field MGV_MAT_ENTRD_GUID CHAR 32 0
MAT_ENTRD_VERSION Version Number for MAT_ENTRD Field MGV_MAT_ENTRD_VERSION CHAR 10 0
INSPLOT Inspection Lot Number QPLOS NUMC 12 0

BAPIOBDLVITEM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BAPIOBDLVITEM BASE_UOM * T006 Units of Measurement MANDT
BAPIOBDLVITEM BASE_UOM BAPIOBDLVITEM BASE_UOM T006 Units of Measurement MSEHI
BAPIOBDLVITEM BASE_UOM_ISO * T006I ISO codes for units of measurement CLIENT
BAPIOBDLVITEM BASE_UOM_ISO BAPIOBDLVITEM BASE_UOM_ISO T006I ISO codes for units of measurement ISOCODE
BAPIOBDLVITEM BATCH * MCH1 Batches (if Batch Management Cross-Plant) MANDT
BAPIOBDLVITEM BATCH BAPIOBDLVITEM MATERIAL MCH1 Batches (if Batch Management Cross-Plant) MATNR
BAPIOBDLVITEM BATCH BAPIOBDLVITEM BATCH MCH1 Batches (if Batch Management Cross-Plant) CHARG
BAPIOBDLVITEM BOMEXPL_NO BAPIOBDLVITEM BOMEXPL_NO SNUM BOM explosion number SERNR
BAPIOBDLVITEM BOMEXPL_NO * SNUM BOM explosion number MANDT
BAPIOBDLVITEM CUMBTCHVOLUN * T006 Units of Measurement MANDT
BAPIOBDLVITEM CUMBTCHVOLUN BAPIOBDLVITEM CUMBTCHVOLUN T006 Units of Measurement MSEHI
BAPIOBDLVITEM CUMBTCHVOLUN_ISO BAPIOBDLVITEM CUMBTCHVOLUN_ISO T006I ISO codes for units of measurement ISOCODE
BAPIOBDLVITEM CUMBTCHVOLUN_ISO * T006I ISO codes for units of measurement CLIENT
BAPIOBDLVITEM CUMBTCHWTUN BAPIOBDLVITEM CUMBTCHWTUN T006 Units of Measurement MSEHI
BAPIOBDLVITEM CUMBTCHWTUN * T006 Units of Measurement MANDT
BAPIOBDLVITEM CUMBTCHWTUN_ISO * T006I ISO codes for units of measurement CLIENT
BAPIOBDLVITEM CUMBTCHWTUN_ISO BAPIOBDLVITEM CUMBTCHWTUN_ISO T006I ISO codes for units of measurement ISOCODE
BAPIOBDLVITEM DELIV_NUMB * VBUK Sales Document: Header Status and Administrative Data MANDT
BAPIOBDLVITEM DELIV_NUMB BAPIOBDLVITEM DELIV_NUMB VBUK Sales Document: Header Status and Administrative Data VBELN
BAPIOBDLVITEM HIERARITEM BAPIOBDLVITEM HIERARITEM VBUP Sales Document: Item Status POSNR
BAPIOBDLVITEM HIERARITEM * VBUP Sales Document: Item Status MANDT
BAPIOBDLVITEM HIERARITEM BAPIOBDLVITEM DELIV_NUMB VBUP Sales Document: Item Status VBELN
BAPIOBDLVITEM ITEM_CATEG BAPIOBDLVITEM ITEM_CATEG TVPT Sales documents: Item categories PSTYV
BAPIOBDLVITEM ITEM_CATEG * TVPT Sales documents: Item categories MANDT
BAPIOBDLVITEM ITM_NUMBER * VBUP Sales Document: Item Status MANDT
BAPIOBDLVITEM ITM_NUMBER BAPIOBDLVITEM DELIV_NUMB VBUP Sales Document: Item Status VBELN
BAPIOBDLVITEM ITM_NUMBER BAPIOBDLVITEM ITM_NUMBER VBUP Sales Document: Item Status POSNR
BAPIOBDLVITEM LOADINGGRP * TLGR Routes: Loading Groups MANDT
BAPIOBDLVITEM LOADINGGRP BAPIOBDLVITEM LOADINGGRP TLGR Routes: Loading Groups LADGR
BAPIOBDLVITEM MATERIAL * MARA General Material Data MANDT
BAPIOBDLVITEM MATERIAL BAPIOBDLVITEM MATERIAL MARA General Material Data MATNR
BAPIOBDLVITEM MATFRGTGRP BAPIOBDLVITEM MATFRGTGRP TMFG Material freight groups MFRGR
BAPIOBDLVITEM MATFRGTGRP * TMFG Material freight groups MANDT
BAPIOBDLVITEM MAT_ENTRD BAPIOBDLVITEM MAT_ENTRD MARA General Material Data MATNR
BAPIOBDLVITEM MAT_ENTRD * MARA General Material Data MANDT
BAPIOBDLVITEM MAT_GRP_SM * TVEGR Material Group: Packaging Materials MANDT
BAPIOBDLVITEM MAT_GRP_SM BAPIOBDLVITEM MAT_GRP_SM TVEGR Material Group: Packaging Materials MAGRV
BAPIOBDLVITEM MOVE_TYPE * T156 Movement Type MANDT
BAPIOBDLVITEM MOVE_TYPE BAPIOBDLVITEM MOVE_TYPE T156 Movement Type BWART
BAPIOBDLVITEM PROMOTION BAPIOBDLVITEM PROMOTION WAKH Promotion Header Data, IS-R AKTNR
BAPIOBDLVITEM PROMOTION * WAKH Promotion Header Data, IS-R MANDT
BAPIOBDLVITEM SALES_UNIT * T006 Units of Measurement MANDT
BAPIOBDLVITEM SALES_UNIT BAPIOBDLVITEM SALES_UNIT T006 Units of Measurement MSEHI
BAPIOBDLVITEM SALES_UNIT_ISO * T006I ISO codes for units of measurement CLIENT
BAPIOBDLVITEM SALES_UNIT_ISO BAPIOBDLVITEM SALES_UNIT_ISO T006I ISO codes for units of measurement ISOCODE
BAPIOBDLVITEM SPEC_STOCK * T148 Special Stock Indicator MANDT
BAPIOBDLVITEM SPEC_STOCK BAPIOBDLVITEM SPEC_STOCK T148 Special Stock Indicator SOBKZ
BAPIOBDLVITEM TRANS_GRP * TTGR Delivery Scheduling: Transportation Groups MANDT
BAPIOBDLVITEM TRANS_GRP BAPIOBDLVITEM TRANS_GRP TTGR Delivery Scheduling: Transportation Groups TRAGR
BAPIOBDLVITEM UNIT_OF_WT * T006 Units of Measurement MANDT
BAPIOBDLVITEM UNIT_OF_WT BAPIOBDLVITEM UNIT_OF_WT T006 Units of Measurement MSEHI
BAPIOBDLVITEM UNIT_OF_WT_ISO BAPIOBDLVITEM UNIT_OF_WT_ISO T006I ISO codes for units of measurement ISOCODE
BAPIOBDLVITEM UNIT_OF_WT_ISO * T006I ISO codes for units of measurement CLIENT
BAPIOBDLVITEM VOLUMEUNIT * T006 Units of Measurement MANDT
BAPIOBDLVITEM VOLUMEUNIT BAPIOBDLVITEM VOLUMEUNIT T006 Units of Measurement MSEHI
BAPIOBDLVITEM VOLUMEUNIT_ISO * T006I ISO codes for units of measurement CLIENT
BAPIOBDLVITEM VOLUMEUNIT_ISO BAPIOBDLVITEM VOLUMEUNIT_ISO T006I ISO codes for units of measurement ISOCODE