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
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	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	ABLNR	CATT - Test case	nvarchar	30	CHAR	(N' ')	No		CATNR	Allow NULL?
2	ATYP	CATT - Type	char	1	CHAR	(N' ')	Yes		CATATYP	Allow NULL?
3	MODEL	CATT: Test Module Flag	char	1	CHAR	(N' ')	Yes		CATMODEL	Allow NULL?
4	APPL	CATT: Application	nvarchar	2	CHAR	(N' ')	Yes		CATAPPL	Allow NULL?
5	SAPPL	CATT: Sub-application	nvarchar	3	CHAR	(N' ')	Yes		CATSUBAP	Allow NULL?
6	THST1	CATT: Component	nvarchar	3	CHAR	(N' ')	Yes		CATTHST1	Allow NULL?
7	THST2	CATT: Test Hierarchy Level 6	nvarchar	3	NUMC	(N'000')	Yes		CATTHST2	Allow NULL?
8	THST3	CATT: Test Hierarchy Level 3	nvarchar	3	NUMC	(N'000')	Yes		CATTHST3	Allow NULL?
9	THST4	CATT: Test Hierarchy Level 4	nvarchar	3	NUMC	(N'000')	Yes		CATTHST4	Allow NULL?
10	THST5	CATT: Test Hierarchy Level 5	nvarchar	3	NUMC	(N'000')	Yes		CATTHST5	Allow NULL?
11	IQ0NR	CATT: Reference to Test Case Number in QSA Tool IQ00	nvarchar	8	NUMC	(N'00000000')	Yes		CATIQ0NR	Allow NULL?
12	RVON	CATT - Valid from Release	nvarchar	3	CHAR	(N' ')	Yes		CATRVON	Allow NULL?
13	RBIS	CATT - changed in Release	nvarchar	3	CHAR	(N' ')	Yes		CATRBIS	Allow NULL?
14	SYST	CATT - System ID	nvarchar	3	CHAR	(N' ')	Yes		CATSYSTEM	Allow NULL?
15	MAND	CATT: Original Client	nvarchar	3	NUMC	(N'000')	Yes		CATMAND	Allow NULL?
16	LVORM	CATT - Delete flag	char	1	CHAR	(N' ')	Yes		CATLVORM	Allow NULL?
17	BATCH	CATT - Background flag	char	1	CHAR	(N' ')	Yes		CATBATCH	Allow NULL?
18	FREIG	CATT: Released flag	char	1	CHAR	(N' ')	Yes		CATFREIG	Allow NULL?
19	ABBRU	CATT: Termination flag	char	1	CHAR	(N' ')	Yes		CATABBRU	Allow NULL?
20	INAKT	CATT: Inactive flag	char	1	CHAR	(N' ')	Yes		CATINAKT	Allow NULL?
21	EXCMD	CATT - External variants	char	1	CHAR	(N' ')	Yes		CATEXCMD	Allow NULL?
22	OSPRA	CATT: Original Language	char	1	LANG	(N' ')	Yes	T002	CATOSPRA	Allow NULL?
23	ERFAS	CATT: Creator	nvarchar	12	CHAR	(N' ')	Yes		CATEUSER	Allow NULL?
24	ERDAT	CATT: Creation Date	nvarchar	8	DATS	(N'00000000')	Yes		CATEDATE	Allow NULL?
25	AENDER	CATT: Last Change by	nvarchar	12	CHAR	(N' ')	Yes		CATAUSER	Allow NULL?
26	AEDAT	CATT: Date of last change to test procedure data	nvarchar	8	DATS	(N'00000000')	Yes		CATADATE	Allow NULL?
27	MUSER	CATT: Mail Address	nvarchar	12	CHAR	(N' ')	Yes		CATMUSER	Allow NULL?
28	PAIN01	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
29	PAIN02	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
30	PAIN03	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
31	PAIN04	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
32	PAIN05	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
33	PAIN06	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
34	PAIN07	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
35	PAIN08	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
36	PAIN09	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
37	PAIN10	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
38	PAIN11	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
39	PAIN12	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
40	PAIN13	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
41	PAIN14	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
42	PAIN15	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
43	PAIN16	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
44	PAIN17	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
45	PAIN18	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
46	PAIN19	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
47	PAIN20	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
48	AETIME	Time of last change	nvarchar	6	TIMS	(N'000000')	Yes		CATTAETIME	Allow NULL?
49	TFNAM	Assignment of test case name to hypertext module	nvarchar	20	CHAR	(N' ')	Yes		CATTFNAM	Allow NULL?
50	TFAEN	Test case assignment changed by	nvarchar	12	CHAR	(N' ')	Yes		CATTFAEN	Allow NULL?
51	TFAED	Test case change date	nvarchar	8	DATS	(N'00000000')	Yes		CATTFAED	Allow NULL?
52	TFAET	Time of last test case change	nvarchar	6	TIMS	(N'000000')	Yes		CATTFAET	Allow NULL?
53	EKLAS	Development class?	nvarchar	4	CHAR	(N' ')	Yes		CATEKLAS	Allow NULL?
54	PRKNZ	Use external transaction data	char	1	CHAR	(N' ')	Yes		CATXVARI	Allow NULL?
55	PRNAM	Tester name	nvarchar	12	CHAR	(N' ')	Yes		CATPRNAM	Allow NULL?
56	PRDAT	Test date	nvarchar	8	DATS	(N'00000000')	Yes		CATPRDAT	Allow NULL?
57	PRTIM	Test time	nvarchar	6	TIMS	(N'000000')	Yes		CATPRTIM	Allow NULL?
58	PRSYS	Test system	nvarchar	3	CHAR	(N' ')	Yes		CATPRSYS	Allow NULL?
59	PRMND	Test client	nvarchar	3	NUMC	(N'000')	Yes		CATPRMND	Allow NULL?
60	PRREL	CATT - valid until Release	nvarchar	3	CHAR	(N' ')	Yes		CATPRREL	Allow NULL?
61	KATEG	CATT - Application-independent ID	char	1	CHAR	(N' ')	Yes		CATKATEG	Allow NULL?
62	NUPLA	Use platform test	char	1	CHAR	(N' ')	Yes		CATNUPLA	Allow NULL?
63	NUANW	Use of applications test	char	1	CHAR	(N' ')	Yes		CATNUANW	Allow NULL?
64	NULAN	Country-specific test use	char	1	CHAR	(N' ')	Yes		CATNULAN	Allow NULL?
65	NUIND	Individual test use	char	1	CHAR	(N' ')	Yes		CATNUIND	Allow NULL?
66	NUHOT	CATT - Conversion flag	char	1	CHAR	(N' ')	Yes		CATNUHOT	Allow NULL?
67	ABFRO	Dependency frontend	char	1	CHAR	(N' ')	Yes		CATABFRO	Allow NULL?
68	ABPLA	Platform dependency	char	1	CHAR	(N' ')	Yes		CATABPLA	Allow NULL?
69	ABSPR	Language-Dependence	char	1	CHAR	(N' ')	Yes		CATABSPR	Allow NULL?
70	ABLAN	Country-dependency	char	1	CHAR	(N' ')	Yes		CATABLAN	Allow NULL?
71	ABKON	Context-dependent	char	1	CHAR	(N' ')	Yes		CATABKON	Allow NULL?
72	SPRAK	CATT - Language ID	char	1	LANG	(N' ')	Yes	T002	CATSPRAK	Allow NULL?
73	LANDK	Country code	nvarchar	3	CHAR	(N' ')	Yes	T005	CATLANDK	Allow NULL?
74	KONTK	CATT - Context flag	char	1	CHAR	(N' ')	Yes		CATKONTK	Allow NULL?
75	PRIOT	Priority	char	1	NUMC	(N'0')	Yes		CATPRIOR	Allow NULL?
76	ZEITB	Time requirement	nvarchar	6	NUMC	(N'000000')	Yes		CATZEITB	Allow NULL?
77	FGNAM	Release name	nvarchar	12	CHAR	(N' ')	Yes		CATFGNAM	Allow NULL?
78	FGDAT	Release date	nvarchar	8	DATS	(N'00000000')	Yes		CATFGDAT	Allow NULL?
79	FGTIM	Release time	nvarchar	6	TIMS	(N'000000')	Yes		CATFGTIM	Allow NULL?
80	PAIN21	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
81	PAIN22	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
82	PAIN23	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
83	PAIN24	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
84	PAIN25	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
85	PAIN26	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
86	PAIN27	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
87	PAIN28	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
88	PAIN29	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	Allow NULL?
89	PAIN30	CATT: Parameter value	nvarchar	20	CHAR	(N' ')	Yes		CATPAINVL	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