	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

183 columns | ERP 6.0 | SWENR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/OPT/VIM_1ITEM_S	Document Item	103	SWENR	Site Number	nvarchar	8	0
2	/OPT/VIM_TITEM	Document Item	103	SWENR	Site Number	nvarchar	8	0
3	REMOB_T_COND	Assign Condition Type & Measurement Type	3	SWENR	Site Number	nvarchar	8	0
4	REMOB_T_LOG	Visit History	4	SWENR	Site Number	nvarchar	8	0
5	VIYCEXPITEM	Expense Items	59	SWENR	Valid Site	nvarchar	8	0
6	VIYCPG	Participation Group for CAM	3	SWENR	Valid Site	nvarchar	8	0
7	VIYCSETTL	Settlement Identification with Log Reference	25	SWENR	Site Number	nvarchar	8	0
8	YVIM_1ITEM	Document Item	103	SWENR	Site Number	nvarchar	8	0
9	ZEIM_VBAK	Sales Document: Header Data	124	SWENR	Business Entity Number	nvarchar	8	0
TOPBasic Data
10	VIBDBE	Business Entity	4	SWENR	Site Number	nvarchar	8	0
11	VIBDBU	Building	4	SWENR	Site Number	nvarchar	8	0
12	VIBDPLANOBJ	Plan Pooled Space	5	SWENR	Site Number	nvarchar	8	0
13	VIBDPLANPS	Plan Pooled Spaces	3	SWENR	Site Number	nvarchar	8	0
14	VIBDPR	Land	4	SWENR	Site Number	nvarchar	8	0
15	VIBDRO	Rental Object	4	SWENR	Site Number	nvarchar	8	0
16	VIBDROOCC	Occupancy History	10	SWENR	Site Number	nvarchar	8	0
TOPDunning
17	MHNK	Dunning data (account entries)	55	SWENR	Site Number	nvarchar	8	0
TOPFinancial Accounting
18	/OPT/VIM_1ITEM	Document Item	103	SWENR	Site Number	nvarchar	8	0
19	KMZEI	FI: Account Assignment Model Item Information	80	SWENR	Site Number	nvarchar	8	0
20	KOMU	Account Assignment Templates for G/L Account Items	80	SWENR	Site Number	nvarchar	8	0
TOPFlexible Real Estate Management
21	VIAKHO13	WEG-Verwaltung: Umlage Eigentümerabrechnung	11	SWENR	Nummer der Wirtschaftseinheit	nvarchar	8	0
22	VIAKHO20	WEG-Verwaltung: Guthaben/Forderungen Eigentümerabrechnung	4	SWENR	Nummer der Wirtschaftseinheit	nvarchar	8	0
23	VIAKHO21	Mandatsverwaltung: Gesplittete Abrechnungsgrößen	3	SWENR	Nummer der Wirtschaftseinheit	nvarchar	8	0
24	VIAKHOIR	WEG-Verwaltung: Stammdaten Bank/ Instandhaltungsrücklage	6	SWENR	Nummer der Wirtschaftseinheit	nvarchar	8	0
25	VIAKHOPO	WEG-Verwaltung: Jahresübersicht Umlage Bank/Rücklagen	9	SWENR	Nummer der Wirtschaftseinheit	nvarchar	8	0
26	VICAINTRENO	Assignment of INTRENO / OBJNR / IMKEY	9	SWENR	Site Number	nvarchar	8	0
27	VIFANLA	LUM: Flurstück - Zugeordnete Anlagenstammsätze	5	SWENR	Nummer der Wirtschaftseinheit	nvarchar	8	0
28	VIFANLA_LOG	LUM: Flurstück - Integration Anlagenbuchhaltung	4	SWENR	Nummer der Wirtschaftseinheit	nvarchar	8	0
29	VIFFLAECHEN	LUM: Flurstück - Flächen Bestand/Nutzung/Anlagen	7	SWENR	Nummer der Wirtschaftseinheit	nvarchar	8	0
30	VIFWEFLAECHEGIS	LUM: Flurstück - Zugeordn. WE-Flächen im GIS Anlagensicht	4	SWENR	Nummer der Wirtschaftseinheit	nvarchar	8	0
31	VIXCSCCHTAPE	Header Data for External Heating Expenses Settlement	7	SWENR	Valid Site	nvarchar	8	0
32	VIXCSCCHTPITEM	Item Data for External Heating Expenses Settlement	5	SWENR	Valid Site	nvarchar	8	0
33	VIXCSCCHTPSHAR	Distribution for External Heating Expenses Settlement	4	SWENR	Valid Site	nvarchar	8	0
TOPInput Tax Treatment
34	VIBECOME	Mietobjekte zum Berichtigungsobjekt (Optionssatzermittlung)	4	SWENR	Nummer der Wirtschaftseinheit	nvarchar	8	0
TOPLogistics - General
35	CHBSPRP	Reports offered at the pre-sales tool	3	SWENR	Site Number	nvarchar	8	0
36	CHBSPRPT	Text table to CHBSPRP	4	SWENR	Site Number	nvarchar	8	0
37	HBSAFF	Affected building in Home Building Solution	3	SWENR	Site Number	nvarchar	8	0
38	HBSAUT	Helper table for auto generation ...	3	SWENR	Site Number	nvarchar	8	0
39	HBSCMP	Community Plan Data within Home Building Solution	3	SWENR	Site Number	nvarchar	8	0
40	HBSFLS	Fit-List	3	SWENR	Site Number	nvarchar	8	0
41	HBSFSP	Help dummy table	3	SWENR	Site Number	nvarchar	8	0
42	HBSPPH	Permitted Development Phases	3	SWENR	Site Number	nvarchar	8	0
43	HBSRLC	Characteristics for Rules	3	SWENR	Site Number	nvarchar	8	0
44	HBSRLS	Affected Building List	3	SWENR	Site Number	nvarchar	8	0
45	HBSSPH	Permitted Sales Phases	3	SWENR	Site Number	nvarchar	8	0
TOPMigration
46	VIGWARARFL	Schlüssel archivierter arch. Flächen	3	SWENR	Talousyksikön numero	nvarchar	8	0
47	VIGWARARRA	Schlüssel archivierter arch. Räume	3	SWENR	Talousyksikön numero	nvarchar	8	0
48	VIGWARFL	Immobilien gew.: Architektonische Fläche (statischer Teil)	16	SWENR	Talousyksikön numero	nvarchar	8	0
49	VIGWARRA	Immobilien gew.: Architektonischer Raum (statischer Teil)	15	SWENR	Talousyksikön numero	nvarchar	8	0
50	VIGWARVMFL	Schlüssel archivierter Mietflächen und -räume	3	SWENR	Talousyksikön numero	nvarchar	8	0
51	VIGWFLGGZU	Immobilien gew.: Fl.-Zuordnung zu Gebäude oder Grundstück	7	SWENR	Talousyksikön numero	nvarchar	8	0
52	VIGWRAGEZU	Immobilien gew.: Ra-Zuordnung zu Gebäude oder Gebäudeteil	7	SWENR	Talousyksikön numero	nvarchar	8	0
53	VIGWVMFLZ	Immobilien gew.:Stammdaten Vermietfldche (zeitabh.Teil)	7	SWENR	Talousyksikön numero	nvarchar	8	0
54	VIGWVOBW	Immobilien gew.: Vorbelegung d.Konditionen f. BuKr/WE/GE/G	3	SWENR	Talousyksikön numero	nvarchar	8	0
55	VIGWVOBW_UPD	Immobilien gew.: Änderungsprotokoll der Konditionsvorbeleg.	3	SWENR	Talousyksikön numero	nvarchar	8	0
56	VIGW_VOBW	CRE Ph.2.1 neu: Vorbelegung d.Konditionen f. BuKr/WE/GE/GR	3	SWENR	Talousyksikön numero	nvarchar	8	0
57	VIGW_VOBW_UPD	Immobilien gew.: Änderungsprotokoll der Konditionsvorbeleg.	3	SWENR	Talousyksikön numero	nvarchar	8	0
TOPProfit Center Accounting
58	KE1_WU_IM_ITEM	PCA Where-Used List: Itemization for Real Estate	13	SWENR	Site Number	nvarchar	8	0
TOPReal Estate Localization Czech Republic
59	/CEERE/SDANA	Property tax return - items	14	SWENR	Site Number	nvarchar	8	0
60	/CEERE/SDANJEDN	Property tax - units	4	SWENR	Site Number	nvarchar	8	0
61	/CEERE/SDANP	Property tax - master	5	SWENR	Site Number	nvarchar	8	0
62	/CEERE/SDANPARC	Property tax - plots of land	4	SWENR	Site Number	nvarchar	8	0
TOPReal Estate Management
63	ONRIA	Calculation unit object number index	4	SWENR	Site Number	nvarchar	8	0
64	ONRIM	Rental unit object number index	4	SWENR	Site Number	nvarchar	8	0
65	ONRIV	Rental agreement item object number index	5	SWENR	Site Number	nvarchar	8	0
66	S401	RE standard analysis partner	14	SWENR	Site Number	nvarchar	8	0
67	S402	Business entities	74	SWENR	Site Number	nvarchar	8	0
68	S404	Properties	74	SWENR	Site Number	nvarchar	8	0
69	S405	Building	14	SWENR	Site Number	nvarchar	8	0
70	S406	Rental units	16	SWENR	Site Number	nvarchar	8	0
71	S407	Rental agreements	148	SWENR	Site Number	nvarchar	8	0
72	S408	Land registers	88	SWENR	Site Number	nvarchar	8	0
73	VIAK01	History of acct settlement runs	3	SWENR	Site Number	nvarchar	8	0
74	VIAK02	Settlement Participation for Service Charge Settlement	4	SWENR	Site Number	nvarchar	8	0
75	VIAK03	Settlement Unit Master Record	3	SWENR	Valid business entity	nvarchar	8	0
76	VIAK04	Allocation of Settlement Variants to Settlement Unit	3	SWENR	Site Number	nvarchar	8	0
77	VIAK05	Allocation of rental units to calculation unit	3	SWENR	Site Number	nvarchar	8	0
78	VIAK06	Calculation unit relations	6	SWENR	Site Number	nvarchar	8	0
79	VIAK07	Calculation unit option rate	3	SWENR	Site Number	nvarchar	8	0
80	VIAK08	DME Settlement Units Master Data	4	SWENR	Site Number	nvarchar	8	0
81	VIAK09	Assignment of Heating Systems to Calculation Units	6	SWENR	Site Number	nvarchar	8	0
82	VIAK11	Inclusion of acct settlement results from D-tape	4	SWENR	Site Number	nvarchar	8	0
83	VIAK13	Apportionment Result for List Evaluation (SCSettlement)	10	SWENR	Site Number	nvarchar	8	0
84	VIAK14	RA credit memo/receivable:now only used as structure!	4	SWENR	Site Number	nvarchar	8	0
85	VIAK17	Interface for settlement / transfer of advance payments	5	SWENR	Site Number	nvarchar	8	0
86	VIAK18	Management fee surcharge for service charges settlement	5	SWENR	Site Number	nvarchar	8	0
87	VIAK19	Costs Directly Assigned to Lease-Out	12	SWENR	Site Number	nvarchar	8	0
88	VIAK20	RA credit memo/receivable (incid.exp.sttlmnt created)	4	SWENR	Site Number	nvarchar	8	0
89	VIAK21	Split settlement factors for settlement variant	3	SWENR	Site Number	nvarchar	8	0
90	VIAK22	Heat.oil supply	3	SWENR	Site Number	nvarchar	8	0
91	VIAK22T	Heat.oil supply texts	3	SWENR	Site Number	nvarchar	8	0
92	VIAK24	Service charges settlement: Allocate RU to set of part. RUs	5	SWENR	Site Number	nvarchar	8	0
93	VIAK25	Cost collector for SU (per settlement period)	3	SWENR	Valid business entity	nvarchar	8	0
94	VIAK26	Master Settlement Unit: Participating Settlement Units	3	SWENR	Valid business entity	nvarchar	8	0
95	VIAKBSEG	Document Line Item from SCS for Interface	98	SWENR	Site Number	nvarchar	8	0
96	VIAKT5	Rental units allocation ID	4	SWENR	Site Number	nvarchar	8	0
97	VIARMV	Key for archived lease-outs	4	SWENR	Site Number	nvarchar	8	0
98	VIAROBJ	Archived real estate objects	10	SWENR	Site Number	nvarchar	8	0
99	VIBEME	Assign rental units to correction items	4	SWENR	Site Number	nvarchar	8	0
100	VIBEPP	Flow data - Planned items for real estate management	9	SWENR	Site Number	nvarchar	8	0
101	VIGBSTD	Real estate register of land register	17	SWENR	Site Number	nvarchar	8	0
102	VILIC	ICI Historical Data	6	SWENR	Site Number	nvarchar	8	0
103	VILID	ICI Historical Data of D-Building	5	SWENR	Site Number	nvarchar	8	0
104	VILIR	IRE Historical data	7	SWENR	Site Number	nvarchar	8	0
105	VIMI01	Rental unit - Master data	3	SWENR	Site Number	nvarchar	8	0
106	VIMI02	Fixtures and Fittings Characteristics of a Rental Unit	3	SWENR	Site Number	nvarchar	8	0
107	VIMI04	Old. replaced in 3.0 with VIMIMV	4	SWENR	Site Number	nvarchar	8	0
108	VIMI07	Reported Sales for Sales-Based Lease-Out	4	SWENR	Site Number	nvarchar	8	0
109	VIMI08	Apportionment units per rental unit	3	SWENR	Site Number	nvarchar	8	0
110	VIMI09	Graded Lease-Out	4	SWENR	Site Number	nvarchar	8	0
111	VIMI10	Rental agreement additional text	5	SWENR	Site Number	nvarchar	8	0
112	VIMI14	RA: Adjustment block for terms types	4	SWENR	Site Number	nvarchar	8	0
113	VIMI16	RE: Records of a Rent Adjustment Run	4	SWENR	Site Number	nvarchar	8	0
114	VIMI18	Rent Adjustment History for Lease-Out	4	SWENR	Site Number	nvarchar	8	0
115	VIMI20	Compar.accommod.:Assign RU or ext. comp.aprtmnt to accommod.	6	SWENR	Site Number	nvarchar	8	0
116	VIMI21	Alloc. rental unit - comparative accomm. for rent adjustment	3	SWENR	Site Number	nvarchar	8	0
117	VIMI22	Assignment / Rental unit - rental request offers	3	SWENR	Site Number	nvarchar	8	0
118	VIMI23	Determination of Year and Percent for Sls-Bsd LO	4	SWENR	Site Number	nvarchar	8	0
119	VIMI24	Percentage for Sales for Sales-Based Lease-Out	4	SWENR	Site Number	nvarchar	8	0
120	VIMI25	Sales reports	4	SWENR	Site Number	nvarchar	8	0
121	VIMI26	Notice of rental agreement	4	SWENR	Site Number	nvarchar	8	0
122	VIMI28	Sales settlement histories	4	SWENR	Site Number	nvarchar	8	0
123	VIMI31	Allocation of rental units to modernization measure	4	SWENR	Site Number	nvarchar	8	0
124	VIMI32	Other collateral	4	SWENR	Site Number	nvarchar	8	0
125	VIMI33	Offers for a rental unit (-> VIMIMV)	4	SWENR	Site Number	nvarchar	8	0
126	VIMI34	Determine year and percent for sales-based agreement (offer)	4	SWENR	Site Number	nvarchar	8	0
127	VIMI35	Percent for sales for sales-based rental agrmnt (offer)	4	SWENR	Site Number	nvarchar	8	0
128	VIMI36	Index-Linked Lease-Out Offer	4	SWENR	Site Number	nvarchar	8	0
129	VIMI37	RA offer: Adjustment block for term types	4	SWENR	Site Number	nvarchar	8	0
130	VIMI39	Tenant change; data for apartment inspection	4	SWENR	Site Number	nvarchar	8	0
131	VIMI40	Tenant change: Data on release of rental deposits	4	SWENR	Site Number	nvarchar	8	0
132	VIMI43	Allocation of expert opinion to rental units	4	SWENR	Site Number	nvarchar	8	0
133	VIMI47	Tenant change: Alloc.of maint.orders to sec.deposit release	4	SWENR	Site Number	nvarchar	8	0
134	VIMIMV	Lease-Out	5	SWENR	Site Number	nvarchar	8	0
135	VIMITH	Rental agreement number and doc.number for printing invoices	3	SWENR	Site Number	nvarchar	8	0
136	VIOB01	Business entities	3	SWENR	Site Number	nvarchar	8	0
137	VIOB02	Property master data	3	SWENR	Site Number	nvarchar	8	0
138	VIOB03	Real estate building master	3	SWENR	Site Number	nvarchar	8	0
139	VIOB04	Buildings: Fixtures and fittings characteristics	3	SWENR	Site Number	nvarchar	8	0
140	VIOB05	Building option rate	3	SWENR	Site Number	nvarchar	8	0
141	VIOB06	Property option rate	3	SWENR	Site Number	nvarchar	8	0
142	VIOB07	Business entity option rate	3	SWENR	Site Number	nvarchar	8	0
143	VIOB08	Room	3	SWENR	Site Number	nvarchar	8	0
144	VIOB09	Areas for each Rental Unit (Obsolete)	3	SWENR	Site Number	nvarchar	8	0
145	VIOB10	Number of rooms per rental unit	3	SWENR	Site Number	nvarchar	8	0
146	VIOB14	Areas for Building (Obsolete)	3	SWENR	Site Number	nvarchar	8	0
147	VIOB15	Areas for properties	3	SWENR	Site Number	nvarchar	8	0
148	VIOB20	Fixtures and fittings objects for building	3	SWENR	Site Number	nvarchar	8	0
149	VIOB22	Rooms	6	SWENR	Site Number	nvarchar	8	0
150	VIOB24	Rental units per usage type (plan)	3	SWENR	Site Number	nvarchar	8	0
151	VIOB27	Relationship between properties and buildings	3	SWENR	Site Number	nvarchar	8	0
152	VIOB28	OLD, replaced by VIOB39 for 3.0	6	SWENR	Site Number	nvarchar	8	0
153	VIOB29	OLD, replaced by VIOB39 for 3.0	6	SWENR	Site Number	nvarchar	8	0
154	VIOB35	Productive Holdings	6	SWENR	Site Number	nvarchar	8	0
155	VIOB38	Relationship between Real Estate objects and SAP-PS	6	SWENR	Site Number	nvarchar	8	0
156	VIOB39	Relationship between Real Estate objects and SAP-PM	6	SWENR	Site Number	nvarchar	8	0
157	VIROZ	Real Estate: IPD reporting additional fields	3	SWENR	Site Number	nvarchar	8	0
158	VIRPS405	Building	14	SWENR	Site Number	nvarchar	8	0
159	VIRPS406	Rental units	16	SWENR	Site Number	nvarchar	8	0
160	VIRPS407	Rental agreements	148	SWENR	Site Number	nvarchar	8	0
161	VIVW05	Management contract: Managed objects	9	SWENR	Site Number	nvarchar	8	0
162	VIVW08	Events for management contracts	10	SWENR	Site Number	nvarchar	8	0
163	VIWB10	Mieteinheitenzuordnung der Wirtschaftlichkeitsberechnung	4	SWENR	Nummer der Wirtschaftseinheit	nvarchar	8	0
164	VIWB52	WB: Laufende Aufwendungen II - ME-Zuordnung zu Bewirtschaft.	6	SWENR	Nummer der Wirtschaftseinheit	nvarchar	8	0
165	VIWEGB	Relation table between buildings and assets	3	SWENR	Site Number	nvarchar	8	0
166	VIWEGR	Relation table between property and assets	3	SWENR	Site Number	nvarchar	8	0
167	VIWI01	Cost Efficiency Analysis Total Costs	3	SWENR	Site Number	nvarchar	8	0
168	VIWI02	Cost Efficiency Analysis Finance Plan	3	SWENR	Site Number	nvarchar	8	0
169	VIWI03	Cost Efficiency Analysis Current Expenditure	3	SWENR	Site Number	nvarchar	8	0
170	VIWI04	Cost Efficiency Analysis Average Rent/Charges	3	SWENR	Site Number	nvarchar	8	0
171	VIWI05	Cost Efficiency Analysis Current Expenditure	3	SWENR	Site Number	nvarchar	8	0
172	VIWIGK	Cost Efficiency Analysis Total Costs	3	SWENR	Site Number	nvarchar	8	0
173	VIWIRT	Cost Efficiency Analysis Basic Table	3	SWENR	Site Number	nvarchar	8	0
174	VIWIV1	Simplified CEA: Property and Building Description	3	SWENR	Site Number	nvarchar	8	0
175	VIWIV2	Simplified CEA: Calculation of Total Costs	3	SWENR	Site Number	nvarchar	8	0
176	VIWIV3	Simplified CEA: Finance Plan Outside Funds	3	SWENR	Site Number	nvarchar	8	0
177	VIWIV4	Simplified CEA: Finance Plan Internal Activities	3	SWENR	Site Number	nvarchar	8	0
178	VIZNRN	Assignment: Real Estate numbers <-> IMKEY <-> INTRENO	5	SWENR	Site Number	nvarchar	8	0
TOPReal Estate Slovakia
179	VIXCSKSDANP	Property Tax - Master data	5	SWENR	Site Number	nvarchar	8	0
180	VIXCSKTAXRET_P	Property Tax Return SK - Items - Sections II,III,IV	7	SWENR	Site Number	nvarchar	8	0
TOPSales
181	VBAK	Sales Document: Header Data	124	SWENR	Business Entity Number	nvarchar	8	0
TOPService Charge Settlement
182	VISCPG	Participation Group	4	SWENR	Valid Site	nvarchar	8	0
183	VISCSU	Settlement unit	4	SWENR	Valid Site	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

183 columns | ERP 6.0 | SWENR