SAP ABAP Table ALVIT (ALV Item for Stock Overview of Handling Units)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-HU-MD (Application Component) Master data
     ⤷ ISAUTO_VHU_PACKOBJ (Package) Packing Instructions and Packing Dialog (Core)

Basic Data

Table Category	INTTAB	Structure
Structure	ALVIT	Table Relationship Diagram
Short Description	ALV Item for Stock Overview of Handling Units

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	HDID	☐	PL_HDID	NUMC6	NUMC	6	0	Header identification for ALV header
2	ITID	☐	PL_ITID	NUMC6	NUMC	6	0	Item identification for ALV item
3	PACKSTAT_ICON	☐	PL_PACKSTAT_ICON	CHAR10	CHAR	10	0	Representation of packing status of HU with icon "STOPLIGHT"
4	PACKSTAT_GLOBAL	☐	PL_PACKSTATU	PL_PACKSTATU	CHAR	1	0	Packing status
5	PACKSTAT_GLO_TXT	☐	PL_PACKSTATU_TXT	CHAR40	CHAR	40	0	Packing status
6	PACKLEVEL	☐	PL_LEVEL	NUMC	NUMC	5	0	Packing level
7	ITEMTYPE	☐	PL_ITTYP	PL_ITTYP	CHAR	1	0	Item category in prototype HU item
8	SHOWMATNR	☐	PL_SHOWMATNR	CHAR40	CHAR	40	0	Material number of a HU item with level information
9	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
10	EXIDV	☐	EXIDV	EXIDV	CHAR	20	0	External Handling Unit Identification
11	EXIDA	☐	EXIDA	EXIDA	CHAR	1	0	Type of External Handling Unit Identifier
12	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
13	LSTEL	☐	LSTEL	LSTEL	CHAR	2	0	Loading Point	TVLA
14	BRGEW	☐	BRGEW_VEKP	MENG15	QUAN	15	3	Total Weight of Handling Unit
15	NTGEW	☐	NTGEW_VEKP	MENG15	QUAN	15	3	Loading Weight of Handling Unit
16	MAGEW	☐	MAGEW_VEKP	MENG15	QUAN	15	3	Allowed Loading Weight of a Handling Unit
17	TARAG	☐	TARAG_VEKP	MENG15	QUAN	15	3	Tare weight of handling unit
18	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
19	BTVOL	☐	BTVOL_VEKP	MENG15	QUAN	15	3	Total volume of handling unit
20	NTVOL	☐	NTVOL_VEKP	MENG15	QUAN	15	3	Loading Volume of Handling Unit
21	MAVOL	☐	MAVOL_VEKP	MENG15	QUAN	15	3	Allowed Loading Volume for Handling Unit
22	TAVOL	☐	TAVOL_VEKP	MENG15	QUAN	15	3	Tare volume of handling unit
23	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
24	ANZGL	☐	ANZGL	ANZGL	INT4	10	0	Number of Similar Packaging Materials
25	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
26	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
27	ERUHR	☐	ERZET	UZEIT	TIMS	6	0	Entry time
28	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
29	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
30	AEZET	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
31	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
32	VEGR1	☐	VEGR1	VEGR1	CHAR	5	0	Handling Unit Group 1 (Freely Definable)	TVE1
33	VEGR2	☐	VEGR2	VEGR2	CHAR	5	0	Handling Unit Group 2 (Freely Definable)	TVE2
34	VEGR3	☐	VEGR3	VEGR3	CHAR	5	0	Handling Unit Group 3 (Freely Definable)	TVE3
35	VEGR4	☐	VEGR4	VEGR4	CHAR	5	0	Handling Unit Group 4 (Freely Definable)	TVE4
36	VEGR5	☐	VEGR5	VEGR5	CHAR	5	0	Handling Unit Group 5 (Freely Definable)	TVE5
37	VHILM	☐	VHILM	MATNR	CHAR	18	0	Packaging Materials	MARA
38	LAENG	☐	LAENG	MENG13	QUAN	13	3	Length
39	BREIT	☐	BREIT	MENG13	QUAN	13	3	Width
40	HOEHE	☐	HOEHE	MENG13	QUAN	13	3	Height
41	MEABM	☐	MEABM	MEINS	UNIT	3	0	Unit of Dimension for Length/Width/Height	T006
42	ERLKZ	☐	VOLLS	XFELD	CHAR	1	0	Status (at this time without functionality)
43	GEWTO	☐	GEWTO	PRZ21	DEC	3	1	Excess weight tolerance for shipping unit
44	VOLTO	☐	VOLTO	PRZ21	DEC	3	1	Excess volume tolerance limit during packing
45	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
46	VOLEH_MAX	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
47	GEWEI_MAX	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
48	VBELN_GEN	☐	VBELN_GEN	VBELN	CHAR	10	0	Delivery in Which Packaging Material Is Generated as an Item	*
49	INHALT	☐	INHALT	TEXT40	CHAR	40	0	Description of Handling Unit Content
50	VHART	☐	VHIART	TRATY	CHAR	4	0	Shipping material type	TVTY
51	KAPPL	☐	NA_KAPPL	KAPPL	CHAR	2	0	Application for output conditions	*
52	KALSM	☐	KALSMB	KALSM	CHAR	6	0	Output determination procedure	*
53	KSCHL	☐	NA_KSCHL	KSCHL	CHAR	4	0	Output Type	*
54	MAGRV	☐	MAGRV	MAGRV	CHAR	4	0	Material Group: Packaging Materials	TVEGR
55	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
56	VTWEG	☐	VTWKU	VTWEG	CHAR	2	0	Reference distrib.channel for cust.and material masters	*
57	LADLG	☐	LADLG	LADLG	QUAN	6	0	Lgth of loading platform in lgth of LdPlat measurement units
58	LADEH	☐	LADEH	MEINS	UNIT	3	0	Unit of Measure to Measure the Length of Loading Platform	T006
59	FARZT	☐	FARZT	FARZT	QUAN	3	0	Travel Time
60	FAREH	☐	FAREH	MEINS	UNIT	3	0	Unit of Travel Time	T006
61	ENTFE	☐	ENTFE	ENTFE	QUAN	6	0	Distance Travelled
62	EHENT	☐	EHENT	MEINS	UNIT	3	0	Unit of Distance	T006
63	GEWFX	☐	GEWFX	XFELD	CHAR	1	0	Weight and Volume Fixed
64	VELTP	☐	VELTP	VELTP	CHAR	1	0	Packaging Material Category
65	EXIDV2	☐	EXIDV2	EXIDV	CHAR	20	0	Handling Unit's 2nd External Identification
66	LANDT	☐	LANDT	LAND1	CHAR	3	0	Country providing means of transport	T005
67	LANDF	☐	LANDF	LAND1	CHAR	3	0	Driver's Nationality	T005
68	NAMEF	☐	NAMEF	NAME	CHAR	35	0	Driver name
69	NAMBE	☐	NAMBE	NAME	CHAR	35	0	Passenger's name
70	VHILM_KU	☐	VHILM_KU	IDNEX	CHAR	35	0	Partner's (Customer's or Vendor's) Packaging Material
71	VPOBJ	☐	VPOBJ	VPOBJ	CHAR	2	0	Packing Object
72	VPOBJKEY	☐	VPOBJKEY	CHAR20	CHAR	20	0	Key for Object to Which the Handling Unit is Assigned
73	HANDLE	☐	GUID_VEKP	SYSUUID_22	CHAR	22	0	Worldwide unique key for VEKP-VENUM
74	WMSTA	☐	LVS_WMSTA	LVS_WMSTA	CHAR	1	0	WM status for container material
75	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
76	SAPRL	☐	SAPRL	SAPRL	CHAR	4	0	SAP Release
77	KZGVH	☐	KZGVH	XFELD	CHAR	1	0	Shipping material is closed packaging
78	ADGE_DG	☐	ADGE_DG	X	CHAR	1	0	Packing Level is Relevant for Dangerous Goods
79	ADGE_DGPR	☐	ADGE_DGPR	X	CHAR	1	0	Indicator: Packing level is relevant for printing
80	UEVEL	☐	UEVEL	VENUM	CHAR	10	0	Higher-Level Handling Unit	*
81	PACKVORSCHR	☐	PL_PACKNR_CONV	PL_PACKNR_CONV	CHAR	22	0	Packing instruction
82	PACKVORSCHR_ST	☐	PL_PACKSTATUS_LOCAL	PL_PACKSTATU	CHAR	1	0	Local packing status for a single HU (without sub HUs)
83	LABELTYP	☐	PL_SHIPLABEL	XFELD	CHAR	1	0	Indicator: do not print external shipping label
84	ZUL_AUFL	☐	PL_MAXSTWE	MENG15	QUAN	15	3	Allowed load
85	STATUS	☐	HU_STATUS	HU_STATUS	CHAR	4	0	Handling unit status
86	.INCLUDE	☐				0	0	Packing: Handling Unit Item (Contents)
87	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
88	VENUM	☐	VENUM	VENUM	CHAR	10	0	Internal Handling Unit Number	VEKP
89	VEPOS	☐	VEPOS	VEPOS	NUMC	6	0	Handling Unit Item	*
90	VELIN	☐	VELIN	VELIN	CHAR	1	0	Type of Handling-unit Item Content
91	VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
92	POSNR	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
93	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
94	UNVEL	☐	UNVEL	VENUM	CHAR	10	0	Lower-level handling unit	*
95	VEMNG	☐	VEMNG	MENG15	QUAN	15	3	Base Quantity Packed in the Handling Unit Item
96	VEMNG_FLO	☐	LGMNG_FLO	FLTP	FLTP	16	16	Internal field/ Do not use / LGMNG in float / MUM
97	VEMEH	☐	VEMEH	MEINS	UNIT	3	0	Base Unit of Measure of the Quantity to be Packed (VEMNG)	T006
98	ALTME	☐	VV_ALTME	MEINS	UNIT	3	0	Alternative unit of measure for stock unit of measure	T006
99	VEANZ	☐	VEANZ	ANZGL	INT4	10	0	Number of Auxiliary Packaging Materials in the HU Item
100	KZBEI	☐	KZBEI	XFELD	CHAR	1	0	Indicator: Supplementary item
101	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
102	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
103	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
104	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
105	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
106	BESTQ	☐	BESTQ	BESTQ	CHAR	1	0	Stock Category in the Warehouse Management System
107	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
108	SONUM	☐	LVS_SONUM	LVS_SONUM	CHAR	16	0	Special Stock Number
109	QPLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	*
110	ANZSN	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers
111	SERAIL	☐	SERAIL	SERAIL	CHAR	4	0	Serial Number Profile	T377P
112	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	TVPT
113	POSNR_GEN	☐	POSNR_GEN	POSNR	NUMC	6	0	Generated delivery item	*
114	P_MATERIAL	☐	HU_P_MAT	IDNEX	CHAR	35	0	Material number of partner (customer / supplier)
115	WDATU	☐	LVS_WDATU	DATUM	DATS	8	0	Date of goods receipt
116	VFDAT	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
117	HU_LGORT	☐	HU_LGORT	HU_LGORT	CHAR	1	0	Content is Located at an HU-managed Storage Location
118	XCHAR	☐	HUM_RES	XFELD	CHAR	1	0	HU Item has a Tentative Assignment
119	SPE_IDPLATE	☐	/SPE/DE_IDPLATE		CHAR	20	0	Identification of the HU Content

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ALVIT	ALTME	T006	MSEHI
2	ALVIT	EHENT	T006	MSEHI	REF	C	CN
3	ALVIT	FAREH	T006	MSEHI	REF	C	CN
4	ALVIT	GEWEI	T006	MSEHI	REF	C	CN
5	ALVIT	LADEH	T006	MSEHI	REF	C	CN
6	ALVIT	LANDF	T005	LAND1	REF	C	CN
7	ALVIT	LANDT	T005	LAND1	REF	C	CN
8	ALVIT	LGNUM	T300	LGNUM	REF	1	CN
9	ALVIT	LGORT	T001L	LGORT
10	ALVIT	LSTEL	TVLA	LSTEL	REF	C	CN
11	ALVIT	MAGRV	TVEGR	MAGRV	REF	C	CN
12	ALVIT	MANDT	T000	MANDT	KEY	1	CN
13	ALVIT	MATNR	MARA	MATNR		C	CN
14	ALVIT	MEABM	T006	MSEHI	REF	C	CN
15	ALVIT	MEINS	T006	MSEHI	REF	C	CN
16	ALVIT	POSNR	VBUP	POSNR	REF	C	CN
17	ALVIT	PSTYV	TVPT	PSTYV
18	ALVIT	SERAIL	T377P	SERAIL
19	ALVIT	VBELN	VBUK	VBELN	REF	C	CN
20	ALVIT	VEGR1	TVE1	VEGR1	REF	1	CN
21	ALVIT	VEGR2	TVE2	VEGR2	REF	1	CN
22	ALVIT	VEGR3	TVE3	VEGR3	REF	1	CN
23	ALVIT	VEGR4	TVE4	VEGR4	REF	1	CN
24	ALVIT	VEGR5	TVE5	VEGR5	REF	1	CN
25	ALVIT	VEMEH	T006	MSEHI	REF	C	CN
26	ALVIT	VENUM	VEKP	VENUM	KEY	1	CN
27	ALVIT	VHART	TVTY	TRATY	REF	C	CN
28	ALVIT	VHILM	MARA	MATNR	REF	C	CN
29	ALVIT	VOLEH	T006	MSEHI	REF	C	CN
30	ALVIT	VSTEL	TVST	VSTEL	REF	C	CN
31	ALVIT	WERKS	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in