SAP ABAP Table VBDPL (Document Item View for Delivery Note)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LE-SHP-GF (Application Component) Basic Functions
     ⤷ VLD (Package) WS-SHP: Print, SAPscript

Basic Data

Table Category	INTTAB	Structure
Structure	VBDPL	Table Relationship Diagram
Short Description	Document Item View for Delivery Note

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
2	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
3	POSEX	☐	POSEX	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
4	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	MATWA	☐	MATWA	MATNR	CHAR	18	0	Material entered	MARA
6	IDNKD	☐	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number
7	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
8	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
9	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
10	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
11	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
12	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
13	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
14	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
15	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	T005
16	HERKR	☐	HERKR	REGIO	CHAR	3	0	Region of origin of material (non-preferential origin)	*
17	STAWN	☐	STAWN	STAWN	CHAR	17	0	Commodity Code/Import Code Number for Foreign Trade	*
18	BRGEW	☐	BRGEW_15	MENG15	QUAN	15	3	Gross weight
19	NTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
20	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
21	LFIMG	☐	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
22	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
23	MBDAT	☐	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
24	VBELN_VAUF	☐	VBELN_VAUF	VBELN	CHAR	10	0	Order	VBUK
25	POSNR_VAUF	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
26	AUDAT_VAUF	☐	AUDAT_VAUF	DATUM	DATS	8	0	Sales order date
27	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
28	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
29	BSTZD	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
30	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
31	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
32	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
33	INCO1_BEZ	☐	INCO1_BEZ	TEXT30	CHAR	30	0	Incoterm description
34	TDNAME	☐	TDOBNAME	TDOBNAME	CHAR	70	0	Name
35	UEPOS	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures	*
36	VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
37	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
38	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
39	EXART	☐	EXART	EXART	CHAR	2	0	Business Transaction Type for Foreign Trade	*
40	EXART_BEZ	☐	BEZEI20	TEXT20	CHAR	20	0	Description
41	GRWRT	☐	GRWRT	GRWRT	CURR	13	2	Statistical value for foreign trade
42	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
43	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	*
44	VGTYP	☐	VGTYP	VORG_TYP	CHAR	3	0	Activity or element category
45	SORTKRI	☐	SORTKRI	CHAR20	CHAR	20	0	Sort Criterion
46	LGMNG	☐	LGMNG	MENG13	QUAN	13	3	Actual quantity delivered in stockkeeping units
47	KCMENG	☐	KCMENG	MENG15	QUAN	15	3	Cumulative batch quantity of all split items (in StckUnit)
48	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
49	UECHA	☐	UECHA	POSNR	NUMC	6	0	Higher-Level Item of Batch Split Item	*
50	KCBRGEW	☐	KCBRGEW	MENG15	QUAN	15	3	Cumulative gross weight of all batch split items
51	KCNTGEW	☐	KCNTGEW	MENG15	QUAN	15	3	Cumulative net weight of all batch split items
52	KCGEWEI	☐	KCGEWEI	MEINS	UNIT	3	0	Weight unit for weight of all batch split items	*
53	KCVOLUM	☐	KCVOLUM	MENG15	QUAN	15	3	Cumulative volume of all batch split items
54	KCVOLEH	☐	KCVOLEH	MEINS	UNIT	3	0	Volume Unit for Volume of all Batch Split Items	*
55	KNUMH_CH	☐	KNUMH_CH	KNUMB	CHAR	10	0	Number of condition record from batch determination
56	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
57	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
58	CUOBJ	☐	CUOBJ_VA	CUOBJ	NUMC	18	0	Configuration
59	CUOBJ_CH	☐	CUOBJ_CH	CUOBJ	NUMC	18	0	Internal object number of the batch classification
60	SHKZG	☐	SHKZG_VA	XFELD	CHAR	1	0	Returns Item
61	PCKPF	☐	PCKPF	PCKPF	CHAR	1	0	Packing control
62	ABRVW	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator	*
63	ABART	☐	ABART	ABART	CHAR	1	0	Release type
64	ABRLI	☐	ABRLI	ABRLI	NUMC	4	0	Internal delivery schedule number	*
65	AESKD	☐	AESKD	AESKD	CHAR	17	0	Customer Engineering Change Status
66	EMPST	☐	EMPST	TEXT25	CHAR	25	0	Receiving point
67	ABTNR	☐	ABTNR	ABTNR	CHAR	4	0	Department number	*
68	POSAR	☐	POSAR	POSAR	CHAR	1	0	Item type
69	PSTYV	☐	PSTYV_VL	PSTYV	CHAR	4	0	Delivery item category	TVLP
70	TPREL	☐	TPREL	XFELD	CHAR	1	0	Indicator: Relevance for transport of deliv. item categories
71	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
72	KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
73	KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	*
74	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
75	NETWR	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
76	ANZSN	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers
77	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
78	SUGRD	☐	SUGRD	SUGRD	CHAR	4	0	Reason for material substitution	*
79	SUDRU	☐	SUDRU	XFELD	CHAR	1	0	Original entry will be printed
80	VBRST	☐	VBRST	CHAR14	CHAR	14	0	Customer point of consumption
81	USR01_VBLB	☐	USR01_D	TEXT35	CHAR	35	0	Additional data field 1 for delivery schedules
82	USR02_VBLB	☐	USR02_D	TEXT35	CHAR	35	0	Additional data field 2 for delivery schedules
83	USR03_VBLB	☐	USR03_D	TEXT35	CHAR	35	0	Additional data field 3 for delivery schedules
84	USR04_VBLB	☐	USR04_D	CHAR10	CHAR	10	0	Additional data field 4 for delivery schedules
85	USR05_VBLB	☐	USR05_D	CHAR10	CHAR	10	0	Additional data field 5 for delivery schedules
86	PREFE	☐	PREFE	PREFE	CHAR	1	0	Preference indicator in export/import
87	LABNK	☐	LABNK	TEXT17	CHAR	17	0	Customer number for forecast / JIT dlv. sched.
88	ABRDT	☐	ABRDT	DATUM	DATS	8	0	Delivery Schedule Date
89	KZUMW	☐	KZUMW	XFELD	CHAR	1	0	Indicator: Environmentally relevant
90	PROFL	☐	ADGE_PROFL	ADGD_PROFL	CHAR	3	0	Dangerous goods indicator profile	*
91	IDGPA	☐	ADGE_IDGPA	X	CHAR	1	0	Relevant for Dangerous Goods Documents
92	IDGCH	☐	ADGE_IDGCH	X	CHAR	1	0	Relevant for Dangerous Goods Checks
93	DGNTGEW	☐	ADGE_NTGEW	MENG15	QUAN	15	3	Dangerous goods - net weight
94	DGBRGEW	☐	ADGE_BRGEW	MENG15	QUAN	15	3	Dangerous Goods - Gross Weight
95	DGGEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
96	DGVOLUM	☐	ADGE_VOLUM	MENG15	QUAN	15	3	Dangerous goods - volume
97	DGVOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
98	DGARAND	☐	ADGE_KARN	X	CHAR	1	0	Exemption
99	DGREPQU	☐	ADGE_IRQA	X	CHAR	1	0	Indicator: Reportable quantity
100	DGPULIM	☐	ADGE_IPUL	X	CHAR	1	0	Packed Under 450 l
101	DGPAS	☐	ADGE_PAS	X	CHAR	1	0	Listed Goods
102	DGMDDAT	☐	ADGE_MDDAT	DATUM	DATS	8	0	Selection date dangerous goods master data
103	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
104	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	*
105	BSTKD_E	☐	BSTKD_E	BSTKD	CHAR	35	0	Ship-to Party's Purchase Order Number
106	BSTDK_E	☐	BSTDK_E	DATUM	DATS	8	0	Ship-to party's PO date
107	BSARK_E	☐	BSARK_E	BSARK	CHAR	4	0	Ship-to party purchase order type	*
108	IHREZ_E	☐	IHREZ_E	TEXT12	CHAR	12	0	Ship-to party character
109	POSEX_E	☐	POSEX_E	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
110	VBKLT	☐	VBKLT	VBKLT	CHAR	1	0	SD document indicator
111	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
112	MTART	☐	MTART	MTART	CHAR	4	0	Material type	*
113	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*
114	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	*
115	QMDAT	☐	QMDAT	DATUM	DATS	8	0	Date of Notification
116	.INCLUDE	☐				0	0	Multistep Returns - Item Data for Printing
117	MSR_ID	☐	MSR_PROCESS_ID	MSR_PROCESS_ID	CHAR	10	0	Process Identification Number
118	MSR_ITEM	☐	MSR_PROCESS_ITEM	MSR_PROCESS_ITEM	NUMC	6	0	Item Number
119	RMA_CUSTOMER	☐	MSR_CRMA_NR	MSR_RMA_NR	CHAR	20	0	Customer RMA Number
120	MSR_RET_REASON	☐	MSR_RETURNS_REASON	MSR_RETURNS_REASON	CHAR	3	0	Return Reason	*
121	MSR_RET_REASON_TEXT	☐	MSR_RET_REASON_TEXT	TEXT60	CHAR	60	0	Return Reason Description
122	MSR_MAT_RECEIVED	☐	MSR_MATERIAL_RECEIVED	XFELD	CHAR	1	0	Material Received
123	MSR_FU_CODE	☐	MSR_FU_CODE	MSR_FU_CODE	CHAR	4	0	Follow-Up Activity Code	*
124	MSR_FU_CODE_TEXT	☐	MSR_FU_CODE_TEXT	TEXT60	CHAR	60	0	Follow-Up Activity Description
125	MSR_FORW_VENDOR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
126	MSR_FWV_TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
127	MSR_FWV_ADDRNUM	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
128	MSR_FWV_NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
129	MSR_FWV_NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
130	MSR_FWV_NAME3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
131	MSR_FWV_NAME4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
132	MSR_FWV_STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
133	MSR_FWV_PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
134	MSR_FWV_PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
135	MSR_FWV_CITY_CODE2	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)	*
136	MSR_FWV_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
137	MSR_FWV_LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
138	MSR_FWV_POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
139	MSR_FWV_CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
140	MSR_FWV_CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
141	MSR_FWV_REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
142	RMA_VENDOR	☐	MSR_VRMA_NR	MSR_RMA_NR	CHAR	20	0	Vendor RMA Number
143	MSR_REFUND_CODE	☐	MSR_RETURNS_REFUND_CODE	MSR_RETURNS_REFUND_CODE	CHAR	3	0	Returns Refund Code
144	MSR_REFUND_CODE_TEXT	☐	MSR_REFUND_CODE_TEXT	TEXT60	CHAR	60	0	Refund Code Description
145	MSR_FORW_PLANT1	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
146	MSR_PLANT1_TXT	☐	NAME1	TEXT30	CHAR	30	0	Name
147	MSR_FORW_PLANT2	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
148	MSR_PLANT2_TXT	☐	NAME1	TEXT30	CHAR	30	0	Name
149	MSR_FORW_PLANT3	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
150	MSR_PLANT3_TXT	☐	NAME1	TEXT30	CHAR	30	0	Name
151	.INCLUDE	☐				0	0	Doc.Item View Delivery Note: Customer Modification
152	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
153	.INCLU--AP	☐				0	0	Fields for Material Sorting VBDPL
154	.INCLUDE	☐				0	0	Doc.Item View Delivery Note: Customer Modification
155	/BEV1/EMMVGR1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1	*
156	/BEV1/EMMVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	*
157	/BEV1/EMMVGR3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3	*
158	/BEV1/EMMVGR4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4	*
159	/BEV1/EMMVGR5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5	*
160	/BEV1/EMNEUPOS	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VBDPL	GEWEI	T006	MSEHI
2	VBDPL	HERKL	T005	LAND1
3	VBDPL	INCO1	TINC	INCO1
4	VBDPL	LGORT	T001L	LGORT
5	VBDPL	MATNR	MARA	MATNR
6	VBDPL	MATWA	MARA	MATNR
7	VBDPL	POSNR	VBUP	POSNR
8	VBDPL	POSNR_VAUF	VBUP	POSNR
9	VBDPL	PSTYV	TVLP	PSTYV	REF	1	CN
10	VBDPL	VBELN_VAUF	VBUK	VBELN
11	VBDPL	VRKME	T006	MSEHI
12	VBDPL	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in