| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | PROCGUID | Log GUID for Performance Analysis | varbinary | 16 | 0 | RAW | | No | | PROCGUID | |
| 2 | DESTIN | Logical Destination (Specified in Function Call) | nvarchar | 32 | 0 | CHAR | (N' ') | No | * | RFCDEST | Allow NULL? |
| 3 | LFNUM | Global Performance Analysis: Sequence Number | nvarchar | 8 | 0 | CHAR | (N' ') | No | | LFNUMB | Allow NULL? |
| 4 | ASCHEMA | Name of Evaluation Schema (Global Performance Analysis) | nvarchar | 56 | 0 | CHAR | (N' ') | No | | ASCHEMA | Allow NULL? |
| 5 | AOBJECT | Name of Evaluation Object (Global Performance Analysis) | nvarchar | 56 | 0 | CHAR | (N' ') | No | | AOBJECT | Allow NULL? |
| 6 | TOTALEXEC | Total Number of Executions of Identical SQL Statements | decimal | 10 | 0 | DEC | ((0)) | Yes | | TOTALEXEC | |
| 7 | EXECTIME | Total Runtime for SQL Statements (in Microseconds) | decimal | 12 | 0 | DEC | ((0)) | Yes | | EXECTIME | |
| 8 | RECPROCNUM | Total Number of Database Records Passed to Program | decimal | 10 | 0 | DEC | ((0)) | Yes | | RECPROCNUM | |
| 9 | WPROCTIME | Time in Work Process (Reponse Time - Wait Time) in ms | decimal | 18 | 2 | DEC | ((0)) | Yes | | WPROCTIME | |
| 10 | KBYTETRANS | Amount of Data Transferred in KB (= Queue + Source + DSQL) | decimal | 13 | 2 | DEC | ((0)) | Yes | | KBYTETRANS | |
| 11 | RESPTIME | Response Time in ms | decimal | 18 | 2 | DEC | ((0)) | Yes | | RESPTIME | |
| 12 | WAITTIME | Queue Wait Time in ms | decimal | 13 | 2 | DEC | ((0)) | Yes | | WAITTIME1 | |
| 13 | CPUTIME | CPU Time in ms | decimal | 18 | 2 | DEC | ((0)) | Yes | | CPUTIME | |
| 14 | LDGENTIME | Load and Generation Time in ms | decimal | 13 | 2 | DEC | ((0)) | Yes | | LDGENTIME | |
| 15 | MEMORYUSED | Memory Used in MBytes | decimal | 13 | 2 | DEC | ((0)) | Yes | | MEMORYUSED | |
| 16 | DBTIME | Database Time in ms | decimal | 13 | 2 | DEC | ((0)) | Yes | | DBTIME | |
| 17 | DBCHANGES | Number of Physical Database Changes | decimal | 13 | 2 | DEC | ((0)) | Yes | | DBCHANGES | |
| 18 | ROUNDTRIPS | SAP Workload: Number of Roundtrips | decimal | 18 | 2 | DEC | ((0)) | Yes | | ROUNDTRIPS | |
| 19 | INOUTDATA | Total Data Volume Between Front End and App. Server (KB) | decimal | 16 | 2 | DEC | ((0)) | Yes | | INOUTDATA | |
| 20 | INDATA | Average Data Volume to Application Server per Step (kBytes) | decimal | 16 | 2 | DEC | ((0)) | Yes | | INDATA_P | |
| 21 | OUTDATA | Average Data Volume to Front End per Step (kBytes) | decimal | 16 | 2 | DEC | ((0)) | Yes | | OUTDATA_P | |
| 22 | TOTALEX_ST | Number of Database Accesses (SEL, UPD, INS, DEL)(Statistics) | decimal | 13 | 2 | DEC | ((0)) | Yes | | TOTALEX_ST | |
| 23 | RECPROCNUM_ST | Total Number of DB Recs Delivered to Program (Statistics) | decimal | 13 | 2 | DEC | ((0)) | Yes | | RECPROCNUM_ST | |
| 24 | TOTALEXEC_SAW | Standard Deviation: Total Number of Identical SQL Statements | decimal | 13 | 2 | DEC | ((0)) | Yes | | TOTALEXEC_SAW | |
| 25 | EXECTIME_SAW | Standard Deviation: Total Execution Time: SQL Statements | decimal | 15 | 2 | DEC | ((0)) | Yes | | EXECTIME_SAW | |
| 26 | RECPROCNUM_SAW | Standard Deviation: Total Number of Database Recs Delivered | decimal | 13 | 2 | DEC | ((0)) | Yes | | RECPROCNUM_SAW | |
| 27 | WPROCTIME_SAW | Standard Deviation: Time in Work Process | decimal | 18 | 2 | DEC | ((0)) | Yes | | WPROCTIME_SAW | |
| 28 | KBYTETRANS_SAW | Standard Deviation: Transferred Data Volume in Kilobytes | decimal | 13 | 2 | DEC | ((0)) | Yes | | KBYTETRANS_SAW | |
| 29 | RESPTIME_SAW | Standard Deviation: Response Time | decimal | 18 | 2 | DEC | ((0)) | Yes | | RESPTIME_SAW | |
| 30 | WAITTIME_SAW | Standard Deviation: Wait Time in the Queue in ms | decimal | 13 | 2 | DEC | ((0)) | Yes | | WAITTIME_SAW | |
| 31 | CPUTIME_SAW | Standard Deviation: CPU Time | decimal | 18 | 2 | DEC | ((0)) | Yes | | CPUTIME_SAW | |
| 32 | LDGENTIME_SAW | Standard Deviation: Load and Generation Time in ms | decimal | 13 | 2 | DEC | ((0)) | Yes | | LDGENTIME_SAW | |
| 33 | MEMORYUSED_SAW | Standard Deviation: Size of Utilized Memory | decimal | 13 | 2 | DEC | ((0)) | Yes | | MEMORYUSED_SAW | |
| 34 | DBTIME_SAW | Standard Deviation: Database Time in ms | decimal | 13 | 2 | DEC | ((0)) | Yes | | DBTIME_SAW | |
| 35 | DBCHANGES_SAW | Standard Deviation: Number of Physical Database Changes | decimal | 13 | 2 | DEC | ((0)) | Yes | | DBCHANGES_SAW | |
| 36 | ROUNDTRIPS_SAW | Standard Deviation: Number of Roundtrips | decimal | 18 | 2 | DEC | ((0)) | Yes | | ROUNDTRIPS_SAW | |
| 37 | INDATA_SAW | Standard Deviation: Data Volume to Application Server | decimal | 16 | 2 | DEC | ((0)) | Yes | | INDATA_SAW | |
| 38 | OUTDATA_SAW | Standard Deviation: Data Volume to Front End | decimal | 16 | 2 | DEC | ((0)) | Yes | | OUTDATA_SAW | |
| 39 | TOTALEX_ST_SAW | Standard Deviation: Number of DB Accesses (Statistics) | decimal | 13 | 2 | DEC | ((0)) | Yes | | TOTALEX_ST_SAW | |
| 40 | RECPROCNUM_STSAW | Standard Deviation: Number of DB Recs Delivered (Statistics) | decimal | 13 | 2 | DEC | ((0)) | Yes | | RECPROCNUM_ST_SAW | |
| 41 | STEXTKEY | Metatext | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | STEXTKEY | Allow NULL? |
