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	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Real Estate Management :: Flexible Real Estate Management :: Real Estate Contract
1	ERP EHP7	6.0	VICNCN	55	6	Real Estate Contract	Real Estate Contract

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	INTRENO	Internal Key of Real Estate Object	nvarchar	13	Allow NULL?
3	BUKRS	Company Code	nvarchar	4	Allow NULL?
4	RECNNR	Contract Number	nvarchar	13	Allow NULL?
5	OBJNR	Object Number	nvarchar	22	Allow NULL?
6	IMKEY	Internal Key of Real Estate Object (FI)	nvarchar	8	Allow NULL?
7	CREATIONTYPE	How the Object Was Created	char	1	Allow NULL?
8	RERF	Entered by	nvarchar	12	Allow NULL?
9	DERF	First Entered on	nvarchar	8	Allow NULL?
10	TERF	Time of Initial Entry	nvarchar	6	Allow NULL?
11	REHER	Source of initial entry	nvarchar	10	Allow NULL?
12	RBEAR	Employee ID	nvarchar	12	Allow NULL?
13	DBEAR	Last Edited on	nvarchar	8	Allow NULL?
14	TBEAR	Last Edited at	nvarchar	6	Allow NULL?
15	RBHER	Editing Source	nvarchar	10	Allow NULL?
16	RESPONSIBLE	Person Responsible	nvarchar	12	Allow NULL?
17	USEREXCLUSIVE	User with Exclusive Change Authorization	nvarchar	12	Allow NULL?
18	AUTHGRP	Authorization Group	nvarchar	40	Allow NULL?
19	RECNTYPE	Contract Type	nvarchar	4	Allow NULL?
20	RECNBEG	Date of contract start	nvarchar	8	Allow NULL?
21	RECNENDABS	Term End Date	nvarchar	8	Allow NULL?
22	RECNTXT	Contract name	nvarchar	80	Allow NULL?
23	RECNDACTIV	Contract activation	nvarchar	8	Allow NULL?
24	RECNTLAW	Tenancy law	nvarchar	5	Allow NULL?
25	RECNTXTOLD	Number of old contract	nvarchar	20	Allow NULL?
26	RECNBUKRSCOLLECT	Company code of main contract	nvarchar	4	Allow NULL?
27	RECNNRCOLLECT	Number of Real Estate Main Contract	nvarchar	13	Allow NULL?
28	RECNCNCURR	Currency for Contract	nvarchar	5	Allow NULL?
29	INDUSTRY	Industry	nvarchar	10	Allow NULL?
30	SRRELEVANT	Relevant to Sales	char	1	Allow NULL?
31	DPTARGETTYPE	Security Deposit Type	nvarchar	4	Allow NULL?
32	RECNDAT	Date of Contract Conclusion	nvarchar	8	Allow NULL?
33	RECN2DAT	Date of Second Signature	nvarchar	8	Allow NULL?
34	RECNDPO	Cash Flow Generated Starting On	nvarchar	8	Allow NULL?
35	RECNEND1ST	Date of First Contract End	nvarchar	8	Allow NULL?
36	RECNNOTPER	Contract Notice Per	nvarchar	8	Allow NULL?
37	RECNNOTRECEIPT	Date of receipt of notice	nvarchar	8	Allow NULL?
38	RECNNOTREASON	Reason for Notice	nvarchar	2	Allow NULL?
39	RECNDAKTKU	Notice: Date of Activation	nvarchar	8	Allow NULL?
40	CFARCHIVEDTO	Date Up to Which the Cash Flow Is Archived	nvarchar	8	Allow NULL?
41	CFLOCKEDTO	Date Until Which the Cash Flow Is Locked	nvarchar	8	Allow NULL?
42	CFPOSTINGFROM	First Posting From	nvarchar	8	Allow NULL?
43	BENOCN	Site That Belongs to Contract	nvarchar	8	Allow NULL?
44	TRANSPOSSFROM	Transfer of Possession: Start Date	nvarchar	8	Allow NULL?
45	TRANSPOSSTO	Transfer of Possession: End Date	nvarchar	8	Allow NULL?
46	HASMULTIASSIGN	Multiple Assignment of Object to Group Allowed	char	1	Allow NULL?
47	POSSDATEFROM	Date From Which the Object Is Made Available for Use	nvarchar	8	Allow NULL?
48	POSSDATETO	Date Up to Which the Object Is Used	nvarchar	8	Allow NULL?
49	SECDEPRELEVANT	Relevant to Security Deposit	char	1	Allow NULL?
50	NOTADJSDCN	No Data Update in Security Deposit Contract	char	1	Allow NULL?
51	REYCMAJORCN	CAM Major Contract	nvarchar	13	Allow NULL?
52	REYCDEDUCTMEAS	Deduct Major Tenant Space in Den. when Calc. Subtenant Share	char	1	Allow NULL?
53	REYCMAJORTNT	Major Tenant Contribution Indicator	char	1	Allow NULL?
54	REYCISSUECREDIT	Issue Credit	char	1	Allow NULL?
55	REYCPOSDATEREL	Possession Date Relevant	char	1	Allow NULL?

Name	Primary	Unique	Type	Columns
VICNCN~0	Yes	Yes	CLUSTERED	MANDT, INTRENO
VICNCN~001	No	No	NONCLUSTERED	MANDT, BUKRS, RECNNR
VICNCN~002	No	No	NONCLUSTERED	MANDT, OBJNR
VICNCN~003	No	No	NONCLUSTERED	MANDT, RESPONSIBLE
VICNCN~004	No	No	NONCLUSTERED	MANDT, RECNNRCOLLECT, RECNBUKRSCOLLECT
VICNCN~005	No	No	NONCLUSTERED	MANDT, BUKRS, BENOCN

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

55 COLUMNS | 6 INDEXES | ERP 6.0 | VICNCN TABLE

TOP ERP 6.0 | VICNCN COLUMNS

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

55 COLUMNS | 6 INDEXES | ERP 6.0 | VICNCN TABLE

TOPERP 6.0 | VICNCN COLUMNS

TOPERP 6.0 | VICNCN INDEXES

TOP ERP 6.0 | VICNCN COLUMNS

TOP ERP 6.0 | VICNCN INDEXES