SAP ABAP Table MGV_VEKP (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	MGV_VEKP	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	VENUM	☑	VENUM	VENUM	CHAR	10	0	Internal Handling Unit Number
3	EXIDV	☐	EXIDV	EXIDV	CHAR	20	0	External Handling Unit Identification
4	EXIDA	☐	EXIDA	EXIDA	CHAR	1	0	Type of External Handling Unit Identifier
5	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
6	LSTEL	☐	LSTEL	LSTEL	CHAR	2	0	Loading Point	TVLA
7	BRGEW	☐	BRGEW_VEKP	MENG15	QUAN	15	3	Total Weight of Handling Unit
8	NTGEW	☐	NTGEW_VEKP	MENG15	QUAN	15	3	Loading Weight of Handling Unit
9	MAGEW	☐	MAGEW_VEKP	MENG15	QUAN	15	3	Allowed Loading Weight of a Handling Unit
10	TARAG	☐	TARAG_VEKP	MENG15	QUAN	15	3	Tare weight of handling unit
11	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
12	BTVOL	☐	BTVOL_VEKP	MENG15	QUAN	15	3	Total volume of handling unit
13	NTVOL	☐	NTVOL_VEKP	MENG15	QUAN	15	3	Loading Volume of Handling Unit
14	MAVOL	☐	MAVOL_VEKP	MENG15	QUAN	15	3	Allowed Loading Volume for Handling Unit
15	TAVOL	☐	TAVOL_VEKP	MENG15	QUAN	15	3	Tare volume of handling unit
16	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
17	ANZGL	☐	ANZGL	ANZGL	INT4	10	0	Number of Similar Packaging Materials
18	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
19	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
20	ERUHR	☐	ERZET	UZEIT	TIMS	6	0	Entry time
21	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
22	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
23	AEZET	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
24	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
25	VEGR1	☐	VEGR1	VEGR1	CHAR	5	0	Handling Unit Group 1 (Freely Definable)	TVE1
26	VEGR2	☐	VEGR2	VEGR2	CHAR	5	0	Handling Unit Group 2 (Freely Definable)	TVE2
27	VEGR3	☐	VEGR3	VEGR3	CHAR	5	0	Handling Unit Group 3 (Freely Definable)	TVE3
28	VEGR4	☐	VEGR4	VEGR4	CHAR	5	0	Handling Unit Group 4 (Freely Definable)	TVE4
29	VEGR5	☐	VEGR5	VEGR5	CHAR	5	0	Handling Unit Group 5 (Freely Definable)	TVE5
30	VHILM	☐	VHILM	MATNR	CHAR	18	0	Packaging Materials	MARA
31	LAENG	☐	LAENG	MENG13	QUAN	13	3	Length
32	BREIT	☐	BREIT	MENG13	QUAN	13	3	Width
33	HOEHE	☐	HOEHE	MENG13	QUAN	13	3	Height
34	MEABM	☐	MEABM	MEINS	UNIT	3	0	Unit of Dimension for Length/Width/Height	T006
35	ERLKZ	☐	VOLLS	XFELD	CHAR	1	0	Status (at this time without functionality)
36	GEWTO	☐	GEWTO	PRZ21	DEC	3	1	Excess weight tolerance for shipping unit
37	VOLTO	☐	VOLTO	PRZ21	DEC	3	1	Excess volume tolerance limit during packing
38	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
39	VOLEH_MAX	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
40	GEWEI_MAX	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
41	VBELN_GEN	☐	VBELN_GEN	VBELN	CHAR	10	0	Delivery in Which Packaging Material Is Generated as an Item
42	POSNR_GEN	☐	POSNR_GEN	POSNR	NUMC	6	0	Generated delivery item
43	INHALT	☐	INHALT	TEXT40	CHAR	40	0	Description of Handling Unit Content
44	VHART	☐	VHIART	TRATY	CHAR	4	0	Shipping material type	TVTY
45	KAPPL	☐	NA_KAPPL	KAPPL	CHAR	2	0	Application for output conditions
46	KALSM	☐	KALSMB	KALSM	CHAR	6	0	Output determination procedure
47	KSCHL	☐	NA_KSCHL	KSCHL	CHAR	4	0	Output Type
48	MAGRV	☐	MAGRV	MAGRV	CHAR	4	0	Material Group: Packaging Materials	TVEGR
49	WERKS	☐	HUM_WERKS	WERKS	CHAR	4	0	Plant	MARC
50	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	TVPT
51	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization
52	VTWEG	☐	VTWKU	VTWEG	CHAR	2	0	Reference distrib.channel for cust.and material masters
53	LADLG	☐	LADLG	LADLG	QUAN	6	0	Lgth of loading platform in lgth of LdPlat measurement units
54	LADEH	☐	LADEH	MEINS	UNIT	3	0	Unit of Measure to Measure the Length of Loading Platform	T006
55	FARZT	☐	FARZT	FARZT	QUAN	3	0	Travel Time
56	FAREH	☐	FAREH	MEINS	UNIT	3	0	Unit of Travel Time	T006
57	ENTFE	☐	ENTFE	ENTFE	QUAN	6	0	Distance Travelled
58	EHENT	☐	EHENT	MEINS	UNIT	3	0	Unit of Distance	T006
59	LGORT	☐	HUM_LGORT	LGORT	CHAR	4	0	Storage Location	MARD
60	GEWFX	☐	GEWFX	XFELD	CHAR	1	0	Weight and Volume Fixed
61	VELTP	☐	VELTP	VELTP	CHAR	1	0	Packaging Material Category
62	EXIDV2	☐	EXIDV2	EXIDV	CHAR	20	0	Handling Unit's 2nd External Identification
63	LANDT	☐	LANDT	LAND1	CHAR	3	0	Country providing means of transport	T005
64	LANDF	☐	LANDF	LAND1	CHAR	3	0	Driver's Nationality	T005
65	NAMEF	☐	NAMEF	NAME	CHAR	35	0	Driver name
66	NAMBE	☐	NAMBE	NAME	CHAR	35	0	Passenger's name
67	VHILM_KU	☐	VHILM_KU	IDNEX	CHAR	35	0	Partner's (Customer's or Vendor's) Packaging Material
68	VPOBJ	☐	VPOBJ	VPOBJ	CHAR	2	0	Packing Object
69	VPOBJKEY	☐	VPOBJKEY	CHAR20	CHAR	20	0	Key for Object to Which the Handling Unit is Assigned
70	HANDLE	☐	GUID_VEKP	SYSUUID_22	CHAR	22	0	Worldwide unique key for VEKP-VENUM
71	WMSTA	☐	LVS_WMSTA	LVS_WMSTA	CHAR	1	0	WM status for container material
72	LGNUM	☐	HUM_LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
73	SAPRL	☐	SAPRL	SAPRL	CHAR	4	0	SAP Release
74	KZGVH	☐	KZGVH	XFELD	CHAR	1	0	Shipping material is closed packaging
75	ADGE_DG	☐	ADGE_DG	X	CHAR	1	0	Packing Level is Relevant for Dangerous Goods
76	ADGE_DGPR	☐	ADGE_DGPR	X	CHAR	1	0	Indicator: Packing level is relevant for printing
77	UEVEL	☐	UEVEL	VENUM	CHAR	10	0	Higher-Level Handling Unit
78	PACKVORSCHR	☐	PL_PACKNR_CONV	PL_PACKNR_CONV	CHAR	22	0	Packing instruction
79	PACKVORSCHR_ST	☐	PL_PACKSTATUS_LOCAL	PL_PACKSTATU	CHAR	1	0	Local packing status for a single HU (without sub HUs)
80	LABELTYP	☐	PL_SHIPLABEL	XFELD	CHAR	1	0	Indicator: do not print external shipping label
81	ZUL_AUFL	☐	PL_MAXSTWE	MENG15	QUAN	15	3	Allowed load
82	STATUS	☐	HU_STATUS	HU_STATUS	CHAR	4	0	Handling unit status
83	HU_LGORT	☐	HU_LGORT	HU_LGORT	CHAR	1	0	Content is Located at an HU-managed Storage Location
84	HU_SYSTEM	☐	HUMSYS	HUMSYS	CHAR	1	0	HU and IM Stock in Separate Systems
85	SPE_HDALL	☐	/SPE/INB_HDALL	XFELD	CHAR	1	0	Inbound delivery header not yet complete (on Hold)
86	SPE_VLSTK	☐	VLSTK	VLSTK	CHAR	1	0	Distribution Status (Decentralized Warehouse Processing)
87	SPE_DELDEC	☐	/SPE/INB_DELDEC	XFELD	CHAR	1	0	Delete indicator for the confirmation of deleted HUs
88	SPE_IDART_01	☐	/SPE/DE_HUIDART	/SPE/DO_HUIDART	CHAR	1	0	Handling Unit Identification Type
89	SPE_IDENT_01	☐	/SPE/DE_IDENT		CHAR	40	0	Alternative HU Identification
90	SPE_IDART_02	☐	/SPE/DE_HUIDART	/SPE/DO_HUIDART	CHAR	1	0	Handling Unit Identification Type
91	SPE_IDENT_02	☐	/SPE/DE_IDENT		CHAR	40	0	Alternative HU Identification
92	SPE_IDART_03	☐	/SPE/DE_HUIDART	/SPE/DO_HUIDART	CHAR	1	0	Handling Unit Identification Type
93	SPE_IDENT_03	☐	/SPE/DE_IDENT		CHAR	40	0	Alternative HU Identification
94	SPE_IDART_04	☐	/SPE/DE_HUIDART	/SPE/DO_HUIDART	CHAR	1	0	Handling Unit Identification Type
95	SPE_IDENT_04	☐	/SPE/DE_IDENT		CHAR	40	0	Alternative HU Identification
96	SPE_LOGPOS	☐	/SPE/DE_LOGPOS		CHAR	2	0	Logical Position of Handling Unit
97	SPE_CHK_COUNTER	☐	/SPE/DE_CHK_CTR	NUMC5	NUMC	5	0	Check number for cross-delivery handling units
98	EPC1	☐	ABI_EPC1	ABI_HEX64	CHAR	96	0	Electronic Product Code 1
99	EPC2	☐	ABI_EPC2	ABI_HEX64	CHAR	96	0	Electronic Product Code 2
100	PACKAGE_CAT	☐	EHS_ADGE_PACKAGE_CAT	EHS_ADGD_PACKAGE_CAT	CHAR	15	0	Category of Package
101	TRANSP_INDEX	☐	EHS_ADGE_TRANSP_INDEX	DEC5_2	DEC	7	2	Transport Index
102	CRIT_SAF_INDEX	☐	EHS_ADGE_CRIT_SAF_INDEX	DEC5_2	DEC	7	2	Criticality Safety Index
103	FLG_DG_PACKAGE	☐	ADGE_FLG_DG_PACKAGE	ESDFLAG	CHAR	1	0	Dangerous Goods Package
104	DG_PACKAGE_LEVEL	☐	ADGE_DG_PACKAGE_LEVEL	ADGD_DG_PACKAGE_LEVEL	CHAR	3	0	Level of Dangerous Goods Packaging	TDG95
105	PACKCODE	☐	CBDUE_PACOD	CBUND_PACOD	CHAR	10	0	Actual Packaging Code	CCUNC121
106	INSTR_ENCL_CAT	☐	CBUNE_INSTR_ENCL_CAT	CBUND_INSTR_ENCL_CAT	CHAR	15	0	Category of Instruction for Enclosure	CCUNC113
107	MAT_DAMAGED_CL7	☐	ADGE_MAT_DAMAGED_CL7	ADGD_YES_NO_NOT_DEFINED	CHAR	1	0	Damaged Material (Class 7)
108	DOSE_RATE_BULK	☐	ADGE_DOSE_RATE	ADGD_QUAN_9_5	QUAN	9	5	Radiation Level (Unpacked)
109	DOSE_RATE_BULK_U	☐	ADGE_DOSE_RATE_U	MEINS	UNIT	3	0	Unit of Radiation Level (Unpacked)	T006
110	DOSE_RATE_PACK	☐	ADGE_DOSE_RATE_PACKAGED	ADGD_QUAN_9_5	QUAN	9	5	Radation Level Packed
111	U_DOSE_RATE_PACK	☐	ADGE_DOSE_RATE_PACKAGED_U	MEINS	UNIT	3	0	Unit of Radiation Level Packed	T006
112	LEADING_LWDG	☐	ADGE_LEADING_LWDG	HMD_LWDG	CHAR	12	0	Leading Dangerous Goods Regulation	THM063
113	MAX_GROSS_WEIGHT	☐	ADGE_MAX_GROSS_WEIGHT	HMD_QUAN	QUAN	8	2	Maximum Gross Mass
114	U_MAX_GROSS_WGHT	☐	ADGE_U_MAX_GROSS_WGHT	MEINS	UNIT	3	0	Unit for Maximum Gross Mass	T006
115	LYARD	☐	LXYRD_YARD	LXYRD_YARD	CHAR	3	0	Yard
116	YLCCL	☐	LXYRDM_YLCCL	LXYRDM_YLCCL	CHAR	2	0	Location Class
117	YLOCT	☐	LXYRD_YLOCT	CHAR10	CHAR	10	0	Location
118	STATS	☐	LXYRD_OBSTS	LXYRD_HUSTS	CHAR	2	0	Vehicle Stock Status
119	PRRTY	☐	LXYRD_PRRTY	CHAR2	CHAR	2	0	Vehicle Priority
120	FWAGN	☐	LXYRD_FWAGN	LIFNR	CHAR	10	0	Forwarding Agent
121	SCACD	☐	LEINT_SCACD	SCACD	CHAR	4	0	Standard carrier access code
122	OWNER	☐	LXYRD_OWNER	CHAR10	CHAR	10	0	Vehicle Owner
123	TRNPD	☐	LXYRD_TRNPD	CHAR20	CHAR	20	0	Transponder
124	SEALN1	☐	LXYRD_SEALN	CHAR10	CHAR	10	0	Sealing Number
125	SEALN2	☐	LXYRD_SEALN	CHAR10	CHAR	10	0	Sealing Number
126	SEALN3	☐	LXYRD_SEALN	CHAR10	CHAR	10	0	Sealing Number
127	SEALN4	☐	LXYRD_SEALN	CHAR10	CHAR	10	0	Sealing Number
128	SEALN5	☐	LXYRD_SEALN	CHAR10	CHAR	10	0	Sealing Number
129	BLIND	☐	LXYRD_BLOCK	XFELD	CHAR	1	0	Block
130	RSNCD	☐	LXYRD_RSNCD	CHAR2	CHAR	2	0	Reason Code	LYRSN
131	RFTYP	☐	LXYRD_RFDTY	LXYRD_RFDTY	CHAR	2	0	Reference Document Type
132	REFER	☐	LXYRD_DOCRF	LXYRD_DOCRF	CHAR	10	0	Reference Document
133	PTMST	☐	LXYRD_PTMST	LXHME_TSTMP	DEC	15	0	Planned End Time
134	ATMST	☐	LXYRD_ATMSF	LXHME_TSTMP	DEC	15	0	Actual Start Time
135	YDOOR	☐	LEINT_LGTOR	LGTOR	CHAR	3	0	Door
136	YSTGA	☐	LEINT_LGBZO	LGBZO	CHAR	10	0	Staging Area
137	URGFL	☐	LXYRD_URGFL	FLAG	CHAR	1	0	Urgent (Relevant for Cross-Docking)
138	PRFLG	☐	LXYRD_PRFLG	FLAG	CHAR	1	0	Permanence of Vehicle in Yard
139	SLFLG	☐	LXYRD_SLFLG	FLAG	CHAR	1	0	Sealing Required
140	SIGNI	☐	LEINT_SIGNI	TEXT20	CHAR	20	0	Container ID
141	LTEXT	☐	LXYRD_TEXT_DE	TEXT40	CHAR	40	0	Text
142	MATNR_EXT	☐	MATNR_EXT	MATNR_EXT	CHAR	40	0	External Long Material Number
143	MATNR_VERS	☐	MATNR_VERS	MATNR_VERS	CHAR	10	0	Material Version Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MGV_VEKP	DG_PACKAGE_LEVEL	TDG95	DG_PACKAGE_LEVEL		1	CN
2	MGV_VEKP	DOSE_RATE_BULK_U	T006	MSEHI		1	CN
3	MGV_VEKP	EHENT	T006	MSEHI	REF	C	CN
4	MGV_VEKP	FAREH	T006	MSEHI	REF	C	CN
5	MGV_VEKP	GEWEI	T006	MSEHI	REF	C	CN
6	MGV_VEKP	GEWEI_MAX	T006	MSEHI	REF	C	CN
7	MGV_VEKP	INSTR_ENCL_CAT	CCUNC113	INSTR_ENCL_CAT		1	CN
8	MGV_VEKP	LADEH	T006	MSEHI	REF	C	CN
9	MGV_VEKP	LANDF	T005	LAND1	REF	C	CN
10	MGV_VEKP	LANDT	T005	LAND1	REF	C	CN
11	MGV_VEKP	LEADING_LWDG	THM063	LWDG		1	CN
12	MGV_VEKP	LGNUM	T300	LGNUM	REF	1	CN
13	MGV_VEKP	LGORT	MARD	LGORT	REF	C	CN
14	MGV_VEKP	LSTEL	TVLA	LSTEL	REF	C	CN
15	MGV_VEKP	MAGRV	TVEGR	MAGRV	REF	C	CN
16	MGV_VEKP	MANDT	T000	MANDT	KEY	1	CN
17	MGV_VEKP	MEABM	T006	MSEHI	REF	C	CN
18	MGV_VEKP	MEINS	T006	MSEHI	REF	C	CN
19	MGV_VEKP	PACKCODE	CCUNC121	PACKCODE		1	CN
20	MGV_VEKP	PSTYV	TVPT	PSTYV	REF	C	CN
21	MGV_VEKP	RSNCD	LYRSN	RSNCD
22	MGV_VEKP	U_DOSE_RATE_PACK	T006	MSEHI		1	CN
23	MGV_VEKP	U_MAX_GROSS_WGHT	T006	MSEHI		1	CN
24	MGV_VEKP	VEGR1	TVE1	VEGR1	REF	1	CN
25	MGV_VEKP	VEGR2	TVE2	VEGR2	REF	1	CN
26	MGV_VEKP	VEGR3	TVE3	VEGR3	REF	1	CN
27	MGV_VEKP	VEGR4	TVE4	VEGR4	REF	1	CN
28	MGV_VEKP	VEGR5	TVE5	VEGR5	REF	1	CN
29	MGV_VEKP	VHART	TVTY	TRATY	REF	C	CN
30	MGV_VEKP	VHILM	MARA	MATNR	REF	C	CN
31	MGV_VEKP	VOLEH	T006	MSEHI	REF	C	CN
32	MGV_VEKP	VOLEH_MAX	T006	MSEHI	REF	C	CN
33	MGV_VEKP	VSTEL	TVST	VSTEL	REF	C	CN
34	MGV_VEKP	WERKS	MARC	WERKS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in