SAP VEKP Handling Unit - Header Table Table

Overview

VEKP is a standard SAP S/4HANA table that stores Handling Unit - Header Table data. There are total 141 fields in the VEKP table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VEKP belongs to Basic functions (LO-HU-BF) module and is located in the package Handling Units - General Packing (HANDLING_UNITS).

In addition, following links provide an overview of foreign key relationships, if any, that link VEKP to other SAP tables and standard CDS views available based on VEKP table in S/4HANA 2020.

Techincal Settings of VEKP

Below are technical details of the table VEKP

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of VEKP Fields

The following table gives you an overview of the fields available in VEKP

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
VENUMInternal Handling Unit NumberVENUMCHAR10
EXIDVExternal Handling Unit IdentificationEXIDVCHAR20
EXIDAType of External Handling Unit IdentifierEXIDACHAR1
VSTELShipping Point / Receiving PointVSTELTVSTCHAR4
LSTELLoading PointLSTELTVLACHAR2
BRGEWTotal Weight of Handling UnitBRGEW_VEKPQUAN15
NTGEWLoading Weight of Handling UnitNTGEW_VEKPQUAN15
MAGEWAllowed Loading Weight of a Handling UnitMAGEW_VEKPQUAN15
TARAGTare Weight of Handling UnitTARAG_VEKPQUAN15
GEWEIWeight UnitGEWEIT006UNIT3
BTVOLTotal Volume of Handling UnitBTVOL_VEKPQUAN15
NTVOLLoading Volume of Handling UnitNTVOL_VEKPQUAN15
MAVOLAllowed Loading Volume for Handling UnitMAVOL_VEKPQUAN15
TAVOLTare Volume of Handling UnitTAVOL_VEKPQUAN15
VOLEHVolume unitVOLEHT006UNIT3
ANZGLNumber of Similar Packaging MaterialsANZGLINT410
ERNAMName of Person who Created the ObjectERNAMCHAR12
ERDATDate on which the record was createdERDATDATS8
ERUHREntry timeERZETTIMS6
AENAMName of person who changed objectAENAMCHAR12
AEDATDate of Last ChangeAEDATDATS8
AEZETTime last change was madeAEZETTIMS6
SORTLSort fieldSORTLCHAR10
VEGR1Handling Unit Group 1 (Freely Definable)VEGR1TVE1CHAR5
VEGR2Handling Unit Group 2 (Freely Definable)VEGR2TVE2CHAR5
VEGR3Handling Unit Group 3 (Freely Definable)VEGR3TVE3CHAR5
VEGR4Handling Unit Group 4 (Freely Definable)VEGR4TVE4CHAR5
VEGR5Handling Unit Group 5 (Freely Definable)VEGR5TVE5CHAR5
VHILMPackaging MaterialsVHILMMARACHAR40
LAENGLengthLAENGQUAN13
BREITWidthBREITQUAN13
HOEHEHeightHOEHEQUAN13
MEABMUnit of Dimension for Length/Width/HeightMEABMT006UNIT3
ERLKZStatus (at this time without functionality)VOLLSCHAR1
GEWTOExcess Weight Tolerance for Handling unitGEWTODEC3
VOLTOExcess Volume Tolerance of the Handling UnitVOLTODEC3
MEINSBase Unit of MeasureMEINST006UNIT3
VOLEH_MAXVolume unitVOLEHT006UNIT3
GEWEI_MAXWeight UnitGEWEIT006UNIT3
VBELN_GENDelivery in Which Packaging Material Is Generated as an ItemVBELN_GENCHAR10
POSNR_GENGenerated delivery itemPOSNR_GENNUMC6
INHALTDescription of Handling Unit ContentINHALTCHAR40
VHARTPackaging Material TypeVHIARTTVTYCHAR4
KAPPLApplication for output conditionsNA_KAPPLCHAR2
KALSMOutput determination procedureKALSMBCHAR6
KSCHLOutput TypeNA_KSCHLCHAR4
MAGRVMaterial Group: Packaging MaterialsMAGRVTVEGRCHAR4
WERKSPlantHUM_WERKSMARCCHAR4
PSTYVSales document item categoryPSTYVTVPTCHAR4
VKORGSales OrganizationVKORGCHAR4
VTWEGReference distrib.channel for cust.and material mastersVTWKUCHAR2
LADLGLgth of loading platform in lgth of LdPlat measurement unitsLADLGQUAN6
LADEHUnit of measure to measure the length of loading platformLADEHT006UNIT3
FARZTTravel TimeFARZTQUAN3
FAREHUnit of travel timeFAREHT006UNIT3
ENTFEDistance TravelledENTFEQUAN6
EHENTUnit of distanceEHENTT006UNIT3
LGORTStorage LocationHUM_LGORTMARDCHAR4
GEWFXWeight and Volume FixedGEWFXCHAR1
VELTPPackaging Material CategoryVELTPCHAR1
EXIDV2Handling Unit's 2nd External IdentificationEXIDV2CHAR20
LANDTCountry providing means of transportLANDTT005CHAR3
LANDFDriver's NationalityLANDFT005CHAR3
NAMEFDriver nameNAMEFCHAR35
NAMBEAlternate Driver's NameNAMBECHAR35
VHILM_KUPartner's (Customer's or Vendor's) Packaging MaterialVHILM_KUCHAR35
VPOBJPacking ObjectVPOBJCHAR2
VPOBJKEYKey for Object to Which the Handling Unit is AssignedVPOBJKEYCHAR20
HANDLEWorldwide unique key for VEKP-VENUMGUID_VEKPCHAR22
WMSTAWM Status for Container MaterialLVS_WMSTACHAR1
LGNUMWarehouse Number/Warehouse ComplexHUM_LGNUMT300CHAR3
SAPRLSAP ReleaseSAPRLCHAR4
KZGVHPackaging Material is Closed PackagingKZGVHCHAR1
ADGE_DGPacking Level is Relevant for Dangerous GoodsADGE_DGCHAR1
ADGE_DGPRIndicator: Packing level is relevant for printingADGE_DGPRCHAR1
UEVELHigher-Level Handling UnitUEVELCHAR10
PACKVORSCHRPacking InstructionPL_PACKNR_CONVCHAR22
PACKVORSCHR_STLocal packing status for a single HU (without sub HUs)PL_PACKSTATUS_LOCALCHAR1
LABELTYPCheckbox: Do Not Print External Shipping LabelPL_SHIPLABELCHAR1
ZUL_AUFLAllowed LoadPL_MAXSTWEQUAN15
STATUSHandling unit statusHU_STATUSCHAR4
HU_LGORTContent is Located at an HU-managed Storage LocationHU_LGORTCHAR1
HU_SYSTEMHU and IM Stock in Separate SystemsHUMSYSCHAR1
SPE_HDALLInbound delivery header not yet complete (on Hold)/SPE/INB_HDALLCHAR1
SPE_VLSTKDistribution Status (Decentralized Warehouse Processing)VLSTKCHAR1
SPE_DELDECDelete indicator for the confirmation of deleted HUs/SPE/INB_DELDECCHAR1
SPE_IDART_01Handling Unit Identification Type/SPE/DE_HUIDARTCHAR1
SPE_IDART_02Handling Unit Identification Type/SPE/DE_HUIDARTCHAR1
SPE_IDART_03Handling Unit Identification Type/SPE/DE_HUIDARTCHAR1
SPE_IDART_04Handling Unit Identification Type/SPE/DE_HUIDARTCHAR1
SPE_CHK_COUNTERCheck number for cross-delivery handling units/SPE/DE_CHK_CTRNUMC5
_DATAAGINGData Filter Value for Data AgingDATA_TEMPERATUREDATS8
TM_DOC_IDTM Document IDTMS_TM_DOC_IDCHAR20
TM_DOC_ITEM_IDTM Document Item IDTMS_TM_ITEM_IDCHAR10
HUDHR_INCL_EEW_PSDummy function in length 1DUMMYCHAR1
CHARGBatch NumberCHARG_D*CHAR10
EPC1Electronic Product Code 1ABI_EPC1CHAR96
EPC2Electronic Product Code 2ABI_EPC2CHAR96
PACKAGE_CATCategory of PackageEHS_ADGE_PACKAGE_CATCHAR15
TRANSP_INDEXTransport IndexEHS_ADGE_TRANSP_INDEXDEC7
CRIT_SAF_INDEXCriticality Safety IndexEHS_ADGE_CRIT_SAF_INDEXDEC7
FLG_DG_PACKAGEDangerous Goods PackageADGE_FLG_DG_PACKAGECHAR1
DG_PACKAGE_LEVELLevel of Dangerous Goods PackagingADGE_DG_PACKAGE_LEVELTDG95CHAR3
PACKCODEActual Packaging CodeCBDUE_PACODCCUNC121CHAR10
INSTR_ENCL_CATCategory of Instruction for EnclosureCBUNE_INSTR_ENCL_CATCCUNC113CHAR15
MAT_DAMAGED_CL7Damaged Material (Class 7)ADGE_MAT_DAMAGED_CL7CHAR1
DOSE_RATE_BULKRadiation Level (Unpacked)ADGE_DOSE_RATEQUAN9
DOSE_RATE_BULK_UUnit of Radiation Level (Unpacked)ADGE_DOSE_RATE_UT006UNIT3
DOSE_RATE_PACKRadation Level PackedADGE_DOSE_RATE_PACKAGEDQUAN9
U_DOSE_RATE_PACKUnit of Radiation Level PackedADGE_DOSE_RATE_PACKAGED_UT006UNIT3
LEADING_LWDGLeading Dangerous Goods RegulationADGE_LEADING_LWDGTHM063CHAR12
MAX_GROSS_WEIGHTMaximum Gross MassADGE_MAX_GROSS_WEIGHTQUAN8
U_MAX_GROSS_WGHTUnit for Maximum Gross MassADGE_U_MAX_GROSS_WGHTT006UNIT3
LYARDYardLXYRD_YARDCHAR3
YLCCLLocation ClassLXYRDM_YLCCLCHAR2
YLOCTLocationLXYRD_YLOCTCHAR10
STATSVehicle Stock StatusLXYRD_OBSTSCHAR2
PRRTYVehicle PriorityLXYRD_PRRTYCHAR2
FWAGNForwarding AgentLXYRD_FWAGN*CHAR10
SCACDStandard carrier access codeLEINT_SCACDCHAR4
OWNERVehicle OwnerLXYRD_OWNERCHAR10
TRNPDTransponderLXYRD_TRNPDCHAR20
SEALN1Sealing NumberLXYRD_SEALNCHAR10
SEALN2Sealing NumberLXYRD_SEALNCHAR10
SEALN3Sealing NumberLXYRD_SEALNCHAR10
SEALN4Sealing NumberLXYRD_SEALNCHAR10
SEALN5Sealing NumberLXYRD_SEALNCHAR10
BLINDBlockLXYRD_BLOCKCHAR1
RSNCDReason CodeLXYRD_RSNCDLYRSNCHAR2
RFTYPReference Document TypeLXYRD_RFDTYCHAR2
REFERReference DocumentLXYRD_DOCRFCHAR10
PTMSTPlanned End TimeLXYRD_PTMSTDEC15
ATMSTActual Start TimeLXYRD_ATMSFDEC15
YDOORDoorLEINT_LGTOR*CHAR3
YSTGAStaging AreaLEINT_LGBZO*CHAR10
URGFLUrgent (Relevant for Cross-Docking)LXYRD_URGFLCHAR1
PRFLGPermanence of Vehicle in YardLXYRD_PRFLGCHAR1
SLFLGSealing RequiredLXYRD_SLFLGCHAR1
SIGNIContainer IDLEINT_SIGNICHAR20
LTEXTTextLXYRD_TEXT_DECHAR40

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VEKP

