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 :: Flexible Real Estate Management :: Real Estate Localization :: Real Estate Slovakia
1	ERP EHP7	6.0	VIXCSKTAXRET_S	121	1	Property Tax Return SK - Sheets - Sections II,III,IV	Real Estate Slovakia

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	*	MANDT	Allow NULL?
2	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
3	GJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	No		GJAHR	Allow NULL?
4	SPRAVCE	Tax Administrator	nvarchar	8	0	CHAR	(N' ')	No	*	REXCSKSPRAVCE	Allow NULL?
5	TYPDANP	Type of Tax Return	char	1	0	CHAR	(N' ')	No		REXCSKTYPDANP	Allow NULL?
6	AGR_PAR	Aggregation Parameter	nvarchar	80	0	CHAR	(N' ')	No		REXCSKAGR_PAR	Allow NULL?
7	TYPNEM	Real Estate Object Type	nvarchar	2	0	CHAR	(N' ')	Yes		REXCSKTYPNEM	Allow NULL?
8	ODDIL	Tax Return Section	nvarchar	4	0	CHAR	(N' ')	Yes		REXCSKODDIL	Allow NULL?
9	SHEET	Sheet/Attachment Number	nvarchar	3	0	NUMC	(N'000')	Yes		REXCSKSHEET	Allow NULL?
10	XAGR	Allow Aggregation	char	1	0	CHAR	(N' ')	Yes		REXCSKXAGR	Allow NULL?
11	H_ICO	Company Identification Number (ICO)	nvarchar	8	0	CHAR	(N' ')	Yes		REXCSKICO	Allow NULL?
12	H_DIC	VAT Registration Number	nvarchar	10	0	CHAR	(N' ')	Yes		REXCSKDIC	Allow NULL?
13	HX_KODOBCE	Municipality or City District Code	nvarchar	8	0	CHAR	(N' ')	Yes	*	REXCSKKODOBCE	Allow NULL?
14	HX_KODCOBCE	Subdistrict Code	nvarchar	6	0	CHAR	(N' ')	Yes	*	REXCSKKODCOBCE	Allow NULL?
15	HX_KODKU	Cadastral District Code	nvarchar	6	0	CHAR	(N' ')	Yes	*	REXCSKKODKU	Allow NULL?
16	H_NAZOBCE	Name of Municipality or City District	nvarchar	35	0	CHAR	(N' ')	Yes		REXCSKNAZOBCE	Allow NULL?
17	H_NAZKU	Cadastral District Name	nvarchar	40	0	CHAR	(N' ')	Yes		REXCSKNAZKU	Allow NULL?
18	H_PARCELA	Parcel	nvarchar	10	0	CHAR	(N' ')	Yes		REXCSKPARCELA	Allow NULL?
19	H_DRNEM	Property Type	char	1	0	CHAR	(N' ')	Yes	TIVXCSKDRNEM	REXCSKDRNEM	Allow NULL?
20	H_POPIS	Name of Real Estate Object	nvarchar	80	0	CHAR	(N' ')	Yes		REXCSKPOPIS	Allow NULL?
21	H_PRAVZTAH	Legal Relationship	char	1	0	CHAR	(N' ')	Yes		REXCSKPRAVZTAH	Allow NULL?
22	H_SPOLVLAST	Form of Co-Ownership	char	1	0	CHAR	(N' ')	Yes		REXCSKSPOLVLAST	Allow NULL?
23	H_POCSPOL	Number of Owners	nvarchar	6	0	NUMC	(N'000000')	Yes		REXCSKPOCSPOL	Allow NULL?
24	H_SPOLDOH	Co-Owner by Agreement	char	1	0	CHAR	(N' ')	Yes		REXCSKSPOLDOH	Allow NULL?
25	HX_KOSVOB	Tax Exemption Code	nvarchar	4	0	CHAR	(N' ')	Yes		REXCSKKODOSVOB	Allow NULL?
26	HX_OSVOD	Valid From	nvarchar	4	0	NUMC	(N'0000')	Yes		REXCSKROKOD	Allow NULL?
27	HX_OSVDO	Valid To	nvarchar	4	0	NUMC	(N'0000')	Yes		REXCSKROKDO	Allow NULL?
28	HX_KODREDU	Tax Reduction Code	nvarchar	4	0	CHAR	(N' ')	Yes		REXCSKKODREDU	Allow NULL?
29	HX_REDOD	Valid From	nvarchar	4	0	NUMC	(N'0000')	Yes		REXCSKROKOD	Allow NULL?
30	HX_REDDO	Valid To	nvarchar	4	0	NUMC	(N'0000')	Yes		REXCSKROKDO	Allow NULL?
31	H_DUVOSVOB	Description	nvarchar	80	0	CHAR	(N' ')	Yes		REXCSKDUVOSVOB	Allow NULL?
32	H_ULICE	Street	nvarchar	60	0	CHAR	(N' ')	Yes		AD_STREET	Allow NULL?
33	H_CISLOP	Registration Number	nvarchar	9	0	CHAR	(N' ')	Yes		REXCSKCISLOP	Allow NULL?
34	H_CIZIPOZ	Building on Third-Party Plot	char	1	0	CHAR	(N' ')	Yes		REXCSKCIZIPOZ	Allow NULL?
35	H_CISBYT	House Number of Apartments or Common Areas	nvarchar	8	0	CHAR	(N' ')	Yes		REXCSKCISBYT	Allow NULL?
36	HX_DATVYDRAZ	Auction Date	nvarchar	8	0	DATS	(N'00000000')	Yes		REXCSKDATVYDRAZ	Allow NULL?
37	P_VYMERA	Land Area	decimal	10	2	DEC	((0))	Yes		REXCSKVYMERA
38	P_VYMERAOSV	Exempted Land Area	decimal	10	2	DEC	((0))	Yes		REXCSKVYMERAOSV
39	P_VYMERADAN	Taxable Land Area	decimal	10	2	DEC	((0))	Yes		REXCSKVYMERADAN
40	P_HODNPUDY	Land Price	decimal	9	4	DEC	((0))	Yes		REXCSKCENAP
41	P_ZAKLAD	Tax Base Amount of Land	decimal	12	4	DEC	((0))	Yes		REXCSKZAKLADL
42	P_ZAKLAD_Z	Tax Base Amount	decimal	11	2	DEC	((0))	Yes		REXCSKZAKLAD
43	P_ROCSAZ	Annual Tax Rate	decimal	6	3	DEC	((0))	Yes		REXCSKROCSAZ
44	BA_VYMERAZAS	Built-In Area	decimal	10	2	DEC	((0))	Yes		REXCSKVYMERAZAS
45	BA_VYMERAPODL	Taxable Floor Area	decimal	10	2	DEC	((0))	Yes		REXCSKVYMERAPOD
46	BA_VYMERAOSV	Floor Area Exempted From Tax (Building)	decimal	10	2	DEC	((0))	Yes		REXCSKVYMERAPOS
47	BA_KOEFOSL	Factor	decimal	4	2	DEC	((0))	Yes		REXCSKKOEFOSL
48	BA_ZAKLADM2	Tax Base Amount of Buildings	decimal	10	2	DEC	((0))	Yes		REXCSKZAKLADS
49	BA_ROCSAZ	Annual Tax Rate	decimal	6	3	DEC	((0))	Yes		REXCSKROCSAZ
50	BA_POCPATER	Number of Floors Above the First Floor	nvarchar	3	0	NUMC	(N'000')	Yes		REXCSKPOCPATER	Allow NULL?
51	BA_PRIPLPOD	Increment for Additional Floors	decimal	5	2	DEC	((0))	Yes		REXCSKPRIPLPOD
52	BB_VYMERAZAS	Built-In Area	decimal	10	2	DEC	((0))	Yes		REXCSKVYMERAZAS
53	BB_VYMERAPODL	Taxable Floor Area	decimal	10	2	DEC	((0))	Yes		REXCSKVYMERAPOD
54	BB_VYMERAOSV	Floor Area Exempted From Tax (Building)	decimal	10	2	DEC	((0))	Yes		REXCSKVYMERAPOS
55	BB_VYMERAPODL_A	Taxable Floor Area	decimal	10	2	DEC	((0))	Yes		REXCSKVYMERAPOD
56	BB_VYMERAPODL_B	Taxable Floor Area	decimal	10	2	DEC	((0))	Yes		REXCSKVYMERAPOD
57	BB_VYMERAPODL_C	Taxable Floor Area	decimal	10	2	DEC	((0))	Yes		REXCSKVYMERAPOD
58	BB_VYMERAPODL_D	Taxable Floor Area	decimal	10	2	DEC	((0))	Yes		REXCSKVYMERAPOD
59	BB_VYMERAPODL_E	Taxable Floor Area	decimal	10	2	DEC	((0))	Yes		REXCSKVYMERAPOD
60	BB_VYMERAPODL_F	Taxable Floor Area	decimal	10	2	DEC	((0))	Yes		REXCSKVYMERAPOD
61	BB_VYMERAPODL_G	Taxable Floor Area	decimal	10	2	DEC	((0))	Yes		REXCSKVYMERAPOD
62	BB_POCPATER	Number of Floors Above the First Floor	nvarchar	3	0	NUMC	(N'000')	Yes		REXCSKPOCPATER	Allow NULL?
63	BB_KOEFOSL	Factor	decimal	4	2	DEC	((0))	Yes		REXCSKKOEFOSL
64	BB_ZAKLADM2	Tax Base Amount of Buildings	decimal	10	2	DEC	((0))	Yes		REXCSKZAKLADS
65	BB_POMCAST_A	Tax Base Amount (Floor Areas Used for Diff.Purposes)	decimal	7	5	DEC	((0))	Yes		REXCSZAKLPOM
66	BB_POMCAST_B	Tax Base Amount (Floor Areas Used for Diff.Purposes)	decimal	7	5	DEC	((0))	Yes		REXCSZAKLPOM
67	BB_POMCAST_C	Tax Base Amount (Floor Areas Used for Diff.Purposes)	decimal	7	5	DEC	((0))	Yes		REXCSZAKLPOM
68	BB_POMCAST_D	Tax Base Amount (Floor Areas Used for Diff.Purposes)	decimal	7	5	DEC	((0))	Yes		REXCSZAKLPOM
69	BB_POMCAST_E	Tax Base Amount (Floor Areas Used for Diff.Purposes)	decimal	7	5	DEC	((0))	Yes		REXCSZAKLPOM
70	BB_POMCAST_F	Tax Base Amount (Floor Areas Used for Diff.Purposes)	decimal	7	5	DEC	((0))	Yes		REXCSZAKLPOM
71	BB_POMCAST_G	Tax Base Amount (Floor Areas Used for Diff.Purposes)	decimal	7	5	DEC	((0))	Yes		REXCSZAKLPOM
72	BB_ROCSAZ_A	Annual Tax Rate	decimal	6	3	DEC	((0))	Yes		REXCSKROCSAZ
73	BB_ROCSAZ_B	Annual Tax Rate	decimal	6	3	DEC	((0))	Yes		REXCSKROCSAZ
74	BB_ROCSAZ_C	Annual Tax Rate	decimal	6	3	DEC	((0))	Yes		REXCSKROCSAZ
75	BB_ROCSAZ_D	Annual Tax Rate	decimal	6	3	DEC	((0))	Yes		REXCSKROCSAZ
76	BB_ROCSAZ_E	Annual Tax Rate	decimal	6	3	DEC	((0))	Yes		REXCSKROCSAZ
77	BB_ROCSAZ_F	Annual Tax Rate	decimal	6	3	DEC	((0))	Yes		REXCSKROCSAZ
78	BB_ROCSAZ_G	Annual Tax Rate	decimal	6	3	DEC	((0))	Yes		REXCSKROCSAZ
79	BB_PRIPLPOD_A	Increment for Additional Floors	decimal	5	2	DEC	((0))	Yes		REXCSKPRIPLPOD
80	BB_PRIPLPOD_B	Increment for Additional Floors	decimal	5	2	DEC	((0))	Yes		REXCSKPRIPLPOD
81	BB_PRIPLPOD_C	Increment for Additional Floors	decimal	5	2	DEC	((0))	Yes		REXCSKPRIPLPOD
82	BB_PRIPLPOD_D	Increment for Additional Floors	decimal	5	2	DEC	((0))	Yes		REXCSKPRIPLPOD
83	BB_PRIPLPOD_E	Increment for Additional Floors	decimal	5	2	DEC	((0))	Yes		REXCSKPRIPLPOD
84	BB_PRIPLPOD_F	Increment for Additional Floors	decimal	5	2	DEC	((0))	Yes		REXCSKPRIPLPOD
85	BB_PRIPLPOD_G	Increment for Additional Floors	decimal	5	2	DEC	((0))	Yes		REXCSKPRIPLPOD
86	BB_DANPOM_A	Tax Amount (Buildings)	decimal	11	3	DEC	((0))	Yes		REXCSKDANB
87	BB_DANPOM_B	Tax Amount (Buildings)	decimal	11	3	DEC	((0))	Yes		REXCSKDANB
88	BB_DANPOM_C	Tax Amount (Buildings)	decimal	11	3	DEC	((0))	Yes		REXCSKDANB
89	BB_DANPOM_D	Tax Amount (Buildings)	decimal	11	3	DEC	((0))	Yes		REXCSKDANB
90	BB_DANPOM_E	Tax Amount (Buildings)	decimal	11	3	DEC	((0))	Yes		REXCSKDANB
91	BB_DANPOM_F	Tax Amount (Buildings)	decimal	11	3	DEC	((0))	Yes		REXCSKDANB
92	BB_DANPOM_G	Tax Amount (Buildings)	decimal	11	3	DEC	((0))	Yes		REXCSKDANB
93	F_VYMERAPODL_B	Floor Area	decimal	6	2	DEC	((0))	Yes		REXCSKVYMPP
94	F_VYMERAPODL_NB	Floor Area	decimal	6	2	DEC	((0))	Yes		REXCSKVYMPP
95	F_VYMERAOSV_B	Floor Area Exempted From Tax	decimal	6	2	DEC	((0))	Yes		REXCSKVYMPPOSV
96	F_VYMERAOSV_NB	Floor Area Exempted From Tax	decimal	6	2	DEC	((0))	Yes		REXCSKVYMPPOSV
97	F_VYMERADAN_B	Taxable Floor Area	decimal	6	2	DEC	((0))	Yes		REXCSKVYMPPDAN
98	F_VYMERADAN_NB	Taxable Floor Area	decimal	6	2	DEC	((0))	Yes		REXCSKVYMPPDAN
99	F_ZAKLADM2_B	Taxable Floor Area	decimal	6	2	DEC	((0))	Yes		REXCSKZAKLADPP
100	F_ZAKLADM2_NB	Taxable Floor Area	decimal	6	2	DEC	((0))	Yes		REXCSKZAKLADPP
101	F_ROCSAZ_B	Annual Tax Rate	decimal	6	3	DEC	((0))	Yes		REXCSKROCSAZ
102	F_ROCSAZ_NB	Annual Tax Rate	decimal	6	3	DEC	((0))	Yes		REXCSKROCSAZ
103	F_DAN_B	Tax Amount (Apartments and Common Areas)	decimal	11	3	DEC	((0))	Yes		REXCSKDANF
104	F_DAN_NB	Tax Amount (Apartments and Common Areas)	decimal	11	3	DEC	((0))	Yes		REXCSKDANF
105	F_DANPOMV_B	Tax Amount (Apartments and Common Areas)	decimal	11	3	DEC	((0))	Yes		REXCSKDANF
106	F_DANPOMV_NB	Tax Amount (Apartments and Common Areas)	decimal	11	3	DEC	((0))	Yes		REXCSKDANF
107	F_DANSNIZ_B	Tax Amount (Apartments and Common Areas)	decimal	11	3	DEC	((0))	Yes		REXCSKDANF
108	F_DANSNIZ_NB	Tax Amount (Apartments and Common Areas)	decimal	11	3	DEC	((0))	Yes		REXCSKDANF
109	POZNAMKA	Remark	nvarchar	100	0	CHAR	(N' ')	Yes		REXCSKPOZN	Allow NULL?
110	DAN	Total Tax Amount	decimal	11	3	DEC	((0))	Yes		REXCSKDAN
111	DANPOMV	Tax Amount (for Part of the Year)	decimal	11	3	DEC	((0))	Yes		REXCSKDANPOM
112	DANSNIZ	Tax Reduction Amount	decimal	11	3	DEC	((0))	Yes		REXCSKDANRED
113	DANUHR	Tax Settlement Amount	decimal	11	3	DEC	((0))	Yes		REXCSKDANUHR
114	DANROZ	Tax Difference Amount	decimal	11	3	DEC	((0))	Yes		REXCSKDANROZ
115	TAXTOTAL	Total Tax Amount	decimal	11	2	CURR	((0))	Yes		REXCSKTAXTOTAL
116	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	*	WAERS	Allow NULL?
117	DATVYPOCTU	Calculation Date	nvarchar	8	0	DATS	(N'00000000')	Yes		REXCSKDATVYPOCTU	Allow NULL?
118	CASVYPOCTU	Calculation Time	nvarchar	6	0	TIMS	(N'000000')	Yes		REXCSKCASVYPOCTU	Allow NULL?
119	STAVYPOCTU	Calculation Status	char	1	0	CHAR	(N' ')	Yes		REXCSKSTAVYPOCTU	Allow NULL?
120	USERVYPOCTU	Calculation Executed By	nvarchar	12	0	CHAR	(N' ')	Yes		REXCSKVYPOCETL	Allow NULL?
121	LOG_HNDL	Application Log: Log Handle	nvarchar	22	0	CHAR	(N' ')	Yes		BALLOGHNDL	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

121 COLUMNS | 1 INDEXES | ERP 6.0 | VIXCSKTAXRET_S TABLE

TOP ERP 6.0 | VIXCSKTAXRET_S COLUMNS

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

121 COLUMNS | 1 INDEXES | ERP 6.0 | VIXCSKTAXRET_S TABLE

TOPERP 6.0 | VIXCSKTAXRET_S COLUMNS

TOPERP 6.0 | VIXCSKTAXRET_S INDEXES

TOP ERP 6.0 | VIXCSKTAXRET_S COLUMNS

TOP ERP 6.0 | VIXCSKTAXRET_S INDEXES