SAP ABAP View MGV_VEKP (Selection VEKP with material version, see: http://material)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ LO-MD-MM (Application Component) Material Master
     ⤷ MGV_MATNR (Package) Material number conversion (long mat. no.)

Basic Data

View Type	D	Database View
Database View	MGV_VEKP
Short Description	Selection VEKP with material version, see: http://material
Root table	VEKP	Handling Unit - Header Table

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VEKP	VEKP
2	MATERIALID

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VEKP	MANDT	JL	EQ				0	0
2	MATERIALID	MANDT	JR	EQ			AND	0	0
3	VEKP	VHILM	JL	EQ				0	0
4	MATERIALID	MATNR_INT	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20130529
SAP Release Created in