SAP table HUMSEG (Reference-HU-Item for Material Doc.Item that was Posted Last)

SAP table HUMSEG has 6 primary key fields being MANDT,VENUM,VEPOS,MBLPO,MBLNR,MJAHR.

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 CLNT 3 0 MANDT
VENUM Internal Handling Unit Number CHAR 10 0 VENUM
VEPOS Handling Unit Item NUMC 6 0 VEPOS
MBLPO Item in Material Document NUMC 4 0 MBLPO
MBLNR Number of Material Document CHAR 10 0 MBLNR
MJAHR Material Document Year NUMC 4 0 MJAHR
TSTMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TZNTSTMPS
MOVEMENT_TYPE Packing: Pack in HU Stor.Loc. / Unpack in HU Stor.Loc. CHAR 1 0 HU_DIRECTION
+ Pack at an HU-managed storage location
- Unpack in non-HU storage location
QUANTITY Base Quantity Packed in the Handling Unit Item QUAN 15 3 VEMNG
MEINS Base Unit of Measure UNIT 3 0 MEINS
OBJECT Object Key's Object Type CHAR 2 0 HU_OBJECT
01 Outbound Delivery
02 Sales Document
03 Inbound Delivery
04 Shipment
05 Warehouse Management
06 Non-Assigned Handling Unit
07 Repetitive Manufacturing - Finished Products
08 Work Order for Components
09 Work Order for Finished Products
10 Verification: Completeness Check Assignment to Prod.Order
11 Verification: Sequence Check - Assignment to Prod.Order
12 Non-Assigned Handling Unit
14 Packing Station
ID Initial Data Transfer
IV Physical Inventory
JI JIT Inbound
JO JIT Outbound
LA Goods Issue in Warehouse System
LE Goods Receipt in Warehouse System
LS Further History in External System
LU Posting Change in Warehouse System
MM Posting Change and/or Stock Transfer
MS Material Document Cancellation
PO Purchase Order
QP Inspection Lot
SC Difference Comparison
UM Repack Entry
WA Goods Issue Document
WE Goods Receipt Document
ATTRIBUTE Posting Type of Material Doc. with which the HU was Posted CHAR 1 0 HU_POSTING_TYPE_D
/CWM/VEMNG Parallel Quantity QUAN 15 3 /CWM/VEMNG
/CWM/VEMEH Parallel Unit of Measure UNIT 3 0 * /CWM/VEMEH