| 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 | INSTANCE | Instance Name | nvarchar | 40 | 0 | CHAR | (N' ') | No | | MSNAME3 | Allow NULL? |
| 4 | LFNUM | Global Performance Analysis: Sequence Number | nvarchar | 8 | 0 | CHAR | (N' ') | No | | LFNUMB | Allow NULL? |
| 5 | TCODE | Performance Log: Statistical Record Transaction Code | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | STAT_TCODE | Allow NULL? |
| 6 | OKEY | Performance Protocol Statistical Record Open Key (Text) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | OKEY | Allow NULL? |
| 7 | CONNECTION_NAME | Perofrmance Protocol Statisticsl Record DB Connection | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CONNECTION_NAME | Allow NULL? |
| 8 | WPROCTIME | Time in Work Process (Reponse Time - Wait Time) in ms | decimal | 24 | 2 | DEC | ((0)) | Yes | | WPROCTIME2 | |
| 9 | KBYTETRANS | Amount of Data Transferred in KB (= Queue + Source + DSQL) | decimal | 14 | 2 | DEC | ((0)) | Yes | | KBYTETRANS2 | |
| 10 | RESPTIME | Response Time in ms | decimal | 24 | 2 | DEC | ((0)) | Yes | | RESPTIME2 | |
| 11 | WAITTIME | Queue Wait Time in ms | decimal | 14 | 2 | DEC | ((0)) | Yes | | WAITTIME2 | |
| 12 | CPUTIME | CPU Time in ms | decimal | 18 | 2 | DEC | ((0)) | Yes | | CPUTIME | |
| 13 | LDGENTIME | Load and Generation Time in ms | decimal | 14 | 2 | DEC | ((0)) | Yes | | LDGENTIME2 | |
| 14 | MEMORYUSED | Memory Used in MBytes | decimal | 24 | 2 | DEC | ((0)) | Yes | | MEMORYUSED2 | |
| 15 | DBTIME | Database Time in ms | decimal | 24 | 2 | DEC | ((0)) | Yes | | DBTIME2 | |
| 16 | DBCHANGES | Number of Physical Database Changes | decimal | 14 | 2 | DEC | ((0)) | Yes | | DBCHANGES2 | |
| 17 | ROUNDTRIPS | SAP Workload: Number of Roundtrips | decimal | 18 | 2 | DEC | ((0)) | Yes | | ROUNDTRIPS | |
| 18 | INOUTDATA | Total Data Volume Between Front End and App. Server (KB) | decimal | 16 | 2 | DEC | ((0)) | Yes | | INOUTDATA | |
| 19 | INDATA | Average Data Volume to Application Server per Step (kBytes) | decimal | 16 | 2 | DEC | ((0)) | Yes | | INDATA_P | |
| 20 | OUTDATA | Average Data Volume to Front End per Step (kBytes) | decimal | 16 | 2 | DEC | ((0)) | Yes | | OUTDATA_P | |
| 21 | RECPROCNUM_ST | Total Number of DB Recs Delivered to Program (Statistics) | decimal | 15 | 2 | DEC | ((0)) | Yes | | RECPROCNUM_ST2 | |
| 22 | TOTALEX_ST | Number of Database Accesses (SEL, UPD, INS, DEL)(Statistics) | decimal | 15 | 2 | DEC | ((0)) | Yes | | TOTALEX_ST2 | |
