1. Home
  2. Resources
  3. SAP Tables
  4. VBDPL - Document Item View for Delivery Note

SAP Table VBDPL

Document Item View for Delivery Note

VBDPL (Document Item View for Delivery Note) 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 VBDPL to other SAP tables.

VBDPL table fields

Field Data element Checktable Datatype Length Decimals
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
POSNR Item number of the SD document POSNR VBUP NUMC 6 0
POSEX Item Number of the Underlying Purchase Order POSEX CHAR 6 0
MATNR Material Number MATNR MARA CHAR 18 0
MATWA Material entered MATWA MARA CHAR 18 0
IDNKD Material Number Used by Customer MATNR_KU CHAR 35 0
ARKTX Short text for sales order item ARKTX CHAR 40 0
WERKS Plant WERKS_D T001W CHAR 4 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
SPART Division SPART CHAR 2 0
VKBUR Sales Office VKBUR CHAR 4 0
CHARG Batch Number CHARG_D CHAR 10 0
SERNR BOM explosion number SERNR CHAR 8 0
HERKL Country of origin of the material HERKL T005 CHAR 3 0
HERKR Region of origin of material (non-preferential origin) HERKR CHAR 3 0
STAWN Commodity Code/Import Code Number for Foreign Trade STAWN CHAR 17 0
BRGEW Gross weight BRGEW_15 QUAN 15 3
NTGEW Net weight NTGEW_15 QUAN 15 3
GEWEI Weight Unit GEWEI T006 UNIT 3 0
LFIMG Actual quantity delivered (in sales units) LFIMG QUAN 13 3
VRKME Sales unit VRKME T006 UNIT 3 0
MBDAT Material Staging/Availability Date MBDAT DATS 8 0
VBELN_VAUF Order VBELN_VAUF VBUK CHAR 10 0
POSNR_VAUF Sales Document Item POSNR_VA VBUP NUMC 6 0
AUDAT_VAUF Sales order date AUDAT_VAUF DATS 8 0
BSTDK Customer purchase order date BSTDK DATS 8 0
BSTNK Customer purchase order number BSTNK CHAR 20 0
BSTZD Purchase order number supplement BSTZD CHAR 4 0
IHREZ Your Reference IHREZ CHAR 12 0
INCO1 Incoterms (Part 1) INCO1 TINC CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
INCO1_BEZ Incoterm description INCO1_BEZ CHAR 30 0
TDNAME Name TDOBNAME CHAR 70 0
UEPOS Higher-level item in bill of material structures UEPOS NUMC 6 0
VOLUM Volume VOLUM_15 QUAN 15 3
VOLEH Volume unit VOLEH UNIT 3 0
EAN11 International Article Number (EAN/UPC) EAN11 CHAR 18 0
EXART Business Transaction Type for Foreign Trade EXART CHAR 2 0
EXART_BEZ Description BEZEI20 CHAR 20 0
GRWRT Statistical value for foreign trade GRWRT CURR 13 2
VGBEL Document number of the reference document VGBEL CHAR 10 0
VGPOS Item number of the reference item VGPOS NUMC 6 0
VGTYP Activity or element category VGTYP CHAR 3 0
SORTKRI Sort Criterion SORTKRI CHAR 20 0
LGMNG Actual quantity delivered in stockkeeping units LGMNG QUAN 13 3
KCMENG Cumulative batch quantity of all split items (in StckUnit) KCMENG QUAN 15 3
MEINS Base Unit of Measure MEINS UNIT 3 0
UECHA Higher-Level Item of Batch Split Item UECHA NUMC 6 0
KCBRGEW Cumulative gross weight of all batch split items KCBRGEW QUAN 15 3
KCNTGEW Cumulative net weight of all batch split items KCNTGEW QUAN 15 3
KCGEWEI Weight unit for weight of all batch split items KCGEWEI UNIT 3 0
KCVOLUM Cumulative volume of all batch split items KCVOLUM QUAN 15 3
KCVOLEH Volume Unit for Volume of all Batch Split Items KCVOLEH UNIT 3 0
KNUMH_CH Number of condition record from batch determination KNUMH_CH CHAR 10 0
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 0
UMVKN Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 0
CUOBJ Configuration CUOBJ_VA NUMC 18 0
CUOBJ_CH Internal object number of the batch classification CUOBJ_CH NUMC 18 0
SHKZG Returns Item SHKZG_VA CHAR 1 0
X Yes
NULL No
PCKPF Packing control PCKPF CHAR 1 0
NULL Can be packed
A Must be packed
B Cannot be packed
ABRVW Usage Indicator ABRVW CHAR 3 0
ABART Release type ABART CHAR 1 0
NULL Order
1 Forecast dlv. sched.
2 JIT delivery schedule
3 Issue for external agent (only in delivery)
4 Returns for scheduling agreemnt w/ release (only in dlvy)
5 Planning delivery schedule
6 Delivery order (only in the delivery)
7 Returns for delivery order (only in delivery)
ABRLI Internal delivery schedule number ABRLI NUMC 4 0
AESKD Customer Engineering Change Status AESKD CHAR 17 0
EMPST Receiving point EMPST CHAR 25 0
ABTNR Department number ABTNR CHAR 4 0
POSAR 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)
PSTYV Delivery item category PSTYV_VL TVLP CHAR 4 0
TPREL Indicator: Relevance for transport of deliv. item categories TPREL CHAR 1 0
X Yes
NULL No
KZWI1 Subtotal 1 from pricing procedure for condition KZWI1 CURR 13 2
KPEIN Condition pricing unit KPEIN DEC 5 0
KMEIN Condition unit KMEIN UNIT 3 0
NETPR Net price NETPR CURR 11 2
NETWR Net Value in Document Currency NETWR CURR 15 2
ANZSN Number of serial numbers ANZSN INT4 10 0
AKTNR Promotion WAKTION CHAR 10 0
SUGRD Reason for material substitution SUGRD CHAR 4 0
SUDRU Original entry will be printed SUDRU CHAR 1 0
X Yes
NULL No
VBRST Customer point of consumption VBRST CHAR 14 0
USR01_VBLB Additional data field 1 for delivery schedules USR01_D CHAR 35 0
USR02_VBLB Additional data field 2 for delivery schedules USR02_D CHAR 35 0
USR03_VBLB Additional data field 3 for delivery schedules USR03_D CHAR 35 0
USR04_VBLB Additional data field 4 for delivery schedules USR04_D CHAR 10 0
USR05_VBLB Additional data field 5 for delivery schedules USR05_D CHAR 10 0
PREFE Preference indicator in export/import PREFE CHAR 1 0
A Not checked
B Checked - price influenced
C Generally allowed
D Generally not allowed
E Authorized for preference: set manually
F Not authorized for preference: component of mixed origins
LABNK Customer number for forecast / JIT dlv. sched. LABNK CHAR 17 0
ABRDT Delivery Schedule Date ABRDT DATS 8 0
KZUMW Environmentally Relevant KZUMW CHAR 1 0
X Yes
NULL No
PROFL Dangerous Goods Indicator Profile ADGE_PROFL CHAR 3 0
IDGPA Relevant for Dangerous Goods Documents ADGE_IDGPA CHAR 1 0
X Yes
NULL No
IDGCH Relevant for Dangerous Goods Checks ADGE_IDGCH CHAR 1 0
X Yes
NULL No
DGNTGEW Dangerous goods - net weight ADGE_NTGEW QUAN 15 3
DGBRGEW Dangerous Goods - Gross Weight ADGE_BRGEW QUAN 15 3
DGGEWEI Weight Unit GEWEI UNIT 3 0
DGVOLUM Dangerous goods - volume ADGE_VOLUM QUAN 15 3
DGVOLEH Volume unit VOLEH UNIT 3 0
DGARAND Exemption ADGE_KARN CHAR 1 0
X Yes
NULL No
DGREPQU Indicator: Reportable quantity ADGE_IRQA CHAR 1 0
X Yes
NULL No
DGPULIM Packed Under 450 l ADGE_IPUL CHAR 1 0
X Yes
NULL No
DGPAS Listed Goods ADGE_PAS CHAR 1 0
X Yes
NULL No
DGMDDAT Selection date dangerous goods master data ADGE_MDDAT DATS 8 0
BSTKD Customer purchase order number BSTKD CHAR 35 0
BSARK Customer purchase order type BSARK CHAR 4 0
BSTKD_E Ship-to Party's Purchase Order Number BSTKD_E CHAR 35 0
BSTDK_E Ship-to party's PO date BSTDK_E DATS 8 0
BSARK_E Ship-to party purchase order type BSARK_E CHAR 4 0
IHREZ_E Ship-to party character IHREZ_E CHAR 12 0
POSEX_E Item Number of the Underlying Purchase Order POSEX_E CHAR 6 0
VBKLT SD document indicator VBKLT CHAR 1 0
NULL No classification
A Billing request (line item billing)
B Delivery order
C Scheduling agreement with delivery order
D Invoice correction request
E Delivery order correction
F Repair processing: Leading serviceable material
G Repair processing: Leading service product
H Scheduling agreement with external service agent processing
I Consignment issue by external service agent
K Correct consignment issue by external service agent
R Order for Billing Between Company Codes (RRICB)
MATKL Material Group MATKL CHAR 9 0
MTART Material Type MTART CHAR 4 0
PRODH Product hierarchy PRODH_D CHAR 18 0
QMNUM Notification No QMNUM CHAR 12 0
QMDAT Date of Notification QMDAT DATS 8 0
MSR_ID Process Identification Number MSR_PROCESS_ID CHAR 10 0
MSR_ITEM Item Number MSR_PROCESS_ITEM NUMC 6 0
RMA_CUSTOMER Customer RMA Number MSR_CRMA_NR CHAR 20 0
MSR_RET_REASON Return Reason MSR_RETURNS_REASON CHAR 3 0
MSR_RET_REASON_TEXT Return Reason Description MSR_RET_REASON_TEXT CHAR 60 0
MSR_MAT_RECEIVED Material Received MSR_MATERIAL_RECEIVED CHAR 1 0
X Yes
NULL No
MSR_FU_CODE Follow-Up Activity Code MSR_FU_CODE CHAR 4 0
MSR_FU_CODE_TEXT Follow-Up Activity Description MSR_FU_CODE_TEXT CHAR 60 0
MSR_FORW_VENDOR Account Number of Vendor or Creditor LIFNR CHAR 10 0
MSR_FWV_TITLE Form-of-Address Key AD_TITLE CHAR 4 0
MSR_FWV_ADDRNUM Address number AD_ADDRNUM CHAR 10 0
MSR_FWV_NAME1 Name 1 AD_NAME1 CHAR 40 0
MSR_FWV_NAME2 Name 2 AD_NAME2 CHAR 40 0
MSR_FWV_NAME3 Name 3 AD_NAME3 CHAR 40 0
MSR_FWV_NAME4 Name 4 AD_NAME4 CHAR 40 0
MSR_FWV_STREET Street AD_STREET CHAR 60 0
MSR_FWV_PO_BOX PO Box AD_POBX CHAR 10 0
MSR_FWV_PO_BOX_LOC PO Box city AD_POBXLOC CHAR 40 0
MSR_FWV_CITY_CODE2 City PO box code (City file) AD_CIT2NUM CHAR 12 0
MSR_FWV_COUNTRY Country Key LAND1 CHAR 3 0
MSR_FWV_LANGU Language Key SPRAS LANG 1 0
MSR_FWV_POST_CODE1 City postal code AD_PSTCD1 CHAR 10 0
MSR_FWV_CITY1 City AD_CITY1 CHAR 40 0
MSR_FWV_CITY2 District AD_CITY2 CHAR 40 0
MSR_FWV_REGION Region (State, Province, County) REGIO CHAR 3 0
RMA_VENDOR Vendor RMA Number MSR_VRMA_NR CHAR 20 0
MSR_REFUND_CODE Returns Refund Code MSR_RETURNS_REFUND_CODE CHAR 3 0
MSR_REFUND_CODE_TEXT Refund Code Description MSR_REFUND_CODE_TEXT CHAR 60 0
MSR_FORW_PLANT1 Plant WERKS_D CHAR 4 0
MSR_PLANT1_TXT Name NAME1 CHAR 30 0
MSR_FORW_PLANT2 Plant WERKS_D CHAR 4 0
MSR_PLANT2_TXT Name NAME1 CHAR 30 0
MSR_FORW_PLANT3 Plant WERKS_D CHAR 4 0
MSR_PLANT3_TXT Name NAME1 CHAR 30 0
DUMMY Dummy function in length 1 DUMMY CHAR 1 0
/BEV1/EMMVGR1 Material group 1 MVGR1 CHAR 3 0
/BEV1/EMMVGR2 Material group 2 MVGR2 CHAR 3 0
/BEV1/EMMVGR3 Material group 3 MVGR3 CHAR 3 0
/BEV1/EMMVGR4 Material group 4 MVGR4 CHAR 3 0
/BEV1/EMMVGR5 Material group 5 MVGR5 CHAR 3 0
/BEV1/EMNEUPOS Item number of the SD document POSNR NUMC 6 0
BWTAR Valuation Type BWTAR_D CHAR 10 0

