SAP ABAP Table ADASYSMO (SYSDBA.SYSMONITOR and Selection From SYSDBA.SYSPARSEID)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-DB-SDB (Application Component) MaxDB
⤷ SADA (Package) Porting and CCMS SAP DB
⤷ BC-DB-SDB (Application Component) MaxDB
⤷ SADA (Package) Porting and CCMS SAP DB
Basic Data
Table Category | INTTAB | Structure |
Structure | ADASYSMO | Table Relationship Diagram |
Short Description | SYSDBA.SYSMONITOR and Selection From SYSDBA.SYSPARSEID |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | SYSK | ADA_SYSK | CHAR16 | CHAR | 16 | 0 | SAP DB: Syskey | ||
2 | LINKAGE | ADA_LINK | CHAR2 | CHAR | 2 | 0 | SAP DB: Linkage | ||
3 | PARSEID | ADA_PAID | CHAR24 | CHAR | 24 | 0 | SAP DB: Parse ID | ||
4 | ROWS_READ | ADA_READ | DEC20 | DEC | 20 | 0 | SAP DB: Counter for rows read | ||
5 | ROWS_QUAL | ADA_QUAL | DEC20 | DEC | 20 | 0 | SAP DB: Counter for qualified rows | ||
6 | VIRTUAL_R | ADA_VRDS | DEC20 | DEC | 20 | 0 | SAP DB: Counter for virtual reads | ||
7 | SUBREQS | ADA_REQS | DEC20 | DEC | 20 | 0 | SAP DB: Counter for subrequests | ||
8 | STRATEGY | ADA_STRA | CHAR40 | CHAR | 40 | 0 | SAP DB: Strategy of SQL optimizer | ||
9 | RUNTIME | ADA_RTIM | DEC20_3 | DEC | 20 | 3 | SAP DB: SQL command runtime in seconds | ||
10 | VWAITS | ADA_VWAI | DEC20 | DEC | 20 | 0 | SAP DB: Counter for SQL waits | ||
11 | VSUSPENDS | ADA_VSUS | DEC20 | DEC | 20 | 0 | SAP DB: Counter for task suspensions | ||
12 | PHYS_IO | ADA_PHIO | DEC20 | DEC | 20 | 0 | SAP DB: Counter for physical I/O access | ||
13 | R_FETCHED | ADA_RFET | DEC20 | DEC | 20 | 0 | SAP DB: Counter for "gotten" rows | ||
14 | F_CALLS | ADA_FCAL | DEC20 | DEC | 20 | 0 | SAP DB: Number of get calls | ||
15 | ROOT1 | ADA_ROOT | INT4 | INT4 | 10 | 0 | SAP DB: Root of a DB index | ||
16 | ROOT2 | ADA_ROOT | INT4 | INT4 | 10 | 0 | SAP DB: Root of a DB index | ||
17 | ROOT3 | ADA_ROOT | INT4 | INT4 | 10 | 0 | SAP DB: Root of a DB index | ||
18 | ROOT4 | ADA_ROOT | INT4 | INT4 | 10 | 0 | SAP DB: Root of a DB index | ||
19 | ROOT5 | ADA_ROOT | INT4 | INT4 | 10 | 0 | SAP DB: Root of a DB index | ||
20 | ROOT6 | ADA_ROOT | INT4 | INT4 | 10 | 0 | SAP DB: Root of a DB index | ||
21 | RES_COPIED | ADA_RESC | CHAR3 | CHAR | 3 | 0 | SAP DB: Indicator whether result should be phys. built | ||
22 | A_DATE | SDBA_DATE | DATS | DATS | 8 | 0 | Date stamp | ||
23 | A_TIME | SDBA_TIME | SYTIME | TIMS | 6 | 0 | Time (24 hour clock) for DBA action to run | ||
24 | TABNAME | ADATABNAME | CHAR30 | CHAR | 30 | 0 | SDB Table Name | ||
25 | S_SQLSTMNT | ADA_SSTMT | CHAR80 | CHAR | 80 | 0 | SAP DB: Start of SQL command | ||
26 | SELTIVITY | ADA_SELTY | DEC3_2 | DEC | 5 | 2 | SAP DB: Ratio of qualified to read rows | ||
27 | VR_PERLINE | ADA_VRPL | DEC20_2 | DEC | 20 | 2 | SAP DB: Number of page accesses per row | ||
28 | OPERATION | ADA_OP | CHAR10 | CHAR | 10 | 0 | SAP DB: SQL operation | ||
29 | JOB | SYREPID | PROGRAMM | CHAR | 40 | 0 | ABAP Program: Current Main Program | * | |
30 | LINE | ABP_CONT | INT4 | 10 | 0 | Offset of a Processing Control Block | |||
31 | OWNER | SADAOWN | CHAR32 | CHAR | 32 | 0 | SAP DB: Database table owner | ||
32 | TOTAL_IO | ADA_VALUE | DEC20 | DEC | 20 | 0 | SYSDBA.MONITOR.VALUE | ||
33 | JOB_LONG | CHAR120 | CHAR120 | CHAR | 120 | 0 | char120 |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |