SAP Table HUINV_ITEM
Handling Unit: Physical Inventory Document Item
HUINV_ITEM (Handling Unit: Physical Inventory Document Item) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link HUINV_ITEM to other SAP tables.
HUINV_ITEM table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client ID
|
SYMANDT |
CLNT
|
3 | 0 | ||||||||||||
|
HANDLE
UUID in X form (binary)
|
SYSUUID_X |
RAW
|
16 | 0 | ||||||||||||
|
ITEM_NR
Item Number from the Inventory Document
|
HUINV_ITEMNR |
NUMC
|
6 | 0 | ||||||||||||
|
VENUM
Internal Handling Unit Number
|
VENUM |
CHAR
|
10 | 0 | ||||||||||||
|
VEPOS
Handling Unit Item
|
VEPOS |
NUMC
|
6 | 0 | ||||||||||||
|
MATNR
Material Number
|
MATNR |
CHAR
|
18 | 0 | ||||||||||||
|
CHARG
Batch Number
|
CHARG_D |
CHAR
|
10 | 0 | ||||||||||||
|
BESTQ
Stock Category in the Warehouse Management System
|
BESTQ |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
HUEXIST
Handling unit physically exists
|
HUINV_HUEXIST |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
HUEXISTNOT
Handling unit does not physically exist
|
HUINV_HUEXNOT |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
VHILM
Packaging Materials
|
VHILM |
CHAR
|
18 | 0 | ||||||||||||
|
EXIDV
External Handling Unit Identification
|
EXIDV |
CHAR
|
20 | 0 | ||||||||||||
|
TOP_EXIDV
Identification of the highest HU in a hierarchy
|
HUINV_TOP_HU |
CHAR
|
20 | 0 | ||||||||||||
|
VEMNG
Base Quantity Packed in the Handling Unit Item
|
VEMNG |
QUAN
|
15 | 3 | ||||||||||||
|
MEINS
Base Unit of Measure
|
MEINS |
UNIT
|
3 | 0 | ||||||||||||
|
QUANTITY
Base Quantity Packed in the Handling Unit Item
|
VEMNG |
QUAN
|
15 | 3 | ||||||||||||
|
ALTME
Alternative unit of measure for stock unit of measure
|
VV_ALTME |
UNIT
|
3 | 0 | ||||||||||||
|
HUINV_NULL
Item was counted with zero quantity
|
HUINV_NULL |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
IVPOS
Item number in inventory document
|
LVS_IVPOS |
NUMC
|
4 | 0 | ||||||||||||
|
LGNUM
Warehouse Number / Warehouse Complex
|
LGNUM |
CHAR
|
3 | 0 | ||||||||||||
|
GRUND
Reason for Movement
|
MB_GRBEW | T157D |
NUMC
|
4 | 0 | |||||||||||
|
COUNT_NR
Count Indicator for Item
|
HUINV_COUNT_NR |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
CHANGE_USER
Name of the user that changed the data record
|
HUINV_USER_CH |
CHAR
|
12 | 0 | ||||||||||||
|
CHANGE_DATE
Date on which the data record was changed
|
HUINV_DATA_CH |
DATS
|
8 | 0 | ||||||||||||
|
CHANGE_TIME
Time at which the data record was changed
|
HUINV_TIME_CH |
TIMS
|
6 | 0 | ||||||||||||
|
COUNTED
Inventory document/item is completely counted
|
HUINV_COUNTED |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
DELETED
Inventory document/item was deleted
|
HUINV_DELETE |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
POSTED
Inventory document/item was cleared
|
HUINV_POSTED |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
MBLNR
Number of Material Document
|
MBLNR |
CHAR
|
10 | 0 | ||||||||||||
|
MJAHR
Material Document Year
|
MJAHR |
NUMC
|
4 | 0 | ||||||||||||
|
MBLPO
Item in Material Document
|
MBLPO |
NUMC
|
4 | 0 | ||||||||||||
|
FLAG_SNR
Checkbox
|
XFELD |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
UEVEL
Higher-Level Handling Unit
|
UEVEL |
CHAR
|
10 | 0 | ||||||||||||
|
SOBKZ
Special Stock Indicator
|
SOBKZ |
CHAR
|
1 | 0 | ||||||||||||
|
SONUM
Special Stock Number
|
LVS_SONUM |
CHAR
|
16 | 0 | ||||||||||||
|
/CWM/VEMNG
Parallel Quantity
|
/CWM/VEMNG |
QUAN
|
15 | 3 | ||||||||||||
|
/CWM/VEMEH
Parallel Unit of Measure
|
/CWM/VEMEH |
UNIT
|
3 | 0 | ||||||||||||
|
/CWM/QUANTITY
Parallel Quantity
|
/CWM/VEMNG |
QUAN
|
15 | 3 | ||||||||||||
|
/CWM/ALTME
Alternative Parallel Unit of Measure
|
/CWM/ALTME |
UNIT
|
3 | 0 | ||||||||||||