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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

B1 8.8: Top 10 requests

	Table	Columns	Description
1	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OINM	101	Whse Journal
6	OVPM	154	Outgoing Payments
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Real Estate Management
1	ERP EHP7	6.0	S407	193	1	Rental agreements	Real Estate Management

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	SSOUR	Statistic(s) origin	nvarchar	4	0	Allow NULL?
3	VRSIO	Version number in the information structure	nvarchar	3	0	Allow NULL?
4	SPMON	Period to analyze - month	nvarchar	6	0	Allow NULL?
5	SPTAG	Period to analyze - current date	nvarchar	8	0	Allow NULL?
6	SPWOC	Period to analyze - week	nvarchar	6	0	Allow NULL?
7	SPBUP	Period to analyze - posting period	nvarchar	6	0	Allow NULL?
8	BUKRS_01	Company Code	nvarchar	4	0	Allow NULL?
9	GSBER_02	Business Area	nvarchar	4	0	Allow NULL?
10	SWENR_03	Site Number	nvarchar	8	0	Allow NULL?
11	SGRNR_04	Property Number for BE	nvarchar	8	0	Allow NULL?
12	SGENR_05	Building Number	nvarchar	8	0	Allow NULL?
13	SMENR_06	Number of Rental Unit	nvarchar	8	0	Allow NULL?
14	SMIVE_07	Lease-Out Number	nvarchar	13	0	Allow NULL?
15	PERIV	Fiscal Year Variant	nvarchar	2	0	Allow NULL?
16	VWDAT	Pointer to administrative data	nvarchar	10	0	Allow NULL?
17	USRUNIT	User field: Unit for quantity fields	nvarchar	3	0	Allow NULL?
18	USRCUKY	User field: Unit for value fields	nvarchar	5	0	Allow NULL?
19	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
20	FEINS	Area unit	nvarchar	3	0	Allow NULL?
21	DERSTDR	Date When the Lease-Out was First Printed	nvarchar	8	0	Allow NULL?
22	PROFL	Settlement profile for costs	nvarchar	6	0	Allow NULL?
23	ABNNR	Settlement firm: number	nvarchar	20	0	Allow NULL?
24	STECHEM	Settlement firm: Evaluation group	nvarchar	13	0	Allow NULL?
25	ABNUNR	Settlement company: subnumber	nvarchar	3	0	Allow NULL?
26	XNNPARTABW	Alternative payer: surname	nvarchar	20	0	Allow NULL?
27	XPARTNRABW	Alternative payer: name	nvarchar	35	0	Allow NULL?
28	XORT	Address: City	nvarchar	35	0	Allow NULL?
29	XPLZ	Address: Postal code	nvarchar	10	0	Allow NULL?
30	XSTRASSE	Address: Street/house number	nvarchar	35	0	Allow NULL?
31	ANKUEN	Notification until (for renewal of contract)	nvarchar	2	0	Allow NULL?
32	XMVANART	Lease-out primary adjustment type	nvarchar	15	0	Allow NULL?
33	XMVANART44	Lease-Out Secondary Adjustment Type	nvarchar	15	0	Allow NULL?
34	DASPVON	Adjustment block as from	nvarchar	8	0	Allow NULL?
35	DASPBIS	Adjustment block until	nvarchar	8	0	Allow NULL?
36	ANZMV	No. of lease-outs	decimal	6	0
37	AZIMM	Number of rooms	decimal	6	0
38	AHALBZI	Number of half rooms	decimal	6	0
39	SKUEFR	Type of notice period	char	1	0	Allow NULL?
40	SAUSTKL	Fixtures and fittings category	nvarchar	2	0	Allow NULL?
41	BANKKS	Bank Keys	nvarchar	15	0	Allow NULL?
42	DBKERH	Cash deposit received on	nvarchar	8	0	Allow NULL?
43	MEINS	Base Unit of Measure	nvarchar	3	0	Allow NULL?
44	XBELEGNG	RU occupancy by LO (used by third-prty/private/corp.grp)	nvarchar	30	0	Allow NULL?
45	SBELEGNG	RU occupancy by LO (used by third-prty/private/corp.grp)	char	1	0	Allow NULL?
46	USR02	User-defined field 1 for 10 characters	nvarchar	10	0	Allow NULL?
47	USR03	User-defined field 2 for 10 characters	nvarchar	10	0	Allow NULL?
48	USR00	User-defined field 1 for 20 characters	nvarchar	20	0	Allow NULL?
49	USR01	User field 2 for 20 characters	nvarchar	20	0	Allow NULL?
50	USR08	User field 1 for date	nvarchar	8	0	Allow NULL?
51	USR09	User field 2 for date	nvarchar	8	0	Allow NULL?
52	USRUNIT1	User field: Unit for quantity fields	nvarchar	3	0	Allow NULL?
53	USRCUKY2	User field: Unit for value fields	nvarchar	5	0	Allow NULL?
54	USRCUKY1	User field: Unit for value fields	nvarchar	5	0	Allow NULL?
55	USRUNIT2	User field: Unit for quantity fields	nvarchar	3	0	Allow NULL?
56	USR10	User field 1 indicator for evaluations	char	1	0	Allow NULL?
57	USR11	User field 2 indicator for evaluations	char	1	0	Allow NULL?
58	USR04	User Field 1 for Set (Length 12,3)	decimal	15	3
59	USR05	User Field 2 for Set (Length 12,3)	decimal	15	3
60	USR06	User field 1 for values (length 10.3)	decimal	13	3
61	USR07	User field 2 for values (length 10.3)	decimal	13	3
62	JBETRST	Security deposit granted	char	1	0	Allow NULL?
63	BKONDQM	Currency amount per area unit	decimal	13	2
64	FBEZUG	Reference area for calculation of amounts per area unit	decimal	15	2
65	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
66	DERZAHL	Date: 1st debit position	nvarchar	8	0	Allow NULL?
67	DAKTV	Date: Activation	nvarchar	8	0	Allow NULL?
68	DAUSZG	Date: Move-out	nvarchar	8	0	Allow NULL?
69	DEINZG	Date: Move-in	nvarchar	8	0	Allow NULL?
70	DKUEZU	Date: Notice	nvarchar	8	0	Allow NULL?
71	DMIBEG	Date: Start of rent	nvarchar	8	0	Allow NULL?
72	DMIEND	Date: rental end	nvarchar	8	0	Allow NULL?
73	DUNTBIS	Date: Provisional agreement from	nvarchar	8	0	Allow NULL?
74	ZUSPKUNNR	Subsidizer: Customer number	nvarchar	10	0	Allow NULL?
75	BABRE	Settlement units	decimal	14	4
76	PERHOE	Percentage rate increase	decimal	10	2
77	FKONDFLA	Area for condition type	decimal	15	2
78	SGENR	Building Number	nvarchar	8	0	Allow NULL?
79	XGEBT	Building: part	nvarchar	15	0	Allow NULL?
80	SGEBT	Part of Building	nvarchar	2	0	Allow NULL?
81	GERSTD	Jurisdiction	nvarchar	35	0	Allow NULL?
82	SSTOCKW	Floor	nvarchar	3	0	Allow NULL?
83	XSTOCKW	Floor (text)	nvarchar	15	0	Allow NULL?
84	GSBER	Business Area	nvarchar	4	0	Allow NULL?
85	XASPGRD	Reason for adjustment block (text)	nvarchar	30	0	Allow NULL?
86	XMANSP	Dunning block reason	nvarchar	30	0	Allow NULL?
87	SASPGRD	Reason for adjustment block	nvarchar	2	0	Allow NULL?
88	SGRNR	Property Number for BE	nvarchar	8	0	Allow NULL?
89	KUNNR	Main tenant: Customer number	nvarchar	10	0	Allow NULL?
90	XNNPART	Master tenant: last name	nvarchar	20	0	Allow NULL?
91	XPARTNR	Master tenant: name	nvarchar	35	0	Allow NULL?
92	INTRENO	Internal Real Estate Master Data Code	nvarchar	13	0	Allow NULL?
93	DKAUFOPT	Purchase option: date	nvarchar	8	0	Allow NULL?
94	JKAUFOPT	Purchase option: indicator	char	1	0	Allow NULL?
95	BKAUTION	Deposit: amount	decimal	13	2
96	JMFREI	Condition is not checked	char	1	0	Allow NULL?
97	DGULTAB	Condition: effective from	nvarchar	8	0	Allow NULL?
98	SKOART	Condition Type (Smallest Subdivision of Condition Records)	nvarchar	4	0	Allow NULL?
99	BKOND	Condition item currency amount	decimal	15	2
100	KOSTL	Cost center: name	nvarchar	10	0	Allow NULL?
101	DATAB	Cost center: effective from_	nvarchar	8	0	Allow NULL?
102	XKUEFR	Type of notice period	nvarchar	30	0	Allow NULL?
103	DKUEFR	Notice period: months	decimal	6	0
104	XLGESCH	Location in floor (text)	nvarchar	15	0	Allow NULL?
105	RLGESCH	Location on Floor	nvarchar	2	0	Allow NULL?
106	SLAGK	Location class	nvarchar	2	0	Allow NULL?
107	MANSP	Dunning: Blocking reason	char	1	0	Allow NULL?
108	JMAHNMSP	Dunning: Block indicator	char	1	0	Allow NULL?
109	MABER	Dunning: area	nvarchar	2	0	Allow NULL?
110	MADAT	Date of last dunning letter	nvarchar	8	0	Allow NULL?
111	MANST	Dunning: level	char	1	0	Allow NULL?
112	BMWST	Value-added tax amount included	decimal	13	2
113	AMELDIN	Sales reporting interval	nvarchar	2	0	Allow NULL?
114	SMENR	Number of Rental Unit	nvarchar	8	0	Allow NULL?
115	XMBEZ	Reason for rent reduction	nvarchar	30	0	Allow NULL?
116	SKAUTART	Type of Rental Collateral	char	1	0	Allow NULL?
117	XKAUTART	Deposit: type	nvarchar	15	0	Allow NULL?
118	XAUSTKL	Represent. list of rents: Fixture/fitting category	nvarchar	15	0	Allow NULL?
119	XLAGK	Representative list of rents: locat.class	nvarchar	30	0	Allow NULL?
120	XMIETSP	Representative list of rents: allocation	nvarchar	15	0	Allow NULL?
121	SMIETSP	Representative list of rents assignment	nvarchar	6	0	Allow NULL?
122	SMIVE	Lease-Out Number	nvarchar	13	0	Allow NULL?
123	XMVART	Lease out: Type	nvarchar	15	0	Allow NULL?
124	FLG_MITARB	Employee indicator	char	1	0	Allow NULL?
125	OBJNR	Object number	nvarchar	22	0	Allow NULL?
126	SPARTNR	Partner number	nvarchar	22	0	Allow NULL?
127	SMVANART	Rental agreement primary adjustment type	char	1	0	Allow NULL?
128	PRCTR	Profit Center	nvarchar	10	0	Allow NULL?
129	JBKRZ	Cash deposit instalment payment	char	1	0	Allow NULL?
130	REINS	Unit for cubic volume	nvarchar	3	0	Allow NULL?
131	JRMSCHPR	Tenant service charge settlement?	char	1	0	Allow NULL?
132	DGABANRT44	Secondary adjustment type valid from	nvarchar	8	0	Allow NULL?
133	DBISANRT44	Secondary adjustment type valid until	nvarchar	8	0	Allow NULL?
134	SMVANART44	Rental agreement secondary adjustment type	char	1	0	Allow NULL?
135	SICHGEB	Guarantor	nvarchar	30	0	Allow NULL?
136	JSKUEND	Special right of notice	char	1	0	Allow NULL?
137	STTXT_EXT	Status: Set by user	nvarchar	40	0	Allow NULL?
138	STTXT_INT	Status: Set by system	nvarchar	40	0	Allow NULL?
139	DGAB	Date when the apportionment factor becomes valid	nvarchar	8	0	Allow NULL?
140	SABRG	Apportionment unit	nvarchar	4	0	Allow NULL?
141	PPROZ0	Sales: minimum percentage	decimal	5	2
142	BMINUMS	Sales: minimum	decimal	13	2
143	BUMSPROJ	Sales: plan	decimal	13	2
144	DVMUN	Contract signed by landlord	nvarchar	8	0	Allow NULL?
145	VERLG	Contract renewal by ... months	nvarchar	3	0	Allow NULL?
146	SMVART	External Real Estate contract type	nvarchar	4	0	Allow NULL?
147	JVERL	Contract renewal	char	1	0	Allow NULL?
148	SWENR	Site Number	nvarchar	8	0	Allow NULL?
149	XGZLSCH	Payment method for credit memos	nvarchar	30	0	Allow NULL?
150	ZLSCH	Payment Method	char	1	0	Allow NULL?
151	XZLSCH	Payment method	nvarchar	30	0	Allow NULL?
152	GZLSCH	Payment method for credit memos	char	1	0	Allow NULL?
153	PZUABSP	Surcharge or reduction for representative list of rents	decimal	10	2
154	PROZTEIL	Subsidy percentage rate	decimal	5	2
155	DGUELTAB	Date as from when subsidy valid	nvarchar	8	0	Allow NULL?
156	DGUELBIS	Date up to when subsidy valid	nvarchar	8	0	Allow NULL?
157	DFAELL	Subsidy due date	nvarchar	8	0	Allow NULL?
158	BZUBETR	Subsidy/allowance amount	decimal	13	2
159	BMAXBETR	Subsidy/grant maximum amount	decimal	13	2
160	XZUSPKUNNR	Subsidizer	nvarchar	35	0	Allow NULL?
161	ZUSP	Subsidies available, indicator	char	1	0	Allow NULL?
162	SPARTNRABW	Alternative payer (partner number)	nvarchar	10	0	Allow NULL?
163	DAENDDR	Date When the Lease-Out was Changed and Printed Out	nvarchar	8	0	Allow NULL?
164	DMIENKUE	End Date of Lease-Out	nvarchar	8	0	Allow NULL?
165	E_SMIVE	Contract No. of Collective Lease-Outs	nvarchar	13	0	Allow NULL?
166	IND_SECTOR	Industry of master tenant	nvarchar	4	0	Allow NULL?
167	XIND_SECT	Industry of master tenant	nvarchar	20	0	Allow NULL?
168	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	Allow NULL?
169	JVSTOPT	Input tax opting (indicator)	char	1	0	Allow NULL?
170	SVSTSOND	Input tax opting reason	char	1	0	Allow NULL?
171	XVSTSOND	Input tax opting reason	nvarchar	20	0	Allow NULL?
172	SKUEKEY	Notice rule	nvarchar	12	0	Allow NULL?
173	SKUEART	Notice Type of Lease-Out	char	1	0	Allow NULL?
174	XKUEART	Notice Type of Lease-Out	nvarchar	20	0	Allow NULL?
175	HBKID	Short Key for a House Bank	nvarchar	5	0	Allow NULL?
176	FEHLBEL	Reference code false occupancy charges	nvarchar	20	0	Allow NULL?
177	R1DATUM	1st date for vacating	nvarchar	8	0	Allow NULL?
178	R2DATUM	2nd date for vacating	nvarchar	8	0	Allow NULL?
179	KLDATUM	Date of complaint	nvarchar	8	0	Allow NULL?
180	KLAKTZEI	Complaint reference code	nvarchar	20	0	Allow NULL?
181	TXJCD	Tax Jurisdiction	nvarchar	15	0	Allow NULL?
182	DFLOWFIX	Flows fixed upto	nvarchar	8	0	Allow NULL?
183	KONTOBV	Bank procedure account number	nvarchar	10	0	Allow NULL?
184	ZLSCH_DEB	Customer payment methods	nvarchar	10	0	Allow NULL?
185	GZLSCH_DEB	Payment methods for customer credit memos	nvarchar	10	0	Allow NULL?
186	DGUELAB	Date when the rent adjustment becomes valid	nvarchar	8	0	Allow NULL?
187	XSTANDNR	Number of garage / parking space	nvarchar	5	0	Allow NULL?
188	OSMIVE	Number of old contract	nvarchar	20	0	Allow NULL?
189	SDUNMOD	Dunning level for dunning of non-approved rent adjustments	nvarchar	4	0	Allow NULL?
190	SKOTYP	Condition category	nvarchar	3	0	Allow NULL?
191	DUMMYFIELD	Single-Character Indicator	char	1	0	Allow NULL?
192	SNUNR	Rental unit external usage type	nvarchar	4	0	Allow NULL?
193	XNUNR	Rental unit usage type (text)	nvarchar	30	0	Allow NULL?

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

193 COLUMNS | 1 INDEXES | ERP 6.0 | S407 TABLE

TOP ERP 6.0 | S407 COLUMNS

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

193 COLUMNS | 1 INDEXES | ERP 6.0 | S407 TABLE

TOPERP 6.0 | S407 COLUMNS

TOPERP 6.0 | S407 INDEXES

TOP ERP 6.0 | S407 COLUMNS

TOP ERP 6.0 | S407 INDEXES