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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
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
Financial Accounting :: General Ledger Accounting :: Basic Functions
1	ERP EHP7	6.0	TTXY	99	1	External tax interface: tax information	Basic Functions

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	AWTYP	Reference Transaction	nvarchar	5	CHAR	(N' ')	No	*	AWTYP	Allow NULL?
3	AWREF	Reference Document Number	nvarchar	10	CHAR	(N' ')	No		AWREF	Allow NULL?
4	AWORG	Reference Organizational Units	nvarchar	10	CHAR	(N' ')	No		AWORG	Allow NULL?
5	KPOSN	Condition item number	nvarchar	6	NUMC	(N'000000')	No		KPOSN	Allow NULL?
6	MWSKZ	Tax on sales/purchases code	nvarchar	2	CHAR	(N' ')	No	*	MWSKZ	Allow NULL?
7	SHPTO	Tax Jurisdiction	nvarchar	15	CHAR	(N' ')	No	*	TXJCD	Allow NULL?
8	CLIENT	Client	nvarchar	3	CLNT	(N'000')	No	*	MANDT	Allow NULL?
9	COMP_CODE	Company Code	nvarchar	4	CHAR	(N' ')	No	*	BUKRS	Allow NULL?
10	DIVISION	Business Area	nvarchar	4	CHAR	(N' ')	No	*	GSBER	Allow NULL?
11	COUNTRY	Tax departure country	nvarchar	3	CHAR	(N' ')	No	*	LANDTX	Allow NULL?
12	DOC_NUMBER	Accounting Document Number	nvarchar	10	CHAR	(N' ')	No		BELNR_D	Allow NULL?
13	POS_NO	Sales Document Item	nvarchar	6	NUMC	(N'000000')	No	*	POSNR_VA	Allow NULL?
14	ACCNT_NO	Account number	nvarchar	16	CHAR	(N' ')	No		KONTO	Allow NULL?
15	ACCNT_CLS	Classification item of an account (Customer/vendor)	nvarchar	10	CHAR	(N' ')	No		KONTOCLASS	Allow NULL?
16	TAX_DATE	Date in CHAR format	nvarchar	8	CHAR	(N' ')	No		DATE	Allow NULL?
17	REP_DATE	Date in CHAR format	nvarchar	8	CHAR	(N' ')	Yes		DATE	Allow NULL?
18	TXJCD_ST	Tax Jurisdiction	nvarchar	15	CHAR	(N' ')	No	*	TXJCD	Allow NULL?
19	TXJCD_SF	Tax Jurisdiction	nvarchar	15	CHAR	(N' ')	No	*	TXJCD	Allow NULL?
20	TXJCD_POA	Tax Jurisdiction	nvarchar	15	CHAR	(N' ')	No	*	TXJCD	Allow NULL?
21	TXJCD_POO	Tax Jurisdiction	nvarchar	15	CHAR	(N' ')	No	*	TXJCD	Allow NULL?
22	TXJCD_IND	Indicator: Jurisdiction code used for tax calculation	char	1	CHAR	(N' ')	No		TXJCDIND	Allow NULL?
23	PTP_IND	Indicator: Point of Title Passage	char	1	CHAR	(N' ')	No		PTP_IND	Allow NULL?
24	APAR_IND	Indicator for A/P or A/R	char	1	CHAR	(N' ')	No		APAR_IND	Allow NULL?
25	TXJCD_L1	Length of the Nth Part of the Tax Jurisdiction Code	nvarchar	2	NUMC	(N'00')	No		LENGX_TXD	Allow NULL?
26	TXJCD_L2	Length of the Nth Part of the Tax Jurisdiction Code	nvarchar	2	NUMC	(N'00')	No		LENGX_TXD	Allow NULL?
27	TXJCD_L3	Length of the Nth Part of the Tax Jurisdiction Code	nvarchar	2	NUMC	(N'00')	No		LENGX_TXD	Allow NULL?
28	TXJCD_L4	Length of the Nth Part of the Tax Jurisdiction Code	nvarchar	2	NUMC	(N'00')	No		LENGX_TXD	Allow NULL?
29	TAX_TYPE	Indicator: Sales/use/rental/service/tax	char	1	CHAR	(N' ')	No		TAXTYPEXT	Allow NULL?
30	MATNR	Material number with 18 characters	nvarchar	18	CHAR	(N' ')	No		TAXMATNR18	Allow NULL?
31	PROD_CODE	SAP internal product code (external interface)	nvarchar	10	CHAR	(N' ')	No		PROCD_TTXP	Allow NULL?
32	QUANTITY	Quantity	nvarchar	13	CHAR	(N' ')	No		QUANT_13	Allow NULL?
33	UNIT	Unit	nvarchar	3	CHAR	(N' ')	No		UNIT_3	Allow NULL?
34	AMOUNT	Tax base amount	nvarchar	15	CHAR	(N' ')	No		BASAMOUNT	Allow NULL?
35	CURRENCY	Currency Key	nvarchar	5	CHAR	(N' ')	No		CURR_5	Allow NULL?
36	CURR_DEC	Number of decimal places for currency (characters)	nvarchar	3	CHAR	(N' ')	No		CURDECCHAR	Allow NULL?
37	FREIGHT_AM	Freight Amount	nvarchar	15	CHAR	(N' ')	No		FRTAMOUNT	Allow NULL?
38	EXEMPT_AMT	Exempt amount	nvarchar	15	CHAR	(N' ')	No		EXMTAMOUNT	Allow NULL?
39	EXEMPT_IND	Indicator: Transaction is tax exempt/taxable	char	1	CHAR	(N' ')	No		EXTEXMTFLG	Allow NULL?
40	CREDIT_IND	Indicator: Tax credit	char	1	CHAR	(N' ')	No		EXTCREDFLG	Allow NULL?
41	UPDATE_IND	Audit file update indicator (external interface)	char	1	CHAR	(N' ')	No		UPDATE_FLG	Allow NULL?
42	OVWRT_IND	Overwrite indicator	char	1	CHAR	(N' ')	No		EXTOVRFLG	Allow NULL?
43	TAXPCT0	Level n tax rate	nvarchar	15	CHAR	(N' ')	No		TAXPERCNT	Allow NULL?
44	TAXPCT1	Level n tax rate	nvarchar	15	CHAR	(N' ')	No		TAXPERCNT	Allow NULL?
45	TAXPCT2	Level n tax rate	nvarchar	15	CHAR	(N' ')	No		TAXPERCNT	Allow NULL?
46	TAXPCT3	Level n tax rate	nvarchar	15	CHAR	(N' ')	No		TAXPERCNT	Allow NULL?
47	TAXPCT4	Level n tax rate	nvarchar	15	CHAR	(N' ')	No		TAXPERCNT	Allow NULL?
48	TAXPCT5	Level n tax rate	nvarchar	15	CHAR	(N' ')	No		TAXPERCNT	Allow NULL?
49	TAXPCT6	Level n tax rate	nvarchar	15	CHAR	(N' ')	No		TAXPERCNT	Allow NULL?
50	TAXPCT7	Level n tax rate	nvarchar	15	CHAR	(N' ')	No		TAXPERCNT	Allow NULL?
51	TAXPCT8	Level n tax rate	nvarchar	15	CHAR	(N' ')	No		TAXPERCNT	Allow NULL?
52	TAXPCT9	Level n tax rate	nvarchar	15	CHAR	(N' ')	No		TAXPERCNT	Allow NULL?
53	TAXPCOV	Total tax rate	nvarchar	15	CHAR	(N' ')	No		TAXPERCNTG	Allow NULL?
54	TAXAMT0	Level n tax amount	nvarchar	15	CHAR	(N' ')	No		TAXAMOUNT	Allow NULL?
55	TAXAMT1	Level n tax amount	nvarchar	15	CHAR	(N' ')	No		TAXAMOUNT	Allow NULL?
56	TAXAMT2	Level n tax amount	nvarchar	15	CHAR	(N' ')	No		TAXAMOUNT	Allow NULL?
57	TAXAMT3	Level n tax amount	nvarchar	15	CHAR	(N' ')	No		TAXAMOUNT	Allow NULL?
58	TAXAMT4	Level n tax amount	nvarchar	15	CHAR	(N' ')	No		TAXAMOUNT	Allow NULL?
59	TAXAMT5	Level n tax amount	nvarchar	15	CHAR	(N' ')	No		TAXAMOUNT	Allow NULL?
60	TAXAMT6	Level n tax amount	nvarchar	15	CHAR	(N' ')	No		TAXAMOUNT	Allow NULL?
61	TAXAMT7	Level n tax amount	nvarchar	15	CHAR	(N' ')	No		TAXAMOUNT	Allow NULL?
62	TAXAMT8	Level n tax amount	nvarchar	15	CHAR	(N' ')	No		TAXAMOUNT	Allow NULL?
63	TAXAMT9	Level n tax amount	nvarchar	15	CHAR	(N' ')	No		TAXAMOUNT	Allow NULL?
64	TAXAMOV	Total tax amount	nvarchar	15	CHAR	(N' ')	No		TAXAMOUNTG	Allow NULL?
65	TAXBAS0	Tax base amount level n	nvarchar	15	CHAR	(N' ')	No		TAXBASE	Allow NULL?
66	TAXBAS1	Tax base amount level n	nvarchar	15	CHAR	(N' ')	No		TAXBASE	Allow NULL?
67	TAXBAS2	Tax base amount level n	nvarchar	15	CHAR	(N' ')	No		TAXBASE	Allow NULL?
68	TAXBAS3	Tax base amount level n	nvarchar	15	CHAR	(N' ')	No		TAXBASE	Allow NULL?
69	TAXBAS4	Tax base amount level n	nvarchar	15	CHAR	(N' ')	No		TAXBASE	Allow NULL?
70	TAXBAS5	Tax base amount level n	nvarchar	15	CHAR	(N' ')	No		TAXBASE	Allow NULL?
71	TAXBAS6	Tax base amount level n	nvarchar	15	CHAR	(N' ')	No		TAXBASE	Allow NULL?
72	TAXBAS7	Tax base amount level n	nvarchar	15	CHAR	(N' ')	No		TAXBASE	Allow NULL?
73	TAXBAS8	Tax base amount level n	nvarchar	15	CHAR	(N' ')	No		TAXBASE	Allow NULL?
74	TAXBAS9	Tax base amount level n	nvarchar	15	CHAR	(N' ')	No		TAXBASE	Allow NULL?
75	EXMATFLG	Code for material tax exemption	nvarchar	2	CHAR	(N' ')	No		EXMATCODE	Allow NULL?
76	EXCUSFLG	Code for customer tax exemption	nvarchar	2	CHAR	(N' ')	No		EXCUSCODE	Allow NULL?
77	EXAMT0	Exempt amount	nvarchar	15	CHAR	(N' ')	No		EXMTAMOUNT	Allow NULL?
78	EXAMT1	Exempt amount	nvarchar	15	CHAR	(N' ')	No		EXMTAMOUNT	Allow NULL?
79	EXAMT2	Exempt amount	nvarchar	15	CHAR	(N' ')	No		EXMTAMOUNT	Allow NULL?
80	EXAMT3	Exempt amount	nvarchar	15	CHAR	(N' ')	No		EXMTAMOUNT	Allow NULL?
81	EXAMT4	Exempt amount	nvarchar	15	CHAR	(N' ')	No		EXMTAMOUNT	Allow NULL?
82	EXAMT5	Exempt amount	nvarchar	15	CHAR	(N' ')	No		EXMTAMOUNT	Allow NULL?
83	EXAMT6	Exempt amount	nvarchar	15	CHAR	(N' ')	No		EXMTAMOUNT	Allow NULL?
84	EXAMT7	Exempt amount	nvarchar	15	CHAR	(N' ')	No		EXMTAMOUNT	Allow NULL?
85	EXAMT8	Exempt amount	nvarchar	15	CHAR	(N' ')	No		EXMTAMOUNT	Allow NULL?
86	EXAMT9	Exempt amount	nvarchar	15	CHAR	(N' ')	No		EXMTAMOUNT	Allow NULL?
87	EXCODE0	Tax Exemption Reason Code	nvarchar	2	CHAR	(N' ')	No		EXDETCODE	Allow NULL?
88	EXCODE1	Tax Exemption Reason Code	nvarchar	2	CHAR	(N' ')	No		EXDETCODE	Allow NULL?
89	EXCODE2	Tax Exemption Reason Code	nvarchar	2	CHAR	(N' ')	No		EXDETCODE	Allow NULL?
90	EXCODE3	Tax Exemption Reason Code	nvarchar	2	CHAR	(N' ')	No		EXDETCODE	Allow NULL?
91	EXCODE4	Tax Exemption Reason Code	nvarchar	2	CHAR	(N' ')	No		EXDETCODE	Allow NULL?
92	EXCODE5	Tax Exemption Reason Code	nvarchar	2	CHAR	(N' ')	No		EXDETCODE	Allow NULL?
93	EXCODE6	Tax Exemption Reason Code	nvarchar	2	CHAR	(N' ')	No		EXDETCODE	Allow NULL?
94	EXCODE7	Tax Exemption Reason Code	nvarchar	2	CHAR	(N' ')	No		EXDETCODE	Allow NULL?
95	EXCODE8	Tax Exemption Reason Code	nvarchar	2	CHAR	(N' ')	No		EXDETCODE	Allow NULL?
96	EXCODE9	Tax Exemption Reason Code	nvarchar	2	CHAR	(N' ')	No		EXDETCODE	Allow NULL?
97	EXCERTIF	Customer tax exemption certificate number defined in SAP	nvarchar	25	CHAR	(N' ')	No		EXCERTIF	Allow NULL?
98	EXREASON	Tax Exemption Reason Code	nvarchar	2	CHAR	(N' ')	No		EXDETCODE	Allow NULL?
99	USER_DATA	User-specific field	nvarchar	50	CHAR	(N' ')	No		USER_DATA	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

99 COLUMNS | 1 INDEXES | ERP 6.0 | TTXY TABLE

TOP ERP 6.0 | TTXY COLUMNS

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

99 COLUMNS | 1 INDEXES | ERP 6.0 | TTXY TABLE

TOPERP 6.0 | TTXY COLUMNS

TOPERP 6.0 | TTXY INDEXES

TOP ERP 6.0 | TTXY COLUMNS

TOP ERP 6.0 | TTXY INDEXES