1. Home
  2. Resources
  3. SAP Tables
  4. HUINV_ITEM - Handling Unit: Physical Inventory Document Item

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
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
NULL Available Stock
Q Stock in Quality Control
R Returns Stock
S Blocked Stock
HUEXIST Handling unit physically exists HUINV_HUEXIST CHAR 1 0
X Yes
NULL No
HUEXISTNOT Handling unit does not physically exist HUINV_HUEXNOT CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
DELETED Inventory document/item was deleted HUINV_DELETE CHAR 1 0
X Yes
NULL No
POSTED Inventory document/item was cleared HUINV_POSTED CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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

HUINV_ITEM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
HUINV_ITEM GRUND HUINV_ITEM MANDT T157D Reason for Movement MANDT
HUINV_ITEM GRUND * T157D Reason for Movement BWART
HUINV_ITEM GRUND HUINV_ITEM GRUND T157D Reason for Movement GRUND