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	TWAA	52	1	Promotion Type, IS-R	Promotion

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	AKART	Promotion Type	nvarchar	4	Allow NULL?
3	AKTYP	Promotion Category	nvarchar	4	Allow NULL?
4	VKONB	Validity of purch. cond. lead time before promotion start	nvarchar	3	Allow NULL?
5	VKONE	Follow-on time of purchasing conditions after promotion end	nvarchar	3	Allow NULL?
6	EKKON	Create purchase price condition records	char	1	Allow NULL?
7	VKKON	Create sales price condition records	char	1	Allow NULL?
8	VLISB	Leadtime listing	nvarchar	3	Allow NULL?
9	VLISE	Listing follow-up time	nvarchar	3	Allow NULL?
10	VBEKB	Lead time, announcement of promotion start	nvarchar	3	Allow NULL?
11	VWEFI	Lead time goods receipt in store before start of promotion	nvarchar	3	Allow NULL?
12	NUMKI	Number range in the case of internal number assignment	nvarchar	2	Allow NULL?
13	NUMKE	Number range in the case of external number assignment	nvarchar	2	Allow NULL?
14	KOBOG	Group of condition types/tables for purchasing conditions	nvarchar	4	Allow NULL?
15	KOPGR	Screen sequence group for document header & item	nvarchar	4	Allow NULL?
16	FELDK	Field selection group for document header	nvarchar	4	Allow NULL?
17	AUFAR	Allocation Table Type	nvarchar	4	Allow NULL?
18	BEKTY	Promotion announcement category	nvarchar	4	Allow NULL?
19	KAPPL	Application for output conditions	nvarchar	2	Allow NULL?
20	KSBEK	Message Schema	nvarchar	6	Allow NULL?
21	KOBVK	Group of condition types/tables for sales price conditions	nvarchar	4	Allow NULL?
22	SPVKO	Sales Organization for Suggested Sales Price	nvarchar	4	Allow NULL?
23	SPVTW	Distribution Channel for Suggested Sales Price	nvarchar	2	Allow NULL?
24	SPKNR	Plant-Based Customer no. for Suggested Sales Price	nvarchar	10	Allow NULL?
25	LIGRU	List group	char	1	Allow NULL?
26	KALKE	Activation type for sales prices	char	1	Allow NULL?
27	VZKON	Create DC condition records	char	1	Allow NULL?
28	LIVAR	List variant for sales price calculation	nvarchar	2	Allow NULL?
29	EKERV	Promotion: Purchase price determination sequence	nvarchar	2	Allow NULL?
30	KSCHL_PERC	Condition Type Percentage Discount	nvarchar	4	Allow NULL?
31	KSCHL_VAL	Condition Type Absolute Discount	nvarchar	4	Allow NULL?
32	NO_KALK	Price Activation w/o Price Calculation	char	1	Allow NULL?
33	LCHECK	Check Against Listing Rules/Listing Conditions	char	1	Allow NULL?
34	SPPLT	Price List of Default Sales Price	nvarchar	2	Allow NULL?
35	FIELDCAT	Archive Information System Field Catalog	nvarchar	15	Allow NULL?
36	MEDIA_TYPE	Media Type	nvarchar	4	Allow NULL?
37	CUSTOMER_TYPE	Customer Type	nvarchar	4	Allow NULL?
38	FORMTYPE	Form Type	char	1	Allow NULL?
39	WAELA	Currency current promotion - planning	nvarchar	5	Allow NULL?
40	ALLOW_PMAT_IGNO	Variant Price Allowed (for Promotion Type)	char	1	Allow NULL?
41	ITEMS_4_BBY	Control of Subsequent Processing of Bonus Buy Materials	char	1	Allow NULL?
42	ALLOW_DISP_MAT	Addition of Display Materials Allowed	char	1	Allow NULL?
43	INIT_SLS_PRICE	Allow Initial Sales Price in Price Activation	char	1	Allow NULL?
44	XPROMOTION_MEDIA	IS-M: Allowed Promotion Types for Contract Interface	char	1	Allow NULL?
45	DUELI	Leadtime Listing Due	nvarchar	3	Allow NULL?
46	DUEPP	Leadtime Purchase Price Activation Due	nvarchar	3	Allow NULL?
47	DUESP	Leadtime Sales Price Activation Due	nvarchar	3	Allow NULL?
48	ODUSP	Leadtime Sales Price Activation	nvarchar	3	Allow NULL?
49	DUEAL	Leadtime Allocation Table Generation Due	nvarchar	3	Allow NULL?
50	ODUAL	Leadtime Allocation Table Generation	nvarchar	3	Allow NULL?
51	ODUAN	Leadtime Annoucement Overdue	nvarchar	3	Allow NULL?
52	BPROF	Bonus Buy: Bonus buy profile	nvarchar	4	Allow NULL?

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

52 COLUMNS | 1 INDEXES | ERP 6.0 | TWAA TABLE

TOP ERP 6.0 | TWAA COLUMNS

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

52 COLUMNS | 1 INDEXES | ERP 6.0 | TWAA TABLE

TOPERP 6.0 | TWAA COLUMNS

TOPERP 6.0 | TWAA INDEXES

TOP ERP 6.0 | TWAA COLUMNS

TOP ERP 6.0 | TWAA INDEXES