VEKP SAP (Handling Unit - Header Table) Table details
Dictionary Type: Table
Description: Handling Unit - Header Table
Description: Handling Unit - Header Table
Table field list including key, data, relationships and ABAP select examples
VEKP is a standard SAP Table which is used to store Handling Unit - Header Table data and is available within R/3 SAP systems depending on the version and release level.
The VEKP table consists of various fields, each holding specific information or linking keys about Handling Unit - Header Table data available in SAP. These include VENUM (Internal Handling Unit Number), EXIDV (External Handling Unit Identification), EXIDA (Type of External Handling Unit Identifier), VSTEL (Shipping Point/Receiving Point).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VEKP table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VENUM | Internal Handling Unit Number | VENUM | CHAR | 10 | ALPHA | VENUM | VEL | ||
EXIDV | External Handling Unit Identification | EXIDV | CHAR | 20 | ALPHA | EXIDV | HU_IDENT_ALLG | ||
EXIDA | Type of External Handling Unit Identifier | EXIDA | CHAR | 1 | EXIDA | ||||
VSTEL | Shipping Point/Receiving Point | VSTEL | CHAR | 4 | TVST | VSTEL | VST | ||
LSTEL | Loading Point | LSTEL | CHAR | 2 | TVLA | LSTEL | |||
BRGEW | Total Weight of Handling Unit | BRGEW_VEKP | QUAN | 15(3) | MENG15 | ||||
NTGEW | Loading Weight of Handling Unit | NTGEW_VEKP | QUAN | 15(3) | MENG15 | ||||
MAGEW | Allowed Loading Weight of a Handling Unit | MAGEW_VEKP | QUAN | 15(3) | MENG15 | ||||
TARAG | Tare weight of handling unit | TARAG_VEKP | QUAN | 15(3) | MENG15 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
BTVOL | Total Volume of Handling Unit | BTVOL_VEKP | QUAN | 15(3) | MENG15 | ||||
NTVOL | Loading Volume of Handling Unit | NTVOL_VEKP | QUAN | 15(3) | MENG15 | ||||
MAVOL | Allowed Loading Volume for Handling Unit | MAVOL_VEKP | QUAN | 15(3) | MENG15 | ||||
TAVOL | Tare volume of handling unit | TAVOL_VEKP | QUAN | 15(3) | MENG15 | ||||
VOLEH | Volume unit | VOLEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
ANZGL | Number of Similar Packaging Materials | ANZGL | INT4 | 10 | ANZGL | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERUHR | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AEZET | Time last change was made | AEZET | TIMS | 6 | UZEIT | ||||
SORTL | Sort field | SORTL | CHAR | 10 | CHAR10 | ||||
VEGR1 | Handling Unit Group 1 (Freely Definable) | VEGR1 | CHAR | 5 | TVE1 | VEGR1 | |||
VEGR2 | Handling Unit Group 2 (Freely Definable) | VEGR2 | CHAR | 5 | TVE2 | VEGR2 | |||
VEGR3 | Handling Unit Group 3 (Freely Definable) | VEGR3 | CHAR | 5 | TVE3 | VEGR3 | |||
VEGR4 | Handling Unit Group 4 (Freely Definable) | VEGR4 | CHAR | 5 | TVE4 | VEGR4 | |||
VEGR5 | Handling Unit Group 5 (Freely Definable) | VEGR5 | CHAR | 5 | TVE5 | VEGR5 | |||
VHILM | Packaging Materials | VHILM | CHAR | 18 | MARA | MATN1 | MATNR | ||
LAENG | Length | LAENG | QUAN | 13(3) | MENG13 | ||||
BREIT | Width | BREIT | QUAN | 13(3) | MENG13 | ||||
HOEHE | Height | HOEHE | QUAN | 13(3) | MENG13 | ||||
MEABM | Unit of Dimension for Length/Width/Height | MEABM | UNIT | 3 | T006 | CUNIT | MEINS | ||
ERLKZ | Status (at this time without functionality) | VOLLS | CHAR | 1 | XFELD | ||||
GEWTO | Excess Weight Tolerance for Handling unit | GEWTO | DEC | 3(1) | PRZ21 | ||||
VOLTO | Excess Volume Tolerance of the Handling Unit | VOLTO | DEC | 3(1) | PRZ21 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
VOLEH_MAX | Volume unit | VOLEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
GEWEI_MAX | Weight Unit | GEWEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
VBELN_GEN | Delivery in Which Packaging Material Is Generated as an Item | VBELN_GEN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
POSNR_GEN | Generated delivery item | POSNR_GEN | NUMC | 6 | Assigned to domain | POSNR | |||
INHALT | Description of Handling Unit Content | INHALT | CHAR | 40 | TEXT40 | ||||
VHART | Packaging Material Type | VHIART | CHAR | 4 | TVTY | TRATY | |||
KAPPL | Application for output conditions | NA_KAPPL | CHAR | 2 | Assigned to domain | KAPPL | NA_KAPPL | ||
KALSM | Output determination procedure | KALSMB | CHAR | 6 | Assigned to domain | KALSM | |||
KSCHL | Output Type | NA_KSCHL | CHAR | 4 | Assigned to domain | KSCHL | NAC | CSH_NA_KSCHL | |
MAGRV | Material Group: Packaging Materials | MAGRV | CHAR | 4 | TVEGR | MAGRV | |||
WERKS | Plant | HUM_WERKS | CHAR | 4 | MARC | WERKS | WRK | H_T001W | |
PSTYV | Sales document item category | PSTYV | CHAR | 4 | TVPT | PSTYV | |||
VKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
VTWEG | Reference distrib.channel for cust.and material masters | VTWKU | CHAR | 2 | Assigned to domain | VTWEG | VTW | ||
LADLG | Lgth of loading platform in lgth of LdPlat measurement units | LADLG | QUAN | 6 | LADLG | ||||
LADEH | Unit of measure to measure the length of loading platform | LADEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
FARZT | Travel Time | FARZT | QUAN | 3 | FARZT | ||||
FAREH | Unit of travel time | FAREH | UNIT | 3 | T006 | CUNIT | MEINS | ||
ENTFE | Distance Travelled | ENTFE | QUAN | 6 | ENTFE | ||||
EHENT | Unit of distance | EHENT | UNIT | 3 | T006 | CUNIT | MEINS | ||
LGORT | Storage Location | HUM_LGORT | CHAR | 4 | MARD | LGORT | LAG | ||
GEWFX | Weight and Volume Fixed | GEWFX | CHAR | 1 | XFELD | ||||
VELTP | Packaging Material Category | VELTP | CHAR | 1 | VELTP | ||||
EXIDV2 | Handling Unit's 2nd External Identification | EXIDV2 | CHAR | 20 | ALPHA | EXIDV | |||
LANDT | Country providing means of transport | LANDT | CHAR | 3 | T005 | LAND1 | |||
LANDF | Driver's Nationality | LANDF | CHAR | 3 | T005 | LAND1 | |||
NAMEF | Driver name | NAMEF | CHAR | 35 | NAME | ||||
NAMBE | Alternate Driver's Name | NAMBE | CHAR | 35 | NAME | ||||
VHILM_KU | Partner's (Customer's or Vendor's) Packaging Material | VHILM_KU | CHAR | 35 | IDNEX | ||||
VPOBJ | Packing Object | VPOBJ | CHAR | 2 | VPOBJ | ||||
VPOBJKEY | Key for Object to Which the Handling Unit is Assigned | VPOBJKEY | CHAR | 20 | CHAR20 | ||||
HANDLE | Worldwide unique key for VEKP-VENUM | GUID_VEKP | CHAR | 22 | SYSUUID_22 | ||||
WMSTA | WM status for container material | LVS_WMSTA | CHAR | 1 | LVS_WMSTA | ||||
LGNUM | Warehouse Number / Warehouse Complex | HUM_LGNUM | CHAR | 3 | T300 | LGNUM | LGN | ||
SAPRL | SAP Release | SAPRL | CHAR | 4 | SAPRL | ||||
KZGVH | Packaging Material is Closed Packaging | KZGVH | CHAR | 1 | XFELD | ||||
ADGE_DG | Packing Level is Relevant for Dangerous Goods | ADGE_DG | CHAR | 1 | X | ||||
ADGE_DGPR | Indicator: Packing level is relevant for printing | ADGE_DGPR | CHAR | 1 | X | ||||
UEVEL | Higher-Level Handling Unit | UEVEL | CHAR | 10 | Assigned to domain | ALPHA | VENUM | ||
PACKVORSCHR | Packing instruction | PL_PACKNR_CONV | CHAR | 22 | VHUPI | PL_PACKNR_CONV | PL_PI1 | ||
PACKVORSCHR_ST | Local packing status for a single HU (without sub HUs) | PL_PACKSTATUS_LOCAL | CHAR | 1 | PL_PACKSTATU | ||||
LABELTYP | Indicator: do not print external shipping label | PL_SHIPLABEL | CHAR | 1 | XFELD | ||||
ZUL_AUFL | Allowed load | PL_MAXSTWE | QUAN | 15(3) | MENG15 | ||||
STATUS | Handling unit status | HU_STATUS | CHAR | 4 | HU_STATUS | ||||
HU_LGORT | Content is Located at an HU-managed Storage Location | HU_LGORT | CHAR | 1 | HU_LGORT | ||||
HU_SYSTEM | HU and IM Stock in Separate Systems | HUMSYS | CHAR | 1 | HUMSYS | ||||
SPE_HDALL | Inbound delivery header not yet complete (on Hold) | /SPE/INB_HDALL | CHAR | 1 | XFELD | ||||
SPE_VLSTK | Distribution Status (Decentralized Warehouse Processing) | VLSTK | CHAR | 1 | VLSTK | ||||
SPE_DELDEC | Delete indicator for the confirmation of deleted HUs | /SPE/INB_DELDEC | CHAR | 1 | XFELD | ||||
SPE_IDART_01 | Handling Unit Identification Type | /SPE/DE_HUIDART | CHAR | 1 | /SPE/DO_HUIDART | ||||
SPE_IDENT_01 | Alternative HU Identification | /SPE/DE_IDENT | CHAR | 40 | |||||
SPE_IDART_02 | Handling Unit Identification Type | /SPE/DE_HUIDART | CHAR | 1 | /SPE/DO_HUIDART | ||||
SPE_IDENT_02 | Alternative HU Identification | /SPE/DE_IDENT | CHAR | 40 | |||||
SPE_IDART_03 | Handling Unit Identification Type | /SPE/DE_HUIDART | CHAR | 1 | /SPE/DO_HUIDART | ||||
SPE_IDENT_03 | Alternative HU Identification | /SPE/DE_IDENT | CHAR | 40 | |||||
SPE_IDART_04 | Handling Unit Identification Type | /SPE/DE_HUIDART | CHAR | 1 | /SPE/DO_HUIDART | ||||
SPE_IDENT_04 | Alternative HU Identification | /SPE/DE_IDENT | CHAR | 40 | |||||
SPE_LOGPOS | Logical Position of Handling Unit | /SPE/DE_LOGPOS | CHAR | 2 | |||||
SPE_CHK_COUNTER | Check number for cross-delivery handling units | /SPE/DE_CHK_CTR | NUMC | 5 | NUMC5 | ||||
.INCLU--AP | 0 | ||||||||
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
.INCLU--AP | 0 | ||||||||
EPC1 | Electronic Product Code 1 | ABI_EPC1 | CHAR | 96 | ABI_HEX64 | ||||
EPC2 | Electronic Product Code 2 | ABI_EPC2 | CHAR | 96 | ABI_HEX64 | ||||
.INCLU--AP | 0 | ||||||||
PACKAGE_CAT | Category of Package | EHS_ADGE_PACKAGE_CAT | CHAR | 15 | EHS_ADGD_PACKAGE_CAT | ||||
TRANSP_INDEX | Transport Index | EHS_ADGE_TRANSP_INDEX | DEC | 7(2) | DEC5_2 | ||||
CRIT_SAF_INDEX | Criticality Safety Index | EHS_ADGE_CRIT_SAF_INDEX | DEC | 7(2) | DEC5_2 | ||||
FLG_DG_PACKAGE | Dangerous Goods Package | ADGE_FLG_DG_PACKAGE | CHAR | 1 | ESDFLAG | ||||
DG_PACKAGE_LEVEL | Level of Dangerous Goods Packaging | ADGE_DG_PACKAGE_LEVEL | CHAR | 3 | TDG95 | ADGD_DG_PACKAGE_LEVEL | |||
PACKCODE | Actual Packaging Code | CBDUE_PACOD | CHAR | 10 | CCUNC121 | CBUND_PACOD | |||
INSTR_ENCL_CAT | Category of Instruction for Enclosure | CBUNE_INSTR_ENCL_CAT | CHAR | 15 | CCUNC113 | CBUND_INSTR_ENCL_CAT | |||
MAT_DAMAGED_CL7 | Damaged Material (Class 7) | ADGE_MAT_DAMAGED_CL7 | CHAR | 1 | ADGD_YES_NO_NOT_DEFINED | ||||
DOSE_RATE_BULK | Radiation Level (Unpacked) | ADGE_DOSE_RATE | QUAN | 9(5) | ADGD_QUAN_9_5 | ||||
DOSE_RATE_BULK_U | Unit of Radiation Level (Unpacked) | ADGE_DOSE_RATE_U | UNIT | 3 | T006 | CUNIT | MEINS | ||
DOSE_RATE_PACK | Radation Level Packed | ADGE_DOSE_RATE_PACKAGED | QUAN | 9(5) | ADGD_QUAN_9_5 | ||||
U_DOSE_RATE_PACK | Unit of Radiation Level Packed | ADGE_DOSE_RATE_PACKAGED_U | UNIT | 3 | T006 | CUNIT | MEINS | ||
LEADING_LWDG | Leading Dangerous Goods Regulation | ADGE_LEADING_LWDG | CHAR | 12 | THM063 | HMD_LWDG | |||
MAX_GROSS_WEIGHT | Maximum Gross Mass | ADGE_MAX_GROSS_WEIGHT | QUAN | 8(2) | HMD_QUAN | ||||
U_MAX_GROSS_WGHT | Unit for Maximum Gross Mass | ADGE_U_MAX_GROSS_WGHT | UNIT | 3 | T006 | CUNIT | MEINS | ||
.INCLU--AP | 0 | ||||||||
LYARD | Yard | LXYRD_YARD | CHAR | 3 | Assigned to domain | LXYRD_YARD | LXYRD_LYARD | H_LXYRD_LYARD | |
YLCCL | Location Class | LXYRDM_YLCCL | CHAR | 2 | LXYRDM_YLCCL | ||||
YLOCT | Location | LXYRD_YLOCT | CHAR | 10 | CHAR10 | ||||
STATS | Vehicle Stock Status | LXYRD_OBSTS | CHAR | 2 | LXYRD_HUSTS | ||||
PRRTY | Vehicle Priority | LXYRD_PRRTY | CHAR | 2 | CHAR2 | ||||
FWAGN | Forwarding Agent | LXYRD_FWAGN | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
SCACD | Standard carrier access code | LEINT_SCACD | CHAR | 4 | SCACD | ||||
OWNER | Vehicle Owner | LXYRD_OWNER | CHAR | 10 | CHAR10 | ||||
TRNPD | Transponder | LXYRD_TRNPD | CHAR | 20 | CHAR20 | ||||
SEALN1 | Sealing Number | LXYRD_SEALN | CHAR | 10 | CHAR10 | ||||
SEALN2 | Sealing Number | LXYRD_SEALN | CHAR | 10 | CHAR10 | ||||
SEALN3 | Sealing Number | LXYRD_SEALN | CHAR | 10 | CHAR10 | ||||
SEALN4 | Sealing Number | LXYRD_SEALN | CHAR | 10 | CHAR10 | ||||
SEALN5 | Sealing Number | LXYRD_SEALN | CHAR | 10 | CHAR10 | ||||
BLIND | Block | LXYRD_BLOCK | CHAR | 1 | XFELD | ||||
RSNCD | Reason Code | LXYRD_RSNCD | CHAR | 2 | LYRSN | CHAR2 | |||
RFTYP | Reference Document Type | LXYRD_RFDTY | CHAR | 2 | LXYRD_RFDTY | ||||
REFER | Reference Document | LXYRD_DOCRF | CHAR | 10 | ALPHA | LXYRD_DOCRF | |||
PTMST | Planned End Time | LXYRD_PTMST | DEC | 15 | TSHME | LXHME_TSTMP | |||
ATMST | Actual Start Time | LXYRD_ATMSF | DEC | 15 | TSHME | LXHME_TSTMP | |||
YDOOR | Door | LEINT_LGTOR | CHAR | 3 | Assigned to domain | LGTOR | |||
YSTGA | Staging Area | LEINT_LGBZO | CHAR | 10 | Assigned to domain | LGBZO | |||
URGFL | Urgent (Relevant for Cross-Docking) | LXYRD_URGFL | CHAR | 1 | FLAG | ||||
PRFLG | Permanence of Vehicle in Yard | LXYRD_PRFLG | CHAR | 1 | FLAG | ||||
SLFLG | Sealing Required | LXYRD_SLFLG | CHAR | 1 | FLAG | ||||
SIGNI | Container ID | LEINT_SIGNI | CHAR | 20 | TEXT20 | ||||
LTEXT | Text | LXYRD_TEXT_DE | CHAR | 40 | TEXT40 |
Key field | Non-key field |
How do I retrieve data from SAP table VEKP using ABAP code
The following ABAP code Example will allow you to do a basic selection on VEKP to SELECT all data from the tableDATA: WA_VEKP TYPE VEKP.
SELECT SINGLE *
FROM VEKP
INTO CORRESPONDING FIELDS OF WA_VEKP
WHERE...
How to access SAP table VEKP
Within an ECC or HANA version of SAP you can also view further information about VEKP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects