/SMB/SQL_TRACE - Table for SQL Trace details
Table for SQL Trace details information is stored in SAP table /SMB/SQL_TRACE.
It is part of development package /SMB/UTILITY in software component SV-CLD-FRM-INF. This development package consists of objects that can be grouped under "Utility Functions".
It is part of development package /SMB/UTILITY in software component SV-CLD-FRM-INF. This development package consists of objects that can be grouped under "Utility Functions".
Fields for table /SMB/SQL_TRACE
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CREATED_DATE | Date of Traced Activity | X | /SMB/ST05_DATE | DATS | 16 | |
| CREATED_TIME | Start Time of Traced Activity | X | /SMB/ST05_TIME | CHAR | 24 | |
| CREATED_BY | User Who Executed Recorded Action | X | /SMB/ST05_USER_NAME | CHAR | 24 | |
| CINDEX | SQL Index | X | /SMB/SQL_INDEX | INT4 | 4 | |
| CHANGED_DATE | Date of Traced Activity | /SMB/ST05_DATE | DATS | 16 | ||
| CHANGED_TIME | Start Time of Traced Activity | /SMB/ST05_TIME | CHAR | 24 | ||
| CHANGED_BY | User Who Executed Recorded Action | /SMB/ST05_USER_NAME | CHAR | 24 | ||
| TABLENAME | Object That a Traced Activity Accessed | /SMB/ST05_OBJECT | CHAR | 60 | ||
| STATEMENT | Statement(SELECT/INSERT/UPDATE/DELETE) | /SMB/ST05_STATEMENT | CHAR | 12 |