VEKP

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_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]
    PRIMARY KEY (MANDT, VENUM)
);