SCI_CC_ALV SAP (SCI: Structure for ALV Display in Cursor Cache Analysis) Structure details
Description: SCI: Structure for ALV Display in Cursor Cache Analysis
Structure field list including key, data, relationships and ABAP select examples
SCI_CC_ALV is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "SCI: Structure for ALV Display in Cursor Cache Analysis" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_SCI_CC_ALV TYPE SCI_CC_ALV.
The SCI_CC_ALV table consists of various fields, each holding specific information or linking keys about SCI: Structure for ALV Display in Cursor Cache Analysis data available in SAP. These include FULL_TABLE_SCAN (SCI: ID for Full Table Scan in Cursor Cache Analysis), FULL_INDEX_SCAN (SCI: ID for Full Index Scan in Cursor Cache Analysis), INDEX_CLIENT_SCAN (SCI: ID for Index Range Scan of Client in CC Analysis), INDEX_RANGE_SCAN (SCI: ID for Index Range Scan in Cursor Cache Analysis).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP SCI_CC_ALV structure fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| ADDRESS | SCI: Address of Statement in Cursor Cache Analysis | SCI_CC_ADD | CHAR | 16 | |||||
| FULL_TABLE_SCAN | SCI: ID for Full Table Scan in Cursor Cache Analysis | SCI_CC_FTS | CHAR | 1 | SYCHAR01 | ||||
| FULL_INDEX_SCAN | SCI: ID for Full Index Scan in Cursor Cache Analysis | SCI_CC_FIS | CHAR | 1 | SYCHAR01 | ||||
| INDEX_CLIENT_SCAN | SCI: ID for Index Range Scan of Client in CC Analysis | SCI_CC_ICS | CHAR | 1 | SYCHAR01 | ||||
| INDEX_RANGE_SCAN | SCI: ID for Index Range Scan in Cursor Cache Analysis | SCI_CC_IRS | CHAR | 1 | SYCHAR01 | ||||
| HASH_JOIN | SCI: ID for Hash Join in Cursor Cache Analysis | SCI_CC_HJO | CHAR | 1 | SYCHAR01 | ||||
| TAB_IDX_OBJ | SCI: Table or Index in Cursor Cache Analysis | SCI_CC_TIO | CHAR | 34 | |||||
| BUFFERED_TABLE | SCI: Buffered Table Found in Cursor Cache | SCI_CC_BUF | CHAR | 5 | |||||
| SOURCE | SCI: Program Name in Cursor Cache Analysis | SCI_CC_SRC | CHAR | 64 | |||||
| ACTION | SCI: Action in Cursor Cache Analysis | SCI_CC_ACT | CHAR | 64 | |||||
| RATIO_TO_ALL | SCI: Cursor Cache Analysis/Portion Re. All Statements | SCI_CC_PCT | DEC | 3(1) | |||||
| DISK_READS | SCI: Disk Reads per Execution in Cursor Cache Analysis | SCI_CC_DIR | DEC | 31 | |||||
| BUFFER_GETS | SCI: Buffer Gets per Execution in Cursor Cache Analysis | SCI_CC_BFG | DEC | 31 | |||||
| CPU_TIME | SCI: CPU Time in Cursor Cache Analysis | SCI_CC_CPU | DEC | 31 | |||||
| EXECUTIONS | SCI: Number of Executions in Cursor Cache Analysis | SCI_CC_EXE | DEC | 31 | |||||
| CPU_TIME_E | SCI: CPU Time for Each Execution in Cursor Cache Analysis | SCI_CC_CPE | DEC | 31 | |||||
| SQL_STMNT | SCI: SQL Statement (Short) in Cursor Cache Analysis | SCI_CC_STM | CHAR | 60 |
| Key field | Non-key field |
How do I retrieve data from SAP structure SCI_CC_ALV using ABAP code?
As SCI_CC_ALV is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on SCI_CC_ALV as there is no data to select.How to access SAP table SCI_CC_ALV
Within an ECC or HANA version of SAP you can also view further information about SCI_CC_ALV and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects