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/SDANA	116	1	Property tax return - items	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	SWENR	Site Number	nvarchar	8	0	Allow NULL?
15	KEYNEM	Property Key	nvarchar	8	0	Allow NULL?
16	CLISTU	Number of tax return sheet	nvarchar	3	0	Allow NULL?
17	NAZEVOBCE	Name of Municipality or City District	nvarchar	35	0	Allow NULL?
18	NAZEVKU	Cadastral District Name	nvarchar	40	0	Allow NULL?
19	NARPARK	Property Located in National Park	char	1	0	Allow NULL?
20	PARCKMEN	Master Number of Parcel	nvarchar	5	0	Allow NULL?
21	PARCPOD	Additional Number of Parcel	nvarchar	3	0	Allow NULL?
22	PARCDIL	Parcel Sub-Number	nvarchar	2	0	Allow NULL?
23	VYMERA	Total Area	decimal	9	2
24	PRAVZTAH	Legal Relations	nvarchar	4	0	Allow NULL?
25	SV_CITATEL	Co-Ownership Share (Numerator)	decimal	7	0
26	SV_JMENOVATEL	Co-Ownership Share (Denominator)	decimal	7	0
27	VYMERAOSV	Area Exempted From Tax	decimal	9	2
28	VYMERAPOD	Floor Area for Business	decimal	9	2
29	ZASTPL	Covered Area	decimal	9	2
30	PLOCHANP	Total Area of Floors Above the Ground Floor	decimal	9	2
31	KODOSVOB	Tax Exemption Code	nvarchar	5	0	Allow NULL?
32	ROKOSVOD	Tax Exemption Period: Start Year	nvarchar	4	0	Allow NULL?
33	ROKOSVDO	Tax Exemption Period: End Year	nvarchar	4	0	Allow NULL?
34	CENASTODH	Estimated Price	char	1	0	Allow NULL?
35	CENAODHAD	Estimated Land Price	decimal	9	2
36	POCPATER	Number of Other Aboveground Floors	decimal	3	0
37	CISLOP	Registration Number	nvarchar	6	0	Allow NULL?
38	ROKDOKONC	Completion Year of Building	nvarchar	4	0	Allow NULL?
39	POPIS	Name of Property Tax Object	nvarchar	80	0	Allow NULL?
40	CIZIPOZ	Building on Third-Party Plot	char	1	0	Allow NULL?
41	DRUHSTA	Building Type	nvarchar	2	0	Allow NULL?
42	BYTKAT	Apartment category	nvarchar	4	0	Allow NULL?
43	SVISKONST	Vertical supporting structure	nvarchar	2	0	Allow NULL?
44	JEDNKMEN	Unit-master part	nvarchar	6	0	Allow NULL?
45	JEDNBYT	Unit-apartment	nvarchar	3	0	Allow NULL?
46	PLNOSVOB	Full Tax Exemption	char	1	0	Allow NULL?
47	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
48	X18	Area of Land Type	decimal	9	2
49	X19	Land Price per Square Meter	decimal	9	2
50	X20	Tax Base According to Par.5 (1,2)	decimal	11	2
51	X21	Tax Rate (Par. 6(1))	decimal	5	2
52	X22	Tax Base (Par.5(3))	decimal	9	2
53	X23	Tax Rate (Par 6(2))	decimal	5	2
54	X24	Factor According to Par. 6(4)	decimal	5	2
55	X25	Land Tax	decimal	11	2
56	X26	Claim for Exemption in Area	decimal	9	2
57	X27	Amount of Claim for Exemption (Par. 4,18(1))	decimal	11	2
58	X28	Tax Liability	decimal	11	2
59	X41	Covered area	decimal	9	2
60	X42	Basic tax rate §11(1)	decimal	5	2
61	X43	Number of above-ground floors	decimal	9	0
62	X44	Incr.base rate for another above-ground floor §11(2)	decimal	9	2
63	X45	Factor according to §11(3,4)	decimal	5	2
64	X46	Resulting tax rate	decimal	9	2
65	X47	Building tax	decimal	11	2
66	X48	Business area	decimal	9	2
67	X49	Tax increase according to §11(5)	decimal	11	2
68	X50	Area relation §9(2)	decimal	9	2
69	X51	Amount of exempt claim §11	decimal	11	2
70	X52	Amount of claim for deduction §18(2)	decimal	11	2
71	X53	Tax liability	decimal	11	2
72	X54_O	Total land tax - till 2008	decimal	11	2
73	X54	Total Amount of Land Tax	decimal	11	2
74	X54_B	Total Amount of Land Tax	decimal	11	2
75	X55_O	Total building tax - till 2008	decimal	11	2
76	X55	Total Amount of Building Tax	decimal	11	2
77	X55_B	Total Amount of Building Tax	decimal	11	2
78	X56_O	Total property tax - till 2008	decimal	11	2
79	X56	Total Amount of Property Tax	decimal	11	2
80	X56_B	Total Amount of Property Tax	decimal	11	2
81	XKO12	Municipality Coefficient (Par. 12)	tinyint	3	0
82	X58_1	Installment 1	decimal	11	2
83	X58_2	Installment 2	decimal	11	2
84	X59_1	Installment 1	decimal	11	2
85	X59_2	Installment 2	decimal	11	2
86	X59_3	Installment 3	decimal	11	2
87	X59_4	Installment 4	decimal	11	2
88	X67	Land type area	decimal	9	2
89	X68A	Com.quotient denominator	int	10	0	Allow NULL?
90	X68B	Com.quotient numerator	int	10	0	Allow NULL?
91	X69	Co-owned land type are	decimal	9	2
92	X70	Land price per square meter	decimal	9	2
93	X71	Tax base according to p.5 par. 1,2	decimal	11	2
94	X72	Tax rate §6(1)	decimal	5	2
95	X73	Tax base §5(3)	decimal	9	2
96	X74	Tax rate §6(2)	decimal	5	2
97	X75	Factor according to §6(4)	decimal	5	2
98	X76	Land tax	decimal	11	2
99	X77	Claim for area exempt	decimal	9	2
100	X78	Amount of claim for exempt §4,18(1)	decimal	11	2
101	X79	Liability to pay taxes	decimal	11	2
102	X95	Floor area of the unit	decimal	9	2
103	X96	Factor according to §10(2)	decimal	5	2
104	X97	Base tax rate according to §10(2)	decimal	9	2
105	X98	Base tax rate according to §11(1)	decimal	5	2
106	X99	Factor according to §11(3,4)	decimal	5	2
107	X100	Resulting tax rate	decimal	5	2
108	X101	Building tax	decimal	11	2
109	X102	Amount of claim for exemption according to §9	decimal	11	2
110	X103	Tax liability	decimal	11	2
111	DATVYPOCTU	Calculation Date	nvarchar	8	0	Allow NULL?
112	CASVYPOCTU	Calculation Time	nvarchar	6	0	Allow NULL?
113	STAVYPOCTU	Calculation status	char	1	0	Allow NULL?
114	VYPOCETL	Calculation Executed by	nvarchar	12	0	Allow NULL?
115	TBUKR2	Dominant Enterprise/Company Code	nvarchar	4	0	Allow NULL?
116	MBUKR	Indicator: Dominant Company Code	char	1	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

116 COLUMNS | 1 INDEXES | ERP 6.0 | /CEERE/SDANA TABLE

TOP ERP 6.0 | /CEERE/SDANA COLUMNS

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

116 COLUMNS | 1 INDEXES | ERP 6.0 | /CEERE/SDANA TABLE

TOPERP 6.0 | /CEERE/SDANA COLUMNS

TOPERP 6.0 | /CEERE/SDANA INDEXES

TOP ERP 6.0 | /CEERE/SDANA COLUMNS

TOP ERP 6.0 | /CEERE/SDANA INDEXES