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	VIWI02	95	1	Cost Efficiency Analysis Finance Plan	Real Estate Management

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	No	*	BUKRS	Allow NULL?
3	SWENR	Site Number	nvarchar	8	0	CHAR	(N' ')	No	*	SWENR	Allow NULL?
4	DATUM	Date of Cost Efficiency Analysis	nvarchar	8	0	DATS	(N'00000000')	No		VVWBDAT	Allow NULL?
5	FREMD1_TXT	CEA: Finance plan outside funds description	nvarchar	50	0	CHAR	(N' ')	Yes		VVWBFPF1TX	Allow NULL?
6	FREMD1_GES	CEA: Finance plan total outside funds	decimal	13	2	CURR	((0))	Yes		VVWBFPF1GE
7	FREMD1_OW	CEA: Finance plan outside funds pub. auth. appartments	decimal	13	2	CURR	((0))	Yes		VVWBFPF1OW
8	FREMD1_SW	CEA: Finance plan outside funds other apartments	decimal	13	2	CURR	((0))	Yes		VVWBFPF1SW
9	FREMD1_SR	CEA: Financial plan outside funds other rooms	decimal	13	2	CURR	((0))	Yes		VVWBFPF1SR
10	FREMD2_TXT	CEA: Finance plan outside funds description	nvarchar	50	0	CHAR	(N' ')	Yes		VVWBFPF1TX	Allow NULL?
11	FREMD2_GES	CEA: Finance plan total outside funds	decimal	13	2	CURR	((0))	Yes		VVWBFPF1GE
12	FREMD2_OW	CEA: Finance plan outside funds pub. auth. appartments	decimal	13	2	CURR	((0))	Yes		VVWBFPF1OW
13	FREMD2_SW	CEA: Finance plan outside funds other apartments	decimal	13	2	CURR	((0))	Yes		VVWBFPF1SW
14	FREMD2_SR	CEA: Financial plan outside funds other rooms	decimal	13	2	CURR	((0))	Yes		VVWBFPF1SR
15	FREMD3_TXT	CEA: Finance plan outside funds description	nvarchar	50	0	CHAR	(N' ')	Yes		VVWBFPF1TX	Allow NULL?
16	FREMD3_GES	CEA: Finance plan total outside funds	decimal	13	2	CURR	((0))	Yes		VVWBFPF1GE
17	FREMD3_OW	CEA: Finance plan outside funds pub. auth. appartments	decimal	13	2	CURR	((0))	Yes		VVWBFPF1OW
18	FREMD3_SW	CEA: Finance plan outside funds other apartments	decimal	13	2	CURR	((0))	Yes		VVWBFPF1SW
19	FREMD3_SR	CEA: Financial plan outside funds other rooms	decimal	13	2	CURR	((0))	Yes		VVWBFPF1SR
20	FREMD4_TXT	CEA: Finance plan outside funds description	nvarchar	50	0	CHAR	(N' ')	Yes		VVWBFPF1TX	Allow NULL?
21	FREMD4_GES	CEA: Finance plan total outside funds	decimal	13	2	CURR	((0))	Yes		VVWBFPF1GE
22	FREMD4_OW	CEA: Finance plan outside funds pub. auth. appartments	decimal	13	2	CURR	((0))	Yes		VVWBFPF1OW
23	FREMD4_SW	CEA: Finance plan outside funds other apartments	decimal	13	2	CURR	((0))	Yes		VVWBFPF1SW
24	FREMD4_SR	CEA: Financial plan outside funds other rooms	decimal	13	2	CURR	((0))	Yes		VVWBFPF1SR
25	FREMD5_TXT	CEA: Finance plan outside funds description	nvarchar	50	0	CHAR	(N' ')	Yes		VVWBFPF1TX	Allow NULL?
26	FREMD5_GES	CEA: Finance plan total outside funds	decimal	13	2	CURR	((0))	Yes		VVWBFPF1GE
27	FREMD5_OW	CEA: Finance plan outside funds pub. auth. appartments	decimal	13	2	CURR	((0))	Yes		VVWBFPF1OW
28	FREMD5_SW	CEA: Finance plan outside funds other apartments	decimal	13	2	CURR	((0))	Yes		VVWBFPF1SW
29	FREMD5_SR	CEA: Financial plan outside funds other rooms	decimal	13	2	CURR	((0))	Yes		VVWBFPF1SR
30	FREMD6_TXT	CEA: Finance plan outside funds description	nvarchar	50	0	CHAR	(N' ')	Yes		VVWBFPF1TX	Allow NULL?
31	FREMD6_GES	CEA: Finance plan total outside funds	decimal	13	2	CURR	((0))	Yes		VVWBFPF1GE
32	FREMD6_OW	CEA: Finance plan outside funds pub. auth. appartments	decimal	13	2	CURR	((0))	Yes		VVWBFPF1OW
33	FREMD6_SW	CEA: Finance plan outside funds other apartments	decimal	13	2	CURR	((0))	Yes		VVWBFPF1SW
34	FREMD6_SR	CEA: Financial plan outside funds other rooms	decimal	13	2	CURR	((0))	Yes		VVWBFPF1SR
35	FREMD7_TXT	CEA: Finance plan outside funds description	nvarchar	50	0	CHAR	(N' ')	Yes		VVWBFPF1TX	Allow NULL?
36	FREMD7_GES	CEA: Finance plan total outside funds	decimal	13	2	CURR	((0))	Yes		VVWBFPF1GE
37	FREMD7_OW	CEA: Finance plan outside funds pub. auth. appartments	decimal	13	2	CURR	((0))	Yes		VVWBFPF1OW
38	FREMD7_SW	CEA: Finance plan outside funds other apartments	decimal	13	2	CURR	((0))	Yes		VVWBFPF1SW
39	FREMD7_SR	CEA: Financial plan outside funds other rooms	decimal	13	2	CURR	((0))	Yes		VVWBFPF1SR
40	FREMD8_TXT	CEA: Finance plan outside funds description	nvarchar	50	0	CHAR	(N' ')	Yes		VVWBFPF1TX	Allow NULL?
41	FREMD8_GES	CEA: Finance plan total outside funds	decimal	13	2	CURR	((0))	Yes		VVWBFPF1GE
42	FREMD8_OW	CEA: Finance plan outside funds pub. auth. appartments	decimal	13	2	CURR	((0))	Yes		VVWBFPF1OW
43	FREMD8_SW	CEA: Finance plan outside funds other apartments	decimal	13	2	CURR	((0))	Yes		VVWBFPF1SW
44	FREMD8_SR	CEA: Financial plan outside funds other rooms	decimal	13	2	CURR	((0))	Yes		VVWBFPF1SR
45	FREMD9_TXT	CEA: Finance plan outside funds description	nvarchar	50	0	CHAR	(N' ')	Yes		VVWBFPF1TX	Allow NULL?
46	FREMD9_GES	CEA: Finance plan total outside funds	decimal	13	2	CURR	((0))	Yes		VVWBFPF1GE
47	FREMD9_OW	CEA: Finance plan outside funds pub. auth. appartments	decimal	13	2	CURR	((0))	Yes		VVWBFPF1OW
48	FREMD9_SW	CEA: Finance plan outside funds other apartments	decimal	13	2	CURR	((0))	Yes		VVWBFPF1SW
49	FREMD9_SR	CEA: Financial plan outside funds other rooms	decimal	13	2	CURR	((0))	Yes		VVWBFPF1SR
50	VERLBK_TXT	CEA: Finance plan lost constr. costs surcharge description	nvarchar	50	0	CHAR	(N' ')	Yes		VVWBFPVBTX	Allow NULL?
51	VERLBK_GES	CEA: Finance plan lost constr. cost surcharge total	decimal	13	2	CURR	((0))	Yes		VVWBFPVBGE
52	VERLBK_OW	CEA: Finance plan lost constr. cost surcharge total	decimal	13	2	CURR	((0))	Yes		VVWBFPVBOW
53	VERLBK_SW	CEA: Finance plan lost constr. cost surcharge total	decimal	13	2	CURR	((0))	Yes		VVWBFPVBSW
54	VERLBK_SR	CEA: Finance plan lost constr. cost surcharge total	decimal	13	2	CURR	((0))	Yes		VVWBFPVBSR
55	EIGZI1_GES	CEA: Finance plan own substitute interest rate 1 total	decimal	13	2	CURR	((0))	Yes		VVWBFPZ1GE
56	EIGZI1_OW	CEA: Finance plan own substitute interest rate 1 PA apart.	decimal	13	2	CURR	((0))	Yes		VVWBFPZ1OW
57	EIGZI1_SW	CEA: Finance plan own substitute interest rate 1 other ap.	decimal	13	2	CURR	((0))	Yes		VVWBFPZ1SW
58	EIGZI1_SR	CEA: Finance plan own substitute interest rate 1 other rooms	decimal	13	2	CURR	((0))	Yes		VVWBFPZ1SR
59	EIGZI2_GES	CEA: Finance plan own substitute interest rate 2 total	decimal	13	2	CURR	((0))	Yes		VVWBFPZ2GE
60	EIGZI2_OW	CEA: Finance plan own substitute interest rate 2 PA apart.	decimal	13	2	CURR	((0))	Yes		VVWBFPZ2OW
61	EIGZI2_SW	CEA: Finance plan own substitute interest rate 2 other ap.	decimal	13	2	CURR	((0))	Yes		VVWBFPZ2SW
62	EIGZI2_SR	CEA: Finance plan own substitute interest rate 2 other rooms	decimal	13	2	CURR	((0))	Yes		VVWBFPZ2SR
63	EIGER1_GES	CEA: Finance plan own substitute total family loan	decimal	13	2	CURR	((0))	Yes		VVWBFPE1GE
64	EIGER1_OW	CEA: Finance plan own substitute total family loan	decimal	13	2	CURR	((0))	Yes		VVWBFPE1OW
65	EIGER1_SW	CEA: Finance plan own substitute total family loan	decimal	13	2	CURR	((0))	Yes		VVWBFPE1SW
66	EIGER1_SR	CEA: Finance plan own substitute total family loan	decimal	13	2	CURR	((0))	Yes		VVWBFPE1SR
67	EIGER2_GES	CEA: Finance plan own substitute total development loan	decimal	13	2	CURR	((0))	Yes		VVWBFPE2GE
68	EIGER2_OW	CEA: Finance plan own substitute total development loan	decimal	13	2	CURR	((0))	Yes		VVWBFPE2OW
69	EIGER2_SW	CEA: Finance plan own substitute total development loan	decimal	13	2	CURR	((0))	Yes		VVWBFPE2SW
70	EIGER2_SR	CEA: Finance plan own substitute total development loan	decimal	13	2	CURR	((0))	Yes		VVWBFPE2SR
71	EIGER3_GES	CEA: Finance plan own substitute total tenant loan	decimal	13	2	CURR	((0))	Yes		VVWBFPE3GE
72	EIGER3_OW	CEA: Finance plan own substitute total tenant loan PA accom.	decimal	13	2	CURR	((0))	Yes		VVWBFPE3OW
73	EIGER3_SW	CEA: Finance plan own substitute tenant loan other rooms	decimal	13	2	CURR	((0))	Yes		VVWBFPE3SW
74	EIGER3_SR	CEA: Finance plan own substitute tenant loan other rooms	decimal	13	2	CURR	((0))	Yes		VVWBFPE3SR
75	EIGER4_GES	CEA: Finance plan own substitute total others	decimal	13	2	CURR	((0))	Yes		VVWBFPE4GE
76	EIGER4_OW	CEA: Finance plan own substitute other public auth. accom.	decimal	13	2	CURR	((0))	Yes		VVWBFPE4OW
77	EIGER4_SW	CEA: Finance plan own substitute other apartments	decimal	13	2	CURR	((0))	Yes		VVWBFPE4SW
78	EIGER4_SR	CEA: Finance plan own substitute total other rooms	decimal	13	2	CURR	((0))	Yes		VVWBFPE4SR
79	EIGER4_TXT	CEA: Finance plan own substitute description others	nvarchar	50	0	CHAR	(N' ')	Yes		VVWBFPETXT	Allow NULL?
80	SUMME_GES	CEA: Total financial plan	decimal	13	2	CURR	((0))	Yes		VVWBFPSUGE
81	SUMME_OW	CEA: Total financial plan	decimal	13	2	CURR	((0))	Yes		VVWBFPSUOW
82	SUMME_SW	CEA: Total financial plan	decimal	13	2	CURR	((0))	Yes		VVWBFPSUSW
83	SUMME_SR	CEA: Total financial plan	decimal	13	2	CURR	((0))	Yes		VVWBFPSUSR
84	EIG_GELDW	CEA: Financial plans own substitute financial means app	decimal	13	2	CURR	((0))	Yes		VVWBFPEIGW
85	EIG_GELDG	CEA: Financial plans own substitute financial means app	decimal	13	2	CURR	((0))	Yes		VVWBFPEIGG
86	EIG_SACHW	CEA: Financial plans own substitute financial means app.	decimal	13	2	CURR	((0))	Yes		VVWBFPEISW
87	EIG_SACHG	CEA: Financial plans own substitute financial means app.	decimal	13	2	CURR	((0))	Yes		VVWBFPEISG
88	EIG_BAUW	CEA: Financial plans own substitute financial means app.part	decimal	13	2	CURR	((0))	Yes		VVWBFPEIBW
89	EIG_BAUG	CEA: Financial plans own substitute financial means app.part	decimal	13	2	CURR	((0))	Yes		VVWBFPEIBG
90	EIG_GEBW	CEA: Finance plan own substitute used building part	decimal	13	2	CURR	((0))	Yes		VVWBFPEIVW
91	EIG_GEBG	CEA: Finance plan own substitute used building part comm.	decimal	13	2	CURR	((0))	Yes		VVWBFPEIVG
92	EIG_SUMW	CEA: Financial plans own substitute financial means app.	decimal	13	2	CURR	((0))	Yes		VVWBFPEISW
93	EIG_SUMG	CEA: Financial plans own substitute financial means app.	decimal	13	2	CURR	((0))	Yes		VVWBFPEISG
94	EIG_ZINS1	CEA: Financial plan own substitute interest rate 1	decimal	5	2	DEC	((0))	Yes		VVWBFPEIZ1
95	EIG_ZINS2	CEA: Finance plan own substitute interest rate 2	decimal	5	2	DEC	((0))	Yes		VVWBFPEIZ2

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

95 COLUMNS | 1 INDEXES | ERP 6.0 | VIWI02 TABLE

TOP ERP 6.0 | VIWI02 COLUMNS

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

95 COLUMNS | 1 INDEXES | ERP 6.0 | VIWI02 TABLE

TOPERP 6.0 | VIWI02 COLUMNS

TOPERP 6.0 | VIWI02 INDEXES

TOP ERP 6.0 | VIWI02 COLUMNS

TOP ERP 6.0 | VIWI02 INDEXES