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	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

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 :: Logistics Basic Data :: Promotion
1	ERP EHP7	6.0	WAKP	83	2	Promotion Item Data	Promotion

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	AKTNR	Promotion	nvarchar	10	0	Allow NULL?
3	ARTNR	Material Number	nvarchar	18	0	Allow NULL?
4	MEBME	Sales unit	nvarchar	3	0	Allow NULL?
5	AKPOS	Promotion Item Number	nvarchar	6	0	Allow NULL?
6	SATNR	Cross-Plant Configurable Material	nvarchar	18	0	Allow NULL?
7	MATKL	Material Group	nvarchar	9	0	Allow NULL?
8	AKTHE	Promotion theme	nvarchar	4	0	Allow NULL?
9	BZQFI	Supply Source Determination Status	char	1	0	Allow NULL?
10	AKBSP	Item status, listing	char	1	0	Allow NULL?
11	NBPOS	No. of modules with this material as an item	smallint	5	0
12	RESKZ	Check Against Listing Rules/Listing Conditions	char	1	0	Allow NULL?
13	BEKTY	Promotion announcement category	nvarchar	4	0	Allow NULL?
14	SPDAT	Date on which promotion material is blocked for promotion	nvarchar	8	0	Allow NULL?
15	SPGRU	Reason for promotion block	char	1	0	Allow NULL?
16	EKORG	Purchasing Organization	nvarchar	4	0	Allow NULL?
17	EKGRP	Purchasing Group	nvarchar	3	0	Allow NULL?
18	VKORG	Sales Organization	nvarchar	4	0	Allow NULL?
19	VTWEG	Distribution Channel	nvarchar	2	0	Allow NULL?
20	AKLIZ	Planned delivery time for promotional goods	decimal	3	0
21	PUMVP	Promotion Plan Mat. Sales Vol. at Promo. Sales Price	decimal	13	2
22	PUMEP	Promotion plan: mat. sales at PP in sales currency	decimal	13	2
23	PUMEN	Promotion plan: sales volume at purchase price (net/net)	decimal	13	2
24	PABBM	Planned Sales Qty. of Promotion Material in Sales Units	decimal	13	3
25	PABLM	Planned Sales Qty of Promotion Material in Logistics Units	decimal	13	3
26	AUFME	Promotion plan: Material allocation table quantity	decimal	13	3
27	PLVKP	Sales price for promotion item	decimal	11	2
28	VPEIN	Sales price unit	decimal	5	0
29	PLEKP	Purchase price for promotion item	decimal	11	2
30	PLEKN	Basic purchase price: net/net - promotion item	decimal	11	2
31	EPEIN	Price Unit	decimal	5	0
32	WAEEK	Purchase price currency	nvarchar	5	0	Allow NULL?
33	WAELA	Currency current promotion - planning	nvarchar	5	0	Allow NULL?
34	MEINS	Base unit of measure	nvarchar	3	0	Allow NULL?
35	MELOG	Logistics unit	nvarchar	3	0	Allow NULL?
36	MEBPR	Order Price Unit (Purchasing)	nvarchar	3	0	Allow NULL?
37	MEAUF	Allocation table unit	nvarchar	3	0	Allow NULL?
38	RGART	Return type for promotional material	char	1	0	Allow NULL?
39	MIAMG	Minimum order qty for promotional material	decimal	13	3
40	NDISP	Replenishment indicator	nvarchar	2	0	Allow NULL?
41	FBDAT	Earliest Order Date	nvarchar	8	0	Allow NULL?
42	SBDAT	Latest Order Date	nvarchar	8	0	Allow NULL?
43	FLDAT	Earliest delivery date	nvarchar	8	0	Allow NULL?
44	SLDAT	Latest delivery date	nvarchar	8	0	Allow NULL?
45	APSTP	Item category of allocation table	nvarchar	4	0	Allow NULL?
46	BEDAT	Order date with vendor	nvarchar	8	0	Allow NULL?
47	VREGE	Retail Promotion: Allocation Rule Number	nvarchar	10	0	Allow NULL?
48	ABELN	Allocation Table Number	nvarchar	10	0	Allow NULL?
49	ABELP	Item number of allocation table	nvarchar	5	0	Allow NULL?
50	ETIAG	IS-R Labeling: material grouping (deactivated in 4.0)	nvarchar	18	0	Allow NULL?
51	EKKPS	Maintenance status of purchase price conditions	char	1	0	Allow NULL?
52	VKKPS	Maintenance status of sales price conditions	char	1	0	Allow NULL?
53	EKKON	Create purchase price condition records	char	1	0	Allow NULL?
54	VKKON	Create sales price condition records	char	1	0	Allow NULL?
55	ACTIV	No. of successful price activations	tinyint	3	0
56	ERNAM	Name of Person who Created the Object	nvarchar	12	0	Allow NULL?
57	ERDAT	Date on Which Record Was Created	nvarchar	8	0	Allow NULL?
58	AENAM	Name of Person Who Changed Object	nvarchar	12	0	Allow NULL?
59	AEDAT	Changed On	nvarchar	8	0	Allow NULL?
60	ECKPKZ	Indicates whether price point tables should override price	char	1	0	Allow NULL?
61	VZKON	Create DC condition records	char	1	0	Allow NULL?
62	VZKPS	Maintenance status of DC conditions	char	1	0	Allow NULL?
63	EPRGR	Price Point Group, Promotion Item	nvarchar	6	0	Allow NULL?
64	NVKP	Standard sales price	decimal	11	2
65	VK_AKTIV_AB	Sales prices active from	nvarchar	8	0	Allow NULL?
66	VK_AKTIV_BI	Sales price active to	nvarchar	8	0	Allow NULL?
67	BATNR	Allocation material number	nvarchar	18	0	Allow NULL?
68	EKERV	Promotion: Purchase price determination sequence	nvarchar	2	0	Allow NULL?
69	REB_VALUE	Value of Absolute Discount	decimal	11	2
70	REB_PERC	Percentage Discount	decimal	5	2
71	REB_STATUS	Discount Status	char	1	0	Allow NULL?
72	NO_KALK	Price Activation w/o Price Calculation	char	1	0	Allow NULL?
73	ASTRA	Retail Promotion: Allocation Strategy	nvarchar	4	0	Allow NULL?
74	OFFER_TYPE	Offer Type Price	nvarchar	2	0	Allow NULL?
75	OFFER_TYPE_DSC	Offer Type Discount	nvarchar	2	0	Allow NULL?
76	OFFER_ID	Offer ID for Price	nvarchar	36	0	Allow NULL?
77	OFFER_ID_DSC	Offer ID for Discount	nvarchar	36	0	Allow NULL?
78	OFFER_PRDGRP	Product Group in Offer (Price)	nvarchar	3	0	Allow NULL?
79	OFFER_PRDGRP_DSC	Product Group in Offer (Discount)	nvarchar	3	0	Allow NULL?
80	ITEM_CREAT_INDIC	Promotion Item Indicator for Transferred Materials	char	1	0	Allow NULL?
81	PABBM_OFFER_PRC	Planned sales qty in sales units for material in price offer	decimal	13	3
82	PABBM_OFFER_DSC	Planned sales qty in sales units of material in discnt offer	decimal	13	3
83	ASTRA_VAR	Allocation Strategy Variant	nvarchar	14	0	Allow NULL?

Name	Primary	Unique	Type	Columns
WAKP~0	Yes	Yes	CLUSTERED	MANDT, AKTNR, ARTNR, MEBME
WAKP~IN1	No	No	NONCLUSTERED	MANDT, ARTNR, MEBME

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

83 COLUMNS | 2 INDEXES | ERP 6.0 | WAKP TABLE

TOP ERP 6.0 | WAKP COLUMNS

TOP ERP 6.0 | WAKP 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

83 COLUMNS | 2 INDEXES | ERP 6.0 | WAKP TABLE

TOPERP 6.0 | WAKP COLUMNS

TOPERP 6.0 | WAKP INDEXES

TOP ERP 6.0 | WAKP COLUMNS

TOP ERP 6.0 | WAKP INDEXES