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
Cross-Application Components
1	ERP EHP7	6.0	VVBKD	70	3	Sales Document: Business Data	Cross-Application Components

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	VBELN	Sales and Distribution Document Number	nvarchar	10	0	Allow NULL?
3	POSNR	Item number of the SD document	nvarchar	6	0	Allow NULL?
4	KONDA	Price group (customer)	nvarchar	2	0	Allow NULL?
5	KDGRP	Customer group	nvarchar	2	0	Allow NULL?
6	BZIRK	Sales district	nvarchar	6	0	Allow NULL?
7	PLTYP	Price list type	nvarchar	2	0	Allow NULL?
8	INCO1	Incoterms (Part 1)	nvarchar	3	0	Allow NULL?
9	INCO2	Incoterms (Part 2)	nvarchar	28	0	Allow NULL?
10	KZAZU	Order Combination Indicator	char	1	0	Allow NULL?
11	PERFK	Invoice dates (calendar identification)	nvarchar	2	0	Allow NULL?
12	PERRL	Invoice list schedule (calendar identification)	nvarchar	2	0	Allow NULL?
13	MRNKZ	Manual invoice maintenance	char	1	0	Allow NULL?
14	KURRF	Exchange rate for FI postings	decimal	9	5
15	VALTG	Additional value days	nvarchar	2	0	Allow NULL?
16	VALDT	Fixed value date	nvarchar	8	0	Allow NULL?
17	ZTERM	Terms of Payment Key	nvarchar	4	0	Allow NULL?
18	ZLSCH	Payment Method	char	1	0	Allow NULL?
19	KTGRD	Account assignment group for this customer	nvarchar	2	0	Allow NULL?
20	KURSK	Exchange Rate for Price Determination	decimal	9	5
21	PRSDT	Date for pricing and exchange rate	nvarchar	8	0	Allow NULL?
22	FKDAT	Billing date for billing index and printout	nvarchar	8	0	Allow NULL?
23	FBUDA	Date on which services rendered	nvarchar	8	0	Allow NULL?
24	GJAHR	Fiscal Year	nvarchar	4	0	Allow NULL?
25	POPER	Posting period	nvarchar	3	0	Allow NULL?
26	STCUR	Exchange rate for statistics	decimal	9	5
27	MSCHL	Dunning key	char	1	0	Allow NULL?
28	MANSP	Dunning block	char	1	0	Allow NULL?
29	FPLNR	Billing plan number / invoicing plan number	nvarchar	10	0	Allow NULL?
30	WAKTION	Promotion	nvarchar	10	0	Allow NULL?
31	ABSSC	Payment guarantee procedure	nvarchar	6	0	Allow NULL?
32	LCNUM	Financial doc. processing: Internal financial doc. number	nvarchar	10	0	Allow NULL?
33	J_1AFITP	Tax type	nvarchar	2	0	Allow NULL?
34	J_1ARFZ	Reason for zero VAT	char	1	0	Allow NULL?
35	J_1AREGIO	Region (State, Province, County)	nvarchar	3	0	Allow NULL?
36	J_1AGICD	Activity Code for Gross Income Tax	nvarchar	2	0	Allow NULL?
37	J_1ADTYP	Distribution Type for Employment Tax	nvarchar	2	0	Allow NULL?
38	J_1ATXREL	Tax relevant classification	nvarchar	10	0	Allow NULL?
39	ABTNR	Department number	nvarchar	4	0	Allow NULL?
40	EMPST	Receiving point	nvarchar	25	0	Allow NULL?
41	BSTKD	Customer purchase order number	nvarchar	35	0	Allow NULL?
42	BSTDK	Customer purchase order date	nvarchar	8	0	Allow NULL?
43	BSARK	Customer purchase order type	nvarchar	4	0	Allow NULL?
44	IHREZ	Your Reference	nvarchar	12	0	Allow NULL?
45	BSTKD_E	Ship-to Party's Purchase Order Number	nvarchar	35	0	Allow NULL?
46	BSTDK_E	Ship-to party's PO date	nvarchar	8	0	Allow NULL?
47	BSARK_E	Ship-to party purchase order type	nvarchar	4	0	Allow NULL?
48	IHREZ_E	Ship-to party character	nvarchar	12	0	Allow NULL?
49	POSEX_E	Item Number of the Underlying Purchase Order	nvarchar	6	0	Allow NULL?
50	KURSK_DAT	Translation Date	nvarchar	8	0	Allow NULL?
51	KURRF_DAT	Translation Date	nvarchar	8	0	Allow NULL?
52	KDKG1	Customer condition group 1	nvarchar	2	0	Allow NULL?
53	KDKG2	Customer condition group 2	nvarchar	2	0	Allow NULL?
54	KDKG3	Customer condition group 3	nvarchar	2	0	Allow NULL?
55	KDKG4	Customer condition group 4	nvarchar	2	0	Allow NULL?
56	KDKG5	Customer condition group 5	nvarchar	2	0	Allow NULL?
57	WKWAE	Value contract currency	nvarchar	5	0	Allow NULL?
58	WKKUR	Exchange rate in value contract currency	decimal	9	5
59	AKWAE	Currency key for letter-of-credit procg in foreign trade	nvarchar	5	0	Allow NULL?
60	AKKUR	Exchange rate for letter-of-credit procg in foreign trade	decimal	9	5
61	AKPRZ	Depreciation percentage for financial document processing	decimal	5	2
62	J_1AINDXP	Inflation Index	nvarchar	5	0	Allow NULL?
63	J_1AIDATEP	Indexing base date	nvarchar	8	0	Allow NULL?
64	BSTKD_M	Customer PO number as matchcode field	nvarchar	35	0	Allow NULL?
65	DELCO	Agreed delivery time	nvarchar	3	0	Allow NULL?
66	FFPRF	Dynamic Item Processor Profile	nvarchar	8	0	Allow NULL?
67	BEMOT	Accounting Indicator	nvarchar	2	0	Allow NULL?
68	FAKTF	Billing form	nvarchar	2	0	Allow NULL?
69	RRREL	Revenue recognition category	char	1	0	Allow NULL?
70	ACDATV	Proposed start date for accrual period	char	1	0	Allow NULL?

Name	Primary	Unique	Type	Columns
VVBKD~0	Yes	Yes	CLUSTERED	MANDT, VBELN, POSNR
VVBKD~BST	No	No	NONCLUSTERED	MANDT, BSTKD_M
VVBKD~LOC	No	No	NONCLUSTERED	MANDT, LCNUM

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

70 COLUMNS | 3 INDEXES | ERP 6.0 | VVBKD TABLE

TOP ERP 6.0 | VVBKD COLUMNS

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

70 COLUMNS | 3 INDEXES | ERP 6.0 | VVBKD TABLE

TOPERP 6.0 | VVBKD COLUMNS

TOPERP 6.0 | VVBKD INDEXES

TOP ERP 6.0 | VVBKD COLUMNS

TOP ERP 6.0 | VVBKD INDEXES