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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Services :: CollectionsDisbursements
1	ERP EHP7	6.0	VVKKFOPT	72	1	Table for FS-CD Test Data of Structure VKKKFOP	CollectionsDisbursements

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	GSFNR	Business Transaction Number	nvarchar	16	CHAR	(N' ')	No		GSFNR_VK	Allow NULL?
3	BELNR	Transfer Document Number	nvarchar	6	CHAR	(N' ')	No		BELNR_VK	Allow NULL?
4	LFDNB	Seq. Number - Single Document	nvarchar	3	NUMC	(N'000')	No		LFDNB_VK	Allow NULL?
5	BETRW	Posting Amount with +/- Sign in CHAR Format	nvarchar	27	CHAR	(N' ')	Yes		BETRG_VKC	Allow NULL?
6	BUGRD	Posting Reason	nvarchar	3	NUMC	(N'000')	Yes	*	BUGRD_VK	Allow NULL?
7	HVORG	Main Transaction for Line Item	nvarchar	4	CHAR	(N' ')	Yes	*	HVORG_KK	Allow NULL?
8	TVORG	Subtransaction for Document Item	nvarchar	4	CHAR	(N' ')	Yes	*	TVORG_KK	Allow NULL?
9	OPHVORG	Main Transaction for Line Item	nvarchar	4	CHAR	(N' ')	Yes	*	HVORG_KK	Allow NULL?
10	OPTVORG	Subtransaction for Document Item	nvarchar	4	CHAR	(N' ')	Yes	*	TVORG_KK	Allow NULL?
11	FAEDN	Due date for net payment	nvarchar	8	DATS	(N'00000000')	Yes		FAEDN_KK	Allow NULL?
12	FAEDS	Due Date for Cash Discount	nvarchar	8	DATS	(N'00000000')	Yes		FAEDS_KK	Allow NULL?
13	FOKNZ	Subledger Item Indicator	char	1	CHAR	(N' ')	Yes		FOKNZ_VK	Allow NULL?
14	BUKRS	Company Code	nvarchar	4	CHAR	(N' ')	Yes	*	BUKRS	Allow NULL?
15	GSBER	Business Area	nvarchar	4	CHAR	(N' ')	Yes	*	GSBER	Allow NULL?
16	LNDSL	Country Key	nvarchar	3	CHAR	(N' ')	Yes	*	LAND1	Allow NULL?
17	PRGRP	Product Group	nvarchar	2	CHAR	(N' ')	Yes	*	PRGRP_VK	Allow NULL?
18	VKONT	Contract Account	nvarchar	12	CHAR	(N' ')	Yes	*	VKONT_VK	Allow NULL?
19	GPART	Business Partner	nvarchar	10	CHAR	(N' ')	Yes	*	GPART_VK	Allow NULL?
20	EMGPA	Alternative Business Partner for Payments	nvarchar	10	CHAR	(N' ')	Yes	*	EMGPA_KK	Allow NULL?
21	EMADE	Address number in external system	nvarchar	20	CHAR	(N' ')	Yes		BU_ADEXT	Allow NULL?
22	EMBVT	Bank Details ID of Payee	nvarchar	4	CHAR	(N' ')	Yes		EMBVT_KK	Allow NULL?
23	SPZAH	Lock Reason for Automatic Payment	char	1	CHAR	(N' ')	Yes	TFK008	SPZAH_KK	Allow NULL?
24	SPZFD	Payment Lock Valid from	nvarchar	8	DATS	(N'00000000')	Yes		SPZFD_VK	Allow NULL?
25	SPZTD	Payment lock valid to	nvarchar	8	DATS	(N'00000000')	Yes		SPZTD_VK	Allow NULL?
26	PYMET	Payment Method	char	1	CHAR	(N' ')	Yes	*	PYMET_KK	Allow NULL?
27	PYGRP	Grouping field for automatic payments	nvarchar	10	CHAR	(N' ')	Yes		PYGRP_KK	Allow NULL?
28	INDYN	Key for Index/Dynamic Basis of an Insurance Contract	nvarchar	5	CHAR	(N' ')	Yes		INDYN_VK	Allow NULL?
29	INFAK	Index Value or Dynamic Factor in CHAR Format	nvarchar	17	CHAR	(N' ')	Yes		INFAK_VKC	Allow NULL?
30	RBART	Legal Relationship Type	nvarchar	2	CHAR	(N' ')	Yes	*	RBART_VK	Allow NULL?
31	VTREF	Reference Specifications from Contract	nvarchar	20	CHAR	(N' ')	Yes		VTREF_KK	Allow NULL?
32	VTRE2	Additional Reference Information	nvarchar	20	CHAR	(N' ')	Yes		VTRE2_KK	Allow NULL?
33	VTRE3	Supplementary contract number	nvarchar	20	CHAR	(N' ')	Yes		VTREF_VK	Allow NULL?
34	VGPART2	Business Partner Number	nvarchar	10	CHAR	(N' ')	Yes	*	GPART_KK	Allow NULL?
35	VGPART3	Business Partner Number	nvarchar	10	CHAR	(N' ')	Yes	*	GPART_KK	Allow NULL?
36	STAKZ	Type of statistical item	char	1	CHAR	(N' ')	Yes		STAKZ_KK	Allow NULL?
37	SKTPZ	Cash discount percentage rate	nvarchar	11	CHAR	(N' ')	Yes		SKTPZ_VKC	Allow NULL?
38	STPRZ	Insurance tax percentage in CHAR format	nvarchar	11	CHAR	(N' ')	Yes		STPRZ_VKC	Allow NULL?
39	GRKEY	Grouping Key for Displaying Open Items	nvarchar	3	CHAR	(N' ')	Yes		GRKEY_KK	Allow NULL?
40	VERKZ	Item Can Only Be Cleared	char	1	CHAR	(N' ')	Yes		VERKZ_KK	Allow NULL?
41	BEWAR	Transaction Type	nvarchar	3	CHAR	(N' ')	Yes	*	RMVCT	Allow NULL?
42	VSARL_VX	Insurance Type	nvarchar	6	CHAR	(N' ')	Yes	*	VSARL_VX	Allow NULL?
43	KOSTL	Cost Center	nvarchar	10	CHAR	(N' ')	Yes	*	KOSTL	Allow NULL?
44	PRCTR	Profit Center	nvarchar	10	CHAR	(N' ')	Yes	*	PRCTR	Allow NULL?
45	ADKNZ	Additional Acct Assignments in BP Items as Well	char	1	CHAR	(N' ')	Yes		ADKNZ_VK	Allow NULL?
46	OPTXT	Item text	nvarchar	50	CHAR	(N' ')	Yes		OPTXT_KK	Allow NULL?
47	FDGRP	Planning Group	nvarchar	10	CHAR	(N' ')	Yes	*	FDGRP_KK	Allow NULL?
48	FDZTG	Additional Days for Cash Management	nvarchar	2	NUMC	(N'00')	Yes		FDZTG_KK	Allow NULL?
49	WWI00	Version Number Component	nvarchar	2	CHAR	(N' ')	Yes		CHAR2	Allow NULL?
50	WWI01	Version Number Component	nvarchar	2	CHAR	(N' ')	Yes		CHAR2	Allow NULL?
51	WWI02	R/2 table	nvarchar	5	CHAR	(N' ')	Yes		CHAR5	Allow NULL?
52	WWI10	Version Number Component	nvarchar	2	CHAR	(N' ')	Yes		CHAR2	Allow NULL?
53	WWI11	3-Byte field	nvarchar	3	CHAR	(N' ')	Yes		CHAR3	Allow NULL?
54	WWI12	R/2 table	nvarchar	5	CHAR	(N' ')	Yes		CHAR5	Allow NULL?
55	WWI13	Character field, 8 characters long	nvarchar	8	CHAR	(N' ')	Yes		CHAR8	Allow NULL?
56	WWI20	Version Number Component	nvarchar	2	CHAR	(N' ')	Yes		CHAR2	Allow NULL?
57	WWI30	Version Number Component	nvarchar	2	CHAR	(N' ')	Yes		CHAR2	Allow NULL?
58	WWI40	Character Field Length = 10	nvarchar	10	CHAR	(N' ')	Yes		CHAR10	Allow NULL?
59	WWI50	Field length 18	nvarchar	18	CHAR	(N' ')	Yes		CHAR18	Allow NULL?
60	LNDSL_VX	Country Where Risk Is Situated	nvarchar	3	CHAR	(N' ')	Yes	TLXXLSL	LNDSL_VX	Allow NULL?
61	GSART_VX	Business Transaction Type	nvarchar	2	CHAR	(N' ')	Yes	TLXXGSA	GSART_VX	Allow NULL?
62	BSART_VX	In-Force Business Type	nvarchar	2	CHAR	(N' ')	Yes	TLXXBSA	BSART_VX	Allow NULL?
63	GZART_VX	Underwriting Type	nvarchar	2	CHAR	(N' ')	Yes	TLXXGZA	GZART_VX	Allow NULL?
64	SDART_VX	Type of Loss	nvarchar	2	CHAR	(N' ')	Yes	TLXXSDA	SDART_VX	Allow NULL?
65	SJAHR_VX	Year of loss	nvarchar	4	CHAR	(N' ')	Yes		SJAHR_VX	Allow NULL?
66	MJAHR_VX	Reporting Year	nvarchar	4	CHAR	(N' ')	Yes		MJAHR_VX	Allow NULL?
67	RSART_VX	Risk type	nvarchar	2	CHAR	(N' ')	Yes	TLXXRSA	RSART_VX	Allow NULL?
68	FUBER_VX	Insurance Functional Area	nvarchar	3	CHAR	(N' ')	Yes	TLXXFUB	FUBER_VX	Allow NULL?
69	BEBER_VX	Organizational area - insurance	nvarchar	3	CHAR	(N' ')	Yes	TLXXBEB	BEBER_VX	Allow NULL?
70	BSGRP_VX	In-Force Business Group for Pension Funds and Life Insurance	nvarchar	3	CHAR	(N' ')	Yes	TLXXBSG	BSGRP_VX	Allow NULL?
71	TESTTEXT	Graphic object type: description	nvarchar	40	CHAR	(N' ')	Yes		NODE_TEXT	Allow NULL?
72	VVI91_ME	3-Byte field	nvarchar	3	CHAR	(N' ')	Yes		CHAR3	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

72 COLUMNS | 1 INDEXES | ERP 6.0 | VVKKFOPT TABLE

TOP ERP 6.0 | VVKKFOPT COLUMNS

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

72 COLUMNS | 1 INDEXES | ERP 6.0 | VVKKFOPT TABLE

TOPERP 6.0 | VVKKFOPT COLUMNS

TOPERP 6.0 | VVKKFOPT INDEXES

TOP ERP 6.0 | VVKKFOPT COLUMNS

TOP ERP 6.0 | VVKKFOPT INDEXES