SAP ABAP Table AMSUR (Global Performance Analysis: Overview Summarized Log Data)

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	TRANSP	Transparent table
Transparent table	AMSUR	Table Relationship Diagram
Short Description	Global Performance Analysis: Overview Summarized Log Data

Delivery and Maintenance

Pool/cluster
Delivery Class	S	System table, maint. only by SAP, change = modification
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	DESTIN	☑	RFCDEST	RFCDEST	CHAR	32	0	Logical Destination (Specified in Function Call)	*
3	LFNUM	☑	LFNUMB	CHAR8	CHAR	8	0	Global Performance Analysis: Sequence Number
4	ASCHEMA	☐	ASCHEMA	TEXT56	CHAR	56	0	Name of Evaluation Schema (Global Performance Analysis)
5	AOBJECT	☐	AOBJECT	TEXT56	CHAR	56	0	Name of Evaluation Object (Global Performance Analysis)
6	.INCLUDE	☐				0	0	DB Structure: Cumulated Performance Data from Trace and Stat
7	TOTALEXEC	☐	TOTALEXEC	DECI10	DEC	10	0	Total Number of Executions of Identical SQL Statements
8	EXECTIME	☐	EXECTIME	DEC12	DEC	12	0	Total Runtime for SQL Statements (in Microseconds)
9	RECPROCNUM	☐	RECPROCNUM	DECI10	DEC	10	0	Total Number of Database Records Passed to Program
10	WPROCTIME	☐	WPROCTIME		DEC	18	2	Time in Work Process (Reponse Time - Wait Time) in ms
11	KBYTETRANS	☐	KBYTETRANS		DEC	13	2	Amount of Data Transferred in KB (= Queue + Source + DSQL)
12	RESPTIME	☐	RESPTIME		DEC	18	2	Response Time in ms
13	WAITTIME	☐	WAITTIME1		DEC	13	2	Queue Wait Time in ms
14	CPUTIME	☐	CPUTIME		DEC	18	2	CPU Time in ms
15	LDGENTIME	☐	LDGENTIME		DEC	13	2	Load and Generation Time in ms
16	MEMORYUSED	☐	MEMORYUSED		DEC	13	2	Memory Used in MBytes
17	DBTIME	☐	DBTIME		DEC	13	2	Database Time in ms
18	DBCHANGES	☐	DBCHANGES		DEC	13	2	Number of Physical Database Changes
19	ROUNDTRIPS	☐	ROUNDTRIPS		DEC	18	2	SAP Workload: Number of Roundtrips
20	INOUTDATA	☐	INOUTDATA		DEC	16	2	Total Data Volume Between Front End and App. Server (KB)
21	INDATA	☐	INDATA_P		DEC	16	2	Average Data Volume to Application Server per Step (kBytes)
22	OUTDATA	☐	OUTDATA_P		DEC	16	2	Average Data Volume to Front End per Step (kBytes)
23	TOTALEX_ST	☐	TOTALEX_ST		DEC	13	2	Number of Database Accesses (SEL, UPD, INS, DEL)(Statistics)
24	RECPROCNUM_ST	☐	RECPROCNUM_ST		DEC	13	2	Total Number of DB Recs Delivered to Program (Statistics)
25	TOTALEXEC_SAW	☐	TOTALEXEC_SAW		DEC	13	2	Standard Deviation: Total Number of Identical SQL Statements
26	EXECTIME_SAW	☐	EXECTIME_SAW		DEC	15	2	Standard Deviation: Total Execution Time: SQL Statements
27	RECPROCNUM_SAW	☐	RECPROCNUM_SAW		DEC	13	2	Standard Deviation: Total Number of Database Recs Delivered
28	WPROCTIME_SAW	☐	WPROCTIME_SAW		DEC	18	2	Standard Deviation: Time in Work Process
29	KBYTETRANS_SAW	☐	KBYTETRANS_SAW		DEC	13	2	Standard Deviation: Transferred Data Volume in Kilobytes
30	RESPTIME_SAW	☐	RESPTIME_SAW		DEC	18	2	Standard Deviation: Response Time
31	WAITTIME_SAW	☐	WAITTIME_SAW		DEC	13	2	Standard Deviation: Wait Time in the Queue in ms
32	CPUTIME_SAW	☐	CPUTIME_SAW		DEC	18	2	Standard Deviation: CPU Time
33	LDGENTIME_SAW	☐	LDGENTIME_SAW		DEC	13	2	Standard Deviation: Load and Generation Time in ms
34	MEMORYUSED_SAW	☐	MEMORYUSED_SAW		DEC	13	2	Standard Deviation: Size of Utilized Memory
35	DBTIME_SAW	☐	DBTIME_SAW		DEC	13	2	Standard Deviation: Database Time in ms
36	DBCHANGES_SAW	☐	DBCHANGES_SAW		DEC	13	2	Standard Deviation: Number of Physical Database Changes
37	ROUNDTRIPS_SAW	☐	ROUNDTRIPS_SAW		DEC	18	2	Standard Deviation: Number of Roundtrips
38	INDATA_SAW	☐	INDATA_SAW		DEC	16	2	Standard Deviation: Data Volume to Application Server
39	OUTDATA_SAW	☐	OUTDATA_SAW		DEC	16	2	Standard Deviation: Data Volume to Front End
40	TOTALEX_ST_SAW	☐	TOTALEX_ST_SAW		DEC	13	2	Standard Deviation: Number of DB Accesses (Statistics)
41	RECPROCNUM_STSAW	☐	RECPROCNUM_ST_SAW		DEC	13	2	Standard Deviation: Number of DB Recs Delivered (Statistics)
42	STEXTKEY	☐	STEXTKEY		CHAR	4	0	Metatext

History

Last changed by/on	SAP	20110908
SAP Release Created in	610