SAP ABAP Table MCVTRLPB (Reference Structure for MCVTRLP)

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	MCVTRLPB	Table Relationship Diagram
Short Description	Reference Structure for MCVTRLP

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

History

Last changed by/on	SAP	20140121
SAP Release Created in