SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

/SDF/SQLTOP Table in SAP | SQL Monitor: Top Statements Table & Fields List

/SDF/SQLTOP is a SAP table coming under SV module and ST-PI component.View details, Fields & related tables of /SDF/SQLTOP in SAP.

  • Table description : SQL Monitor: Top Statements
  • Module : SV-SMG-DIA
  • Parent Module : SV
  • Package : /SDF/ZQLM
  • Software Component : ST-PI
/SDF/SQLTOP table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP /SDF/SQLTOP Table Fields structure

FieldNoteData ElementDomain
TIMESTAMPTimestamp for SQLM Data Collection/SDF/SQLTIMESTAMP/SDF/SQLTIMESTAMP
.INCLUDESQL Monitor: Key (Source)    
PROGNAMEABAP Program NamePROGNAMEPROGNAME
PROGKINDSQL Monitor: Program Kind/SDF/ZQLMPROGKIND/SDF/ZQLMPROGKIND
PROCTYPESQL Monitor: Processing Block Type/SDF/ZQLMPROCTYPE  
PROCNAMESQL Monitor: Processing Block Name/SDF/ZQLMPROCNAME  
PROCLINESQL Monitor: Line Number in Processing Block/SDF/ZQLMPROCLINE  
.INCLUDESQL Monitor: Subkey (Internal)    
RUNLEVELSQL Monitor: Run Mode/SDF/ZQLMRUNLEVEL/SDF/ZQLMRUNLEVEL
ROOTTYPESQL Monitor: Request Type/SDF/ZQLMROOTTYPE/SDF/ZQLMROOTTYPE
ROOTNAMESQL Monitor: Request Entry Point (Transaction, etc.)/SDF/ZQLMROOTNAME  
STMTKINDSQL Monitor: SQL Operation/SDF/ZQLMSTMTKIND/SDF/ZQLMSTMTKIND
TABLENAMESQL Monitor: Table Name/SDF/ZQLMTABLENAMEDBOBJ_NAME
HASHHash Value (160 Bits)HASH160X  
.INCLUDESQL Monitor: Source Info    
INCLUDEABAP Program NamePROGNAMEPROGNAME
LINENatural numberINT4INT4
PGMIDProgram ID in Requests and TasksPGMIDPGMID
OBJECTObject TypeTROBJTYPEOBJECT
OBJ_NAMEObject Name in Object DirectorySOBJ_NAMESOBJ_NAME
DEVCLASSPackageDEVCLASSDEVCLASS
.INCLUDESQL Monitor: Payload    
XCNTSQL Monitor: Total Number of Executions/SDF/ZQLMEXECNT  
.INCLUDESQL Monitor: Rollarea    
RCNTSQL Monitor: Internal Sessions Affected/SDF/ZQLMROLLAREACNT  
XCNTRCNTSQL Monitor: Executions per Internal Sessions/SDF/ZQLMEXECNTROLLAREACNT/SDF/ZQLMDECIMAL3
.INCLUDESQL Monitor: Runtime    
RTMINSQL Monitor: Minimum Value of Execution Time/SDF/ZQLMRUNTIMEMIN/SDF/ZQLMRUNTIME
RTMAXSQL Monitor: Maximum Value of Execution Time/SDF/ZQLMRUNTIMEMAX/SDF/ZQLMRUNTIME
RTCNTSQL Monitor: Count/SDF/ZQLMRUNTIMECNT  
RTSUMSQL Monitor: Total Execution Time/SDF/ZQLMRUNTIMESUM/SDF/ZQLMRUNTIME
RTSQSSQL Monitor: Runtime Sum of Squares/SDF/ZQLMRUNTIMESQS/SDF/ZQLMDECIMAL6
RTAVGSQL Monitor: Mean Value of Execution Time/SDF/ZQLMRUNTIMEAVG/SDF/ZQLMRUNTIME
RTDEVSQL Monitor: Standard Deviation of Execution Time/SDF/ZQLMRUNTIMEDEV/SDF/ZQLMRUNTIME
.INCLUDESQL Monitor: DB Count    
DBMINSQL Monitor: Minimum Value of Fetched / Modified Records/SDF/ZQLMDBCOUNTMIN  
DBMAXSQL Monitor: Maximum Value of Fetched / Modified Records/SDF/ZQLMDBCOUNTMAX  
DBCNTSQL Monitor: DB Count Count/SDF/ZQLMDBCOUNTCNT  
DBSUMSQL Monitor: Total Fetched or Modified Records/SDF/ZQLMDBCOUNTSUM/SDF/ZQLMINTEGER
DBSQSSQL Monitor: DB Count Sum of Squares/SDF/ZQLMDBCOUNTSQS/SDF/ZQLMINTEGER
DBAVGSQL Monitor: Mean Value of Fetched / Modified Records/SDF/ZQLMDBCOUNTAVG/SDF/ZQLMDECIMAL3
DBDEVSQL Monitor: Standard Deviation of Fetched / Modif. Records/SDF/ZQLMDBCOUNTDEV/SDF/ZQLMDECIMAL3
DDATE   
DTIME   

/SDF/SQLTOP related tables

TableNote
/SDF/SQLHISTSQL Monitor: Delta records for top SQL statements
/SDF/SQLTOPSQL Monitor: Top Statements
TKETD_RUNCO-PA Top-Down: Top-Down Distribution Runs
TKETD_RUN_DOCNRCO-PA Top-Down: Top-Down Distribution Runs: Document Numbers
AGSRBE_2SQLCONDConditions used in SQL statements
AGSRBE_2SQLJOINJoins used in SQL statements
AGSRBE_2SQLORGOrgUnits used in SQL statements
AGSRBE_SQLCONDConditions used in SQL statements
AGSRBE_SQLJOINJoins used in SQL statements
AGSRBE_SQLORGOrgUnits used in SQL statements
AMSSUGlobal Performance Analysis: Trace Summary SQL Statements
DB6_OPTPROFILEOptimizer Profiles for SQL Statements
IUUC_DD_SYNC_SQLSystem synchronization: SQL-statements to adjust DB object
ORA_SQLC_STMTTable with statements used by the SQL Command Editor
SADL_V_DATATYPEDifferent data types for testing SQL statements
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com