Table/Structure Field list used by SAP ABAP Program /SSA/DMS (SDCC: Data collectors for MSSQL)
SAP ABAP Program 
/SSA/DMS (SDCC: Data collectors for MSSQL) is using
-
Class (6)
-
Data Element (14)
-
Table/Structure Field (138)
-
Function Module (33)
-
Message Class (1)
-
Class Method (5)
-
Program (3)
-
Table (55)
-
View (4)
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 | Table/Structure Field |
/SSF/BTAB - PID | /SSF/BTAB-PID | |
| 2 | Table/Structure Field |
/SSF/BTAB - PLEN | /SSF/BTAB-PLEN | |
| 3 | Table/Structure Field |
ALV_S_FCAT - FIELDNAME | ALV control: Field name of internal table field | |
| 4 | Table/Structure Field |
ALV_S_FCAT - INTLEN | Internal Length in Bytes | |
| 5 | Table/Structure Field |
DBCON - CON_NAME | Logical name for a database connection | |
| 6 | Table/Structure Field |
DBINDEX - NAME | Table or index name | |
| 7 | Table/Structure Field |
DBINDEX - UNIQUE | Flag for UNIQUE indexes | |
| 8 | Table/Structure Field |
DBINDFLD - FIELD | Name of the DB field | |
| 9 | Table/Structure Field |
DBINDFLD - INDEX | Table or index name | |
| 10 | Table/Structure Field |
DCOBJBEZ - NAME | Name of ABAP Dictionary Object | |
| 11 | Table/Structure Field |
DCOBJDEF - NAME | Name of ABAP Dictionary Object | |
| 12 | Table/Structure Field |
DD02L - TABCLASS | Table category | |
| 13 | Table/Structure Field |
DD02L - TABNAME | Table Name | |
| 14 | Table/Structure Field |
DD02V - AS4USER | Last Changed By | |
| 15 | Table/Structure Field |
DD02V - DDLANGUAGE | Language Key | |
| 16 | Table/Structure Field |
DD02V - DDTEXT | Short Description of Repository Objects | |
| 17 | Table/Structure Field |
DD02V - TABCLASS | Table category | |
| 18 | Table/Structure Field |
DD02V - TABNAME | Table Name | |
| 19 | Table/Structure Field |
DD03P - DATATYPE | Data Type in ABAP Dictionary | |
| 20 | Table/Structure Field |
DD03P - DDLANGUAGE | Language Key | |
| 21 | Table/Structure Field |
DD03P - DDTEXT | Short Description of Repository Objects | |
| 22 | Table/Structure Field |
DD03P - FIELDNAME | Field Name | |
| 23 | Table/Structure Field |
DD03P - KEYFLAG | Identifies a key field of a table | |
| 24 | Table/Structure Field |
DD03P - POSITION | Position of the field in the table | |
| 25 | Table/Structure Field |
DD03P - TABNAME | Table Name | |
| 26 | Table/Structure Field |
DD06V - DDLANGUAGE | Language Key | |
| 27 | Table/Structure Field |
DD06V - DDTEXT | Explanatory short text | |
| 28 | Table/Structure Field |
DD06V - SQLCLASS | Indicator for pool or cluster | |
| 29 | Table/Structure Field |
DD06V - SQLTAB | Name of Pool/Cluster in the Database | |
| 30 | Table/Structure Field |
DD09L - PUFFERUNG | Buffering type indicator | |
| 31 | Table/Structure Field |
DD09L - TABNAME | Table Name | |
| 32 | Table/Structure Field |
DD12L - SQLTAB | Table Name | |
| 33 | Table/Structure Field |
DD12V - ACTFLAG | Activation flag | |
| 34 | Table/Structure Field |
DD12V - AS4DATE | Date of Last Change | |
| 35 | Table/Structure Field |
DD12V - AS4TIME | Last changed at | |
| 36 | Table/Structure Field |
DD12V - AS4USER | Last Changed By | |
| 37 | Table/Structure Field |
DD12V - DBINDEX | Database index | |
| 38 | Table/Structure Field |
DD12V - DBSTATE | Status of index on the database | |
| 39 | Table/Structure Field |
DD12V - DDLANGUAGE | Language Key | |
| 40 | Table/Structure Field |
DD12V - DDTEXT | Explanatory short text | |
| 41 | Table/Structure Field |
DD12V - INDEXNAME | Unique Index ID in a Table | |
| 42 | Table/Structure Field |
DD12V - SQLTAB | Table Name | |
| 43 | Table/Structure Field |
DD12V - UNIQUEFLAG | Flag for UNIQUE indexes | |
| 44 | Table/Structure Field |
DD17V - DDLANGUAGE | Language Key | |
| 45 | Table/Structure Field |
DD17V - FIELDNAME | Field Name | |
| 46 | Table/Structure Field |
DD17V - INDEXNAME | Unique Index ID in a Table | |
| 47 | Table/Structure Field |
DD17V - POSITION | Position of the field in the table | |
| 48 | Table/Structure Field |
DD17V - SQLTAB | Table Name | |
| 49 | Table/Structure Field |
DD26I - TABNAME | Base table of a view | |
| 50 | Table/Structure Field |
DD26I - VIEWNAME | Name of SAP table view | |
| 51 | Table/Structure Field |
DD27P - TABNAME | Table Name | |
| 52 | Table/Structure Field |
DDREFSTRUC - STATE | Status of the ABAP Dictionary object | |
| 53 | Table/Structure Field |
DFIES - DATATYPE | ABAP/4 Dictionary: Screen data type for Screen Painter | |
| 54 | Table/Structure Field |
DFIES - FIELDNAME | Field Name | |
| 55 | Table/Structure Field |
DFIES - LENG | Length (No. of Characters) | |
| 56 | Table/Structure Field |
ENLFDIR - ACTIVE | Function module active | |
| 57 | Table/Structure Field |
ENLFDIR - FUNCNAME | Name of Function Module | |
| 58 | Table/Structure Field |
LVC_S_FCAT - FIELDNAME | ALV control: Field name of internal table field | |
| 59 | Table/Structure Field |
LVC_S_FCAT - INTLEN | Internal Length in Bytes | |
| 60 | Table/Structure Field |
MSQBACKMED - DBNAME | Database name | |
| 61 | Table/Structure Field |
MSQBACKMED - START_DATE | MS SQL Server: Database starting time | |
| 62 | Table/Structure Field |
MSQBAKFILE - BAKSETID | Natural number | |
| 63 | Table/Structure Field |
MSQCCMSJOB - COMMAND | MS SQL server - command executed by the subsytem | |
| 64 | Table/Structure Field |
MSQCCMSJOB - DBNAME | Database name | |
| 65 | Table/Structure Field |
MSQCCMSJOB - ENABLED | MS SQL server - job enable status for execution | |
| 66 | Table/Structure Field |
MSQCCMSJOB - JOBID | MS SQL Server job ID | |
| 67 | Table/Structure Field |
MSQCCMSJOB - JOBTYPE | MS SQL server - Name of the subsystem used for job execution | |
| 68 | Table/Structure Field |
MSQCCMSJOB - JOB_NAME | MS SQl server - name of the job | |
| 69 | Table/Structure Field |
MSQCCMSJOB - LSTRUNDATE | Sql agent job - Last run Date | |
| 70 | Table/Structure Field |
MSQCCMSJOB - LSTRUNTIME | Agent job's last run time | |
| 71 | Table/Structure Field |
MSQCCMSJOB - NEXTRUNDT | Sql agent job - Next run Date | |
| 72 | Table/Structure Field |
MSQCCMSJOB - NEXTRUNTM | SQL Agent Job's Next Run Time | |
| 73 | Table/Structure Field |
MSQCCMSJOB - OWNER | Database user name/ Owner of sql agent job | |
| 74 | Table/Structure Field |
MSQCCMSJOB - RUNDATE | MS SQL server - the date to begin executing the job | |
| 75 | Table/Structure Field |
MSQCCMSJOB - RUNSTATUS | MS SQL server - the status of the job's execution | |
| 76 | Table/Structure Field |
MSQCCMSJOB - RUNTIME | MS SQL server - the time to start executing the server job | |
| 77 | Table/Structure Field |
MSQCCMSJOB - STATUSDESC | Sql Agent Job status description | |
| 78 | Table/Structure Field |
MSQERROUT - ERROUTPUT | MS SQL server - output line of sql server error log | |
| 79 | Table/Structure Field |
MSQSAPSULK - START_DATE | Time stamp when the blocking situation started. | |
| 80 | Table/Structure Field |
MSQSTPRTXT - TEXTLINE | MSQSTPRTXT-TEXTLINE | |
| 81 | Table/Structure Field |
MSQ_LSTAT - FILEKB | Size of the database transaction log in MB. | |
| 82 | Table/Structure Field |
MSQ_LSTAT - NAMELOG | MS SQL server database physical file name with full path | |
| 83 | Table/Structure Field |
MSQ_LSTAT - NUMLINES | Size of the database transaction log in MB. | |
| 84 | Table/Structure Field |
MSQ_LSTAT - NUMLOG | number of SQL Server sql error or sql agent log to display | |
| 85 | Table/Structure Field |
MSSCONNDATA - CON_NAME | Logical name for a database connection | |
| 86 | Table/Structure Field |
MSSCONNDATA - DBSCHEMA | MSSQL Multiconnect : Object source schema | |
| 87 | Table/Structure Field |
MSSDBCCOUT - TEXTLINE | DBCC info message | |
| 88 | Table/Structure Field |
MSSDBSIZEINFO - DB_ALLOC | Allocated space in database in MB | |
| 89 | Table/Structure Field |
MSSDBSIZEINFO - DB_SIZE | Database size in MB | |
| 90 | Table/Structure Field |
MSSDBSIZEINFO - LOG_ALLOC | Allocated space in log in MB | |
| 91 | Table/Structure Field |
MSSDBSIZEINFO - LOG_SIZE | Log size in MB | |
| 92 | Table/Structure Field |
MSSINDINFOCOLL - COLUMNS | Index columns | |
| 93 | Table/Structure Field |
MSSINDINFOCOLL - INDNAME | Index name | |
| 94 | Table/Structure Field |
MSSRANGES - HIGH | MSSRANGES-HIGH | |
| 95 | Table/Structure Field |
MSSRANGES - LOW | MSSRANGES-LOW | |
| 96 | Table/Structure Field |
MSSRANGES - OPTION | MSSRANGES-OPTION | |
| 97 | Table/Structure Field |
MSSRANGES - SIGN | MSSRANGES-SIGN | |
| 98 | Table/Structure Field |
MSSSERIA - VALUE | MSSSERIA-VALUE | |
| 99 | Table/Structure Field |
MSSTOTTABSIZEINFO - INDDATA | Index size in KB | |
| 100 | Table/Structure Field |
MSSTOTTABSIZEINFO - NUMINDS | Number of indexes of user tables | |
| 101 | Table/Structure Field |
MSSTOTTABSIZEINFO - NUMPROCS | Number of stored procedures created in DBI | |
| 102 | Table/Structure Field |
MSSTOTTABSIZEINFO - NUMTABS | Number of user tables | |
| 103 | Table/Structure Field |
MSSTOTTABSIZEINFO - TABDATA | Data size in KB | |
| 104 | Table/Structure Field |
MSSTOTTABSIZEINFO - UNUSED | Unused size in KB | |
| 105 | Table/Structure Field |
MSSXMLOBJREFS - DB_NAME | Database name | |
| 106 | Table/Structure Field |
MSSXPLPLAN - ESTCPU | MSS: Plan estimated CPU | |
| 107 | Table/Structure Field |
MSSXPLPLAN - ESTIO | MSS: Plan estimated IO | |
| 108 | Table/Structure Field |
MSSXPLPLAN - ESTROWS | MSS: Plan estimated rows | |
| 109 | Table/Structure Field |
MSSXPLPLAN - NODEID | MSS: Plan node ID | |
| 110 | Table/Structure Field |
MSSXPLPLAN - OPTYPE | MSS: Plan operation type | |
| 111 | Table/Structure Field |
MSSXPLPLAN - PARENT | MSS: Plan parent node | |
| 112 | Table/Structure Field |
MSSXPLPLAN - STMTTEXT | Text of showplan output | |
| 113 | Table/Structure Field |
MSSXPLPLAN - TOTSUBTREECO | MSS: Plan total subtree cost | |
| 114 | Table/Structure Field |
MSS_DBDATA - VARNAME | MS SQL Server DB property setting name | |
| 115 | Table/Structure Field |
MSS_DBDATA - VARVALUE | Database option value | |
| 116 | Table/Structure Field |
MSS_SCHEMA - NAME | Schema name | |
| 117 | Table/Structure Field |
MSS_STSERV - IS3GB | Is SQL Server on machine with /3GB switch on 'Y' or 'N' | |
| 118 | Table/Structure Field |
MSS_STSERV - ISAWE | Is SQL Server AWE enabled Y' or 'N' | |
| 119 | Table/Structure Field |
MSS_STSERV - ISPAE | Is SQL Server on machine with PAE 'Y' or 'N' | |
| 120 | Table/Structure Field |
MSS_STSERV - NTVER | OS edition: A=Advanced Server, S=Server, D=Datacenter. | |
| 121 | Table/Structure Field |
MSS_STSERV - PRODLEVEL | Date the executable sqlservr.exe was created. | |
| 122 | Table/Structure Field |
REPOSRC - CDAT | Created on | |
| 123 | Table/Structure Field |
REPOSRC - CNAM | Author | |
| 124 | Table/Structure Field |
REPOSRC - PROGNAME | ABAP Program Name | |
| 125 | Table/Structure Field |
REPOSRC - R3STATE | ABAP: Program Status (Active, Saved, Transported...) | |
| 126 | Table/Structure Field |
REPOSRC - RSTAT | Status | |
| 127 | Table/Structure Field |
REPOSRC - SUBC | Program type | |
| 128 | Table/Structure Field |
REPOSRC - UDAT | Changed On | |
| 129 | Table/Structure Field |
REPOSRC - UNAM | Last changed by | |
| 130 | Table/Structure Field |
STXL - SRTF2 | BIN1 data element for SYST | |
| 131 | Table/Structure Field |
SYST - DATUM | ABAP System Field: Current Date of Application Server | |
| 132 | Table/Structure Field |
SYST - DBSYS | ABAP System Field: Central Database System | |
| 133 | Table/Structure Field |
SYST - FDPOS | ABAP System Field: Occurrence in Byte or Character String | |
| 134 | Table/Structure Field |
SYST - LANGU | ABAP System Field: Language Key of Text Environment | |
| 135 | Table/Structure Field |
SYST - SAPRL | ABAP System Field: SAP System Release | |
| 136 | Table/Structure Field |
SYST - SYSID | ABAP System Field: Name of SAP System | |
| 137 | Table/Structure Field |
SYST - TABIX | ABAP System Field: Row Index of Internal Tables | |
| 138 | Table/Structure Field |
SYST - UZEIT | ABAP System Field: Current Time of Application Server |
