SAP table VBDPL (Document Item View for Delivery Note)

Field Description Data Type Length Decimals Checktable Data Element
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
POSNR Item number of the SD document NUMC 6 0 POSNR
POSEX Item Number of the Underlying Purchase Order CHAR 6 0 POSEX
MATNR Material Number CHAR 40 0 MARA MATNR
MATWA Material Entered CHAR 40 0 MARA MATWA
IDNKD Material Number Used by Customer CHAR 35 0 MATNR_KU
ARKTX Short text for sales order item CHAR 40 0 ARKTX
WERKS Plant CHAR 4 0 T001W WERKS_D
LGORT Storage location CHAR 4 0 T001L LGORT_D
VTWEG Distribution Channel CHAR 2 0 VTWEG
SPART Division CHAR 2 0 SPART
VKBUR Sales office CHAR 4 0 VKBUR
CHARG Batch Number CHAR 10 0 CHARG_D
SERNR BOM explosion number CHAR 8 0 SERNR
HERKL Country/Region of Origin of Material (Non-Preferential Ori.) CHAR 3 0 T005 HERKL
HERKR Region of Origin of Material (Non-Preferential Origin) CHAR 3 0 HERKR
STAWN Commodity Code CHAR 17 0 STAWN
BRGEW Gross weight QUAN 15 3 BRGEW_15
NTGEW Net weight QUAN 15 3 NTGEW_15
GEWEI Weight Unit UNIT 3 0 T006 GEWEI
LFIMG Actual quantity delivered (in sales units) QUAN 13 3 LFIMG
VRKME Sales unit UNIT 3 0 T006 VRKME
MBDAT Material Staging/Availability Date DATS 8 0 MBDAT
VBELN_VAUF Order CHAR 10 0 VBELN_VAUF
POSNR_VAUF Sales Document Item NUMC 6 0 POSNR_VA
AUDAT_VAUF Sales order date DATS 8 0 AUDAT_VAUF
BSTDK Customer Reference Date DATS 8 0 BSTDK
BSTNK Customer Reference CHAR 35 0 BSTKD
BSTZD Purchase order number supplement CHAR 4 0 BSTZD
IHREZ Your Reference CHAR 12 0 IHREZ
INCO1 Incoterms (Part 1) CHAR 3 0 TINC INCO1
INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
INCO1_BEZ Incoterm description CHAR 30 0 INCO1_BEZ
TDNAME Name CHAR 70 0 TDOBNAME
UEPOS Higher-Level Item in Bill of Material Structures NUMC 6 0 UEPOS
VOLUM Volume QUAN 15 3 VOLUM_15
VOLEH Volume unit UNIT 3 0 VOLEH
EAN11 International Article Number (EAN/UPC) CHAR 18 0 EAN11
EXART Business Transaction Type CHAR 2 0 EXART
EXART_BEZ Description CHAR 20 0 BEZEI20
GRWRT Statistical value for foreign trade CURR 13 2 GRWRT
VGBEL Document number of the reference document CHAR 10 0 VGBEL
VGPOS Item number of the reference item NUMC 6 0 VGPOS
VGTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
0 Master Contract
1 Sales Activities (CAS)
2 External Transaction
3 Invoice List
4 Credit Memo List
5 Intercompany Invoice
6 Intercompany Credit Memo
7 Delivery/Shipping Notification
8 Shipment
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
SORTKRI Sort Criterion CHAR 20 0 SORTKRI
LGMNG Actual quantity delivered in stockkeeping units QUAN 13 3 LGMNG
KCMENG Cumulative batch quantity of all split items (in StckUnit) QUAN 15 3 KCMENG
MEINS Base Unit of Measure UNIT 3 0 MEINS
UECHA Higher-Level Item of Batch Split Item NUMC 6 0 UECHA
KCBRGEW Cumulative gross weight of all batch split items QUAN 15 3 KCBRGEW
KCNTGEW Cumulative net weight of all batch split items QUAN 15 3 KCNTGEW
KCGEWEI Weight unit for weight of all batch split items UNIT 3 0 KCGEWEI
KCVOLUM Cumulative volume of all batch split items QUAN 15 3 KCVOLUM
KCVOLEH Volume Unit for Volume of all Batch Split Items UNIT 3 0 KCVOLEH
KNUMH_CH Number of condition record from batch determination CHAR 10 0 KNUMH_CH
UMVKZ Numerator (factor) for conversion of sales quantity into SKU DEC 5 0 UMVKZ
UMVKN Denominator (divisor) for conversion of sales Qty into SKU DEC 5 0 UMVKN
CUOBJ Configuration NUMC 18 0 CUOBJ_VA
CUOBJ_CH Internal object number of the batch classification NUMC 18 0 CUOBJ_CH
SHKZG Returns Item CHAR 1 0 SHKZG_VA
PCKPF Packing Control CHAR 1 0 PCKPF
Can be packed
A Must be packed
B Cannot be packed
ABRVW Usage Indicator CHAR 3 0 ABRVW
ABART Release type CHAR 1 0 ABART
Order
1 Forecast Delivery Schedule
2 JIT Delivery Schedule
3 Issue for External Agent (only in delivery)
4 Return for Scheduling Agreemnt with Release (only in dlvy)
5 Planning Delivery Schedule
6 Delivery Order (only in the delivery)
7 Return for Delivery Order (only in delivery)
ABRLI Internal delivery schedule number NUMC 4 0 ABRLI
AESKD Customer Engineering Change Status CHAR 17 0 AESKD
EMPST Receiving Point CHAR 25 0 EMPST
ABTNR Department number CHAR 4 0 ABTNR
POSAR Item Type CHAR 1 0 POSAR
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 CHAR 4 0 TVLP PSTYV_VL
TPREL Indicator: Relevance for transport of deliv. item categories CHAR 1 0 TPREL
KZWI1 Subtotal 1 from Pricing Procedure for Price Element CURR 13 2 KZWI1
KPEIN Condition Pricing Unit DEC 5 0 KPEIN
KMEIN Condition Unit UNIT 3 0 KMEIN
NETPR Net Price CURR 11 2 NETPR
NETWR Net Value in Document Currency CURR 15 2 NETWR
ANZSN Number of serial numbers INT4 10 0 ANZSN
AKTNR Promotion CHAR 10 0 WAKTION
SUGRD Reason for material substitution CHAR 4 0 SUGRD
SUDRU Original entry will be printed CHAR 1 0 SUDRU
VBRST Customer point of consumption CHAR 14 0 VBRST
USR01_VBLB Additional data field 1 for delivery schedules CHAR 35 0 USR01_D
USR02_VBLB Additional data field 2 for delivery schedules CHAR 35 0 USR02_D
USR03_VBLB Additional data field 3 for delivery schedules CHAR 35 0 USR03_D
USR04_VBLB Additional data field 4 for delivery schedules CHAR 10 0 USR04_D
USR05_VBLB Additional data field 5 for delivery schedules CHAR 10 0 USR05_D
PREFE Customs Preference CHAR 1 0 PREFE
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 Current key of delivery schedule CHAR 17 0 LABNK
ABRDT Delivery Schedule Date DATS 8 0 ABRDT
KZUMW Environmentally Relevant CHAR 1 0 KZUMW
PROFL Dangerous Goods Indicator Profile CHAR 3 0 ADGE_PROFL
IDGPA Relevant for Dangerous Goods Documents CHAR 1 0 ADGE_IDGPA
IDGCH Relevant for Dangerous Goods Checks CHAR 1 0 ADGE_IDGCH
DGNTGEW Dangerous goods - net weight QUAN 15 3 ADGE_NTGEW
DGBRGEW Dangerous Goods - Gross Weight QUAN 15 3 ADGE_BRGEW
DGGEWEI Weight Unit UNIT 3 0 GEWEI
DGVOLUM Dangerous goods - volume QUAN 15 3 ADGE_VOLUM
DGVOLEH Volume unit UNIT 3 0 VOLEH
DGARAND Exemption CHAR 1 0 ADGE_KARN
DGREPQU Indicator: Reportable quantity CHAR 1 0 ADGE_IRQA
DGPULIM Packed Under 450 l CHAR 1 0 ADGE_IPUL
DGPAS Listed Goods CHAR 1 0 ADGE_PAS
DGMDDAT Selection date dangerous goods master data DATS 8 0 ADGE_MDDAT
BSTKD Customer Reference CHAR 35 0 BSTKD
BSARK Customer Purchase Order Type CHAR 4 0 BSARK
BSTKD_E Ship-to Party's Customer Reference CHAR 35 0 BSTKD_E
BSTDK_E Ship-to Party's Customer Reference Date DATS 8 0 BSTDK_E
BSARK_E Ship-to Party Purchase Order Type CHAR 4 0 BSARK_E
IHREZ_E Ship-to Party Character CHAR 12 0 IHREZ_E
POSEX_E Item Number of the Underlying Purchase Order CHAR 6 0 POSEX_E
VBKLT SD document indicator CHAR 1 0 VBKLT
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
J JIT Scheduling Agt
K Correct consignment issue by external service agent
P Project-Based Services (PBS)
R Order for Billing Between Company Codes (RRICB)
S Solution Order
MATKL Material Group CHAR 9 0 MATKL
MTART Material type CHAR 4 0 MTART
PRODH Product hierarchy CHAR 18 0 PRODH_D
QMNUM Notification Number CHAR 12 0 QMNUM
QMDAT Date of Notification DATS 8 0 QMDAT
SGT_RCAT Requirement Segment CHAR 40 0 SGT_RCAT
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
MSR_ID Process Identification Number CHAR 10 0 MSR_PROCESS_ID
MSR_ITEM Item Number NUMC 6 0 MSR_PROCESS_ITEM
RMA_CUSTOMER Customer RMA Number CHAR 20 0 MSR_CRMA_NR
MSR_RET_REASON Return Reason CHAR 3 0 * MSR_RETURNS_REASON
MSR_RET_REASON_TEXT Return Reason Description CHAR 60 0 MSR_RET_REASON_TEXT
MSR_MAT_RECEIVED Material Received CHAR 1 0 MSR_MATERIAL_RECEIVED
MSR_FU_CODE Follow-Up Activity Code CHAR 4 0 * MSR_FU_CODE
MSR_FU_CODE_TEXT Follow-Up Activity Description CHAR 60 0 MSR_FU_CODE_TEXT
MSR_FORW_VENDOR Account Number of Supplier CHAR 10 0 LIFNR
MSR_FWV_TITLE Form-of-Address Key CHAR 4 0 * AD_TITLE
MSR_FWV_ADDRNUM Address Number CHAR 10 0 * AD_ADDRNUM
MSR_FWV_NAME1 Name 1 CHAR 40 0 AD_NAME1
MSR_FWV_NAME2 Name 2 CHAR 40 0 AD_NAME2
MSR_FWV_NAME3 Name 3 CHAR 40 0 AD_NAME3
MSR_FWV_NAME4 Name 4 CHAR 40 0 AD_NAME4
MSR_FWV_STREET Street CHAR 60 0 AD_STREET
MSR_FWV_PO_BOX PO Box CHAR 10 0 AD_POBX
MSR_FWV_PO_BOX_LOC PO Box city CHAR 40 0 AD_POBXLOC
MSR_FWV_CITY_CODE2 City PO box code (City file) CHAR 12 0 * AD_CIT2NUM
MSR_FWV_COUNTRY Country/Region Key CHAR 3 0 * LAND1
MSR_FWV_LANGU Language Key LANG 1 0 SPRAS
MSR_FWV_POST_CODE1 City postal code CHAR 10 0 AD_PSTCD1
MSR_FWV_CITY1 City CHAR 40 0 AD_CITY1
MSR_FWV_CITY2 District CHAR 40 0 AD_CITY2
MSR_FWV_REGION Region (State, Province, County) CHAR 3 0 * REGIO
RMA_VENDOR Supplier RMA Number CHAR 20 0 MSR_VRMA_NR
MSR_REFUND_CODE Returns Refund Code CHAR 3 0 MSR_RETURNS_REFUND_CODE
MSR_REFUND_CODE_TEXT Refund Code Description CHAR 60 0 MSR_REFUND_CODE_TEXT
MSR_FORW_PLANT1 Plant CHAR 4 0 WERKS_D
MSR_PLANT1_TXT Name CHAR 30 0 NAME1
MSR_FORW_PLANT2 Plant CHAR 4 0 WERKS_D
MSR_PLANT2_TXT Name CHAR 30 0 NAME1
MSR_FORW_PLANT3 Plant CHAR 4 0 WERKS_D
MSR_PLANT3_TXT Name CHAR 30 0 NAME1
DUMMY Dummy function in length 1 CHAR 1 0 DUMMY
INCOV Incoterms Version CHAR 4 0 TINCV INCOV
INCO2_L Incoterms Location 1 CHAR 70 0 INCO2_L
INCO3_L Incoterms Location 2 CHAR 70 0 INCO3_L
INCO2_L_LBL Incoterms Location 1 Label CHAR 25 0 INCO2_L_LBL
INCO3_L_LBL Incoterms Location 2 Label CHAR 25 0 INCO3_L_LBL
BSTOB Location2 is mandatory CHAR 1 0 BSTOB
Disabled
O Optional
R Required
DUMMY_DELITM_INCL_EEW_PS Dummy function in length 1 CHAR 1 0 DUMMY
DUMMY_DELIVERYITEM_INCL_EEW_TR Dummy function in length 1 CHAR 1 0 DUMMY
BSTKN Customer Reference Date DATS 8 0 BSTDK
/BEV1/EMMVGR1 Material Group 1 CHAR 3 0 * MVGR1
/BEV1/EMMVGR2 Material Group 2 CHAR 3 0 * MVGR2
/BEV1/EMMVGR3 Material Group 3 CHAR 3 0 * MVGR3
/BEV1/EMMVGR4 Material Group 4 CHAR 3 0 * MVGR4
/BEV1/EMMVGR5 Material Group 5 CHAR 3 0 * MVGR5
/BEV1/EMNEUPOS Item number of the SD document NUMC 6 0 POSNR
FSH_SEASON Season CHAR 10 0 FSH_SAISO
FSH_SEASON_YEAR Season Year CHAR 4 0 FSH_SAISJ
FSH_COLLECTION Fashion Collection CHAR 10 0 * FSH_COLLECTION
FSH_THEME Fashion Theme CHAR 10 0 FSH_THEME
LIFEXPOS External item number NUMC 6 0 LIFEXPOS
WRF_CHARSTC1 Characteristic Value 1 CHAR 18 0 WRF_CHARSTC1
WRF_CHARSTC2 Characteristic Value 2 CHAR 18 0 WRF_CHARSTC2
WRF_CHARSTC3 Characteristic Value 3 CHAR 18 0 WRF_CHARSTC3

VBDPL foreign key relationships

Table Field Check Table Check Field
0 VBDPL GEWEI T006 Units of Measurement MANDT
0 VBDPL GEWEI T006 Units of Measurement MSEHI
1 VBDPL HERKL T005 Countries MANDT
1 VBDPL HERKL T005 Countries LAND1
0 VBDPL INCO1 TINC Customers: Incoterms INCO1
1 VBDPL INCOV TINCV Incoterms Versions MANDT
1 VBDPL INCOV TINCV Incoterms Versions INCOV
0 VBDPL LGORT T001L Storage Locations MANDT
0 VBDPL LGORT T001L Storage Locations WERKS
1 VBDPL MATNR MARA General Material Data MANDT
1 VBDPL MATNR MARA General Material Data MATNR
0 VBDPL MATWA MARA General Material Data MANDT
0 VBDPL MATWA MARA General Material Data MATNR
1 VBDPL PSTYV TVLP Deliveries: Item Categories MANDT
1 VBDPL PSTYV TVLP Deliveries: Item Categories PSTYV
0 VBDPL VRKME T006 Units of Measurement MANDT
0 VBDPL VRKME T006 Units of Measurement MSEHI
1 VBDPL WERKS T001W Plants/Branches MANDT
1 VBDPL WERKS T001W Plants/Branches WERKS