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
Basis Components :: Test Workbench :: Use Subcomponents See SAP Note 1156876 :: CATT Computer Aided Test Tool
1	ERP EHP7	6.0	CATA	89	3	CATT: General Test Procedure Data	CATT Computer Aided Test Tool

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	ABLNR	CATT - Test case	nvarchar	30	Allow NULL?
2	ATYP	CATT - Type	char	1	Allow NULL?
3	MODEL	CATT: Test Module Flag	char	1	Allow NULL?
4	APPL	CATT: Application	nvarchar	2	Allow NULL?
5	SAPPL	CATT: Sub-application	nvarchar	3	Allow NULL?
6	THST1	CATT: Component	nvarchar	3	Allow NULL?
7	THST2	CATT: Test Hierarchy Level 6	nvarchar	3	Allow NULL?
8	THST3	CATT: Test Hierarchy Level 3	nvarchar	3	Allow NULL?
9	THST4	CATT: Test Hierarchy Level 4	nvarchar	3	Allow NULL?
10	THST5	CATT: Test Hierarchy Level 5	nvarchar	3	Allow NULL?
11	IQ0NR	CATT: Reference to Test Case Number in QSA Tool IQ00	nvarchar	8	Allow NULL?
12	RVON	CATT - Valid from Release	nvarchar	3	Allow NULL?
13	RBIS	CATT - changed in Release	nvarchar	3	Allow NULL?
14	SYST	CATT - System ID	nvarchar	3	Allow NULL?
15	MAND	CATT: Original Client	nvarchar	3	Allow NULL?
16	LVORM	CATT - Delete flag	char	1	Allow NULL?
17	BATCH	CATT - Background flag	char	1	Allow NULL?
18	FREIG	CATT: Released flag	char	1	Allow NULL?
19	ABBRU	CATT: Termination flag	char	1	Allow NULL?
20	INAKT	CATT: Inactive flag	char	1	Allow NULL?
21	EXCMD	CATT - External variants	char	1	Allow NULL?
22	OSPRA	CATT: Original Language	char	1	Allow NULL?
23	ERFAS	CATT: Creator	nvarchar	12	Allow NULL?
24	ERDAT	CATT: Creation Date	nvarchar	8	Allow NULL?
25	AENDER	CATT: Last Change by	nvarchar	12	Allow NULL?
26	AEDAT	CATT: Date of last change to test procedure data	nvarchar	8	Allow NULL?
27	MUSER	CATT: Mail Address	nvarchar	12	Allow NULL?
28	PAIN01	CATT: Parameter value	nvarchar	20	Allow NULL?
29	PAIN02	CATT: Parameter value	nvarchar	20	Allow NULL?
30	PAIN03	CATT: Parameter value	nvarchar	20	Allow NULL?
31	PAIN04	CATT: Parameter value	nvarchar	20	Allow NULL?
32	PAIN05	CATT: Parameter value	nvarchar	20	Allow NULL?
33	PAIN06	CATT: Parameter value	nvarchar	20	Allow NULL?
34	PAIN07	CATT: Parameter value	nvarchar	20	Allow NULL?
35	PAIN08	CATT: Parameter value	nvarchar	20	Allow NULL?
36	PAIN09	CATT: Parameter value	nvarchar	20	Allow NULL?
37	PAIN10	CATT: Parameter value	nvarchar	20	Allow NULL?
38	PAIN11	CATT: Parameter value	nvarchar	20	Allow NULL?
39	PAIN12	CATT: Parameter value	nvarchar	20	Allow NULL?
40	PAIN13	CATT: Parameter value	nvarchar	20	Allow NULL?
41	PAIN14	CATT: Parameter value	nvarchar	20	Allow NULL?
42	PAIN15	CATT: Parameter value	nvarchar	20	Allow NULL?
43	PAIN16	CATT: Parameter value	nvarchar	20	Allow NULL?
44	PAIN17	CATT: Parameter value	nvarchar	20	Allow NULL?
45	PAIN18	CATT: Parameter value	nvarchar	20	Allow NULL?
46	PAIN19	CATT: Parameter value	nvarchar	20	Allow NULL?
47	PAIN20	CATT: Parameter value	nvarchar	20	Allow NULL?
48	AETIME	Time of last change	nvarchar	6	Allow NULL?
49	TFNAM	Assignment of test case name to hypertext module	nvarchar	20	Allow NULL?
50	TFAEN	Test case assignment changed by	nvarchar	12	Allow NULL?
51	TFAED	Test case change date	nvarchar	8	Allow NULL?
52	TFAET	Time of last test case change	nvarchar	6	Allow NULL?
53	EKLAS	Development class?	nvarchar	4	Allow NULL?
54	PRKNZ	Use external transaction data	char	1	Allow NULL?
55	PRNAM	Tester name	nvarchar	12	Allow NULL?
56	PRDAT	Test date	nvarchar	8	Allow NULL?
57	PRTIM	Test time	nvarchar	6	Allow NULL?
58	PRSYS	Test system	nvarchar	3	Allow NULL?
59	PRMND	Test client	nvarchar	3	Allow NULL?
60	PRREL	CATT - valid until Release	nvarchar	3	Allow NULL?
61	KATEG	CATT - Application-independent ID	char	1	Allow NULL?
62	NUPLA	Use platform test	char	1	Allow NULL?
63	NUANW	Use of applications test	char	1	Allow NULL?
64	NULAN	Country-specific test use	char	1	Allow NULL?
65	NUIND	Individual test use	char	1	Allow NULL?
66	NUHOT	CATT - Conversion flag	char	1	Allow NULL?
67	ABFRO	Dependency frontend	char	1	Allow NULL?
68	ABPLA	Platform dependency	char	1	Allow NULL?
69	ABSPR	Language-Dependence	char	1	Allow NULL?
70	ABLAN	Country-dependency	char	1	Allow NULL?
71	ABKON	Context-dependent	char	1	Allow NULL?
72	SPRAK	CATT - Language ID	char	1	Allow NULL?
73	LANDK	Country code	nvarchar	3	Allow NULL?
74	KONTK	CATT - Context flag	char	1	Allow NULL?
75	PRIOT	Priority	char	1	Allow NULL?
76	ZEITB	Time requirement	nvarchar	6	Allow NULL?
77	FGNAM	Release name	nvarchar	12	Allow NULL?
78	FGDAT	Release date	nvarchar	8	Allow NULL?
79	FGTIM	Release time	nvarchar	6	Allow NULL?
80	PAIN21	CATT: Parameter value	nvarchar	20	Allow NULL?
81	PAIN22	CATT: Parameter value	nvarchar	20	Allow NULL?
82	PAIN23	CATT: Parameter value	nvarchar	20	Allow NULL?
83	PAIN24	CATT: Parameter value	nvarchar	20	Allow NULL?
84	PAIN25	CATT: Parameter value	nvarchar	20	Allow NULL?
85	PAIN26	CATT: Parameter value	nvarchar	20	Allow NULL?
86	PAIN27	CATT: Parameter value	nvarchar	20	Allow NULL?
87	PAIN28	CATT: Parameter value	nvarchar	20	Allow NULL?
88	PAIN29	CATT: Parameter value	nvarchar	20	Allow NULL?
89	PAIN30	CATT: Parameter value	nvarchar	20	Allow NULL?

Name	Primary	Unique	Type	Columns
CATA~0	Yes	Yes	CLUSTERED	ABLNR
CATA~A	No	No	NONCLUSTERED	THST1, SAPPL, APPL
CATA~B	No	No	NONCLUSTERED	ATYP, APPL

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

89 COLUMNS | 3 INDEXES | ERP 6.0 | CATA TABLE

TOP ERP 6.0 | CATA COLUMNS

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

89 COLUMNS | 3 INDEXES | ERP 6.0 | CATA TABLE

TOPERP 6.0 | CATA COLUMNS

TOPERP 6.0 | CATA INDEXES

TOP ERP 6.0 | CATA COLUMNS

TOP ERP 6.0 | CATA INDEXES