VBDPL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VBDPL GEWEI SYST MANDT T006 Units of Measurement MANDT
VBDPL GEWEI VBDPL GEWEI T006 Units of Measurement MSEHI
VBDPL HERKL VBDPL HERKL T005 Countries LAND1
VBDPL HERKL SYST MANDT T005 Countries MANDT
VBDPL INCO1 VBDPL INCO1 TINC Customers: Incoterms INCO1
VBDPL INCO1 SYST MANDT TINC Customers: Incoterms MANDT
VBDPL LGORT VBDPL WERKS T001L Storage Locations WERKS
VBDPL LGORT VBDPL LGORT T001L Storage Locations LGORT
VBDPL LGORT SYST MANDT T001L Storage Locations MANDT
VBDPL MATNR SYST MANDT MARA General Material Data MANDT
VBDPL MATNR VBDPL MATNR MARA General Material Data MATNR
VBDPL MATWA SYST MANDT MARA General Material Data MANDT
VBDPL MATWA VBDPL MATWA MARA General Material Data MATNR
VBDPL POSNR SYST MANDT VBUP Sales Document: Item Status MANDT
VBDPL POSNR VBUK VBELN VBUP Sales Document: Item Status VBELN
VBDPL POSNR VBDPL POSNR VBUP Sales Document: Item Status POSNR
VBDPL POSNR_VAUF VBDPL POSNR_VAUF VBUP Sales Document: Item Status POSNR
VBDPL POSNR_VAUF SYST MANDT VBUP Sales Document: Item Status MANDT
VBDPL POSNR_VAUF VBDPL VBELN_VAUF VBUP Sales Document: Item Status VBELN
VBDPL PSTYV SY MANDT TVLP Deliveries: Item Categories MANDT
VBDPL PSTYV VBDPL PSTYV TVLP Deliveries: Item Categories PSTYV
VBDPL VBELN_VAUF SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBDPL VBELN_VAUF VBDPL VBELN_VAUF VBUK Sales Document: Header Status and Administrative Data VBELN
VBDPL VRKME SYST MANDT T006 Units of Measurement MANDT
VBDPL VRKME VBDPL VRKME T006 Units of Measurement MSEHI
VBDPL WERKS SYST MANDT T001W Plants/Branches MANDT
VBDPL WERKS VBDPL WERKS T001W Plants/Branches WERKS