ERP 6.0: Top 10 requests

	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

B1 8.8: Top 10 requests

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Logistics - General :: Handling Unit Management :: Basic functions
1	ERP EHP7	6.0	VEKP	141	4	Handling Unit - Header Table	Basic functions

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	VENUM	Internal Handling Unit Number	nvarchar	10	0	Allow NULL?
3	EXIDV	External Handling Unit Identification	nvarchar	20	0	Allow NULL?
4	EXIDA	Type of External Handling Unit Identifier	char	1	0	Allow NULL?
5	VSTEL	Shipping Point/Receiving Point	nvarchar	4	0	Allow NULL?
6	LSTEL	Loading Point	nvarchar	2	0	Allow NULL?
7	BRGEW	Total Weight of Handling Unit	decimal	15	3
8	NTGEW	Loading Weight of Handling Unit	decimal	15	3
9	MAGEW	Allowed Loading Weight of a Handling Unit	decimal	15	3
10	TARAG	Tare weight of handling unit	decimal	15	3
11	GEWEI	Weight Unit	nvarchar	3	0	Allow NULL?
12	BTVOL	Total Volume of Handling Unit	decimal	15	3
13	NTVOL	Loading Volume of Handling Unit	decimal	15	3
14	MAVOL	Allowed Loading Volume for Handling Unit	decimal	15	3
15	TAVOL	Tare volume of handling unit	decimal	15	3
16	VOLEH	Volume unit	nvarchar	3	0	Allow NULL?
17	ANZGL	Number of Similar Packaging Materials	int	10	0	Allow NULL?
18	ERNAM	Name of Person who Created the Object	nvarchar	12	0	Allow NULL?
19	ERDAT	Date on Which Record Was Created	nvarchar	8	0	Allow NULL?
20	ERUHR	Entry time	nvarchar	6	0	Allow NULL?
21	AENAM	Name of Person Who Changed Object	nvarchar	12	0	Allow NULL?
22	AEDAT	Changed On	nvarchar	8	0	Allow NULL?
23	AEZET	Time last change was made	nvarchar	6	0	Allow NULL?
24	SORTL	Sort field	nvarchar	10	0	Allow NULL?
25	VEGR1	Handling Unit Group 1 (Freely Definable)	nvarchar	5	0	Allow NULL?
26	VEGR2	Handling Unit Group 2 (Freely Definable)	nvarchar	5	0	Allow NULL?
27	VEGR3	Handling Unit Group 3 (Freely Definable)	nvarchar	5	0	Allow NULL?
28	VEGR4	Handling Unit Group 4 (Freely Definable)	nvarchar	5	0	Allow NULL?
29	VEGR5	Handling Unit Group 5 (Freely Definable)	nvarchar	5	0	Allow NULL?
30	VHILM	Packaging Materials	nvarchar	18	0	Allow NULL?
31	LAENG	Length	decimal	13	3
32	BREIT	Width	decimal	13	3
33	HOEHE	Height	decimal	13	3
34	MEABM	Unit of Dimension for Length/Width/Height	nvarchar	3	0	Allow NULL?
35	ERLKZ	Status (at this time without functionality)	char	1	0	Allow NULL?
36	GEWTO	Excess Weight Tolerance for Handling unit	decimal	3	1
37	VOLTO	Excess Volume Tolerance of the Handling Unit	decimal	3	1
38	MEINS	Base Unit of Measure	nvarchar	3	0	Allow NULL?
39	VOLEH_MAX	Volume unit	nvarchar	3	0	Allow NULL?
40	GEWEI_MAX	Weight Unit	nvarchar	3	0	Allow NULL?
41	VBELN_GEN	Delivery in Which Packaging Material Is Generated as an Item	nvarchar	10	0	Allow NULL?
42	POSNR_GEN	Generated delivery item	nvarchar	6	0	Allow NULL?
43	INHALT	Description of Handling Unit Content	nvarchar	40	0	Allow NULL?
44	VHART	Packaging Material Type	nvarchar	4	0	Allow NULL?
45	KAPPL	Application for output conditions	nvarchar	2	0	Allow NULL?
46	KALSM	Output determination procedure	nvarchar	6	0	Allow NULL?
47	KSCHL	Output Type	nvarchar	4	0	Allow NULL?
48	MAGRV	Material Group: Packaging Materials	nvarchar	4	0	Allow NULL?
49	WERKS	Plant	nvarchar	4	0	Allow NULL?
50	PSTYV	Sales document item category	nvarchar	4	0	Allow NULL?
51	VKORG	Sales Organization	nvarchar	4	0	Allow NULL?
52	VTWEG	Reference distrib.channel for cust.and material masters	nvarchar	2	0	Allow NULL?
53	LADLG	Lgth of loading platform in lgth of LdPlat measurement units	decimal	6	0
54	LADEH	Unit of measure to measure the length of loading platform	nvarchar	3	0	Allow NULL?
55	FARZT	Travel Time	decimal	3	0
56	FAREH	Unit of travel time	nvarchar	3	0	Allow NULL?
57	ENTFE	Distance Travelled	decimal	6	0
58	EHENT	Unit of distance	nvarchar	3	0	Allow NULL?
59	LGORT	Storage Location	nvarchar	4	0	Allow NULL?
60	GEWFX	Weight and Volume Fixed	char	1	0	Allow NULL?
61	VELTP	Packaging Material Category	char	1	0	Allow NULL?
62	EXIDV2	Handling Unit's 2nd External Identification	nvarchar	20	0	Allow NULL?
63	LANDT	Country providing means of transport	nvarchar	3	0	Allow NULL?
64	LANDF	Driver's Nationality	nvarchar	3	0	Allow NULL?
65	NAMEF	Driver name	nvarchar	35	0	Allow NULL?
66	NAMBE	Alternate Driver's Name	nvarchar	35	0	Allow NULL?
67	VHILM_KU	Partner's (Customer's or Vendor's) Packaging Material	nvarchar	35	0	Allow NULL?
68	VPOBJ	Packing Object	nvarchar	2	0	Allow NULL?
69	VPOBJKEY	Key for Object to Which the Handling Unit is Assigned	nvarchar	20	0	Allow NULL?
70	HANDLE	Worldwide unique key for VEKP-VENUM	nvarchar	22	0	Allow NULL?
71	WMSTA	WM status for container material	char	1	0	Allow NULL?
72	LGNUM	Warehouse Number / Warehouse Complex	nvarchar	3	0	Allow NULL?
73	SAPRL	SAP Release	nvarchar	4	0	Allow NULL?
74	KZGVH	Packaging Material is Closed Packaging	char	1	0	Allow NULL?
75	ADGE_DG	Packing Level is Relevant for Dangerous Goods	char	1	0	Allow NULL?
76	ADGE_DGPR	Indicator: Packing level is relevant for printing	char	1	0	Allow NULL?
77	UEVEL	Higher-Level Handling Unit	nvarchar	10	0	Allow NULL?
78	PACKVORSCHR	Packing instruction	nvarchar	22	0	Allow NULL?
79	PACKVORSCHR_ST	Local packing status for a single HU (without sub HUs)	char	1	0	Allow NULL?
80	LABELTYP	Indicator: do not print external shipping label	char	1	0	Allow NULL?
81	ZUL_AUFL	Allowed load	decimal	15	3
82	STATUS	Handling unit status	nvarchar	4	0	Allow NULL?
83	HU_LGORT	Content is Located at an HU-managed Storage Location	char	1	0	Allow NULL?
84	HU_SYSTEM	HU and IM Stock in Separate Systems	char	1	0	Allow NULL?
85	SPE_HDALL	Inbound delivery header not yet complete (on Hold)	char	1	0	Allow NULL?
86	SPE_VLSTK	Distribution Status (Decentralized Warehouse Processing)	char	1	0	Allow NULL?
87	SPE_DELDEC	Delete indicator for the confirmation of deleted HUs	char	1	0	Allow NULL?
88	SPE_IDART_01	Handling Unit Identification Type	char	1	0	Allow NULL?
89	SPE_IDENT_01	Alternative HU Identification	nvarchar	40	0	Allow NULL?
90	SPE_IDART_02	Handling Unit Identification Type	char	1	0	Allow NULL?
91	SPE_IDENT_02	Alternative HU Identification	nvarchar	40	0	Allow NULL?
92	SPE_IDART_03	Handling Unit Identification Type	char	1	0	Allow NULL?
93	SPE_IDENT_03	Alternative HU Identification	nvarchar	40	0	Allow NULL?
94	SPE_IDART_04	Handling Unit Identification Type	char	1	0	Allow NULL?
95	SPE_IDENT_04	Alternative HU Identification	nvarchar	40	0	Allow NULL?
96	SPE_LOGPOS	Logical Position of Handling Unit	nvarchar	2	0	Allow NULL?
97	SPE_CHK_COUNTER	Check number for cross-delivery handling units	nvarchar	5	0	Allow NULL?
98	EPC1	Electronic Product Code 1	nvarchar	96	0	Allow NULL?
99	EPC2	Electronic Product Code 2	nvarchar	96	0	Allow NULL?
100	PACKAGE_CAT	Category of Package	nvarchar	15	0	Allow NULL?
101	TRANSP_INDEX	Transport Index	decimal	7	2
102	CRIT_SAF_INDEX	Criticality Safety Index	decimal	7	2
103	FLG_DG_PACKAGE	Dangerous Goods Package	char	1	0	Allow NULL?
104	DG_PACKAGE_LEVEL	Level of Dangerous Goods Packaging	nvarchar	3	0	Allow NULL?
105	PACKCODE	Actual Packaging Code	nvarchar	10	0	Allow NULL?
106	INSTR_ENCL_CAT	Category of Instruction for Enclosure	nvarchar	15	0	Allow NULL?
107	MAT_DAMAGED_CL7	Damaged Material (Class 7)	char	1	0	Allow NULL?
108	DOSE_RATE_BULK	Radiation Level (Unpacked)	decimal	9	5
109	DOSE_RATE_BULK_U	Unit of Radiation Level (Unpacked)	nvarchar	3	0	Allow NULL?
110	DOSE_RATE_PACK	Radation Level Packed	decimal	9	5
111	U_DOSE_RATE_PACK	Unit of Radiation Level Packed	nvarchar	3	0	Allow NULL?
112	LEADING_LWDG	Leading Dangerous Goods Regulation	nvarchar	12	0	Allow NULL?
113	MAX_GROSS_WEIGHT	Maximum Gross Mass	decimal	8	2
114	U_MAX_GROSS_WGHT	Unit for Maximum Gross Mass	nvarchar	3	0	Allow NULL?
115	LYARD	Yard	nvarchar	3	0	Allow NULL?
116	YLCCL	Location Class	nvarchar	2	0	Allow NULL?
117	YLOCT	Location	nvarchar	10	0	Allow NULL?
118	STATS	Vehicle Stock Status	nvarchar	2	0	Allow NULL?
119	PRRTY	Vehicle Priority	nvarchar	2	0	Allow NULL?
120	FWAGN	Forwarding Agent	nvarchar	10	0	Allow NULL?
121	SCACD	Standard carrier access code	nvarchar	4	0	Allow NULL?
122	OWNER	Vehicle Owner	nvarchar	10	0	Allow NULL?
123	TRNPD	Transponder	nvarchar	20	0	Allow NULL?
124	SEALN1	Sealing Number	nvarchar	10	0	Allow NULL?
125	SEALN2	Sealing Number	nvarchar	10	0	Allow NULL?
126	SEALN3	Sealing Number	nvarchar	10	0	Allow NULL?
127	SEALN4	Sealing Number	nvarchar	10	0	Allow NULL?
128	SEALN5	Sealing Number	nvarchar	10	0	Allow NULL?
129	BLIND	Block	char	1	0	Allow NULL?
130	RSNCD	Reason Code	nvarchar	2	0	Allow NULL?
131	RFTYP	Reference Document Type	nvarchar	2	0	Allow NULL?
132	REFER	Reference Document	nvarchar	10	0	Allow NULL?
133	PTMST	Planned End Time	decimal	15	0
134	ATMST	Actual Start Time	decimal	15	0
135	YDOOR	Door	nvarchar	3	0	Allow NULL?
136	YSTGA	Staging Area	nvarchar	10	0	Allow NULL?
137	URGFL	Urgent (Relevant for Cross-Docking)	char	1	0	Allow NULL?
138	PRFLG	Permanence of Vehicle in Yard	char	1	0	Allow NULL?
139	SLFLG	Sealing Required	char	1	0	Allow NULL?
140	SIGNI	Container ID	nvarchar	20	0	Allow NULL?
141	LTEXT	Text	nvarchar	40	0	Allow NULL?

Name	Primary	Unique	Type	Columns
VEKP~0	Yes	Yes	CLUSTERED	MANDT, VENUM
VEKP~001	No	No	NONCLUSTERED	MANDT, HANDLE
VEKP~B	No	No	NONCLUSTERED	MANDT, VPOBJ, VPOBJKEY
VEKP~C	No	No	NONCLUSTERED	MANDT, EXIDV

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

141 COLUMNS | 4 INDEXES | ERP 6.0 | VEKP TABLE

TOP ERP 6.0 | VEKP COLUMNS

TOP ERP 6.0 | VEKP INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

141 COLUMNS | 4 INDEXES | ERP 6.0 | VEKP TABLE

TOPERP 6.0 | VEKP COLUMNS

TOPERP 6.0 | VEKP INDEXES

TOP ERP 6.0 | VEKP COLUMNS

TOP ERP 6.0 | VEKP INDEXES