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
Real Estate Management
1	ERP EHP7	6.0	VICN01	111	4	Real Estate Contract: Contract Data	Real Estate Management

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	INTRENO	Internal Real Estate Master Data Code	nvarchar	13	CHAR	(N' ')	No		VVINTRENO	Allow NULL?
3	BUKRS	Company Code	nvarchar	4	CHAR	(N' ')	Yes	T001	BUKRS	Allow NULL?
4	RECNTYPE	External Real Estate contract type	nvarchar	4	CHAR	(N' ')	Yes	TIV26	SMVART	Allow NULL?
5	RECNNR	Real Estate Contract Number	nvarchar	13	CHAR	(N' ')	Yes		RECNNR	Allow NULL?
6	RECNDAT	Date of Contract Conclusion	nvarchar	8	DATS	(N'00000000')	Yes		RECNDAT	Allow NULL?
7	RECNBEG	Date of contract start	nvarchar	8	DATS	(N'00000000')	Yes		RECNBEG	Allow NULL?
8	RECNEND	Date of contract end	nvarchar	8	DATS	(N'00000000')	Yes		RECNEND	Allow NULL?
9	RECNADJT	Lease-Out Adjustment Type	char	1	CHAR	(N' ')	Yes	*	SMVAR	Allow NULL?
10	RECNTXT	Contract name	nvarchar	80	CHAR	(N' ')	Yes		RECNTXT	Allow NULL?
11	RECNDPO	Date of first posting	nvarchar	8	DATS	(N'00000000')	Yes		RECNDPO	Allow NULL?
12	RECNOBJNR	Object number	nvarchar	22	CHAR	(N' ')	Yes	*	J_OBJNR	Allow NULL?
13	RECNNOTTYPE	Notice Type of Lease-Out	char	1	CHAR	(N' ')	Yes		SMVKUEART	Allow NULL?
14	RECNNOTKEY	Notice rule	nvarchar	12	CHAR	(N' ')	Yes		SKUEKEY	Allow NULL?
15	RECNNOTPER	Contract Notice Per	nvarchar	8	DATS	(N'00000000')	Yes		DKUZU	Allow NULL?
16	RECNAUTHGR	Authorization group	nvarchar	40	CHAR	(N' ')	Yes		VVBERGRP	Allow NULL?
17	RECNBUSAREA	Business Area	nvarchar	4	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
18	RECNPRCTR	Profit Center	nvarchar	10	CHAR	(N' ')	Yes	CEPC	PRCTR	Allow NULL?
19	RECNACCDETVAL	Account determination key for account determination	nvarchar	10	CHAR	(N' ')	Yes	TIVCN08	VVWERTN_ADCN	Allow NULL?
20	RECNADMONTH	Accrual/deferral method	char	1	CHAR	(N' ')	Yes		VVJMABGR	Allow NULL?
21	RECNDDUNNED	Last dunned on	nvarchar	8	DATS	(N'00000000')	Yes		MADAT	Allow NULL?
22	RECNDCOMPLNT	Date of complaint	nvarchar	8	DATS	(N'00000000')	Yes		VVKLDATUM	Allow NULL?
23	RECNDCOMPLRC	Complaint reference code	nvarchar	20	CHAR	(N' ')	Yes		VVKLAKTZEI	Allow NULL?
24	RECNJURISDIC	Jurisdiction	nvarchar	35	CHAR	(N' ')	Yes		VVXGERSTD	Allow NULL?
25	IMKEY	Internal Key for Real Estate Object	nvarchar	8	CHAR	(N' ')	Yes		IMKEY	Allow NULL?
26	RERF	Entered by	nvarchar	12	CHAR	(N' ')	Yes		RERF	Allow NULL?
27	DERF	First Entered on	nvarchar	8	DATS	(N'00000000')	Yes		DERF	Allow NULL?
28	TERF	Time of Initial Entry	nvarchar	6	TIMS	(N'000000')	Yes		TERF	Allow NULL?
29	REHER	Source of initial entry	nvarchar	10	CHAR	(N' ')	Yes		REHER	Allow NULL?
30	RBEAR	Employee ID	nvarchar	12	CHAR	(N' ')	Yes		RBEAR	Allow NULL?
31	DBEAR	Last Edited on	nvarchar	8	DATS	(N'00000000')	Yes		DBEAR	Allow NULL?
32	TBEAR	Last Edited at	nvarchar	6	TIMS	(N'000000')	Yes		TBEAR	Allow NULL?
33	RBHER	Editing Source	nvarchar	10	CHAR	(N' ')	Yes		RBHER	Allow NULL?
34	RECNUNIT	Area unit	nvarchar	3	UNIT	(N' ')	Yes	T006	RECNUNIT	Allow NULL?
35	RECNKUNNR	Customer Number	nvarchar	10	CHAR	(N' ')	Yes	KNA1	KUNNR	Allow NULL?
36	RECNLIFNR	Account Number of Vendor or Creditor	nvarchar	10	CHAR	(N' ')	Yes	LFA1	LIFNR	Allow NULL?
37	RECNTXJCD	Tax Jurisdiction	nvarchar	15	CHAR	(N' ')	Yes	*	TXJCD	Allow NULL?
38	RECNCURR	Currency key for local currency	nvarchar	5	CUKY	(N' ')	Yes	TCURC	RECNWAERS_H	Allow NULL?
39	RECNTLAW	Tenancy law	nvarchar	5	CHAR	(N' ')	Yes	TIV03	SMIETR	Allow NULL?
40	RECNCURR2	Currency key for the display currency	nvarchar	5	CUKY	(N' ')	Yes	TCURC	RECNWAERS_D	Allow NULL?
41	RECNTXTOLD	Number of old contract	nvarchar	20	CHAR	(N' ')	Yes		VVOSMIVE	Allow NULL?
42	RECNDACTIV	Contract activation	nvarchar	8	DATS	(N'00000000')	Yes		DAKTV	Allow NULL?
43	RECNNRCOLLECT	Number of Real Estate main contract	nvarchar	13	CHAR	(N' ')	Yes		RECNNRCOLLECT	Allow NULL?
44	RECNKOSTL	Cost center of internal contract	nvarchar	10	CHAR	(N' ')	Yes	*	RECNKOSTL	Allow NULL?
45	ZLSCH	Payment Method	char	1	CHAR	(N' ')	Yes	*	DZLSCH	Allow NULL?
46	RECNPREDATA	Flag: Predefined rates	char	1	CHAR	(N' ')	Yes		RECNPREDATA	Allow NULL?
47	SPARTNR	Business Partner Number	nvarchar	10	CHAR	(N' ')	Yes	*	BP_PARTNR	Allow NULL?
48	RECNNOTRECEIPT	Receipt or issue date of notice	nvarchar	8	DATS	(N'00000000')	Yes		DEKUEA	Allow NULL?
49	RECNNOTREASON	Reason for notice	nvarchar	2	NUMC	(N'00')	Yes	TIV39	RKUEGRU	Allow NULL?
50	RECNNOTINVREA	Reason for rejection	nvarchar	2	NUMC	(N'00')	Yes	TIV41	RABLGRU	Allow NULL?
51	RECNJVSTOPT	Input tax opting (indicator)	char	1	CHAR	(N' ')	Yes		VVJVSTOPT	Allow NULL?
52	RECNVSTSOND	Input tax opting reason	char	1	CHAR	(N' ')	Yes	TIV63	SVSTSOND	Allow NULL?
53	RECNMANSP	Dunning block	char	1	CHAR	(N' ')	Yes	T040S	MANSP	Allow NULL?
54	RECNMABER	Dunning Area	nvarchar	2	CHAR	(N' ')	Yes	T047M	MABER	Allow NULL?
55	RECNMAHNA	Dunning Procedure	nvarchar	4	CHAR	(N' ')	Yes	T047A	MAHNA	Allow NULL?
56	RECNMAHNS_D	Dunning level	char	1	NUMC	(N'0')	Yes		MAHNS_D	Allow NULL?
57	RECNNOTCAT	Notice Type	char	1	CHAR	(N' ')	Yes		SKUAR	Allow NULL?
58	RECNGFZLSCH	Payment method for credit memos	char	1	CHAR	(N' ')	Yes	*	RECNGFZLSCH	Allow NULL?
59	RECNZLSPR	Payment Block Key	char	1	CHAR	(N' ')	Yes	T008	DZLSPR	Allow NULL?
60	RECNHBKID	Short Key for a House Bank	nvarchar	5	CHAR	(N' ')	Yes	T012	HBKID	Allow NULL?
61	RECNXBLNR	Note to payee	nvarchar	16	CHAR	(N' ')	Yes		RECNXBLNR1	Allow NULL?
62	RECNDKUZUG	Date notice approved	nvarchar	8	DATS	(N'00000000')	Yes		VVDKUZUG	Allow NULL?
63	RECNDKUABG	Date notice rejected	nvarchar	8	DATS	(N'00000000')	Yes		VVDKUABG	Allow NULL?
64	RECNDWIKU	Date of objection to notice	nvarchar	8	DATS	(N'00000000')	Yes		VVDWIKU	Allow NULL?
65	RECNDKUERCK	Date of withdrawal of notice	nvarchar	8	DATS	(N'00000000')	Yes		DKUERCK	Allow NULL?
66	RECNDKREUEB	Date notice submitted to legal department	nvarchar	8	DATS	(N'00000000')	Yes		VVDKREUEB	Allow NULL?
67	RECNDAKTKU	Activation date	nvarchar	8	DATS	(N'00000000')	Yes		VVDAKTKU	Allow NULL?
68	RECNDSTKU	Reversal date	nvarchar	8	DATS	(N'00000000')	Yes		VVDSTKU	Allow NULL?
69	RECNADJTTYPE	Adjustment triggered by	char	1	CHAR	(N' ')	Yes		RECNADJTTYPE	Allow NULL?
70	RECNADJTRUECK	Retroactive adjustment possible	char	1	CHAR	(N' ')	Yes		RECNADJTRUECK	Allow NULL?
71	RECNBUKRSCOLLECT	Company code of main contract	nvarchar	4	CHAR	(N' ')	Yes	T001	RECNBUKRSCOLLECT	Allow NULL?
72	RECNBASISAEZIF	Base: equivalence number distribution	smallint	5	INT2	((0))	Yes		RECNBASISAEZIF
73	RECNXCROSS	Gross amount indicator	char	1	CHAR	(N' ')	Yes		RECNXCROSS	Allow NULL?
74	RECNMANDAT	Mandate	nvarchar	20	CHAR	(N' ')	Yes		RECNMANDAT	Allow NULL?
75	RECNMANDATTYP	Role of Contract in Mandate	char	1	NUMC	(N'0')	Yes		RECNMANDATTYP	Allow NULL?
76	RECNFLESR	Activation of POR functions	char	1	CHAR	(N' ')	Yes		VVKZESR	Allow NULL?
77	RECNESRNROW	POR participant number of owner	nvarchar	9	NUMC	(N'000000000')	Yes	TIV9I	VVESRNR_EIG	Allow NULL?
78	RECNESRCUIDOW	POR customer identification number	nvarchar	15	CHAR	(N' ')	Yes	TIV9I	VVESRKUID_EIG	Allow NULL?
79	RECNVATNROW	Value-added tax of owner	nvarchar	20	CHAR	(N' ')	Yes		VVMWSTNR_EIG	Allow NULL?
80	RECNBUKRSGKT	Object and account CoCd	nvarchar	4	CHAR	(N' ')	Yes	T001	VVBUKRS_GKT	Allow NULL?
81	RECNKZEIGGKT	Cash account control for owner	char	1	CHAR	(N' ')	Yes		VVKZEIGGKT	Allow NULL?
82	RELSKASSENZ		nvarchar	30		(N' ')	Yes			Allow NULL?
83	RELSGRDNR		nvarchar	30		(N' ')	Yes			Allow NULL?
84	RELSSUBTYPE		nvarchar	4		(N' ')	Yes			Allow NULL?
85	RELSAKTZ		nvarchar	35		(N' ')	Yes			Allow NULL?
86	RELSDAT2		nvarchar	8		(N'00000000')	Yes			Allow NULL?
87	RELSWIRTUEBG		nvarchar	8		(N'00000000')	Yes			Allow NULL?
88	RELSNOTEARLY		nvarchar	8		(N'00000000')	Yes			Allow NULL?
89	RELSOWNER	Business Partner Number	nvarchar	10	CHAR	(N' ')	Yes	*	BP_PARTNR	Allow NULL?
90	RELSROLETYP	Business Partner Role Category	nvarchar	4	CHAR	(N' ')	Yes	*	BP_ROLETYP	Allow NULL?
91	CREATIONTYPE	How the Object Was Created	char	1	CHAR	(N' ')	Yes		RECACREATIONTYPE	Allow NULL?
92	RECNCNCURR	Currency for Contract	nvarchar	5	CUKY	(N' ')	Yes	TCURC	RECNWAERS_CN	Allow NULL?
93	RECNENDABS	Term End Date	nvarchar	8	DATS	(N'00000000')	Yes		RECNCNENDABS	Allow NULL?
94	RECN2DAT	Date of Second Signature	nvarchar	8	DATS	(N'00000000')	Yes		RECN2DAT	Allow NULL?
95	RESPONSIBLE	Person Responsible	nvarchar	12	CHAR	(N' ')	Yes	*	RECARESPONSIBLE	Allow NULL?
96	USEREXCLUSIVE	User with Exclusive Change Authorization	nvarchar	12	CHAR	(N' ')	Yes	*	RECAUSEREXCLUSIVE	Allow NULL?
97	SRRELEVANT	Relevant to Sales	char	1	CHAR	(N' ')	Yes		RECNSALESRENTRELEVANT	Allow NULL?
98	CFARCHIVEDTO	Date Up to Which the Cash Flow Is Archived	nvarchar	8	DATS	(N'00000000')	Yes		RECDCFARCHIVEDTO	Allow NULL?
99	CFLOCKEDTO	Date Until Which the Cash Flow Is Locked	nvarchar	8	DATS	(N'00000000')	Yes		RECDCFLOCKEDTO	Allow NULL?
100	INDUSTRY	Industry	nvarchar	10	CHAR	(N' ')	Yes	*	BU_IND_SECTOR	Allow NULL?
101	DPTARGETTYPE	Security Deposit Type	nvarchar	4	CHAR	(N' ')	Yes	TIVCNDPTYPE	RECNDPTYPE	Allow NULL?
102	BIRELEASE		char	1		(N' ')	Yes			Allow NULL?
103	BIVALIDFROM		nvarchar	8		(N'00000000')	Yes			Allow NULL?
104	BIVALIDTO		nvarchar	8		(N'00000000')	Yes			Allow NULL?
105	BIREPRTO		nvarchar	8		(N'00000000')	Yes			Allow NULL?
106	BIREPRTOTIME		nvarchar	6		(N'000000')	Yes			Allow NULL?
107	BIRECAT		nvarchar	2		(N' ')	Yes			Allow NULL?
108	PUBLICTYPE		nvarchar	2		(N' ')	Yes			Allow NULL?
109	FILENO		nvarchar	35		(N' ')	Yes			Allow NULL?
110	BIPURPOSE		nvarchar	2		(N' ')	Yes			Allow NULL?
111	BIPRICING		nvarchar	2		(N' ')	Yes			Allow NULL?

Name	Primary	Unique	Type	Columns
VICN01~0	Yes	Yes	CLUSTERED	MANDT, INTRENO
VICN01~BV	No	No	NONCLUSTERED	BUKRS, RECNNR
VICN01~COL	No	No	NONCLUSTERED	RECNNRCOLLECT, RECNBUKRSCOLLECT
VICN01~ONR	No	No	NONCLUSTERED	RECNOBJNR

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

111 COLUMNS | 4 INDEXES | ERP 6.0 | VICN01 TABLE

TOP ERP 6.0 | VICN01 COLUMNS

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

111 COLUMNS | 4 INDEXES | ERP 6.0 | VICN01 TABLE

TOPERP 6.0 | VICN01 COLUMNS

TOPERP 6.0 | VICN01 INDEXES

TOP ERP 6.0 | VICN01 COLUMNS

TOP ERP 6.0 | VICN01 INDEXES