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
Application Platform :: Transaction Tax Engine
1	ERP EHP7	6.0	TTEPD3_USITEM	94	1	Persistency TTE Document UsItem	Transaction Tax Engine

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	CLIENT	Client	nvarchar	3	Allow NULL?
2	TTEDOCUMENTID	TTE Document ID	varbinary	16
3	ITEMID	Item Identifier	nvarchar	32	Allow NULL?
4	COMP_CODE	Company Code	nvarchar	4	Allow NULL?
5	DIVISION	Business Area/Division Code	nvarchar	4	Allow NULL?
6	COUNTRY	Tax Departure Country	nvarchar	3	Allow NULL?
7	DOC_NUMBER	Document No.	nvarchar	10	Allow NULL?
8	POS_NO	Tax document item number	nvarchar	6	Allow NULL?
9	ACCNT_NO	External Partner Number	nvarchar	16	Allow NULL?
10	ACCNT_CLS	Taxable Partner Classification	nvarchar	10	Allow NULL?
11	TAX_DATE	Date of Tax Calculation	nvarchar	8	Allow NULL?
12	REP_DATE	Date for Tax Reporting	nvarchar	8	Allow NULL?
13	TXJCD_ST	Jurisdiction code	nvarchar	15	Allow NULL?
14	TXJCD_SF	Jurisdiction code	nvarchar	15	Allow NULL?
15	TXJCD_POA	Jurisdiction code	nvarchar	15	Allow NULL?
16	TXJCD_POO	Jurisdiction code	nvarchar	15	Allow NULL?
17	TXJCD_IND	Indicator: Tax Jurisdiction	char	1	Allow NULL?
18	PTP_IND	Indicator: Space for Title Transfer	char	1	Allow NULL?
19	APAR_IND	Ind.: Transaction on Debit/Credit Side	char	1	Allow NULL?
20	TXJCD_L1	Two digit number	nvarchar	2	Allow NULL?
21	TXJCD_L2	Two digit number	nvarchar	2	Allow NULL?
22	TXJCD_L3	Two digit number	nvarchar	2	Allow NULL?
23	TXJCD_L4	Two digit number	nvarchar	2	Allow NULL?
24	TAX_TYPE	Indicator: Tax Category (Sales/Rental/Use/Lease)	char	1	Allow NULL?
25	MATNR	Calling System Material Number	nvarchar	18	Allow NULL?
26	PROD_CODE	Taxable Product Classification	nvarchar	10	Allow NULL?
27	QUANTITY	Taxable Quantity	nvarchar	13	Allow NULL?
28	UNIT	Tax Base Unit of Measure	nvarchar	3	Allow NULL?
29	AMOUNT	Tax Base Amount	nvarchar	15	Allow NULL?
30	CURRENCY	Tax currency	nvarchar	5	Allow NULL?
31	CURR_DEC	No. of Decimal Places for Tax Reporting Currency	nvarchar	3	Allow NULL?
32	FREIGHT_AM	Freight Amount	nvarchar	15	Allow NULL?
33	EXEMPT_AMT	Tax Exemption Amount	nvarchar	15	Allow NULL?
34	EXEMPT_IND	Indicator: Tax Exemption	char	1	Allow NULL?
35	CREDIT_IND	Indicator: Tax Credit Memo	char	1	Allow NULL?
36	UPDATE_IND	Indicator: Update Calling System	char	1	Allow NULL?
37	OVWRT_IND	Indicator: Overwriting A Calling System	char	1	Allow NULL?
38	TAXPCT0	Tax Percentage Rate	nvarchar	15	Allow NULL?
39	TAXPCT1	Tax Percentage Rate	nvarchar	15	Allow NULL?
40	TAXPCT2	Tax Percentage Rate	nvarchar	15	Allow NULL?
41	TAXPCT3	Tax Percentage Rate	nvarchar	15	Allow NULL?
42	TAXPCT4	Tax Percentage Rate	nvarchar	15	Allow NULL?
43	TAXPCT5	Tax Percentage Rate	nvarchar	15	Allow NULL?
44	TAXPCT6	Tax Percentage Rate	nvarchar	15	Allow NULL?
45	TAXPCT7	Tax Percentage Rate	nvarchar	15	Allow NULL?
46	TAXPCT8	Tax Percentage Rate	nvarchar	15	Allow NULL?
47	TAXPCT9	Tax Percentage Rate	nvarchar	15	Allow NULL?
48	TAXPCOV	Tax Percentage Rate	nvarchar	15	Allow NULL?
49	TAXAMT0	Tax Amount	nvarchar	15	Allow NULL?
50	TAXAMT1	Tax Amount	nvarchar	15	Allow NULL?
51	TAXAMT2	Tax Amount	nvarchar	15	Allow NULL?
52	TAXAMT3	Tax Amount	nvarchar	15	Allow NULL?
53	TAXAMT4	Tax Amount	nvarchar	15	Allow NULL?
54	TAXAMT5	Tax Amount	nvarchar	15	Allow NULL?
55	TAXAMT6	Tax Amount	nvarchar	15	Allow NULL?
56	TAXAMT7	Tax Amount	nvarchar	15	Allow NULL?
57	TAXAMT8	Tax Amount	nvarchar	15	Allow NULL?
58	TAXAMT9	Tax Amount	nvarchar	15	Allow NULL?
59	TAXAMOV	Tax Amount	nvarchar	15	Allow NULL?
60	TAXBAS0	Tax Base Amount From Calling System	nvarchar	15	Allow NULL?
61	TAXBAS1	Tax Base Amount From Calling System	nvarchar	15	Allow NULL?
62	TAXBAS2	Tax Base Amount From Calling System	nvarchar	15	Allow NULL?
63	TAXBAS3	Tax Base Amount From Calling System	nvarchar	15	Allow NULL?
64	TAXBAS4	Tax Base Amount From Calling System	nvarchar	15	Allow NULL?
65	TAXBAS5	Tax Base Amount From Calling System	nvarchar	15	Allow NULL?
66	TAXBAS6	Tax Base Amount From Calling System	nvarchar	15	Allow NULL?
67	TAXBAS7	Tax Base Amount From Calling System	nvarchar	15	Allow NULL?
68	TAXBAS8	Tax Base Amount From Calling System	nvarchar	15	Allow NULL?
69	TAXBAS9	Tax Base Amount From Calling System	nvarchar	15	Allow NULL?
70	EXMATFLG	Tax Exemption Code Material	nvarchar	2	Allow NULL?
71	EXCUSFLG	Tax Exemption Code Business partner	nvarchar	2	Allow NULL?
72	EXAMT0	Tax Exemption Amount	nvarchar	15	Allow NULL?
73	EXAMT1	Tax Exemption Amount	nvarchar	15	Allow NULL?
74	EXAMT2	Tax Exemption Amount	nvarchar	15	Allow NULL?
75	EXAMT3	Tax Exemption Amount	nvarchar	15	Allow NULL?
76	EXAMT4	Tax Exemption Amount	nvarchar	15	Allow NULL?
77	EXAMT5	Tax Exemption Amount	nvarchar	15	Allow NULL?
78	EXAMT6	Tax Exemption Amount	nvarchar	15	Allow NULL?
79	EXAMT7	Tax Exemption Amount	nvarchar	15	Allow NULL?
80	EXAMT8	Tax Exemption Amount	nvarchar	15	Allow NULL?
81	EXAMT9	Tax Exemption Amount	nvarchar	15	Allow NULL?
82	EXCODE0	Code for Tax Exemption	nvarchar	2	Allow NULL?
83	EXCODE1	Code for Tax Exemption	nvarchar	2	Allow NULL?
84	EXCODE2	Code for Tax Exemption	nvarchar	2	Allow NULL?
85	EXCODE3	Code for Tax Exemption	nvarchar	2	Allow NULL?
86	EXCODE4	Code for Tax Exemption	nvarchar	2	Allow NULL?
87	EXCODE5	Code for Tax Exemption	nvarchar	2	Allow NULL?
88	EXCODE6	Code for Tax Exemption	nvarchar	2	Allow NULL?
89	EXCODE7	Code for Tax Exemption	nvarchar	2	Allow NULL?
90	EXCODE8	Code for Tax Exemption	nvarchar	2	Allow NULL?
91	EXCODE9	Code for Tax Exemption	nvarchar	2	Allow NULL?
92	EXCERTIF	Tax Exemption Certificate	nvarchar	25	Allow NULL?
93	EXREASON	Code for Tax Exemption	nvarchar	2	Allow NULL?
94	USER_DATA	User-Specific Data	nvarchar	50	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

94 COLUMNS | 1 INDEXES | ERP 6.0 | TTEPD3_USITEM TABLE

TOP ERP 6.0 | TTEPD3_USITEM COLUMNS

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

94 COLUMNS | 1 INDEXES | ERP 6.0 | TTEPD3_USITEM TABLE

TOPERP 6.0 | TTEPD3_USITEM COLUMNS

TOPERP 6.0 | TTEPD3_USITEM INDEXES

TOP ERP 6.0 | TTEPD3_USITEM COLUMNS

TOP ERP 6.0 | TTEPD3_USITEM INDEXES