SAP table VEKP (Handling Unit - Header Table)

SAP table VEKP has 2 primary key fields being MANDT,VENUM.

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 T000 MANDT
VENUM Internal Handling Unit Number CHAR 10 0 VENUM
EXIDV External Handling Unit Identification CHAR 20 0 EXIDV
EXIDA Type of External Handling Unit Identifier CHAR 1 0 EXIDA
Old shipping unit (before HUs)
A External HU identification = VEKP-VENUM (no HU management)
B Number assigned by customer (no HU management)
C SSCC18 or GTL internal
D SSCC18 or GTL external
E No. rnge obj. HU_VEKP internal interval - SSCC18 before GI
F No. rnge obj. HU_VEKP external interval - SSCC18 before GI
G $ number for packing proposal - only for object '02'
H SSCC18 or GTL from vendor
VSTEL Shipping Point / Receiving Point CHAR 4 0 TVST VSTEL
LSTEL Loading Point CHAR 2 0 TVLA LSTEL
BRGEW Total Weight of Handling Unit QUAN 15 3 BRGEW_VEKP
NTGEW Loading Weight of Handling Unit QUAN 15 3 NTGEW_VEKP
MAGEW Allowed Loading Weight of a Handling Unit QUAN 15 3 MAGEW_VEKP
TARAG Tare Weight of Handling Unit QUAN 15 3 TARAG_VEKP
GEWEI Weight Unit UNIT 3 0 T006 GEWEI
BTVOL Total Volume of Handling Unit QUAN 15 3 BTVOL_VEKP
NTVOL Loading Volume of Handling Unit QUAN 15 3 NTVOL_VEKP
MAVOL Allowed Loading Volume for Handling Unit QUAN 15 3 MAVOL_VEKP
TAVOL Tare Volume of Handling Unit QUAN 15 3 TAVOL_VEKP
VOLEH Volume unit UNIT 3 0 T006 VOLEH
ANZGL Number of Similar Packaging Materials INT4 10 0 ANZGL
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERUHR Entry time TIMS 6 0 ERZET
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Last Changed On DATS 8 0 AEDAT
AEZET Time last change was made TIMS 6 0 AEZET
SORTL Sort field CHAR 10 0 SORTL
VEGR1 Handling Unit Group 1 (Freely Definable) CHAR 5 0 TVE1 VEGR1
VEGR2 Handling Unit Group 2 (Freely Definable) CHAR 5 0 TVE2 VEGR2
VEGR3 Handling Unit Group 3 (Freely Definable) CHAR 5 0 TVE3 VEGR3
VEGR4 Handling Unit Group 4 (Freely Definable) CHAR 5 0 TVE4 VEGR4
VEGR5 Handling Unit Group 5 (Freely Definable) CHAR 5 0 TVE5 VEGR5
VHILM Packaging Materials CHAR 40 0 MARA VHILM
LAENG Length QUAN 13 3 LAENG
BREIT Width QUAN 13 3 BREIT
HOEHE Height QUAN 13 3 HOEHE
MEABM Unit of Dimension for Length/Width/Height UNIT 3 0 T006 MEABM
ERLKZ Status (at this time without functionality) CHAR 1 0 VOLLS
GEWTO Excess Weight Tolerance for Handling unit DEC 3 1 GEWTO
VOLTO Excess Volume Tolerance of the Handling Unit DEC 3 1 VOLTO
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
VOLEH_MAX Volume unit UNIT 3 0 T006 VOLEH
GEWEI_MAX Weight Unit UNIT 3 0 T006 GEWEI
VBELN_GEN Delivery in Which Packaging Material Is Generated as an Item CHAR 10 0 VBELN_GEN
POSNR_GEN Generated delivery item NUMC 6 0 POSNR_GEN
INHALT Description of Handling Unit Content CHAR 40 0 INHALT
VHART Packaging Material Type CHAR 4 0 TVTY VHIART
KAPPL Application for output conditions CHAR 2 0 NA_KAPPL
KALSM Output determination procedure CHAR 6 0 KALSMB
KSCHL Output Type CHAR 4 0 NA_KSCHL
MAGRV Material Group: Packaging Materials CHAR 4 0 TVEGR MAGRV
WERKS Plant CHAR 4 0 MARC HUM_WERKS
PSTYV Sales document item category CHAR 4 0 TVPT PSTYV
VKORG Sales Organization CHAR 4 0 VKORG
VTWEG Reference distrib.channel for cust.and material masters CHAR 2 0 VTWKU
LADLG Lgth of loading platform in lgth of LdPlat measurement units QUAN 6 0 LADLG
LADEH Unit of measure to measure the length of loading platform UNIT 3 0 T006 LADEH
FARZT Travel Time QUAN 3 0 FARZT
FAREH Unit of travel time UNIT 3 0 T006 FAREH
ENTFE Distance Travelled QUAN 6 0 ENTFE
EHENT Unit of distance UNIT 3 0 T006 EHENT
LGORT Storage Location CHAR 4 0 MARD HUM_LGORT
GEWFX Weight and Volume Fixed CHAR 1 0 GEWFX
VELTP Packaging Material Category CHAR 1 0 VELTP
A Means of transport
B Transport equipment
C Packaging materials
D Auxiliary packaging material
EXIDV2 Handling Unit's 2nd External Identification CHAR 20 0 EXIDV2
LANDT Country/Region providing means of transport CHAR 3 0 T005 LANDT
LANDF Driver's Origin CHAR 3 0 T005 LANDF
NAMEF Driver name CHAR 35 0 NAMEF
NAMBE Alternate Driver's Name CHAR 35 0 NAMBE
VHILM_KU Partner's (Customer's or Vendor's) Packaging Material CHAR 35 0 VHILM_KU
VPOBJ Packing Object CHAR 2 0 VPOBJ
00 Not Assigned to an Object
01 Outbound Delivery
02 Sales Document
03 Inbound Delivery
04 Shipment
05 Non-Assigned Handling Unit
06 Non-Assigned Handling Unit
07 Repetitive Manufacturing
08 Work Order for Components
09 Work Order - Finished Product
12 Non-Assigned Handling Unit
21 Cross-Outbound Delivery
23 Cross-Inbound Delivery
VPOBJKEY Key for Object to Which the Handling Unit is Assigned CHAR 20 0 VPOBJKEY
HANDLE Worldwide unique key for VEKP-VENUM CHAR 22 0 GUID_VEKP
WMSTA WM Status for Container Material CHAR 1 0 LVS_WMSTA
Blank
A Being put away
B Put away
C In Stck Rmvl
D For stock transfer
LGNUM Warehouse Number/Warehouse Complex CHAR 3 0 T300 HUM_LGNUM
SAPRL SAP Release CHAR 4 0 SAPRL
KZGVH Packaging Material is Closed Packaging CHAR 1 0 KZGVH
ADGE_DG Packing Level is Relevant for Dangerous Goods CHAR 1 0 ADGE_DG
ADGE_DGPR Indicator: Packing level is relevant for printing CHAR 1 0 ADGE_DGPR
UEVEL Higher-Level Handling Unit CHAR 10 0 UEVEL
PACKVORSCHR Packing Instruction CHAR 22 0 PL_PACKNR_CONV
PACKVORSCHR_ST Local packing status for a single HU (without sub HUs) CHAR 1 0 PL_PACKSTATUS_LOCAL
LABELTYP Checkbox: Do Not Print External Shipping Label CHAR 1 0 PL_SHIPLABEL
ZUL_AUFL Allowed Load QUAN 15 3 PL_MAXSTWE
STATUS Handling unit status CHAR 4 0 HU_STATUS
Blank
0001 Planned
0010 Implemented - stock not posted as goods receipt
0015 Visually Checked
0020 Stock at a non-HU storage location
0030 Stock at HU storage location
0031 Physical inventory
0040 In transit
0050 Posted for GI
0060 Deleted
HU_LGORT Content is Located at an HU-managed Storage Location CHAR 1 0 HU_LGORT
Handling unit without inventory management
A HU w/o inventory mgmt should be posted to HU storage locatn
B HU was posted to stock in transit
C HU with inventory mgmt scheduled for other HU storage loc.
D HU with inventory mgmt scheduled for non-HU storage loc.
X Is in an HU-managed storage location
HU_SYSTEM HU and IM Stock in Separate Systems CHAR 1 0 HUMSYS
Handling unit and IM in the same system
A System with IM stock - HU is managed externally
B System with HU stock - IM stock is managed externally
SPE_HDALL Inbound delivery header not yet complete (on Hold) CHAR 1 0 /SPE/INB_HDALL
SPE_VLSTK Distribution Status (Decentralized Warehouse Processing) CHAR 1 0 VLSTK
Not Relevant
A Relevant
B Distributed
C Confirmed
D Planned for Distribution
E Delivery split was performed locally
F Change Management Switched Off
SPE_DELDEC Delete indicator for the confirmation of deleted HUs CHAR 1 0 /SPE/INB_DELDEC
SPE_IDART_01 Handling Unit Identification Type CHAR 1 0 /SPE/DE_HUIDART
SPE_IDENT_01 Alternative HU Identification CHAR 40 0 /SPE/DE_IDENT
SPE_IDART_02 Handling Unit Identification Type CHAR 1 0 /SPE/DE_HUIDART
SPE_IDENT_02 Alternative HU Identification CHAR 40 0 /SPE/DE_IDENT
SPE_IDART_03 Handling Unit Identification Type CHAR 1 0 /SPE/DE_HUIDART
SPE_IDENT_03 Alternative HU Identification CHAR 40 0 /SPE/DE_IDENT
SPE_IDART_04 Handling Unit Identification Type CHAR 1 0 /SPE/DE_HUIDART
SPE_IDENT_04 Alternative HU Identification CHAR 40 0 /SPE/DE_IDENT
SPE_LOGPOS Logical Position of Handling Unit CHAR 2 0 /SPE/DE_LOGPOS
SPE_CHK_COUNTER Check number for cross-delivery handling units NUMC 5 0 /SPE/DE_CHK_CTR
UUID UUID datatype raw 16 RAW 16 0 LO_HU_UUID_RAW16
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
TM_DOC_ID TM Document ID CHAR 20 0 TMS_TM_DOC_ID
TM_DOC_TCO External Business Transaction Document Type Code CHAR 5 0 TMS_BTD_TYPE_CODE
TM_DOC_ITEM_ID TM Document Item ID CHAR 10 0 TMS_TM_ITEM_ID
HUDHR_INCL_EEW_PS Dummy function in length 1 CHAR 1 0 DUMMY
CHARG Batch Number CHAR 10 0 * CHARG_D
EPC1 Electronic Product Code 1 CHAR 96 0 ABI_EPC1
EPC2 Electronic Product Code 2 CHAR 96 0 ABI_EPC2
PACKAGE_CAT Category of Package CHAR 15 0 EHS_ADGE_PACKAGE_CAT
TRANSP_INDEX Transport Index DEC 7 2 EHS_ADGE_TRANSP_INDEX
CRIT_SAF_INDEX Criticality Safety Index DEC 7 2 EHS_ADGE_CRIT_SAF_INDEX
FLG_DG_PACKAGE Dangerous Goods Package CHAR 1 0 ADGE_FLG_DG_PACKAGE
DG_PACKAGE_LEVEL Level of Dangerous Goods Packaging CHAR 3 0 TDG95 ADGE_DG_PACKAGE_LEVEL
PACKCODE Actual Packaging Code CHAR 10 0 CCUNC121 CBDUE_PACOD
INSTR_ENCL_CAT Category of Instruction for Enclosure CHAR 15 0 CCUNC113 CBUNE_INSTR_ENCL_CAT
MAT_DAMAGED_CL7 Damaged Material (Class 7) CHAR 1 0 ADGE_MAT_DAMAGED_CL7
DOSE_RATE_BULK Radiation Level (Unpacked) QUAN 9 5 ADGE_DOSE_RATE
DOSE_RATE_BULK_U Unit of Radiation Level (Unpacked) UNIT 3 0 T006 ADGE_DOSE_RATE_U
DOSE_RATE_PACK Radation Level Packed QUAN 9 5 ADGE_DOSE_RATE_PACKAGED
U_DOSE_RATE_PACK Unit of Radiation Level Packed UNIT 3 0 T006 ADGE_DOSE_RATE_PACKAGED_U
LEADING_LWDG Leading Dangerous Goods Regulation CHAR 12 0 THM063 ADGE_LEADING_LWDG
MAX_GROSS_WEIGHT Maximum Gross Mass QUAN 8 2 ADGE_MAX_GROSS_WEIGHT
U_MAX_GROSS_WGHT Unit for Maximum Gross Mass UNIT 3 0 T006 ADGE_U_MAX_GROSS_WGHT
LYARD Yard CHAR 3 0 LXYRD_YARD
YLCCL Location Class CHAR 2 0 LXYRDM_YLCCL
01 External location
02 Checkpoint
03 Parking space
04 Weighing point
05 Door
YLOCT Location CHAR 10 0 LXYRD_YLOCT
STATS Vehicle Stock Status CHAR 2 0 LXYRD_OBSTS
PRRTY Vehicle Priority CHAR 2 0 LXYRD_PRRTY
FWAGN Forwarding Agent CHAR 10 0 * LXYRD_FWAGN
SCACD Standard carrier access code CHAR 4 0 LEINT_SCACD
OWNER Vehicle Owner CHAR 10 0 LXYRD_OWNER
TRNPD Transponder CHAR 20 0 LXYRD_TRNPD
SEALN1 Sealing Number CHAR 10 0 LXYRD_SEALN
SEALN2 Sealing Number CHAR 10 0 LXYRD_SEALN
SEALN3 Sealing Number CHAR 10 0 LXYRD_SEALN
SEALN4 Sealing Number CHAR 10 0 LXYRD_SEALN
SEALN5 Sealing Number CHAR 10 0 LXYRD_SEALN
BLIND Block CHAR 1 0 LXYRD_BLOCK
RSNCD Reason Code CHAR 2 0 LYRSN LXYRD_RSNCD
RFTYP Reference Document Type CHAR 2 0 LXYRD_RFDTY
01 Outbound Delivery
03 Inbound Delivery
04 Outbound Shipment
05 Inbound Shipment
08 Non-SAP Document
33 Return Delivery
35 Return Shipment
REFER Reference Document CHAR 10 0 LXYRD_DOCRF
PTMST Planned End Time DEC 15 0 LXYRD_PTMST
ATMST Actual Start Time DEC 15 0 LXYRD_ATMSF
YDOOR Door CHAR 3 0 * LEINT_LGTOR
YSTGA Staging Area CHAR 10 0 * LEINT_LGBZO
URGFL Urgent (Relevant for Cross-Docking) CHAR 1 0 LXYRD_URGFL
PRFLG Permanence of Vehicle in Yard CHAR 1 0 LXYRD_PRFLG
SLFLG Sealing Required CHAR 1 0 LXYRD_SLFLG
SIGNI Container ID CHAR 20 0 LEINT_SIGNI
LTEXT Text CHAR 40 0 LXYRD_TEXT_DE

