SAP table HUINV_ITEM (Handling Unit: Physical Inventory Document Item)

SAP table HUINV_ITEM has 3 primary key fields being MANDT,HANDLE,ITEM_NR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client ID CLNT 3 0 SYMANDT
HANDLE UUID in X form (binary) RAW 16 0 SYSUUID_X
ITEM_NR Item Number from the Inventory Document NUMC 6 0 HUINV_ITEMNR
VENUM Internal Handling Unit Number CHAR 10 0 VENUM
VEPOS Handling Unit Item NUMC 6 0 VEPOS
MATNR Material Number CHAR 40 0 MATNR
CHARG Batch Number CHAR 10 0 CHARG_D
BESTQ Stock Category in the Warehouse Management System CHAR 1 0 BESTQ
Available Stock
Q Stock in Quality Control
R Returns Stock
S Blocked Stock
HUEXIST Handling unit physically exists CHAR 1 0 HUINV_HUEXIST
HUEXISTNOT Handling unit does not physically exist CHAR 1 0 HUINV_HUEXNOT
VHILM Packaging Materials CHAR 40 0 VHILM
EXIDV External Handling Unit Identification CHAR 20 0 EXIDV
TOP_EXIDV Identification of the highest HU in a hierarchy CHAR 20 0 HUINV_TOP_HU
VEMNG Base Quantity Packed in the Handling Unit Item QUAN 15 3 VEMNG
MEINS Base Unit of Measure UNIT 3 0 MEINS
QUANTITY Base Quantity Packed in the Handling Unit Item QUAN 15 3 VEMNG
ALTME Alternative unit of measure for stock unit of measure UNIT 3 0 VV_ALTME
HUINV_NULL Item was counted with zero quantity CHAR 1 0 HUINV_NULL
IVPOS Item number in inventory document NUMC 4 0 LVS_IVPOS
LGNUM Warehouse Number / Warehouse Complex CHAR 3 0 LGNUM
GRUND Reason for Movement NUMC 4 0 T157D MB_GRBEW
COUNT_NR Count Indicator for Item CHAR 1 0 HUINV_COUNT_NR
CHANGE_USER Name of the user that changed the data record CHAR 12 0 HUINV_USER_CH
CHANGE_DATE Date on which the data record was changed DATS 8 0 HUINV_DATA_CH
CHANGE_TIME Time at which the data record was changed TIMS 6 0 HUINV_TIME_CH
COUNTED Inventory document/item is completely counted CHAR 1 0 HUINV_COUNTED
DELETED Inventory document/item was deleted CHAR 1 0 HUINV_DELETE
POSTED Inventory document/item was cleared CHAR 1 0 HUINV_POSTED
MBLNR Number of Material Document CHAR 10 0 MBLNR
MJAHR Material Document Year NUMC 4 0 MJAHR
MBLPO Item in Material Document NUMC 4 0 MBLPO
FLAG_SNR Checkbox CHAR 1 0 XFELD
No
X Yes
UEVEL Higher-Level Handling Unit CHAR 10 0 UEVEL
SOBKZ Special Stock Indicator CHAR 1 0 SOBKZ
SONUM Special Stock Number CHAR 16 0 LVS_SONUM
/CWM/VEMNG Parallel Quantity QUAN 15 3 /CWM/VEMNG
/CWM/VEMEH Parallel Unit of Measure UNIT 3 0 * /CWM/VEMEH
/CWM/QUANTITY Parallel Quantity QUAN 15 3 /CWM/VEMNG
/CWM/ALTME Alternative Parallel Unit of Measure UNIT 3 0 * /CWM/ALTME
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
WRF_CHARSTC1 Characteristic Value 1 CHAR 18 0 WRF_CHARSTC1
WRF_CHARSTC2 Characteristic Value 2 CHAR 18 0 WRF_CHARSTC2
WRF_CHARSTC3 Characteristic Value 3 CHAR 18 0 WRF_CHARSTC3
WRF_CHARSTC1_TXT Characteristic Description 1 CHAR 70 0 WRF_CHARSTC1_TEXT
WRF_CHARSTC2_TXT Characteristic Description 2 CHAR 70 0 WRF_CHARSTC2_TEXT
WRF_CHARSTC3_TXT Characteristic Description 3 CHAR 70 0 WRF_CHARSTC3_TEXT

HUINV_ITEM foreign key relationships

Table Field Check Table Check Field
0 HUINV_ITEM GRUND T157D Reason for Movement MANDT