	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

	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

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
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

58 columns | ERP 6.0 | SGENR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/OPT/VIM_1ITEM_S	Document Item	25	SGENR	Building Number	nvarchar	8	0
2	/OPT/VIM_TITEM	Document Item	25	SGENR	Building Number	nvarchar	8	0
3	REMOB_T_COND	Assign Condition Type & Measurement Type	4	SGENR	Number of Building	nvarchar	8	0
4	REMOB_T_LOG	Visit History	5	SGENR	Number of Building	nvarchar	8	0
5	VIXCITCADRO	Temporary rental object data	27	SGENR	Number of Building	nvarchar	8	0
6	VIYCPG	Participation Group for CAM	4	SGENR	Number of Building	nvarchar	8	0
7	YVIM_1ITEM	Document Item	25	SGENR	Building Number	nvarchar	8	0
TOPBasic Data
8	VIBDBU	Building	5	SGENR	Number of Building	nvarchar	8	0
9	VIBDPLANPS	Plan Pooled Spaces	5	SGENR	Number of Building	nvarchar	8	0
10	VIBDRO	Rental Object	26	SGENR	Number of Building	nvarchar	8	0
TOPFinancial Accounting
11	/OPT/VIM_1ITEM	Document Item	25	SGENR	Building Number	nvarchar	8	0
12	KMZEI	FI: Account Assignment Model Item Information	81	SGENR	Building Number	nvarchar	8	0
13	KOMU	Account Assignment Templates for G/L Account Items	81	SGENR	Building Number	nvarchar	8	0
TOPFlexible Real Estate Management
14	VICAINTRENO	Assignment of INTRENO / OBJNR / IMKEY	11	SGENR	Number of Building	nvarchar	8	0
TOPLogistics - General
15	HBSAFF	Affected building in Home Building Solution	4	SGENR	Building Number	nvarchar	8	0
16	HBSFLS	Fit-List	4	SGENR	Building Number	nvarchar	8	0
17	HBSFSP	Help dummy table	4	SGENR	Building Number	nvarchar	8	0
TOPMigration
18	VIGWARARFL	Schlüssel archivierter arch. Flächen	4	SGENR	Rakennuksen numero	nvarchar	8	0
19	VIGWARARRA	Schlüssel archivierter arch. Räume	4	SGENR	Rakennuksen numero	nvarchar	8	0
20	VIGWARFL	Immobilien gew.: Architektonische Fläche (statischer Teil)	18	SGENR	Rakennuksen numero	nvarchar	8	0
21	VIGWARRA	Immobilien gew.: Architektonischer Raum (statischer Teil)	16	SGENR	Rakennuksen numero	nvarchar	8	0
22	VIGWFLGGZU	Immobilien gew.: Fl.-Zuordnung zu Gebäude oder Grundstück	9	SGENR	Rakennuksen numero	nvarchar	8	0
23	VIGWRAGEZU	Immobilien gew.: Ra-Zuordnung zu Gebäude oder Gebäudeteil	8	SGENR	Rakennuksen numero	nvarchar	8	0
24	VIGWVMFLZ	Immobilien gew.:Stammdaten Vermietfldche (zeitabh.Teil)	17	SGENR	Rakennuksen numero	nvarchar	8	0
25	VIGWVOBW	Immobilien gew.: Vorbelegung d.Konditionen f. BuKr/WE/GE/G	4	SGENR	Rakennuksen numero	nvarchar	8	0
26	VIGWVOBW_UPD	Immobilien gew.: Änderungsprotokoll der Konditionsvorbeleg.	4	SGENR	Rakennuksen numero	nvarchar	8	0
27	VIGW_VOBW	CRE Ph.2.1 neu: Vorbelegung d.Konditionen f. BuKr/WE/GE/GR	4	SGENR	Rakennuksen numero	nvarchar	8	0
28	VIGW_VOBW_UPD	Immobilien gew.: Änderungsprotokoll der Konditionsvorbeleg.	4	SGENR	Rakennuksen numero	nvarchar	8	0
TOPProfit Center Accounting
29	KE1_WU_IM_ITEM	PCA Where-Used List: Itemization for Real Estate	15	SGENR	Building Number	nvarchar	8	0
TOPReal Estate Management
30	S401	RE standard analysis partner	16	SGENR	Building Number	nvarchar	8	0
31	S405	Building	15	SGENR	Building Number	nvarchar	8	0
32	S406	Rental units	18	SGENR	Building: number	nvarchar	8	0
33	S407	Rental agreements	78	SGENR	Building Number	nvarchar	8	0
34	VIAKBSEG	Document Line Item from SCS for Interface	99	SGENR	Building Number	nvarchar	8	0
35	VIARMV	Key for archived lease-outs	7	SGENR	Building Number	nvarchar	8	0
36	VIAROBJ	Archived real estate objects	12	SGENR	Building Number	nvarchar	8	0
37	VIBEPP	Flow data - Planned items for real estate management	75	SGENR	Building Number	nvarchar	8	0
38	VIMI01	Rental unit - Master data	6	SGENR	Building Number	nvarchar	8	0
39	VIOB03	Real estate building master	4	SGENR	Building Number	nvarchar	8	0
40	VIOB04	Buildings: Fixtures and fittings characteristics	4	SGENR	Building Number	nvarchar	8	0
41	VIOB05	Building option rate	4	SGENR	Building Number	nvarchar	8	0
42	VIOB08	Room	4	SGENR	Building Number	nvarchar	8	0
43	VIOB14	Areas for Building (Obsolete)	4	SGENR	Building Number	nvarchar	8	0
44	VIOB20	Fixtures and fittings objects for building	4	SGENR	Building Number	nvarchar	8	0
45	VIOB22	Rooms	7	SGENR	Building Number	nvarchar	8	0
46	VIOB24	Rental units per usage type (plan)	5	SGENR	Building Number	nvarchar	8	0
47	VIOB27	Relationship between properties and buildings	5	SGENR	Building Number	nvarchar	8	0
48	VIOB28	OLD, replaced by VIOB39 for 3.0	8	SGENR	Building Number	nvarchar	8	0
49	VIOB29	OLD, replaced by VIOB39 for 3.0	8	SGENR	Building Number	nvarchar	8	0
50	VIOB38	Relationship between Real Estate objects and SAP-PS	8	SGENR	Building Number	nvarchar	8	0
51	VIOB39	Relationship between Real Estate objects and SAP-PM	8	SGENR	Building Number	nvarchar	8	0
52	VIRPS405	Building	15	SGENR	Building Number	nvarchar	8	0
53	VIRPS406	Rental units	18	SGENR	Building: number	nvarchar	8	0
54	VIRPS407	Rental agreements	78	SGENR	Building Number	nvarchar	8	0
55	VIVW05	Management contract: Managed objects	11	SGENR	Building Number	nvarchar	8	0
56	VIVW08	Events for management contracts	12	SGENR	Building Number	nvarchar	8	0
57	VIWEGB	Relation table between buildings and assets	4	SGENR	Building Number	nvarchar	8	0
58	VIZNRN	Assignment: Real Estate numbers <-> IMKEY <-> INTRENO	7	SGENR	Building Number	nvarchar	8	0

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

58 columns | ERP 6.0 | SGENR