SAP ABAP Table MCVTRLP (Delivery Items in Shipment for LIS Updating)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LE-TRA (Application Component) Transportation
     ⤷ MCT (Package) Application Development R/3 Transportation Inform. System

Basic Data

Table Category	INTTAB	Structure
Structure	MCVTRLP	Table Relationship Diagram
Short Description	Delivery Items in Shipment for LIS Updating

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

Foreign Keys

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

History

Last changed by/on	SAP	20140121
SAP Release Created in