RSODSO_ASQL_LOGS - ANYSQL log table
ANYSQL log table information is stored in SAP table RSODSO_ASQL_LOGS.
It is part of development package RSODSO_ACT_DB_ASQL in software component BW-WHM-DBA. This development package consists of objects that can be grouped under "ANYSQL framework".
It is part of development package RSODSO_ACT_DB_ASQL in software component BW-WHM-DBA. This development package consists of objects that can be grouped under "ANYSQL framework".
Fields for table RSODSO_ASQL_LOGS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| SYS_USER | ABAP System Field: Name of Current User | X | SYST_UNAME | CHAR | 24 | |
| ROUTINE_START_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | X | TIMESTAMPL | DEC | 11 | |
| EXEC_UUID | 16 byte UUID in 26 chars (usually Base 32 encoded) | X | SYSUUID_C26 | CHAR | 52 | |
| EXEC_STEP | Execution step | X | INT4 | 4 | ||
| ROUTINE_NAME | ASQL routine name | CHAR | 128 | |||
| ROUTINE_VERSION | ASQL routine version | INT4 | 4 | |||
| ROUTINE_VARIANT | ASQL routine variant | CHAR | 128 | |||
| STMT_START_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC | 11 | ||
| DB_SYS | Selector Value for Database-Specific Optimizations | DBSYS_TYPE_SELECTOR | CHAR | 20 | ||
| DB_RELEASE | DB release string | CHAR | 32 | |||
| DB_CODE | SQL return code | INT4 | 4 | |||
| DB_MSG | SQL Error Message | DBSQLMSG | CHAR | 2000 | ||
| STMT_STR | SQL statement | STRG | 8 | |||
| ROUTINE_STMT_NO | Statement number | INT4 | 4 | |||
| STMT_FMT | Formatted SQL statement | STRG | 8 | |||
| STMT_END_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC | 11 | ||
| STMT_LOG_LEVEL | ASQL log level | INT1 | 1 | |||
| STMT_EXPLAIN | Access plan for SQL statement | STRG | 8 | |||
| STMT_COMMENT | Comment | CHAR | 512 | |||
| SYS_WP_PID | Process Identification | WPPID | CHAR | 16 | ||
| SYS_WP_SERVER | Application Server Instance | MSNAME | CHAR | 40 | ||
| SYS_WP_NUMBER | Work Process Number | WPINDEX | INT4 | 4 | ||
| SYS_WP_TYP | Internal work process type | WPITYPE | INT1 | 1 | ||
| REC_MODIFIED | Number of modified records | INT4 | 4 | |||
| REC_SELECTED | Number of selected records | INT4 | 4 | |||
| STMT_PARAMS | Statement parameters separated by newline | STRG | 8 |