VEKP foreign key relationships

Table Field Check Table Check Field
0 VEKP DG_PACKAGE_LEVEL TDG95 DG: Define Level of Dangerous Goods Packaging MANDT
1 VEKP DOSE_RATE_BULK_U T006 Units of Measurement MANDT
1 VEKP DOSE_RATE_BULK_U T006 Units of Measurement MSEHI
0 VEKP EHENT T006 Units of Measurement MANDT
0 VEKP EHENT T006 Units of Measurement MSEHI
1 VEKP FAREH T006 Units of Measurement MANDT
1 VEKP FAREH T006 Units of Measurement MSEHI
0 VEKP GEWEI T006 Units of Measurement MANDT
0 VEKP GEWEI T006 Units of Measurement MSEHI
1 VEKP GEWEI_MAX T006 Units of Measurement MANDT
1 VEKP GEWEI_MAX T006 Units of Measurement MSEHI
0 VEKP INSTR_ENCL_CAT CCUNC113 Categories of Instruction for Enclosure MANDT
1 VEKP LADEH T006 Units of Measurement MANDT
1 VEKP LADEH T006 Units of Measurement MSEHI
0 VEKP LANDF T005 Countries MANDT
0 VEKP LANDF T005 Countries LAND1
1 VEKP LANDT T005 Countries MANDT
1 VEKP LANDT T005 Countries LAND1
0 VEKP LEADING_LWDG THM063 DG: Dangerous Goods Regulation MANDT
0 VEKP LEADING_LWDG THM063 DG: Dangerous Goods Regulation LWDG
1 VEKP LGNUM T300 WM Warehouse Numbers MANDT
1 VEKP LGNUM T300 WM Warehouse Numbers LGNUM
0 VEKP LGORT MARD Storage Location Data for Material MANDT
0 VEKP LGORT MARD Storage Location Data for Material MATNR
0 VEKP LGORT MARD Storage Location Data for Material WERKS
0 VEKP LGORT MARD Storage Location Data for Material LGORT
1 VEKP MAGRV TVEGR Material Group: Packaging Materials MANDT
1 VEKP MAGRV TVEGR Material Group: Packaging Materials MAGRV
0 VEKP MANDT T000 Clients MANDT
1 VEKP MEABM T006 Units of Measurement MANDT
0 VEKP MEINS T006 Units of Measurement MANDT
0 VEKP MEINS T006 Units of Measurement MSEHI
1 VEKP PACKCODE CCUNC121 Packaging Codes (Enhanced Data Model) MANDT
1 VEKP PACKCODE CCUNC121 Packaging Codes (Enhanced Data Model) LWDG
1 VEKP PACKCODE CCUNC121 Packaging Codes (Enhanced Data Model) PACKCODE
0 VEKP PSTYV TVPT Sales Documents: Item categories MANDT
0 VEKP PSTYV TVPT Sales Documents: Item categories PSTYV
1 VEKP RSNCD LYRSN Reason codes MANDT
1 VEKP RSNCD LYRSN Reason codes LYARD
0 VEKP U_DOSE_RATE_PACK T006 Units of Measurement MANDT
0 VEKP U_DOSE_RATE_PACK T006 Units of Measurement MSEHI
1 VEKP U_MAX_GROSS_WGHT T006 Units of Measurement MANDT
1 VEKP U_MAX_GROSS_WGHT T006 Units of Measurement MSEHI
0 VEKP VEGR2 TVE2 Shipping Unit Group 2 MANDT
1 VEKP VEGR3 TVE3 Shipping Unit Group 3 MANDT
0 VEKP VEGR4 TVE4 Shipping Unit Group 4 MANDT
1 VEKP VHART TVTY Packaging Material Types MANDT
1 VEKP VHART TVTY Packaging Material Types TRATY
0 VEKP VHILM MARA General Material Data MANDT
0 VEKP VHILM MARA General Material Data MATNR
1 VEKP VOLEH T006 Units of Measurement MANDT
1 VEKP VOLEH T006 Units of Measurement MSEHI
0 VEKP VOLEH_MAX T006 Units of Measurement MANDT
0 VEKP VOLEH_MAX T006 Units of Measurement MSEHI
1 VEKP VSTEL TVST Organizational Unit: Shipping Points MANDT
1 VEKP VSTEL TVST Organizational Unit: Shipping Points VSTEL
0 VEKP WERKS MARC Plant Data for Material MANDT
0 VEKP WERKS MARC Plant Data for Material MATNR
0 VEKP WERKS MARC Plant Data for Material WERKS