Table/Structure Field list used by SAP ABAP Program /SSA/BSB (DB2/390 statement cache download)
SAP ABAP Program
/SSA/BSB (DB2/390 statement cache download) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | /SSF/BTAB - OBJKEY | /SSF/BTAB-OBJKEY | ||
| 2 | /SSF/BTAB - PID | /SSF/BTAB-PID | ||
| 3 | /SSF/BTAB - PLEN | /SSF/BTAB-PLEN | ||
| 4 | /SSF/DHEAD - ADATE | /SSF/DHEAD-ADATE | ||
| 5 | /SSF/DHEAD - ATYPE | /SSF/DHEAD-ATYPE | ||
| 6 | /SSF/DHEAD - AUSER | /SSF/DHEAD-AUSER | ||
| 7 | /SSF/DHEAD - GUID | /SSF/DHEAD-GUID | ||
| 8 | /SSF/DHEAD - SEQNO | /SSF/DHEAD-SEQNO | ||
| 9 | /SSF/DHEAD - USERCOMMENT | /SSF/DHEAD-USERCOMMENT | ||
| 10 | D010SINF - CDAT | Created on | ||
| 11 | D010SINF - CNAM | Author | ||
| 12 | D010SINF - PROG | ABAP Program Name | ||
| 13 | D010SINF - R3STATE | ABAP: Program Status (Active, Saved, Transported...) | ||
| 14 | D010SINF - UDAT | Changed On | ||
| 15 | D010SINF - UNAM | Last changed by | ||
| 16 | DB2DSMEM - MEMB_NAME | DB2DSMEM-MEMB_NAME | ||
| 17 | DB2IXDETL - BPOOL | DB2/390: Buffer pool | ||
| 18 | DB2IXDETL - CLURATIO | Clusterratio: Percentage of rows in clustering order | ||
| 19 | DB2IXDETL - CLUSTERED | Whether the table is actually clustered by the index | ||
| 20 | DB2IXDETL - CLUSTERING | Whether CLUSTER was specified when the index was created | ||
| 21 | DB2IXDETL - COLCOUNT | Number of columns in the key | ||
| 22 | DB2IXDETL - CREATOR | DB2 creator name | ||
| 23 | DB2IXDETL - NAME | Name of a DB2 for OS/390 index | ||
| 24 | DB2IXDETL - NLEVELS | DB2 for OS/390 number of levels in the index tree | ||
| 25 | DB2IXDETL - PARTITIONS | Number of partitions of a tablespace or index | ||
| 26 | DB2IXDETL - STATSTIME | Date and time of last RUNSTATS | ||
| 27 | DB2IXDETL - TBNAME | Name of the table on which the index is defined | ||
| 28 | DB2IXKEY - IXNAME | Name of a DB2 for OS/390 index | ||
| 29 | DB2QDSCCONT - QW0317TX | SQL statement text | ||
| 30 | DB2QSTC - QSTCSTNM | DB2 statement name | ||
| 31 | DB2QTHDDSC - QW0317TX | SQL statement text | ||
| 32 | DB2QW0317 - QW0317TX | SQL statement text | ||
| 33 | DB2QXST - QXDELET | Number of DELETE statements executed | ||
| 34 | DB2QXST - QXDESC | Number of DESCRIBE statements executed | ||
| 35 | DB2QXST - QXFETCH | Number of FETCH statements executed | ||
| 36 | DB2QXST - QXINSRT | Number of INSERT statements executed | ||
| 37 | DB2QXST - QXPREP | Number of PREPARE statements executed | ||
| 38 | DB2QXST - QXSELECT | Number of SELECT statements executed | ||
| 39 | DB2QXST - QXUPDTE | Number of UPDATE statements executed | ||
| 40 | DB2TBDETL - CARDF | Total number of rows in the table | ||
| 41 | DB2TBDETL - CREATOR | DB2 creator name | ||
| 42 | DB2TBDETL - NAME | DB2 table name | ||
| 43 | DB2TBDETL - RECLENGTH | Maximum length (in bytes) of any record in the table | ||
| 44 | DB2TBDETL - SIZE | Size of the table in KB | ||
| 45 | DB2TBDETL - STATSTIME | Date and time of last RUNSTATS | ||
| 46 | DB2TBDETL - TSNAME | Name of the tablespace | ||
| 47 | DB2TBLIST - CREATOR | DB2 creator name | ||
| 48 | DB2TBLIST - NAME | DB2 table name | ||
| 49 | DB2THREADS - ASHOST | Application server host name | ||
| 50 | DB2THREADS - DS_MEMBER | DB2THREADS-DS_MEMBER | ||
| 51 | DB2THREADS - WPID | Work process ID | ||
| 52 | DBCON - CON_NAME | Logical name for a database connection | ||
| 53 | DCOBJBEZ - NAME | Name of ABAP Dictionary Object | ||
| 54 | DCOBJDEF - NAME | Name of ABAP Dictionary Object | ||
| 55 | DD02V - AS4USER | Last Changed By | ||
| 56 | DD02V - DDLANGUAGE | Language Key | ||
| 57 | DD02V - DDTEXT | Short Description of Repository Objects | ||
| 58 | DD02V - TABCLASS | Table category | ||
| 59 | DD02V - TABNAME | Table Name | ||
| 60 | DD03P - DDLANGUAGE | Language Key | ||
| 61 | DD03P - DDTEXT | Short Description of Repository Objects | ||
| 62 | DD03P - FIELDNAME | Field Name | ||
| 63 | DD03P - KEYFLAG | Identifies a key field of a table | ||
| 64 | DD03P - POSITION | Position of the field in the table | ||
| 65 | DD03P - TABNAME | Table Name | ||
| 66 | DD06V - DDLANGUAGE | Language Key | ||
| 67 | DD06V - DDTEXT | Explanatory short text | ||
| 68 | DD06V - SQLCLASS | Indicator for pool or cluster | ||
| 69 | DD06V - SQLTAB | Name of Pool/Cluster in the Database | ||
| 70 | DD09L - AS4DATE | Date of Last Change | ||
| 71 | DD09L - AS4TIME | Last changed at | ||
| 72 | DD09L - AS4USER | Last Changed By | ||
| 73 | DD09L - BUFALLOW | Indicator for buffering allowed/not allowed | ||
| 74 | DD09L - PUFFERUNG | Buffering type indicator | ||
| 75 | DD09L - SCHFELDANZ | No. of key fields for generic buffers | ||
| 76 | DD09L - TABNAME | Table Name | ||
| 77 | DD12V - AS4USER | Last Changed By | ||
| 78 | DD12V - INDEXNAME | Unique Index ID in a Table | ||
| 79 | DD12V - SQLTAB | Table Name | ||
| 80 | DD12V - UNIQUEFLAG | Flag for UNIQUE indexes | ||
| 81 | DD17V - DDLANGUAGE | Language Key | ||
| 82 | DD17V - FIELDNAME | Field Name | ||
| 83 | DD17V - INDEXNAME | Unique Index ID in a Table | ||
| 84 | DD17V - POSITION | Position of the field in the table | ||
| 85 | DD17V - SQLTAB | Table Name | ||
| 86 | DD27P - TABNAME | Table Name | ||
| 87 | LINETAB - LINE | The SQL statement text | ||
| 88 | SCREEN - ACTIVE | SCREEN-ACTIVE | ||
| 89 | SCREEN - GROUP1 | SCREEN-GROUP1 | ||
| 90 | SCREEN - INPUT | SCREEN-INPUT | ||
| 91 | SCREEN - INTENSIFIED | SCREEN-INTENSIFIED | ||
| 92 | SCREEN - NAME | SCREEN-NAME | ||
| 93 | SSCRFIELDS - UCOMM | Function Code | ||
| 94 | SYST - DATUM | ABAP System Field: Current Date of Application Server | ||
| 95 | SYST - DBSYS | ABAP System Field: Central Database System | ||
| 96 | SYST - DYNNR | ABAP System Field: Current Dynpro Number | ||
| 97 | SYST - LANGU | ABAP System Field: Language Key of Text Environment | ||
| 98 | SYST - TABIX | ABAP System Field: Row Index of Internal Tables | ||
| 99 | SYST - TFILL | ABAP System Field: Number of Rows in Internal Tables | ||
| 100 | SYST - UZEIT | ABAP System Field: Current Time of Application Server | ||
| 101 | WPINFOS - APSERVER | Server Name | ||
| 102 | WPINFOS - WP_PID | Process Identification |