VEKP

Transparent Table Application Table
151 Fields 5 CDS Views

Handling Unit - Header Table

VEKP is an SAP database table in S/4HANA. Handling Unit - Header Table. It contains 151 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
E_HandlingUnitHeader view from EXTENSION Extension View for Handling Unit Header
I_ERPHandlingUnitHdrHierNode view_entity from COMPOSITE ERP HU Hdr Hierarchy
I_ERPHandlingUnitItemHierNode view_entity inner COMPOSITE ERP HU Item Hierarchy
I_ERPHandlingUnitReferenceDoc view_entity from BASIC ERP relevant HU reference documents
I_HandlingUnitHeader view from BASIC Handling Unit Header

Fields (151)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY venum VENUM Internal HU no.
exidv EXIDV Handling Unit
exida EXIDA ID Type
vstel VSTEL Shipping Point
lstel LSTEL Loading Point
brgew BRGEW_VEKP Total Weight
ntgew NTGEW_VEKP Loading Weight
magew MAGEW_VEKP Allowed Weight
tarag TARAG_VEKP Tare Weight
gewei GEWEI Unit of Weight
btvol BTVOL_VEKP Total Volume
ntvol NTVOL_VEKP Loading Volume
mavol MAVOL_VEKP Allowed Volume
tavol TAVOL_VEKP Tare Volume
voleh VOLEH Volume Unit
anzgl ANZGL Similar
ernam ERNAM Created By
erdat ERDAT Created On
eruhr ERZET Time
aenam AENAM Changed By
aedat AEDAT Changed On
aezet AEZET Time of change
sortl SORTL Search term
vegr1 VEGR1 HU group 1
vegr2 VEGR2 HU group 2
vegr3 VEGR3 HU group 3
vegr4 VEGR4 HU group 4
vegr5 VEGR5 HU group 5
vhilm VHILM Packaging Materials
laeng LAENG Length
breit BREIT Width
hoehe HOEHE Height
meabm MEABM Unit
erlkz VOLLS Status
gewto GEWTO Excess wt tolerance
volto VOLTO Excess volume tol.
meins MEINS Base Unit
voleh_max VOLEH Volume Unit
gewei_max GEWEI Unit of Weight
vbeln_gen VBELN_GEN Gen.delivery
posnr_gen POSNR_GEN Generated item
inhalt INHALT Content
vhart VHIART Packag.Mat.Type
kappl NA_KAPPL Application
kalsm KALSMB OutputDet.Proc.
kschl NA_KSCHL Output Type
magrv MAGRV Matl Grp Pckmat
werks HUM_WERKS Plant
pstyv PSTYV Item Category
vkorg VKORG Sales Org.
vtweg VTWKU RefDistCh-Cust/Mat.
ladlg LADLG LgthLoadingPltf
ladeh LADEH Unit of length
farzt FARZT Travel time
fareh FAREH Trav.time unit
entfe ENTFE Distance
ehent EHENT Un. of distance
lgort HUM_LGORT Stor. Location
gewfx GEWFX Wt/Vol. Fixed
veltp VELTP Pack. Mat. Cat.
exidv2 EXIDV2 HU ID 2
landt LANDT Ctr/Reg prv.MoT
landf LANDF Driver's orig.
namef NAMEF Driver
nambe NAMBE Alt.Driver
vhilm_ku VHILM_KU CustPckgingMatl
vpobj VPOBJ Pack. Object
vpobjkey VPOBJKEY Object
handle GUID_VEKP Handle
wmsta LVS_WMSTA Container Stat.
lgnum HUM_LGNUM Whse Number
saprl SAPRL SAP Release
kzgvh KZGVH Closed
adge_dg ADGE_DG DG-relevant
adge_dgpr ADGE_DGPR Print-relevant
uevel UEVEL Higher-level HU
packvorschr PL_PACKNR_CONV PackInstruction
packvorschr_st PL_PACKSTATUS_LOCAL Loc.pack.status
labeltyp PL_SHIPLABEL No Shipping Label
zul_aufl PL_MAXSTWE Allowed Load
status HU_STATUS HU status
hu_lgort HU_LGORT HU storage loc.
hu_system HUMSYS HU system
spe_hdall /SPE/INB_HDALL Hold
spe_vlstk VLSTK StatDecntrlWhse
spe_deldec /SPE/INB_DELDEC Del.
spe_idart_01 /SPE/DE_HUIDART HU ID Type
spe_ident_01 /SPE/DE_IDENT Alt Hnd Unit ID
spe_idart_02 /SPE/DE_HUIDART HU ID Type
spe_ident_02 /SPE/DE_IDENT Alt Hnd Unit ID
spe_idart_03 /SPE/DE_HUIDART HU ID Type
spe_ident_03 /SPE/DE_IDENT Alt Hnd Unit ID
spe_idart_04 /SPE/DE_HUIDART HU ID Type
spe_ident_04 /SPE/DE_IDENT Alt Hnd Unit ID
spe_logpos /SPE/DE_LOGPOS Logical Pos.
spe_chk_counter /SPE/DE_CHK_CTR Check Number
uuid LO_HU_UUID_RAW16 UUID Raw 16
_dataaging DATA_TEMPERATURE Data Aging
ps_id /SCWM/DE_PSID Pack. Spec.
ps_level_seq /SCWM/DE_PS_LEVEL_SEQ Level Seq. No.
pb_engine /SCMB/PB_ENGINE UPB Engine
tm_doc_id TMS_TM_DOC_ID TM Document ID
tm_doc_tco TMS_BTD_TYPE_CODE BTDType Code
tm_doc_item_id TMS_TM_ITEM_ID TM Item ID
hudhr_incl_eew_ps DUMMY Dummy function in length 1
charg CHARG_D Batch
epc1 ABI_EPC1 EPC1
epc2 ABI_EPC2 EPC2
package_cat EHS_ADGE_PACKAGE_CAT Cat. of Package
transp_index EHS_ADGE_TRANSP_INDEX Transport Index
crit_saf_index EHS_ADGE_CRIT_SAF_INDEX Crit.Safety Idx
flg_dg_package ADGE_FLG_DG_PACKAGE DG Package
dg_package_level ADGE_DG_PACKAGE_LEVEL DG Pack. Level
packcode CBDUE_PACOD Packaging Code
instr_encl_cat CBUNE_INSTR_ENCL_CAT Encl.Instr.Cat.
mat_damaged_cl7 ADGE_MAT_DAMAGED_CL7 Damaged Matl
dose_rate_bulk ADGE_DOSE_RATE Rad Lvl (Unpkd)
dose_rate_bulk_u ADGE_DOSE_RATE_U RadLvl Un(Unpk)
dose_rate_pack ADGE_DOSE_RATE_PACKAGED Rad. Lvl Packed
u_dose_rate_pack ADGE_DOSE_RATE_PACKAGED_U Unit RadLvl Pkd
leading_lwdg ADGE_LEADING_LWDG Leading DG Reg.
max_gross_weight ADGE_MAX_GROSS_WEIGHT Max. Gross Mass
u_max_gross_wght ADGE_U_MAX_GROSS_WGHT Gross Unit
lyard LXYRD_YARD Yard
ylccl LXYRDM_YLCCL Loc. Class
yloct LXYRD_YLOCT Location
stats LXYRD_OBSTS Vehcle Status
prrty LXYRD_PRRTY Veh. Priority
fwagn LXYRD_FWAGN Fwd. Agent
scacd LEINT_SCACD SCAC
owner LXYRD_OWNER Vehicle Owner
trnpd LXYRD_TRNPD Transponder
sealn1 LXYRD_SEALN Sealing Number
sealn2 LXYRD_SEALN Sealing Number
sealn3 LXYRD_SEALN Sealing Number
sealn4 LXYRD_SEALN Sealing Number
sealn5 LXYRD_SEALN Sealing Number
blind LXYRD_BLOCK Blocked
rsncd LXYRD_RSNCD Reason Code
rftyp LXYRD_RFDTY Ref. Doc. Type
refer LXYRD_DOCRF Ref. Document
ptmst LXYRD_PTMST Plnd End Time
atmst LXYRD_ATMSF Actl Start Time
ydoor LEINT_LGTOR Door
ystga LEINT_LGBZO Staging Area
urgfl LXYRD_URGFL Urgent
prflg LXYRD_PRFLG Permanent
slflg LXYRD_SLFLG Seal. Required
signi LEINT_SIGNI Container ID
ltext LXYRD_TEXT_DE Text

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Handling Unit - Header Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VEKP (
    MANDT,              -- Client [MANDT]
    VENUM,              -- Internal HU no. [VENUM]
    EXIDV,              -- Handling Unit [EXIDV]
    EXIDA,              -- ID Type [EXIDA]
    VSTEL,              -- Shipping Point [VSTEL]
    LSTEL,              -- Loading Point [LSTEL]
    BRGEW,              -- Total Weight [BRGEW_VEKP]
    NTGEW,              -- Loading Weight [NTGEW_VEKP]
    MAGEW,              -- Allowed Weight [MAGEW_VEKP]
    TARAG,              -- Tare Weight [TARAG_VEKP]
    GEWEI,              -- Unit of Weight [GEWEI]
    BTVOL,              -- Total Volume [BTVOL_VEKP]
    NTVOL,              -- Loading Volume [NTVOL_VEKP]
    MAVOL,              -- Allowed Volume [MAVOL_VEKP]
    TAVOL,              -- Tare Volume [TAVOL_VEKP]
    VOLEH,              -- Volume Unit [VOLEH]
    ANZGL,              -- Similar [ANZGL]
    ERNAM,              -- Created By [ERNAM]
    ERDAT,              -- Created On [ERDAT]
    ERUHR,              -- Time [ERZET]
    AENAM,              -- Changed By [AENAM]
    AEDAT,              -- Changed On [AEDAT]
    AEZET,              -- Time of change [AEZET]
    SORTL,              -- Search term [SORTL]
    VEGR1,              -- HU group 1 [VEGR1]
    VEGR2,              -- HU group 2 [VEGR2]
    VEGR3,              -- HU group 3 [VEGR3]
    VEGR4,              -- HU group 4 [VEGR4]
    VEGR5,              -- HU group 5 [VEGR5]
    VHILM,              -- Packaging Materials [VHILM]
    LAENG,              -- Length [LAENG]
    BREIT,              -- Width [BREIT]
    HOEHE,              -- Height [HOEHE]
    MEABM,              -- Unit [MEABM]
    ERLKZ,              -- Status [VOLLS]
    GEWTO,              -- Excess wt tolerance [GEWTO]
    VOLTO,              -- Excess volume tol. [VOLTO]
    MEINS,              -- Base Unit [MEINS]
    VOLEH_MAX,          -- Volume Unit [VOLEH]
    GEWEI_MAX,          -- Unit of Weight [GEWEI]
    VBELN_GEN,          -- Gen.delivery [VBELN_GEN]
    POSNR_GEN,          -- Generated item [POSNR_GEN]
    INHALT,             -- Content [INHALT]
    VHART,              -- Packag.Mat.Type [VHIART]
    KAPPL,              -- Application [NA_KAPPL]
    KALSM,              -- OutputDet.Proc. [KALSMB]
    KSCHL,              -- Output Type [NA_KSCHL]
    MAGRV,              -- Matl Grp Pckmat [MAGRV]
    WERKS,              -- Plant [HUM_WERKS]
    PSTYV,              -- Item Category [PSTYV]
    VKORG,              -- Sales Org. [VKORG]
    VTWEG,              -- RefDistCh-Cust/Mat. [VTWKU]
    LADLG,              -- LgthLoadingPltf [LADLG]
    LADEH,              -- Unit of length [LADEH]
    FARZT,              -- Travel time [FARZT]
    FAREH,              -- Trav.time unit [FAREH]
    ENTFE,              -- Distance [ENTFE]
    EHENT,              -- Un. of distance [EHENT]
    LGORT,              -- Stor. Location [HUM_LGORT]
    GEWFX,              -- Wt/Vol. Fixed [GEWFX]
    VELTP,              -- Pack. Mat. Cat. [VELTP]
    EXIDV2,             -- HU ID 2 [EXIDV2]
    LANDT,              -- Ctr/Reg prv.MoT [LANDT]
    LANDF,              -- Driver's orig. [LANDF]
    NAMEF,              -- Driver [NAMEF]
    NAMBE,              -- Alt.Driver [NAMBE]
    VHILM_KU,           -- CustPckgingMatl [VHILM_KU]
    VPOBJ,              -- Pack. Object [VPOBJ]
    VPOBJKEY,           -- Object [VPOBJKEY]
    HANDLE,             -- Handle [GUID_VEKP]
    WMSTA,              -- Container Stat. [LVS_WMSTA]
    LGNUM,              -- Whse Number [HUM_LGNUM]
    SAPRL,              -- SAP Release [SAPRL]
    KZGVH,              -- Closed [KZGVH]
    ADGE_DG,            -- DG-relevant [ADGE_DG]
    ADGE_DGPR,          -- Print-relevant [ADGE_DGPR]
    UEVEL,              -- Higher-level HU [UEVEL]
    PACKVORSCHR,        -- PackInstruction [PL_PACKNR_CONV]
    PACKVORSCHR_ST,     -- Loc.pack.status [PL_PACKSTATUS_LOCAL]
    LABELTYP,           -- No Shipping Label [PL_SHIPLABEL]
    ZUL_AUFL,           -- Allowed Load [PL_MAXSTWE]
    STATUS,             -- HU status [HU_STATUS]
    HU_LGORT,           -- HU storage loc. [HU_LGORT]
    HU_SYSTEM,          -- HU system [HUMSYS]
    SPE_HDALL,          -- Hold [/SPE/INB_HDALL]
    SPE_VLSTK,          -- StatDecntrlWhse [VLSTK]
    SPE_DELDEC,         -- Del. [/SPE/INB_DELDEC]
    SPE_IDART_01,       -- HU ID Type [/SPE/DE_HUIDART]
    SPE_IDENT_01,       -- Alt Hnd Unit ID [/SPE/DE_IDENT]
    SPE_IDART_02,       -- HU ID Type [/SPE/DE_HUIDART]
    SPE_IDENT_02,       -- Alt Hnd Unit ID [/SPE/DE_IDENT]
    SPE_IDART_03,       -- HU ID Type [/SPE/DE_HUIDART]
    SPE_IDENT_03,       -- Alt Hnd Unit ID [/SPE/DE_IDENT]
    SPE_IDART_04,       -- HU ID Type [/SPE/DE_HUIDART]
    SPE_IDENT_04,       -- Alt Hnd Unit ID [/SPE/DE_IDENT]
    SPE_LOGPOS,         -- Logical Pos. [/SPE/DE_LOGPOS]
    SPE_CHK_COUNTER,    -- Check Number [/SPE/DE_CHK_CTR]
    UUID,               -- UUID Raw 16 [LO_HU_UUID_RAW16]
    _DATAAGING,         -- Data Aging [DATA_TEMPERATURE]
    PS_ID,              -- Pack. Spec. [/SCWM/DE_PSID]
    PS_LEVEL_SEQ,       -- Level Seq. No. [/SCWM/DE_PS_LEVEL_SEQ]
    PB_ENGINE,          -- UPB Engine [/SCMB/PB_ENGINE]
    TM_DOC_ID,          -- TM Document ID [TMS_TM_DOC_ID]
    TM_DOC_TCO,         -- BTDType Code [TMS_BTD_TYPE_CODE]
    TM_DOC_ITEM_ID,     -- TM Item ID [TMS_TM_ITEM_ID]
    HUDHR_INCL_EEW_PS,  -- Dummy function in length 1 [DUMMY]
    CHARG,              -- Batch [CHARG_D]
    EPC1,               -- EPC1 [ABI_EPC1]
    EPC2,               -- EPC2 [ABI_EPC2]
    PACKAGE_CAT,        -- Cat. of Package [EHS_ADGE_PACKAGE_CAT]
    TRANSP_INDEX,       -- Transport Index [EHS_ADGE_TRANSP_INDEX]
    CRIT_SAF_INDEX,     -- Crit.Safety Idx [EHS_ADGE_CRIT_SAF_INDEX]
    FLG_DG_PACKAGE,     -- DG Package [ADGE_FLG_DG_PACKAGE]
    DG_PACKAGE_LEVEL,   -- DG Pack. Level [ADGE_DG_PACKAGE_LEVEL]
    PACKCODE,           -- Packaging Code [CBDUE_PACOD]
    INSTR_ENCL_CAT,     -- Encl.Instr.Cat. [CBUNE_INSTR_ENCL_CAT]
    MAT_DAMAGED_CL7,    -- Damaged Matl [ADGE_MAT_DAMAGED_CL7]
    DOSE_RATE_BULK,     -- Rad Lvl (Unpkd) [ADGE_DOSE_RATE]
    DOSE_RATE_BULK_U,   -- RadLvl Un(Unpk) [ADGE_DOSE_RATE_U]
    DOSE_RATE_PACK,     -- Rad. Lvl Packed [ADGE_DOSE_RATE_PACKAGED]
    U_DOSE_RATE_PACK,   -- Unit RadLvl Pkd [ADGE_DOSE_RATE_PACKAGED_U]
    LEADING_LWDG,       -- Leading DG Reg. [ADGE_LEADING_LWDG]
    MAX_GROSS_WEIGHT,   -- Max. Gross Mass [ADGE_MAX_GROSS_WEIGHT]
    U_MAX_GROSS_WGHT,   -- Gross Unit [ADGE_U_MAX_GROSS_WGHT]
    LYARD,              -- Yard [LXYRD_YARD]
    YLCCL,              -- Loc. Class [LXYRDM_YLCCL]
    YLOCT,              -- Location [LXYRD_YLOCT]
    STATS,              -- Vehcle Status [LXYRD_OBSTS]
    PRRTY,              -- Veh. Priority [LXYRD_PRRTY]
    FWAGN,              -- Fwd. Agent [LXYRD_FWAGN]
    SCACD,              -- SCAC [LEINT_SCACD]
    OWNER,              -- Vehicle Owner [LXYRD_OWNER]
    TRNPD,              -- Transponder [LXYRD_TRNPD]
    SEALN1,             -- Sealing Number [LXYRD_SEALN]
    SEALN2,             -- Sealing Number [LXYRD_SEALN]
    SEALN3,             -- Sealing Number [LXYRD_SEALN]
    SEALN4,             -- Sealing Number [LXYRD_SEALN]
    SEALN5,             -- Sealing Number [LXYRD_SEALN]
    BLIND,              -- Blocked [LXYRD_BLOCK]
    RSNCD,              -- Reason Code [LXYRD_RSNCD]
    RFTYP,              -- Ref. Doc. Type [LXYRD_RFDTY]
    REFER,              -- Ref. Document [LXYRD_DOCRF]
    PTMST,              -- Plnd End Time [LXYRD_PTMST]
    ATMST,              -- Actl Start Time [LXYRD_ATMSF]
    YDOOR,              -- Door [LEINT_LGTOR]
    YSTGA,              -- Staging Area [LEINT_LGBZO]
    URGFL,              -- Urgent [LXYRD_URGFL]
    PRFLG,              -- Permanent [LXYRD_PRFLG]
    SLFLG,              -- Seal. Required [LXYRD_SLFLG]
    SIGNI,              -- Container ID [LEINT_SIGNI]
    LTEXT,              -- Text [LXYRD_TEXT_DE]
    PRIMARY KEY (MANDT, VENUM)
);

Learn More