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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in