SAP ABAP Table SPERFTRAC (Structure for Dialog Global Performance Analysis)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-TWB-TST-P-GPA (Application Component) Global Performance Analysis (Transaction ST30)
     ⤷ S_PERF_TRA (Package) New Performance Trace / Statistics with DB Connection

Basic Data

Table Category	INTTAB	Structure
Structure	SPERFTRAC	Table Relationship Diagram
Short Description	Structure for Dialog Global Performance Analysis

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	PROCGUID	☐	PROCGUID	SYSUUID	RAW	16	0	Log GUID for Performance Analysis
2	PSTARTDATE	☐	TSTARTDATE	SYDATS	DATS	8	0	Start Date of Performance Log
3	PSTARTTIME	☐	TSTARTTIME	SYTIME	TIMS	6	0	Start Time of Performance Log
4	PENDDATE	☐	TENDDATE	SYDATS	DATS	8	0	Performance Log End Date
5	PENDTIME	☐	TENDTIME	SYTIME	TIMS	6	0	Performance Log End Time
6	TRON	☐	XFELD	XFELD	CHAR	1	0	Checkbox
7	TROFF	☐	XFELD	XFELD	CHAR	1	0	Checkbox
8	DESTIN	☐	RFCDEST	RFCDEST	CHAR	32	0	Logical Destination (Specified in Function Call)	*
9	DESTSTAT	☐	DESTSTAT	DESTSTAT	CHAR	132	0	Message Test for Action at Destination
10	RFCHOST	☐	RFCHOST	RFCHOST	CHAR	100	0	Name of target host
11	DESTDATE	☐	DESTDATE	SYDATS	DATS	8	0	Local Date at Destination
12	DESTTIME	☐	DESTTIME	SYTIME	TIMS	6	0	Local Time at Destination
13	DESTSIGN	☐	DESTSIGN	CHAR1	CHAR	1	0	Sign
14	DESTDELTA	☐	DESTDELTA	SYTIME	TIMS	6	0	Time Difference Between Destination and Calling System
15	TRSTAT	☐	SQLTTEXT	CHAR95	CHAR	95	0	Description of performance trace switched on
16	KZSEL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
17	TRTYP_SQL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
18	TRTYP_ENQ	☐	XFELD	XFELD	CHAR	1	0	Checkbox
19	TRTYP_RFC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
20	TRTYP_BUF	☐	XFELD	XFELD	CHAR	1	0	Checkbox
21	CATTNAME	☐	TWB_NAME	TWB_NAME	CHAR	30	0	Test	TNODE02_A
22	DAT_STAT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
23	DAT_TRACE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
24	DATSAV_YES	☐	XFELD	XFELD	CHAR	1	0	Checkbox
25	DATSAV_NO	☐	XFELD	XFELD	CHAR	1	0	Checkbox
26	CAT_ONCE	☐	CAT_ONCE	XFELD	CHAR	1	0	Control: Execute Test Case Once or Twice
27	CAT_TWICE	☐	CAT_ONCE	XFELD	CHAR	1	0	Control: Execute Test Case Once or Twice
28	PROT_ONE	☐	PROT_ONE	XFELD	CHAR	1	0	One Perf. Test per Test Case or One Perf. Test in Total
29	PROT_EACH	☐	PROT_ONE	XFELD	CHAR	1	0	One Perf. Test per Test Case or One Perf. Test in Total
30	SAVLOG_YES	☐	XFELD	XFELD	CHAR	1	0	Checkbox
31	SAVLOG_NO	☐	XFELD	XFELD	CHAR	1	0	Checkbox
32	EC_OBJ_NAME	☐	ETOBJ_NAME	ETOBJ_NAME	CHAR	30	0	eCATT Object
33	PROTIDTEXT_I	☐	PROTIDTEXT	TEXT128	CHAR	128	0	Text for Performance Test
34	PROTIDTEXT_II	☐	PROTIDTEXT	TEXT128	CHAR	128	0	Text for Performance Test
35	COMP_CRIT_YES	☐	COMP_CRIT	XFELD	CHAR	1	0	Comparison of Data with or without Evaluation of Differences
36	COMP_CRIT_NO	☐	COMP_CRIT	XFELD	CHAR	1	0	Comparison of Data with or without Evaluation of Differences
37	COMP_GUID_I	☐	PROCGUID	SYSUUID	RAW	16	0	Log GUID for Performance Analysis
38	COMP_GUID_II	☐	PROCGUID	SYSUUID	RAW	16	0	Log GUID for Performance Analysis
39	TOTALEXEC_L	☐	TOTALEXEC_L	DECV10_2	DEC	10	2	Maximum Difference: Number of Database Accesses (%)
40	TOTALEXEC_B	☐	XFELD	XFELD	CHAR	1	0	Checkbox
41	RECPROCNUM_L	☐	RECPROCNUM_L	DECV10_2	DEC	10	2	Maximum Difference: Number of Database Records Delivered (%)
42	RECPROCNUM_B	☐	XFELD	XFELD	CHAR	1	0	Checkbox
43	RESPTIME	☐	RESPTIME_LA		DEC	15	2	Maximum Average Response Time in Seconds
44	RESPTIME_B	☐	XFELD	XFELD	CHAR	1	0	Checkbox
45	CPUTIME_L	☐	CPUTIME_L	DECV10_2	DEC	10	2	Maximum Difference: CPU Time (%)
46	CPUTIME_B	☐	XFELD	XFELD	CHAR	1	0	Checkbox
47	MEMORYUSED_L	☐	MEMORYUSED_L	DECV10_2	DEC	10	2	Maximum Difference: Maximum Size of Utilized Memory (%)
48	MEMORYUSED_B	☐	XFELD	XFELD	CHAR	1	0	Checkbox
49	ROUNDTRIPS	☐	ROUNDTRIPS_LA		DEC	15	2	Maximum Average Number of Roundtrips
50	ROUNDTRIPS_BA	☐	XFELD	XFELD	CHAR	1	0	Checkbox
51	ROUNDTRIPS_L	☐	ROUNDTRIPS_L	DECV10_2	DEC	10	2	Maximum Difference for Average Number of Roundtrips (%)
52	ROUNDTRIPS_B	☐	XFELD	XFELD	CHAR	1	0	Checkbox
53	INOUTDATA_L	☐	INOUTDATA_L	DECV10_2	DEC	10	2	Maximum Difference: Data Volume to and from App. Server
54	INOUTDATA_B	☐	XFELD	XFELD	CHAR	1	0	Checkbox
55	COLDRUN	☐	COLDRUN	DEC4	DEC	4	0	Number of eCATT Preprocesses of a Performance Analysis
56	HOTRUN	☐	HOTRUN	DEC4	DEC	4	0	Number of eCATT Main Runs of a Performance Analysis
57	RUNWTR	☐	RUNWTR	XFELD	CHAR	1	0	With or Without Main Run for Collecting SQL Trace Data
58	RUNWJV	☐	RUNWJV	XFELD	CHAR	1	0	With or Without DSRs (Distributed Statistics Data)
59	DESTIN_Z	☐	DESTIN_Z	RFCDEST	CHAR	32	0	Destination of the Central System	*
60	WO_TID	☐	WO_TID	XFELD	CHAR	1	0	Find DSRs (Distrib. Stas Data) without Transaction Context
61	PROTIDTEXT_SCI	☐	PROTIDTEXT	TEXT128	CHAR	128	0	Text for Performance Test
62	SCI_GUID	☐	PROCGUID	SYSUUID	RAW	16	0	Log GUID for Performance Analysis
63	RUNWSCI	☐	RUNWSCI	XFELD	CHAR	1	0	With or Without SQL - Trace Analysis
64	DESTIN_SCI	☐	RFCDEST	RFCDEST	CHAR	32	0	Logical Destination (Specified in Function Call)	*
65	KZSEL_SCI	☐	XFELD	XFELD	CHAR	1	0	Checkbox
66	RUNWSCI_STAT	☐	RUNWSCI_STAT	XFELD	CHAR	1	0	With or Without Static Program Analysis
67	CREA_CHECKLIST	☐	CREA_CHECKLIST	XFELD	CHAR	1	0	Create Checklist for General Programming Guidelines
68	GET_ADD_STAT	☐	GET_ADD_STAT	XFELD	CHAR	1	0	Read Additional Statistics Data from Manually Created Dests
69	PERF_MEAS_TYPE	☐	PERF_MEAS_TYPE	XFELD	CHAR	1	0	Performance Measurement with eCATT: Global or Modular

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SPERFTRAC	CATTNAME	TNODE02_A	TC_NAME

History

Last changed by/on	SAP	20110908
SAP Release Created in	50A