SAP ABAP Table VTRLP (Delivery in Shipment: Item)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF (Application Component) Basic Functions
     ⤷ VTR (Package) SD R/3 transport processing

Basic Data

Table Category	INTTAB	Structure
Structure	VTRLP	Table Relationship Diagram
Short Description	Delivery in Shipment: Item

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTRLP	AUFNR	AUFK	AUFNR	REF	C	CN
2	VTRLP	GARVZ	TGAV	GARVZ
3	VTRLP	GEWEI	T006	MSEHI
4	VTRLP	GSBER	TGSB	GSBER	REF	C	CN
5	VTRLP	GTART	TGAR	GTART
6	VTRLP	HERKL	T005	LAND1
7	VTRLP	INCO1	TINC	INCO1
8	VTRLP	KOKRS	TKA01	KOKRS	REF	C	CN
9	VTRLP	KOSTL	CSKS	KOSTL	REF	C	CN
10	VTRLP	LGORT	T001L	LGORT
11	VTRLP	MATNR	MARA	MATNR
12	VTRLP	MATWA	MARA	MATNR
13	VTRLP	POSNR	VBUP	POSNR
14	VTRLP	POSNR_VAUF	VBUP	POSNR
15	VTRLP	PSTYV	TVLP	PSTYV	REF	1	CN
16	VTRLP	VBELN_VAUF	VBUK	VBELN
17	VTRLP	VRKME	T006	MSEHI
18	VTRLP	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20140121
SAP Release Created in