SAP ORAV_SQLTX table - DDIC Structure According to Oracle Table V$SQLTEXT details in SAP

SAP ORAV_SQLTX table summary

Object Name: ORAV_SQLTX
Dictionary Type: Structure
Description: DDIC Structure According to Oracle Table V$SQLTEXT

Field list for ORAV_SQLTX table on an S/4 SAP system

Details

ORAV_SQLTX-ADDRESS table field - Address of statement in the cache ▼

Description: Address of statement in the cache
Field Name: ADDRESS
Data Element: ORAADDRESS
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: CHAR16
MemoryID:
AppClass: SLG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDRESS

ORAV_SQLTX-HASH_VALUE table field - Hash value of statement ▼

Description: Hash value of statement
Field Name: HASH_VALUE
Data Element: ORAHASHVAL
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: ORAP16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HASH_VALUE

ORAV_SQLTX-PIECE table field - Number of piece of SQL text ▼

Description: Number of piece of SQL text
Field Name: PIECE
Data Element: ORAPIECE
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PIECE

ORAV_SQLTX-SQL_TEXT table field - Piece of SQL text ▼

Description: Piece of SQL text
Field Name: SQL_TEXT
Data Element: ORAPIECETX
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: CHAR64
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_TEXT

ORAV_SQLTX-COMMAND_TY table field - Oracle command type definition ▼

Description: Oracle command type definition
Field Name: COMMAND_TY
Data Element: ORACOMTYPE
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMMAND_TY

View list of all SAP tables(S4H/ECC)

Select data from SAP table