SE11 ABAP Dictionary SE11 VEKP

Data SE16 SE16
Popular:
VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

VEKP

Handling Unit - Header Table
SAP SAP Transparent Table 141 Fields
Primary Key:
MANDT VENUM

Dictionary Fields Fields

(141 dari 141 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
VENUM
KEY Int. HU no CHAR 10 - - Internal Handling Unit Number
3
EXIDV
- HU CHAR 20 - - External Handling Unit Identification
4
EXIDA
- ID Type CHAR 1 - - Type of External Handling Unit Identifier
5
VSTEL
- Ship Point CHAR 4 - - Shipping Point/Receiving Point
6
LSTEL
- Loading Pt CHAR 2 - - Loading Point
7
BRGEW
- Total Wght QUAN 15 3 - Total Weight of Handling Unit
8
NTGEW
- Load wght QUAN 15 3 - Loading Weight of Handling Unit
9
MAGEW
- Allowed QUAN 15 3 - Allowed Loading Weight of a Handling Unit
10
TARAG
- Tare wght QUAN 15 3 - Tare weight of handling unit
11
GEWEI
- WeightUnit UNIT 3 - - Weight Unit
12
BTVOL
- Total Vol. QUAN 15 3 - Total Volume of Handling Unit
13
NTVOL
- Load vol. QUAN 15 3 - Loading Volume of Handling Unit
14
MAVOL
- AllowedVol QUAN 15 3 - Allowed Loading Volume for Handling Unit
15
TAVOL
- Tare vol. QUAN 15 3 - Tare volume of handling unit
16
VOLEH
- VolumeUnit UNIT 3 - - Volume unit
17
ANZGL
- Similar INT4 10 - - Number of Similar Packaging Materials
18
ERNAM
- Created CHAR 12 - - Name of Person who Created the Object
19
ERDAT
- On DATS 8 - - Date on Which Record Was Created
20
ERUHR
- Time TIMS 6 - - Entry time
21
AENAM
- By CHAR 12 - - Name of Person Who Changed Object
22
AEDAT
- Chngd DATS 8 - - Changed On
23
AEZET
- TimeOfChng TIMS 6 - - Time last change was made
24
SORTL
- SearchTerm CHAR 10 - - Sort field
25
VEGR1
- HU gr. 1 CHAR 5 - - Handling Unit Group 1 (Freely Definable)
26
VEGR2
- HU gr. 2 CHAR 5 - - Handling Unit Group 2 (Freely Definable)
27
VEGR3
- HU gr. 3 CHAR 5 - - Handling Unit Group 3 (Freely Definable)
28
VEGR4
- HU grp 4 CHAR 5 - - Handling Unit Group 4 (Freely Definable)
29
VEGR5
- HU grp 5 CHAR 5 - - Handling Unit Group 5 (Freely Definable)
30
VHILM
- PackMatls CHAR 18 - - Packaging Materials
31
LAENG
- Length QUAN 13 3 - Length
32
BREIT
- Width QUAN 13 3 - Width
33
HOEHE
- Height QUAN 13 3 - Height
34
MEABM
- Unit UNIT 3 - - Unit of Dimension for Length/Width/Height
35
ERLKZ
- Status CHAR 1 - - Status (at this time without functionality)
36
GEWTO
- ExWghtTol. DEC 3 1 - Excess Weight Tolerance for Handling unit
37
VOLTO
- Ex.vol.tol DEC 3 1 - Excess Volume Tolerance of the Handling Unit
38
MEINS
- Unit UNIT 3 - - Base Unit of Measure
39
VOLEH_MAX
- VolumeUnit UNIT 3 - - Volume unit
40
GEWEI_MAX
- WeightUnit UNIT 3 - - Weight Unit
41
VBELN_GEN
- Gen.deliv. CHAR 10 - - Delivery in Which Packaging Material Is Generated as an Item
42
POSNR_GEN
- Gen.item NUMC 6 - - Generated delivery item
43
INHALT
- Content CHAR 40 - - Description of Handling Unit Content
44
VHART
- PkgMtlType CHAR 4 - - Packaging Material Type
45
KAPPL
- Applicat. CHAR 2 - - Application for output conditions
46
KALSM
- OutDetProc CHAR 6 - - Output determination procedure
47
KSCHL
- OutputType CHAR 4 - - Output Type
48
MAGRV
- Mat.Grp PM CHAR 4 - - Material Group: Packaging Materials
49
WERKS
- Plant CHAR 4 - T001W Plant
50
PSTYV
- Item cat. CHAR 4 - - Sales document item category
51
VKORG
- Sales org. CHAR 4 - - Sales Organization
52
VTWEG
- DChCust/Mt CHAR 2 - - Reference distrib.channel for cust.and material masters
53
LADLG
- LgthLoadPl QUAN 6 - - Lgth of loading platform in lgth of LdPlat measurement units
54
LADEH
- Unit UNIT 3 - - Unit of measure to measure the length of loading platform
55
FARZT
- Travl time QUAN 3 - - Travel Time
56
FAREH
- TravTimeUn UNIT 3 - - Unit of travel time
57
ENTFE
- Distance QUAN 6 - - Distance Travelled
58
EHENT
- UnitofDist UNIT 3 - - Unit of distance
59
LGORT
- Stor. loc. CHAR 4 - T001L Storage Location
60
GEWFX
- Wt/vol.fix CHAR 1 - - Weight and Volume Fixed
61
VELTP
- PackMatCat CHAR 1 - - Packaging Material Category
62
EXIDV2
- ID HU 2 CHAR 20 - - Handling Unit's 2nd External Identification
63
LANDT
- CountryMoT CHAR 3 - - Country providing means of transport
64
LANDF
- Drvr'sNatl CHAR 3 - - Driver's Nationality
65
NAMEF
- Driver CHAR 35 - - Driver name
66
NAMBE
- Alt.Driver CHAR 35 - - Alternate Driver's Name
67
VHILM_KU
- CustPckMat CHAR 35 - - Partner's (Customer's or Vendor's) Packaging Material
68
VPOBJ
- Object CHAR 2 - - Packing Object
69
VPOBJKEY
- Object CHAR 20 - - Key for Object to Which the Handling Unit is Assigned
70
HANDLE
- Handle CHAR 22 - - Worldwide unique key for VEKP-VENUM
71
WMSTA
- Cont.stat. CHAR 1 - - WM status for container material
72
LGNUM
- Whse no. CHAR 3 - - Warehouse Number / Warehouse Complex
73
SAPRL
- Release CHAR 4 - - SAP Release
74
KZGVH
- Closed CHAR 1 - - Packaging Material is Closed Packaging
75
ADGE_DG
- DG-rel. CHAR 1 - - Packing Level is Relevant for Dangerous Goods
76
ADGE_DGPR
- Print rel. CHAR 1 - - Indicator: Packing level is relevant for printing
77
UEVEL
- Hgh.lev.HU CHAR 10 - - Higher-Level Handling Unit
78
PACKVORSCHR
- Pkg instr. CHAR 22 - - Packing instruction
79
PACKVORSCHR_ST
- PStatus CHAR 1 - - Local packing status for a single HU (without sub HUs)
80
LABELTYP
- NoShpLabel CHAR 1 - - Indicator: do not print external shipping label
81
ZUL_AUFL
- Allwd load QUAN 15 3 - Allowed load
82
STATUS
- HU status CHAR 4 - - Handling unit status
83
HU_LGORT
- HU StLoc CHAR 1 - - Content is Located at an HU-managed Storage Location
84
HU_SYSTEM
- HU system CHAR 1 - - HU and IM Stock in Separate Systems
85
SPE_HDALL
- H CHAR 1 - - Inbound delivery header not yet complete (on Hold)
86
SPE_VLSTK
- Stat.Whse CHAR 1 - - Distribution Status (Decentralized Warehouse Processing)
87
SPE_DELDEC
- D CHAR 1 - - Delete indicator for the confirmation of deleted HUs
88
SPE_IDART_01
- HU ID Type CHAR 1 - - Handling Unit Identification Type
89
SPE_IDENT_01
- Alt HU ID CHAR 40 - - Alternative HU Identification
90
SPE_IDART_02
- HU ID Type CHAR 1 - - Handling Unit Identification Type
91
SPE_IDENT_02
- Alt HU ID CHAR 40 - - Alternative HU Identification
92
SPE_IDART_03
- HU ID Type CHAR 1 - - Handling Unit Identification Type
93
SPE_IDENT_03
- Alt HU ID CHAR 40 - - Alternative HU Identification
94
SPE_IDART_04
- HU ID Type CHAR 1 - - Handling Unit Identification Type
95
SPE_IDENT_04
- Alt HU ID CHAR 40 - - Alternative HU Identification
96
SPE_LOGPOS
- Log.Pos CHAR 2 - - Logical Position of Handling Unit
97
SPE_CHK_COUNTER
- Check No NUMC 5 - - Check number for cross-delivery handling units
98
EPC1
- EPC1 CHAR 96 - - Electronic Product Code 1
99
EPC2
- EPC2 CHAR 96 - - Electronic Product Code 2
100
PACKAGE_CAT
- Cat. Pack. CHAR 15 - - Category of Package
101
TRANSP_INDEX
- Trans. Idx DEC 7 2 - Transport Index
102
CRIT_SAF_INDEX
- CrtSftyIdx DEC 7 2 - Criticality Safety Index
103
FLG_DG_PACKAGE
- DG Package CHAR 1 - - Dangerous Goods Package
104
DG_PACKAGE_LEVEL
- DGP Level CHAR 3 - - Level of Dangerous Goods Packaging
105
PACKCODE
- PackCode CHAR 10 - - Actual Packaging Code
106
INSTR_ENCL_CAT
- Encl. Cat. CHAR 15 - - Category of Instruction for Enclosure
107
MAT_DAMAGED_CL7
- Damaged CHAR 1 - - Damaged Material (Class 7)
108
DOSE_RATE_BULK
- Rad (Unpk) QUAN 9 5 - Radiation Level (Unpacked)
109
DOSE_RATE_BULK_U
- RLUn (Unp) UNIT 3 - - Unit of Radiation Level (Unpacked)
110
DOSE_RATE_PACK
- RadL Pckd QUAN 9 5 - Radation Level Packed
111
U_DOSE_RATE_PACK
- UnitRL.Pkd UNIT 3 - - Unit of Radiation Level Packed
112
LEADING_LWDG
- Lead.DGReg CHAR 12 - - Leading Dangerous Goods Regulation
113
MAX_GROSS_WEIGHT
- Max.Gross QUAN 8 2 - Maximum Gross Mass
114
U_MAX_GROSS_WGHT
- Unit UNIT 3 - - Unit for Maximum Gross Mass
115
LYARD
- Yard CHAR 3 - - Yard
116
YLCCL
- Loc Cls CHAR 2 - - Location Class
117
YLOCT
- Location CHAR 10 - - Location
118
STATS
- Status CHAR 2 - - Vehicle Stock Status
119
PRRTY
- Priority CHAR 2 - - Vehicle Priority
120
FWAGN
- Fwd.Agent CHAR 10 - - Forwarding Agent
121
SCACD
- SCAC CHAR 4 - - Standard carrier access code
122
OWNER
- Owner CHAR 10 - - Vehicle Owner
123
TRNPD
- Transp. CHAR 20 - - Transponder
124
SEALN1
- Seal. No. CHAR 10 - - Sealing Number
125
SEALN2
- Seal. No. CHAR 10 - - Sealing Number
126
SEALN3
- Seal. No. CHAR 10 - - Sealing Number
127
SEALN4
- Seal. No. CHAR 10 - - Sealing Number
128
SEALN5
- Seal. No. CHAR 10 - - Sealing Number
129
BLIND
- Blocked CHAR 1 - - Block
130
RSNCD
- Rsn Code CHAR 2 - - Reason Code
131
RFTYP
- Ref.Doc.Tp CHAR 2 - - Reference Document Type
132
REFER
- Ref. Doc. CHAR 10 - - Reference Document
133
PTMST
- Pl.End.Tme DEC 15 - - Planned End Time
134
ATMST
- Act.St.Tme DEC 15 - - Actual Start Time
135
YDOOR
- Door CHAR 3 - - Door
136
YSTGA
- Stage Area CHAR 10 - - Staging Area
137
URGFL
- Urgent CHAR 1 - - Urgent (Relevant for Cross-Docking)
138
PRFLG
- Permanent CHAR 1 - - Permanence of Vehicle in Yard
139
SLFLG
- Sealing CHAR 1 - - Sealing Required
140
SIGNI
- Contnr ID CHAR 20 - - Container ID
141
LTEXT
- Text CHAR 40 - - Text

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk VEKP.

Interactive ERD Diagrams
SAP SD - Shipping Tables Relation → SAP SD Table Mapping & Document Flow →
Standard T-Codes
SE11 SE16
Related Tables
T001W T001L LIKP LIPS VTTP VTTK VBLK VEPO
ANSI SQL Query 
SELECT a.VENUM,
       a.EXIDV,
       a.EXIDA,
       a.VSTEL,
       a.LSTEL,
       a.BRGEW
FROM VEKP AS a
WHERE a.VENUM = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~venum,
       a~exidv,
       a~exida,
       a~vstel,
       a~lstel,
       a~brgew
  FROM vekp AS a
  WHERE a~venum = '0001'
  INTO TABLE @DATA(lt_vekp)
  UP TO 100 ROWS.