SAP Table HUINV_ITEM
Handling Unit: Physical Inventory Document Item
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table HUINV_ITEM (Handling Unit: Physical Inventory Document Item) is a standard table in SAP ERP. It belongs to the package HANDLING_UNITS.
Technical Information
| Table | HUINV_ITEM |
| Short Text | Handling Unit: Physical Inventory Document Item |
| Package | HANDLING_UNITS |
| Table Type | Transparent Table |
Fields for Table HUINV_ITEM
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client ID | SYMANDT | CLNT | 3 | * |
| HANDLE | ✔ | UUID in X form (binary) | SYSUUID_X | RAW | 16 | |
| ITEM_NR | ✔ | Item Number from the Inventory Document | HUINV_ITEMNR | NUMC | 6 | |
| VENUM | Internal Handling Unit Number | VENUM | CHAR | 10 | * | |
| VEPOS | Handling Unit Item | VEPOS | NUMC | 6 | * | |
| MATNR | Material Number | MATNR | CHAR | 18 | * | |
| CHARG | Batch Number | CHARG_D | CHAR | 10 | * | |
| BESTQ | Stock Category in the Warehouse Management System | BESTQ | CHAR | 1 | ||
| HUEXIST | Handling unit physically exists | HUINV_HUEXIST | CHAR | 1 | ||
| HUEXISTNOT | Handling unit does not physically exist | HUINV_HUEXNOT | CHAR | 1 | ||
| VHILM | Packaging Materials | VHILM | CHAR | 18 | * | |
| EXIDV | External Handling Unit Identification | EXIDV | CHAR | 20 | ||
| TOP_EXIDV | Identification of the highest HU in a hierarchy | HUINV_TOP_HU | CHAR | 20 | ||
| VEMNG | Base Quantity Packed in the Handling Unit Item | VEMNG | QUAN | 15 | ||
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | * | |
| QUANTITY | Base Quantity Packed in the Handling Unit Item | VEMNG | QUAN | 15 | ||
| ALTME | Alternative unit of measure for stock unit of measure | VV_ALTME | UNIT | 3 | * | |
| HUINV_NULL | Item was counted with zero quantity | HUINV_NULL | CHAR | 1 | ||
| IVPOS | Item number in inventory document | LVS_IVPOS | NUMC | 4 | ||
| LGNUM | Warehouse Number / Warehouse Complex | LGNUM | CHAR | 3 | * | |
| GRUND | Reason for Movement | MB_GRBEW | NUMC | 4 | T157D | |
| COUNT_NR | Count Indicator for Item | HUINV_COUNT_NR | CHAR | 1 | ||
| CHANGE_USER | Name of the user that changed the data record | HUINV_USER_CH | CHAR | 12 | ||
| CHANGE_DATE | Date on which the data record was changed | HUINV_DATA_CH | DATS | 8 | ||
| CHANGE_TIME | Time at which the data record was changed | HUINV_TIME_CH | TIMS | 6 | ||
| COUNTED | Inventory document/item is completely counted | HUINV_COUNTED | CHAR | 1 | ||
| DELETED | Inventory document/item was deleted | HUINV_DELETE | CHAR | 1 | ||
| POSTED | Inventory document/item was cleared | HUINV_POSTED | CHAR | 1 | ||
| MBLNR | Number of Material Document | MBLNR | CHAR | 10 | ||
| MJAHR | Material Document Year | MJAHR | NUMC | 4 | ||
| MBLPO | Item in Material Document | MBLPO | NUMC | 4 | ||
| FLAG_SNR | Checkbox | XFELD | CHAR | 1 | ||
| UEVEL | Higher-Level Handling Unit | UEVEL | CHAR | 10 | * | |
| SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | * | |
| SONUM | Special Stock Number | LVS_SONUM | CHAR | 16 |