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	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
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	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Real Estate Management :: Flexible Real Estate Management :: Real Estate Localization :: Real Estate Localization Czech Republic
1	ERP EHP7	6.0	/CEERE/SDAN	82	2	Property tax return - sheets	Real Estate Localization Czech Republic

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
3	GJAHR	Fiscal Year	nvarchar	4	0	Allow NULL?
4	TYPDANP	Type of Tax Return	char	1	0	Allow NULL?
5	TYPNEM	Property Category	char	1	0	Allow NULL?
6	DRNEM	Property Type	char	1	0	Allow NULL?
7	KODFU	Tax Office Code	nvarchar	3	0	Allow NULL?
8	KODOBCE	Code of Municipality or City District	nvarchar	8	0	Allow NULL?
9	GEMARK	Local Subdistrict	nvarchar	12	0	Allow NULL?
10	AGR_PAR1	Free aggregation parameter	nvarchar	10	0	Allow NULL?
11	AGR_PAR2	Free aggregation parameter	nvarchar	10	0	Allow NULL?
12	AGR_PAR3	Free aggregation parameter	nvarchar	10	0	Allow NULL?
13	AGR_PAR4	Free aggregation parameter	nvarchar	10	0	Allow NULL?
14	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
15	X18	Area of Land Type	decimal	9	2
16	X19	Land Price per Square Meter	decimal	9	2
17	X20	Tax Base According to Par.5 (1,2)	decimal	11	2
18	X21	Tax Rate (Par. 6(1))	decimal	5	2
19	X22	Tax Base (Par.5(3))	decimal	9	2
20	X23	Tax Rate (Par 6(2))	decimal	5	2
21	X24	Factor According to Par. 6(4)	decimal	5	2
22	X25	Land Tax	decimal	11	2
23	X26	Claim for Exemption in Area	decimal	9	2
24	X27	Amount of Claim for Exemption (Par. 4,18(1))	decimal	11	2
25	X28	Tax Liability	decimal	11	2
26	X41	Covered area	decimal	9	2
27	X42	Basic tax rate §11(1)	decimal	5	2
28	X43	Number of above-ground floors	decimal	9	0
29	X44	Incr.base rate for another above-ground floor §11(2)	decimal	9	2
30	X45	Factor according to §11(3,4)	decimal	5	2
31	X46	Resulting tax rate	decimal	9	2
32	X47	Building tax	decimal	11	2
33	X48	Business area	decimal	9	2
34	X49	Tax increase according to §11(5)	decimal	11	2
35	X50	Area relation §9(2)	decimal	9	2
36	X51	Amount of exempt claim §11	decimal	11	2
37	X52	Amount of claim for deduction §18(2)	decimal	11	2
38	X53	Tax liability	decimal	11	2
39	X54_O	Total land tax - till 2008	decimal	11	2
40	X54	Total Amount of Land Tax	decimal	11	2
41	X54_B	Total Amount of Land Tax	decimal	11	2
42	X55_O	Total building tax - till 2008	decimal	11	2
43	X55	Total Amount of Building Tax	decimal	11	2
44	X55_B	Total Amount of Building Tax	decimal	11	2
45	X56_O	Total property tax - till 2008	decimal	11	2
46	X56	Total Amount of Property Tax	decimal	11	2
47	X56_B	Total Amount of Property Tax	decimal	11	2
48	XKO12	Municipality Coefficient (Par. 12)	tinyint	3	0
49	X67	Land type area	decimal	9	2
50	X68A	Com.quotient denominator	int	10	0	Allow NULL?
51	X68B	Com.quotient numerator	int	10	0	Allow NULL?
52	X69	Co-owned land type are	decimal	9	2
53	X70	Land price per square meter	decimal	9	2
54	X71	Tax base according to p.5 par. 1,2	decimal	11	2
55	X72	Tax rate §6(1)	decimal	5	2
56	X73	Tax base §5(3)	decimal	9	2
57	X74	Tax rate §6(2)	decimal	5	2
58	X75	Factor according to §6(4)	decimal	5	2
59	X76	Land tax	decimal	11	2
60	X77	Claim for area exempt	decimal	9	2
61	X78	Amount of claim for exempt §4,18(1)	decimal	11	2
62	X79	Liability to pay taxes	decimal	11	2
63	X95	Floor area of the unit	decimal	9	2
64	X96	Factor according to §10(2)	decimal	5	2
65	X97	Base tax rate according to §10(2)	decimal	9	2
66	X98	Base tax rate according to §11(1)	decimal	5	2
67	X99	Factor according to §11(3,4)	decimal	5	2
68	X100	Resulting tax rate	decimal	5	2
69	X101	Building tax	decimal	11	2
70	X102	Amount of claim for exemption according to §9	decimal	11	2
71	X103	Tax liability	decimal	11	2
72	CLISTU	Number of tax return sheet	nvarchar	3	0	Allow NULL?
73	STAVLISTU	Status of tax return sheet	char	1	0	Allow NULL?
74	DATVYPOCTU	Calculation Date	nvarchar	8	0	Allow NULL?
75	CASVYPOCTU	Calculation Time	nvarchar	6	0	Allow NULL?
76	VYPOCETL	Calculation Executed by	nvarchar	12	0	Allow NULL?
77	MBUKR	Indicator: Dominant Company Code	char	1	0	Allow NULL?
78	LISTCISLO	Numc3, internal use	nvarchar	3	0	Allow NULL?
79	RVZ_PODNIK	Non-residential Property Type Used for Business	char	1	0	Allow NULL?
80	VYM_PODNIKPO	Landscaped area designed for business	decimal	9	2
81	KC_ZVDA115PO	The increase in tax under § 11a	decimal	11	2
82	KC_DANOSV3PO	Property Tax increased from amount under § 11 (5)	decimal	11	2

Name	Primary	Unique	Type	Columns
/CEERE/SDAN~0	Yes	Yes	CLUSTERED	AGR_PAR4, AGR_PAR3, AGR_PAR2, AGR_PAR1, GEMARK, KODOBCE, KODFU, DRNEM, TYPNEM, TYPDANP, GJAHR, BUKRS, MANDT
/CEERE/SDAN~FU	No	No	NONCLUSTERED	KODFU, TYPDANP, GJAHR, BUKRS, MANDT

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

82 COLUMNS | 2 INDEXES | ERP 6.0 | /CEERE/SDAN TABLE

TOP ERP 6.0 | /CEERE/SDAN COLUMNS

TOP ERP 6.0 | /CEERE/SDAN 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

82 COLUMNS | 2 INDEXES | ERP 6.0 | /CEERE/SDAN TABLE

TOPERP 6.0 | /CEERE/SDAN COLUMNS

TOPERP 6.0 | /CEERE/SDAN INDEXES

TOP ERP 6.0 | /CEERE/SDAN COLUMNS

TOP ERP 6.0 | /CEERE/SDAN INDEXES