SAP SQLTEXT field - Wrapped SQL statement details in SAP


SAP SQLTEXT field summary

Object Name: SQLTEXT
Dictionary Type:
Description: Wrapped SQL statement


SAP field SQLTEXT is available in the following tables

Details
ADASQLAR-SQLTEXT table field - SAP DB: Start of SQL command

Description: SAP DB: Start of SQL command
Field Name: SQLTEXT
Data Element: ADA_SSTMT
Data Type: CHAR
length (Dec): 80(0)
Check table:
Conversion Routine:
Domain Name: CHAR80
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP ADASQLAR table

ORAVSQLAR-SQLTEXT table field - Restriction on SQL statements to be analyzed

Description: Restriction on SQL statements to be analyzed
Field Name: SQLTEXT
Data Element: ORARSQLTXT
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: CHAR40
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP ORAVSQLAR table

MSS_REQUEST-SQLTEXT table field - First 50 characters of a SQL Server statement

Description: First 50 characters of a SQL Server statement
Field Name: SQLTEXT
Data Element: MSSPARTIALSQL
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP MSS_REQUEST table

DB2TIOUT_TREE-SQLTEXT table field - Statement text

Description: Statement text
Field Name: SQLTEXT
Data Element: DB2QSTSTMT
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP DB2TIOUT_TREE table

MSSQUERYSTATS-SQLTEXT table field - First 50 characters of a SQL Server statement

Description: First 50 characters of a SQL Server statement
Field Name: SQLTEXT
Data Element: MSSPARTIALSQL
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP MSSQUERYSTATS table

DB2DEADLK_TREE-SQLTEXT table field - Statement text

Description: Statement text
Field Name: SQLTEXT
Data Element: DB2QSTSTMT
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP DB2DEADLK_TREE table

GORAVSQLAR_DBC-SQLTEXT table field - Restriction on SQL statements to be analyzed

Description: Restriction on SQL statements to be analyzed
Field Name: SQLTEXT
Data Element: ORARSQLTXT
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: CHAR40
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP GORAVSQLAR_DBC table

ORA_PROCESSROW-SQLTEXT table field - Oracle Monitoring: SQL_TEXT: SQL Text of current cursor

Description: Oracle Monitoring: SQL_TEXT: SQL Text of current cursor
Field Name: SQLTEXT
Data Element: ORA_SQL_TEXT
Data Type: LCHR
length (Dec): 1000(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_1000
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP ORA_PROCESSROW table

MSS_STMTHISTDET-SQLTEXT table field - First 50 characters of a SQL Server statement

Description: First 50 characters of a SQL Server statement
Field Name: SQLTEXT
Data Element: MSSPARTIALSQL
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP MSS_STMTHISTDET table

ORA_SM_SESSIONS-SQLTEXT table field - SDD - Oracle lock monitor: SQLTEXT

Description: SDD - Oracle lock monitor: SQLTEXT
Field Name: SQLTEXT
Data Element: ORA_SM_SQLTEXT
Data Type: CHAR
length (Dec): 1000(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_SQLTEXT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP ORA_SM_SESSIONS table

DB2_VIEW_DLK_DET-SQLTEXT table field - Statement text

Description: Statement text
Field Name: SQLTEXT
Data Element: DB2QSTSTMT
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP DB2_VIEW_DLK_DET table

DB2_VIEW_TIO_DET-SQLTEXT table field - Statement text

Description: Statement text
Field Name: SQLTEXT
Data Element: DB2QSTSTMT
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP DB2_VIEW_TIO_DET table

MSSQUERYSTATSOUT-SQLTEXT table field - First 50 characters of a SQL Server statement

Description: First 50 characters of a SQL Server statement
Field Name: SQLTEXT
Data Element: MSSPARTIALSQL
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP MSSQUERYSTATSOUT table

MSSQRYSTATSFROMDB-SQLTEXT table field - First 50 characters of a SQL Server statement

Description: First 50 characters of a SQL Server statement
Field Name: SQLTEXT
Data Element: MSSPARTIALSQL
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP MSSQRYSTATSFROMDB table

/SDF/ZQLMRECORD_DL-SQLTEXT table field - SQL Text

Description: SQL Text
Field Name: SQLTEXT
Data Element:
Data Type: CHAR
length (Dec): 1024(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP /SDF/ZQLMRECORD_DL table

MSS_ACTIVE_REQUEST-SQLTEXT table field - First 50 characters of a SQL Server statement

Description: First 50 characters of a SQL Server statement
Field Name: SQLTEXT
Data Element: MSSPARTIALSQL
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP MSS_ACTIVE_REQUEST table

ORA_S_AWR_SEL_SQLID-SQLTEXT table field - Start of SQL statement

Description: Start of SQL statement
Field Name: SQLTEXT
Data Element: ORASQLTEXT
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: CHAR60
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP ORA_S_AWR_SEL_SQLID table

SYBMON_PROCESSSQLTEXT-SQLTEXT table field -

Description:
Field Name: SQLTEXT
Data Element:
Data Type: STRG
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP SYBMON_PROCESSSQLTEXT table

/SDF/SYB_DB_SQL_STMT_TEXT-SQLTEXT table field - Wrapped SQL statement

Description: Wrapped SQL statement
Field Name: SQLTEXT
Data Element:
Data Type: CHAR
length (Dec): 70(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP /SDF/SYB_DB_SQL_STMT_TEXT table


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table