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

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