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	S408	89	1	Land registers	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	T000	MANDT	Allow NULL?
2	SSOUR	Statistic(s) origin	nvarchar	4	0	CHAR	(N' ')	No		SSOUR	Allow NULL?
3	VRSIO	Version number in the information structure	nvarchar	3	0	CHAR	(N' ')	No	*	VRSIO	Allow NULL?
4	SPMON	Period to analyze - month	nvarchar	6	0	NUMC	(N'000000')	No		SPMON	Allow NULL?
5	SPTAG	Period to analyze - current date	nvarchar	8	0	DATS	(N'00000000')	No		SPTAG	Allow NULL?
6	SPWOC	Period to analyze - week	nvarchar	6	0	NUMC	(N'000000')	No		SPWOC	Allow NULL?
7	SPBUP	Period to analyze - posting period	nvarchar	6	0	NUMC	(N'000000')	No		SPBUP	Allow NULL?
8	SGRUNDB_01	Land register number	nvarchar	8	0	NUMC	(N'00000000')	No	VIGBUCH	SGRUNDB	Allow NULL?
9	PERIV	Fiscal Year Variant	nvarchar	2	0	CHAR	(N' ')	Yes	*	PERIV	Allow NULL?
10	VWDAT	Pointer to administrative data	nvarchar	10	0	NUMC	(N'0000000000')	Yes		VWDAT	Allow NULL?
11	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
12	FEINS	Area unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	FEINS	Allow NULL?
13	XNRA3	Section 3, number of entry	nvarchar	6	0	CHAR	(N' ')	Yes		VVXNRA3	Allow NULL?
14	XORT	Address: City	nvarchar	35	0	CHAR	(N' ')	Yes		VVXORT	Allow NULL?
15	XPLZ	Address: Postal code	nvarchar	10	0	CHAR	(N' ')	Yes		VVXPLZ	Allow NULL?
16	XSTRASSE	Address: Street/house number	nvarchar	35	0	CHAR	(N' ')	Yes		VVXSTRASSE	Allow NULL?
17	RGBA2LB	Type of charges and restrictions for land register type	char	1	0	CHAR	(N' ')	Yes		VVRGBA2LB	Allow NULL?
18	DAUFLASS	Date of conveyance	nvarchar	8	0	DATS	(N'00000000')	Yes		DAUFLASS	Allow NULL?
19	NBANDNR	Land register volume number	nvarchar	15	0	CHAR	(N' ')	Yes		NBANDNR	Allow NULL?
20	RBELAST	Type of encumbrance in section 3 of land register	nvarchar	2	0	NUMC	(N'00')	Yes	TIV02	RBELAST	Allow NULL?
21	XRBELAST	Type of encumbrance in section 3 of land register	nvarchar	15	0	CHAR	(N' ')	Yes		VVXBELAST	Allow NULL?
22	XZUATEXT	Text for entry//removal from land register	nvarchar	60	0	CHAR	(N' ')	Yes		XZUATEXT	Allow NULL?
23	XEINTXT	Charges + restrictions in Section 2 of land register	nvarchar	60	0	CHAR	(N' ')	Yes		XEINTXT	Allow NULL?
24	BDARLEH	Total amount of right registered in Section III	decimal	13	2	CURR	((0))	Yes		BDARLEH
25	BAENLOE	Change or deletion amount	decimal	13	2	CURR	((0))	Yes		BAENLOE
26	DBAUFL	Date of approval of conveyance	nvarchar	8	0	DATS	(N'00000000')	Yes		DBAUFL	Allow NULL?
27	DBEINTR	Date of approval of entry	nvarchar	8	0	DATS	(N'00000000')	Yes		DBEINTR	Allow NULL?
28	DBVORM	Date of approval of priority notice	nvarchar	8	0	DATS	(N'00000000')	Yes		DBVORM	Allow NULL?
29	NBLATTNR	Land register page number	nvarchar	15	0	CHAR	(N' ')	Yes		NBLATTNR	Allow NULL?
30	DATZUAB	Date of entry/removal from land register	nvarchar	8	0	DATS	(N'00000000')	Yes		DATZUAB	Allow NULL?
31	DEINTRAG	Date of entry	nvarchar	8	0	DATS	(N'00000000')	Yes		DEINTRAG	Allow NULL?
32	DAENDER	Change /deletion date	nvarchar	8	0	DATS	(N'00000000')	Yes		DAENDER	Allow NULL?
33	BEFFECT	Effective loan amount	decimal	11	2	CURR	((0))	Yes		BEFFECT
34	JEIGENR	Individual right indicator	char	1	0	CHAR	(N' ')	Yes		JEIGENR	Allow NULL?
35	SNRABT1	No. of entry in section 1 of land register	nvarchar	3	0	NUMC	(N'000')	Yes		SNRABT1	Allow NULL?
36	SNRABT2	Number of entry in section 2 of land register	nvarchar	3	0	NUMC	(N'000')	Yes		SNRABT2	Allow NULL?
37	SNRABT3	No. of entry in Section 3 of land register	nvarchar	3	0	NUMC	(N'000')	Yes		SNRABT3	Allow NULL?
38	RFAKT	Conversion factor for fractional share of property	nvarchar	6	0	CHAR	(N' ')	Yes		VVXFAKT	Allow NULL?
39	NFLURNR	Number of Tract of Land in Land Register	nvarchar	6	0	CHAR	(N' ')	Yes		NFLURNR	Allow NULL?
40	XFLURST	Parcel of Land	nvarchar	10	0	CHAR	(N' ')	Yes		XFLURST	Allow NULL?
41	FLAECHE	Area of area type	decimal	14	4	QUAN	((0))	Yes		VVBFLART
42	FEINS_01	Area unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	FEINS	Allow NULL?
43	JKZLOE	Indicator: Land register entry is marked as being deleted	char	1	0	CHAR	(N' ')	Yes		JKZLOE	Allow NULL?
44	XGEMARK	Local subdistrict ID	nvarchar	12	0	CHAR	(N' ')	Yes		XGEMARK	Allow NULL?
45	PARTNR	Business Partner Number	nvarchar	10	0	CHAR	(N' ')	Yes	BP000	BP_PARTNR	Allow NULL?
46	XGLAUB	Creditor	nvarchar	25	0	CHAR	(N' ')	Yes		XGLAUB	Allow NULL?
47	DAUSZGV	Date: Land register extract from	nvarchar	8	0	DATS	(N'00000000')	Yes		DAUSZGV	Allow NULL?
48	XGBVON	Land register district	nvarchar	25	0	CHAR	(N' ')	Yes		XGBVON	Allow NULL?
49	XPARTNR	Land register: name	nvarchar	35	0	CHAR	(N' ')	Yes		VVXPARTNRG	Allow NULL?
50	SGRUNDB	Land register number	nvarchar	8	0	NUMC	(N'00000000')	Yes	VIGBUCH	SGRUNDB	Allow NULL?
51	XGBAMT	Land registry ID	nvarchar	25	0	CHAR	(N' ')	Yes		XGBAMT	Allow NULL?
52	SGRBA	Land register type	nvarchar	2	0	NUMC	(N'00')	Yes	TDO6	SGRBA	Allow NULL?
53	XGRBA	Type of land register	nvarchar	50	0	CHAR	(N' ')	Yes		XGRBA	Allow NULL?
54	XEIGTLST	Basis of entry	nvarchar	60	0	CHAR	(N' ')	Yes		XEIGTLST	Allow NULL?
55	ZGRUSCH	Land charge interest rate	decimal	10	7	DEC	((0))	Yes		VVZGRUSCH
56	SLFDGRST	Property consecutive number	nvarchar	3	0	NUMC	(N'000')	Yes		SLFDGRST	Allow NULL?
57	NALTGRST	Previous number of property	nvarchar	7	0	CHAR	(N' ')	Yes		NALTGRST	Allow NULL?
58	RGRSTLST	Reference to relational table properties	nvarchar	10	0	NUMC	(N'0000000000')	Yes		RGRSTLST	Allow NULL?
59	BWRTMIN	Net present value of law	decimal	13	2	CURR	((0))	Yes		BWRTMIN
60	XCOMMNT	Comment about lot	nvarchar	60	0	CHAR	(N' ')	Yes		VVXCOMMNT	Allow NULL?
61	XGSLAGE	Description of property location	nvarchar	60	0	CHAR	(N' ')	Yes		XGSLAGE	Allow NULL?
62	NLSBUCHN	Real properties register number	nvarchar	6	0	NUMC	(N'000000')	Yes		NLSBUCHN	Allow NULL?
63	REIGTLST	Reference to relational data base table of owner	nvarchar	10	0	NUMC	(N'0000000000')	Yes		REIGTLST	Allow NULL?
64	XGRSTLST	List of properties for an entry	nvarchar	18	0	CHAR	(N' ')	Yes		XGRSTLST	Allow NULL?
65	DLOESCH	Deletion date	nvarchar	8	0	DATS	(N'00000000')	Yes		DLOESCH	Allow NULL?
66	ZNEBENL	Additional service interest rate	decimal	10	7	DEC	((0))	Yes		VVZNEBENL
67	BNOMIN	Nominal loan amount	decimal	11	2	CURR	((0))	Yes		BNOMIN
68	SNRFLST	Consecutive no. of a lot on a property	nvarchar	3	0	NUMC	(N'000')	Yes		VVSNRFLST	Allow NULL?
69	SNRZUAB	Number of appreciation/depreciation	nvarchar	3	0	NUMC	(N'000')	Yes		SNRZUAB	Allow NULL?
70	SNRABT2A	Changes section 2 of land register, no. of entry	nvarchar	3	0	NUMC	(N'000')	Yes		SNRABT2A	Allow NULL?
71	SNRABT3A	No. of change/deletion in section 3 of land register	nvarchar	3	0	NUMC	(N'000')	Yes		SNRABT3A	Allow NULL?
72	XRNA2A	No. of change in section II	nvarchar	6	0	CHAR	(N' ')	Yes		VVXNRA2A	Allow NULL?
73	XNRA1	Section 1, number of entry	nvarchar	6	0	CHAR	(N' ')	Yes		VVXNRA1	Allow NULL?
74	NRDARLEH	Loan number	nvarchar	12	0	NUMC	(N'000000000000')	Yes		NRDARLEH	Allow NULL?
75	XNRA3A	No of change in sect. III	nvarchar	6	0	CHAR	(N' ')	Yes		VVXNRARA	Allow NULL?
76	XNRBSTD	Number in property list	nvarchar	6	0	CHAR	(N' ')	Yes		VVXNRBSTD	Allow NULL?
77	NRANG	Rank in section 3 of land register	nvarchar	4	0	NUMC	(N'0000')	Yes		NRANG	Allow NULL?
78	JREVAL	Indicator: Revaluation permitted	char	1	0	CHAR	(N' ')	Yes		JREVAL	Allow NULL?
79	XAEND	Text for change or deletion	nvarchar	60	0	CHAR	(N' ')	Yes		VVXAEND	Allow NULL?
80	XBELAST	Text about charge	nvarchar	60	0	CHAR	(N' ')	Yes		XBELAST	Allow NULL?
81	DAUFLVOR	Date of priority notice of conveyance	nvarchar	8	0	DATS	(N'00000000')	Yes		DAUFLVOR	Allow NULL?
82	PWRTMIN	Percentage decrease in value	decimal	5	2	DEC	((0))	Yes		PWRTMIN
83	XWIRTART	Business type	nvarchar	60	0	CHAR	(N' ')	Yes		XWIRTART	Allow NULL?
84	NZUGRST	Entry for property	nvarchar	6	0	CHAR	(N' ')	Yes		VVNZUGRST	Allow NULL?
85	JZUAB	Value appreciation indicator	char	1	0	CHAR	(N' ')	Yes		JZUAB	Allow NULL?
86	ANZGB	No. of land registers	decimal	5	0	DEC	((0))	Yes		VVAGB
87	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUKRS	Allow NULL?
88	SWENR	Site Number	nvarchar	8	0	CHAR	(N' ')	Yes	*	SWENR	Allow NULL?
89	SGRNR	Property Number for BE	nvarchar	8	0	CHAR	(N' ')	Yes	*	SGRNR	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

89 COLUMNS | 1 INDEXES | ERP 6.0 | S408 TABLE

TOP ERP 6.0 | S408 COLUMNS

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

89 COLUMNS | 1 INDEXES | ERP 6.0 | S408 TABLE

TOPERP 6.0 | S408 COLUMNS

TOPERP 6.0 | S408 INDEXES

TOP ERP 6.0 | S408 COLUMNS

TOP ERP 6.0 | S408 INDEXES