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	VIWI05	108	1	Cost Efficiency Analysis Current Expenditure	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	FRKAPTOW1	CEA: Repayment outside capital amount publicly subsid.accom.	decimal	13	2	CURR	((0))	Yes		VVKAPTOW
6	FRKAPTSW1	CEA: Repayment outside capital amount other accommodation	decimal	13	2	CURR	((0))	Yes		VVKAPTSW
7	FRKAPTP1	CEA: Repayment % outside capital	decimal	5	2	DEC	((0))	Yes		VVKAPTP
8	FRKAPZOW1	CEA: Interest outside capital amount publicly subsid.accomm	decimal	13	2	CURR	((0))	Yes		VVKAPZOW
9	FRKAPZSW1	CEA: Interest outside capital amount other accommodation	decimal	13	2	CURR	((0))	Yes		VVKAPZSW
10	FRKAPZP1	CEA: Interest % outside capital	decimal	5	2	DEC	((0))	Yes		VVKAPZP
11	FRKAPTOW2	CEA: Repayment outside capital amount publicly subsid.accom.	decimal	13	2	CURR	((0))	Yes		VVKAPTOW
12	FRKAPTSW2	CEA: Repayment outside capital amount other accommodation	decimal	13	2	CURR	((0))	Yes		VVKAPTSW
13	FRKAPTP2	CEA: Repayment % outside capital	decimal	5	2	DEC	((0))	Yes		VVKAPTP
14	FRKAPZOW2	CEA: Interest outside capital amount publicly subsid.accomm	decimal	13	2	CURR	((0))	Yes		VVKAPZOW
15	FRKAPZSW2	CEA: Interest outside capital amount other accommodation	decimal	13	2	CURR	((0))	Yes		VVKAPZSW
16	FRKAPZP2	CEA: Interest % outside capital	decimal	5	2	DEC	((0))	Yes		VVKAPZP
17	FRKAPTOW3	CEA: Repayment outside capital amount publicly subsid.accom.	decimal	13	2	CURR	((0))	Yes		VVKAPTOW
18	FRKAPTSW3	CEA: Repayment outside capital amount other accommodation	decimal	13	2	CURR	((0))	Yes		VVKAPTSW
19	FRKAPTP3	CEA: Repayment % outside capital	decimal	5	2	DEC	((0))	Yes		VVKAPTP
20	FRKAPZOW3	CEA: Interest outside capital amount publicly subsid.accomm	decimal	13	2	CURR	((0))	Yes		VVKAPZOW
21	FRKAPZSW3	CEA: Interest outside capital amount other accommodation	decimal	13	2	CURR	((0))	Yes		VVKAPZSW
22	FRKAPZP3	CEA: Interest % outside capital	decimal	5	2	DEC	((0))	Yes		VVKAPZP
23	FRKAPTOW4	CEA: Repayment outside capital amount publicly subsid.accom.	decimal	13	2	CURR	((0))	Yes		VVKAPTOW
24	FRKAPTSW4	CEA: Repayment outside capital amount other accommodation	decimal	13	2	CURR	((0))	Yes		VVKAPTSW
25	FRKAPTP4	CEA: Repayment % outside capital	decimal	5	2	DEC	((0))	Yes		VVKAPTP
26	FRKAPZOW4	CEA: Interest outside capital amount publicly subsid.accomm	decimal	13	2	CURR	((0))	Yes		VVKAPZOW
27	FRKAPZSW4	CEA: Interest outside capital amount other accommodation	decimal	13	2	CURR	((0))	Yes		VVKAPZSW
28	FRKAPZP4	CEA: Interest % outside capital	decimal	5	2	DEC	((0))	Yes		VVKAPZP
29	FRKAPTOW5	CEA: Repayment outside capital amount publicly subsid.accom.	decimal	13	2	CURR	((0))	Yes		VVKAPTOW
30	FRKAPTSW5	CEA: Repayment outside capital amount other accommodation	decimal	13	2	CURR	((0))	Yes		VVKAPTSW
31	FRKAPTP5	CEA: Repayment % outside capital	decimal	5	2	DEC	((0))	Yes		VVKAPTP
32	FRKAPZOW5	CEA: Interest outside capital amount publicly subsid.accomm	decimal	13	2	CURR	((0))	Yes		VVKAPZOW
33	FRKAPZSW5	CEA: Interest outside capital amount other accommodation	decimal	13	2	CURR	((0))	Yes		VVKAPZSW
34	FRKAPZP5	CEA: Interest % outside capital	decimal	5	2	DEC	((0))	Yes		VVKAPZP
35	EIKAPZP1	CEA: Interest % own funds	decimal	5	2	DEC	((0))	Yes		VVWBEKPZP
36	EIKAPZOW1	CEA:Interest amount own funds publicly subsid.accomm.	decimal	13	2	CURR	((0))	Yes		VVWBEKPZO
37	EIKAPZSW1	CEA: Interest amount own funds other accommodation	decimal	13	2	CURR	((0))	Yes		VVWBEKPZS
38	EIKAPZP2	CEA: Interest % own funds	decimal	5	2	DEC	((0))	Yes		VVWBEKPZP
39	EIKAPZOW2	CEA:Interest amount own funds publicly subsid.accomm.	decimal	13	2	CURR	((0))	Yes		VVWBEKPZO
40	EIKAPZSW2	CEA: Interest amount own funds other accommodation	decimal	13	2	CURR	((0))	Yes		VVWBEKPZS
41	EEKAPTOW1	CEA: Own substitute - Repayment for pub. auth. accommod.	decimal	13	2	CURR	((0))	Yes		VVWBEEKPTO
42	EEKAPTSW1	CEA: Own substitute - Repayment for other accommod.	decimal	13	2	CURR	((0))	Yes		VVWBEEKPTS
43	EEKAPTP1	CEA: Compensated own fund repayment %	decimal	5	2	DEC	((0))	Yes		VVWBEEKPTP
44	EEKAPZOW1	CEA: Own substitute - Interest for pub. auth. accommod.	decimal	13	2	CURR	((0))	Yes		VVWBEEKPZO
45	EEKAPZSW1	CEA: Own substitute - Interest for other accommod.	decimal	13	2	CURR	((0))	Yes		VVWBEEKPZS
46	EEKAPZP1	CEA: Expenses own substitute insterest %	decimal	5	2	DEC	((0))	Yes		VVWBEEKPZP
47	EEKAPTOW2	CEA: Own substitute - Repayment for pub. auth. accommod.	decimal	13	2	CURR	((0))	Yes		VVWBEEKPTO
48	EEKAPTSW2	CEA: Own substitute - Repayment for other accommod.	decimal	13	2	CURR	((0))	Yes		VVWBEEKPTS
49	EEKAPTP2	CEA: Compensated own fund repayment %	decimal	5	2	DEC	((0))	Yes		VVWBEEKPTP
50	EEKAPZOW2	CEA: Own substitute - Interest for pub. auth. accommod.	decimal	13	2	CURR	((0))	Yes		VVWBEEKPZO
51	EEKAPZSW2	CEA: Own substitute - Interest for other accommod.	decimal	13	2	CURR	((0))	Yes		VVWBEEKPZS
52	EEKAPZP2	CEA: Expenses own substitute insterest %	decimal	5	2	DEC	((0))	Yes		VVWBEEKPZP
53	TSUMME	CEA: Repayment amount costs	decimal	13	2	CURR	((0))	Yes		VVWBTILSUM
54	ABSCHREI	CEA: Expense depreciation	decimal	13	2	CURR	((0))	Yes		VVWBABSCHR
55	ERBBAUM2	CEA: Expenses ground rights area in AU	decimal	14	4	QUAN	((0))	Yes		VVWBEBM2
56	ERBBAUBETR	CEA: Expenses: Ground rights amount per AU	decimal	13	2	CURR	((0))	Yes		VVWBEBBETR
57	ERBBAUSOW	CEA: Expenses ground rights total	decimal	13	2	CURR	((0))	Yes		VVWBEBSUM
58	ERBBAUSSW	CEA: Expenses ground rights total	decimal	13	2	CURR	((0))	Yes		VVWBEBSUM
59	ABSGEB_OW	CEA: Admin costs depreciation bldg subsidized apartment	decimal	13	2	CURR	((0))	Yes		VVWBLAAGOW
60	ABSGEB_SW	CEA: Admin costs depreciation building other apartments	decimal	13	2	CURR	((0))	Yes		VVWBLAAGSW
61	ABSANL_OW	CEA: Admin. costs depreciation of grounds/facilities pub. ap	decimal	13	2	CURR	((0))	Yes		VVWBLAAAOW
62	ABSANL_SW	CEA: Admin. costs deprec. of grounds & facilities other aps	decimal	13	2	CURR	((0))	Yes		VVWBLAAASW
63	ABSCHR_GOW	Amount	decimal	13	2	CURR	((0))	Yes		VVWBLAASOW
64	ABSCHR_GSW	Amount	decimal	13	2	CURR	((0))	Yes		VVWBLAASSW
65	VERW_WOHN	CEA: Administration costs number of apartments	decimal	3	0	DEC	((0))	Yes		VVWBLAVWO
66	VERW_WBETR	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAVWOB
67	VERW_GARA	CEA: Administration costs Garage no.	decimal	3	0	DEC	((0))	Yes		VVWBLAVGA
68	VERW_GBETR	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAVGAB
69	VERW_WBGES	CEA: Administration costs apartments	decimal	13	2	CURR	((0))	Yes		VVWBLAVWBG
70	VERW_WBSOW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAVWBO
71	VERW_WBSSW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAVWBS
72	VERW_GBGES	CEA: Administration costs garage	decimal	13	2	CURR	((0))	Yes		VVWBLAVGBG
73	VERW_GBSOW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAVGBO
74	VERW_GBSSW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAVGBS
75	BETR_GSTOW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLABEGO
76	BETR_GSTSW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLABEGS
77	BETR_WM2	CEA: Administration costs/operating costs living area	decimal	14	4	QUAN	((0))	Yes		VVWBLABEWM
78	BETR_WM2BE	CEA: Admin costs/operating costs amount per m2/living area	decimal	13	2	CURR	((0))	Yes		VVWBLABEWB
79	BETR_NM2	CEA: Administration costs/operating costs usable area	decimal	14	4	QUAN	((0))	Yes		VVWBLABENM
80	BETR_NM2BE	CEA: Admin. costs/operating costs amount per M2 usable area	decimal	13	2	CURR	((0))	Yes		VVWBLABENB
81	BETR_GM2	CEA: Admin costs/operating costs usable area - garage area	decimal	14	4	QUAN	((0))	Yes		VVWBLABEGM
82	BETR_GM2BE	CEA: Admin costs/oper. costs amount per M2 usage/garage area	decimal	13	2	CURR	((0))	Yes		VVWBLABEGB
83	BETR_S1OW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLABS1O
84	BETR_S1SW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLABS1S
85	BETR_S2OW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLABS2O
86	BETR_S2SW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLABS2S
87	INST_WM2	CEA: Administration costs/maintenance costs living area	decimal	14	4	QUAN	((0))	Yes		VVWBLAINWM
88	INST_WM2BE	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAINWB
89	INST_NM2	CEA: Administration and maintenance costs of usage area	decimal	14	4	QUAN	((0))	Yes		VVWBLAINNM
90	INST_NM2BE	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAINNB
91	INST_S1OW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAIS1O
92	INST_S1SW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAIS1S
93	INST_GM2	CEA: Admin costs/maintenance costs usable area or garage	decimal	14	4	QUAN	((0))	Yes		VVWBLAIMGM
94	INST_GM2BE	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAINGB
95	INST_S2OW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAIS2O
96	INST_S2SW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAIS2S
97	MIET_WOGE	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAMWOG
98	MIET_GAGE	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAMGAG
99	MIET_GWGE	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAMGWG
100	MIET_GWPR	CEA: Depreciation costs of total interest of other apart.	decimal	5	2	DEC	((0))	Yes		VVWBLAMGWP
101	MIET_WOAOW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAMWOO
102	MIET_WOASW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAMWOS
103	MIET_GAAOW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAMGAO
104	MIET_GAASW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAMGAS
105	MIET_GWAOW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAMGWO
106	MIET_GWASW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLAMGWS
107	SUMME_OW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLASUOW
108	SUMME_SW	CEA: Depreciation costs of total interest of other apart.	decimal	13	2	CURR	((0))	Yes		VVWBLASUSW

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

108 COLUMNS | 1 INDEXES | ERP 6.0 | VIWI05 TABLE

TOP ERP 6.0 | VIWI05 COLUMNS

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

108 COLUMNS | 1 INDEXES | ERP 6.0 | VIWI05 TABLE

TOPERP 6.0 | VIWI05 COLUMNS

TOPERP 6.0 | VIWI05 INDEXES

TOP ERP 6.0 | VIWI05 COLUMNS

TOP ERP 6.0 | VIWI05 INDEXES