Table NameFieldCardinalityCheck Table
VEKPDG_PACKAGE_LEVEL1: CNTDG95
VEKPDOSE_RATE_BULK_U1: CNT006
VEKPEHENTC: CNT006
VEKPFAREHC: CNT006
VEKPGEWEIC: CNT006
VEKPGEWEI_MAXC: CNT006
VEKPINSTR_ENCL_CAT1: CNCCUNC113
VEKPLADEHC: CNT006
VEKPLANDFC: CNT005
VEKPLANDTC: CNT005
VEKPLEADING_LWDG1: CNTHM063
VEKPLGNUM1: CNT300
VEKPLGORTC: CNMARD
VEKPLSTELC: CNTVLA
VEKPMAGRVC: CNTVEGR
VEKPMANDT1: CNT000
VEKPMEABMC: CNT006
VEKPMEINSC: CNT006
VEKPPACKCODE1: CNCCUNC121
VEKPPSTYVC: CNTVPT
VEKPRSNCD:LYRSN
VEKPU_DOSE_RATE_PACK1: CNT006
VEKPU_MAX_GROSS_WGHT1: CNT006
VEKPVEGR11: CNTVE1
VEKPVEGR21: CNTVE2
VEKPVEGR31: CNTVE3
VEKPVEGR41: CNTVE4
VEKPVEGR51: CNTVE5
VEKPVHARTC: CNTVTY
VEKPVHILMC: CNMARA
VEKPVOLEHC: CNT006
VEKPVOLEH_MAXC: CNT006
VEKPVSTELC: CNTVST
VEKPWERKSC: CNMARC

Other References