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 :: Flexible Real Estate Management :: Real Estate Localization :: Real Estate Localization Czech Republic
1	ERP EHP7	6.0	/CEERE/SDANP	141	2	Property tax - master	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	TYPNEMREM	Real Estate Object Type	char	1	0	Allow NULL?
5	SWENR	Site Number	nvarchar	8	0	Allow NULL?
6	KEYNEM	Property Key	nvarchar	8	0	Allow NULL?
7	TYPNEM	Property Category	char	1	0	Allow NULL?
8	DRNEM	Property Type	char	1	0	Allow NULL?
9	KODFU	Tax Office Code	nvarchar	3	0	Allow NULL?
10	KODOBCE	Code of Municipality or City District	nvarchar	8	0	Allow NULL?
11	NAZEVOBCE	Name of Municipality or City District	nvarchar	35	0	Allow NULL?
12	KODCOBCE	District Code	nvarchar	6	0	Allow NULL?
13	GEMARK	Local Subdistrict	nvarchar	12	0	Allow NULL?
14	NAZEVKU	Cadastral District Name	nvarchar	40	0	Allow NULL?
15	NARPARK	Property Located in National Park	char	1	0	Allow NULL?
16	PARCKMEN	Master Number of Parcel	nvarchar	5	0	Allow NULL?
17	PARCPOD	Additional Number of Parcel	nvarchar	3	0	Allow NULL?
18	PARCDIL	Parcel Sub-Number	nvarchar	2	0	Allow NULL?
19	VYMERA	Total Area	decimal	9	2
20	PRAVZTAH	Legal Relations	nvarchar	4	0	Allow NULL?
21	SV_CITATEL	Co-Ownership Share (Numerator)	decimal	7	0
22	SV_JMENOVATEL	Co-Ownership Share (Denominator)	decimal	7	0
23	VYMERAOSV	Area Exempted From Tax	decimal	9	2
24	VYMERAPOD	Floor Area for Business	decimal	9	2
25	ZASTPL	Covered Area	decimal	9	2
26	PLOCHANP	Total Area of Floors Above the Ground Floor	decimal	9	2
27	KODOSVOB	Tax Exemption Code	nvarchar	5	0	Allow NULL?
28	ROKOSVOD	Tax Exemption Period: Start Year	nvarchar	4	0	Allow NULL?
29	ROKOSVDO	Tax Exemption Period: End Year	nvarchar	4	0	Allow NULL?
30	CENASTODH	Estimated Price	char	1	0	Allow NULL?
31	CENAODHAD	Estimated Land Price	decimal	9	2
32	POCPATER	Number of Other Aboveground Floors	decimal	3	0
33	CISLOP	Registration Number	nvarchar	6	0	Allow NULL?
34	ROKDOKONC	Completion Year of Building	nvarchar	4	0	Allow NULL?
35	POPIS	Name of Property Tax Object	nvarchar	80	0	Allow NULL?
36	CIZIPOZ	Building on Third-Party Plot	char	1	0	Allow NULL?
37	DRUHSTA	Building Type	nvarchar	2	0	Allow NULL?
38	BYTKAT	Apartment category	nvarchar	4	0	Allow NULL?
39	SVISKONST	Vertical supporting structure	nvarchar	2	0	Allow NULL?
40	JEDNKMEN	Unit-master part	nvarchar	6	0	Allow NULL?
41	JEDNBYT	Unit-apartment	nvarchar	3	0	Allow NULL?
42	PLNOSVOB	Full Tax Exemption	char	1	0	Allow NULL?
43	DATZMENY	Date	nvarchar	8	0	Allow NULL?
44	CASZMENY	Time	nvarchar	6	0	Allow NULL?
45	ZMENIL	Changed by	nvarchar	12	0	Allow NULL?
46	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
47	X18	Area of Land Type	decimal	9	2
48	X19	Land Price per Square Meter	decimal	9	2
49	X20	Tax Base According to Par.5 (1,2)	decimal	11	2
50	X21	Tax Rate (Par. 6(1))	decimal	5	2
51	X22	Tax Base (Par.5(3))	decimal	9	2
52	X23	Tax Rate (Par 6(2))	decimal	5	2
53	X24	Factor According to Par. 6(4)	decimal	5	2
54	X25	Land Tax	decimal	11	2
55	X26	Claim for Exemption in Area	decimal	9	2
56	X27	Amount of Claim for Exemption (Par. 4,18(1))	decimal	11	2
57	X28	Tax Liability	decimal	11	2
58	X41	Covered area	decimal	9	2
59	X42	Basic tax rate §11(1)	decimal	5	2
60	X43	Number of above-ground floors	decimal	9	0
61	X44	Incr.base rate for another above-ground floor §11(2)	decimal	9	2
62	X45	Factor according to §11(3,4)	decimal	5	2
63	X46	Resulting tax rate	decimal	9	2
64	X47	Building tax	decimal	11	2
65	X48	Business area	decimal	9	2
66	X49	Tax increase according to §11(5)	decimal	11	2
67	X50	Area relation §9(2)	decimal	9	2
68	X51	Amount of exempt claim §11	decimal	11	2
69	X52	Amount of claim for deduction §18(2)	decimal	11	2
70	X53	Tax liability	decimal	11	2
71	X54_O	Total land tax - till 2008	decimal	11	2
72	X54	Total Amount of Land Tax	decimal	11	2
73	X54_B	Total Amount of Land Tax	decimal	11	2
74	X55_O	Total building tax - till 2008	decimal	11	2
75	X55	Total Amount of Building Tax	decimal	11	2
76	X55_B	Total Amount of Building Tax	decimal	11	2
77	X56_O	Total property tax - till 2008	decimal	11	2
78	X56	Total Amount of Property Tax	decimal	11	2
79	X56_B	Total Amount of Property Tax	decimal	11	2
80	XKO12	Municipality Coefficient (Par. 12)	tinyint	3	0
81	X58_1	Installment 1	decimal	11	2
82	X58_2	Installment 2	decimal	11	2
83	X59_1	Installment 1	decimal	11	2
84	X59_2	Installment 2	decimal	11	2
85	X59_3	Installment 3	decimal	11	2
86	X59_4	Installment 4	decimal	11	2
87	X67	Land type area	decimal	9	2
88	X68A	Com.quotient denominator	int	10	0	Allow NULL?
89	X68B	Com.quotient numerator	int	10	0	Allow NULL?
90	X69	Co-owned land type are	decimal	9	2
91	X70	Land price per square meter	decimal	9	2
92	X71	Tax base according to p.5 par. 1,2	decimal	11	2
93	X72	Tax rate §6(1)	decimal	5	2
94	X73	Tax base §5(3)	decimal	9	2
95	X74	Tax rate §6(2)	decimal	5	2
96	X75	Factor according to §6(4)	decimal	5	2
97	X76	Land tax	decimal	11	2
98	X77	Claim for area exempt	decimal	9	2
99	X78	Amount of claim for exempt §4,18(1)	decimal	11	2
100	X79	Liability to pay taxes	decimal	11	2
101	X95	Floor area of the unit	decimal	9	2
102	X96	Factor according to §10(2)	decimal	5	2
103	X97	Base tax rate according to §10(2)	decimal	9	2
104	X98	Base tax rate according to §11(1)	decimal	5	2
105	X99	Factor according to §11(3,4)	decimal	5	2
106	X100	Resulting tax rate	decimal	5	2
107	X101	Building tax	decimal	11	2
108	X102	Amount of claim for exemption according to §9	decimal	11	2
109	X103	Tax liability	decimal	11	2
110	AGR_PAR1	Free aggregation parameter	nvarchar	10	0	Allow NULL?
111	AGR_PAR2	Free aggregation parameter	nvarchar	10	0	Allow NULL?
112	AGR_PAR3	Free aggregation parameter	nvarchar	10	0	Allow NULL?
113	AGR_PAR4	Free aggregation parameter	nvarchar	10	0	Allow NULL?
114	ANLN1	Main Asset Number	nvarchar	12	0	Allow NULL?
115	ANLN2	Asset Subnumber	nvarchar	4	0	Allow NULL?
116	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
117	GSBER	Business Area	nvarchar	4	0	Allow NULL?
118	PRCTR	Profit Center	nvarchar	10	0	Allow NULL?
119	AUFNR	Order Number	nvarchar	12	0	Allow NULL?
120	PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	Allow NULL?
121	XDAN	Subject to Property Tax	char	1	0	Allow NULL?
122	DATVYPOCTU	Calculation Date	nvarchar	8	0	Allow NULL?
123	CASVYPOCTU	Calculation Time	nvarchar	6	0	Allow NULL?
124	STAVYPOCTU	Calculation status	char	1	0	Allow NULL?
125	VYPOCETL	Calculation Executed by	nvarchar	12	0	Allow NULL?
126	TBUKR2	Dominant Enterprise/Company Code	nvarchar	4	0	Allow NULL?
127	MBUKR	Indicator: Dominant Company Code	char	1	0	Allow NULL?
128	SOLIDAGR	Paved Area (Agricultural Purp.)	decimal	9	2
129	SOLIDIND	Paved Area (Industrial Purp.)	decimal	9	2
130	SOLAAGRE	Tax-Exempt Paved Area (Argicultural Purp.)	decimal	9	2
131	SOLAINDE	Tax-Exempt Paved Area (Industrial Purp.)	decimal	9	2
132	YEAGREFR	First Year of Tax Exemption Period (Agricultural Purp.)	nvarchar	4	0	Allow NULL?
133	YEINDEFR	First Year of Tax Exemption Period (Industrial Purp.)	nvarchar	4	0	Allow NULL?
134	YEAGRETO	Last Year of Tax Exemption Period (Agricultural Purp.)	nvarchar	4	0	Allow NULL?
135	YEINDETO	Last Year of Tax Exemption Period (Industrial Purp.)	nvarchar	4	0	Allow NULL?
136	CODEAGRE	Tax Exemption Code for Paved Area (Agr. Purp.)	nvarchar	5	0	Allow NULL?
137	CODEINDE	Tax Exemption Code for Paved Area (Ind. Purp.)	nvarchar	5	0	Allow NULL?
138	RVZ_PODNIK	Non-residential Property Type Used for Business	char	1	0	Allow NULL?
139	VYM_PODNIKPO	Landscaped area designed for business	decimal	9	2
140	KC_ZVDA115PO	The increase in tax under § 11a	decimal	11	2
141	KC_DANOSV3PO	Property Tax increased from amount under § 11 (5)	decimal	11	2

Name	Primary	Unique	Type	Columns
/CEERE/SDANP~0	Yes	Yes	CLUSTERED	KEYNEM, SWENR, TYPNEMREM, GJAHR, BUKRS, MANDT
/CEERE/SDANP~FU	No	No	NONCLUSTERED	KEYNEM, SWENR, TYPNEM, KODFU, XDAN, 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

141 COLUMNS | 2 INDEXES | ERP 6.0 | /CEERE/SDANP TABLE

TOP ERP 6.0 | /CEERE/SDANP COLUMNS

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

141 COLUMNS | 2 INDEXES | ERP 6.0 | /CEERE/SDANP TABLE

TOPERP 6.0 | /CEERE/SDANP COLUMNS

TOPERP 6.0 | /CEERE/SDANP INDEXES

TOP ERP 6.0 | /CEERE/SDANP COLUMNS

TOP ERP 6.0 | /CEERE/SDANP INDEXES