SAP ORASESSION table - Basis List 'Oracle Session' Structure for the ALV details in SAP

SAP ORASESSION table summary

Object Name: ORASESSION
Dictionary Type: Structure
Description: Basis List 'Oracle Session' Structure for the ALV

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

Details

ORASESSION-SID table field - Session ID ▼

Description: Session ID
Field Name: SID
Data Element: ORASID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORANUMBER4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SID

ORASESSION-SPID table field - Operating System Process ID ▼

Description: Operating System Process ID
Field Name: SPID
Data Element: ORASPID
Data Type: CHAR
length (Dec): 9(0)
Check table:
Conversion Routine:
Domain Name: CHAR9
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SPID

ORASESSION-MACHINE table field - Operating System Machine Name ▼

Description: Operating System Machine Name
Field Name: MACHINE
Data Element: ORAMACHINE
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MACHINE

ORASESSION-PROCESS table field - Operating System Client Process ID ▼

Description: Operating System Client Process ID
Field Name: PROCESS
Data Element: ORAPROCESS
Data Type: CHAR
length (Dec): 9(0)
Check table:
Conversion Routine:
Domain Name: CHAR9
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROCESS

ORASESSION-STATUS table field - State of Session (Active, Inactive, Killed) ▼

Description: State of Session (Active, Inactive, Killed)
Field Name: STATUS
Data Element: ORASTATUS
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR8
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUS

ORASESSION-EVENT table field - Resource or Event That the Session is Waiting For ▼

Description: Resource or Event That the Session is Waiting For
Field Name: EVENT
Data Element: ORAEVENT4
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EVENT

ORASESSION-USERNAME table field - Column USERNAME in V$SESSION ▼

Description: Column USERNAME in V$SESSION
Field Name: USERNAME
Data Element: ORAUSER
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERNAME

ORASESSION-SQL_TEXT table field - Start of SQL statement ▼

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

See all SAP tables containing field SQL_TEXT

ORASESSION-L_READS table field - Total Block and Consistent Gets for the Session ▼

Description: Total Block and Consistent Gets for the Session
Field Name: L_READS
Data Element: ORAL_READS
Data Type: CHAR
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: CHAR14
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field L_READS

ORASESSION-P_READS table field - Physical Read Operations for this Session ▼

Description: Physical Read Operations for this Session
Field Name: P_READS
Data Element: ORAR_READS
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CHAR12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field P_READS

ORASESSION-B_CHANGES table field - Block changes for this session ▼

Description: Block changes for this session
Field Name: B_CHANGES
Data Element: ORAB_CHANG
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CHAR12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field B_CHANGES

ORASESSION-C_CHANGES table field - Consistent Changes for this Session ▼

Description: Consistent Changes for this Session
Field Name: C_CHANGES
Data Element: ORAC_CHANG
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CHAR12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field C_CHANGES

ORASESSION-SEC_WAIT table field - Wait Time in Seconds ▼

Description: Wait Time in Seconds
Field Name: SEC_WAIT
Data Element: ORAS_WAIT
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEC_WAIT

ORASESSION-WAIT_TIME table field - WAIT_TIME Column of v$session_wait ▼

Description: WAIT_TIME Column of v$session_wait
Field Name: WAIT_TIME
Data Element: ORAW_TIME
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAIT_TIME

ORASESSION-P1TEXT table field - Description of First Additional Parameter ▼

Description: Description of First Additional Parameter
Field Name: P1TEXT
Data Element: ORAP1TEXT
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field P1TEXT

ORASESSION-P1 table field - Parameter value 1 ▼

Description: Parameter value 1
Field Name: P1
Data Element: ORAP1
Data Type: CHAR
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: CHAR11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field P1

ORASESSION-P2TEXT table field - Description of Second Additional Parameter ▼

Description: Description of Second Additional Parameter
Field Name: P2TEXT
Data Element: ORAP2TEXT
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field P2TEXT

ORASESSION-P2 table field - Parameter value 2 ▼

Description: Parameter value 2
Field Name: P2
Data Element: ORAP2
Data Type: CHAR
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: CHAR11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field P2

ORASESSION-P3TEXT table field - Description of Third Additional Parameter ▼

Description: Description of Third Additional Parameter
Field Name: P3TEXT
Data Element: ORAP3TEXT
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field P3TEXT

ORASESSION-P3 table field - Parameter value 3 ▼

Description: Parameter value 3
Field Name: P3
Data Element: ORAP3
Data Type: CHAR
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: CHAR11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field P3

ORASESSION-TRANS_STATUS table field - Status ▼

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

See all SAP tables containing field TRANS_STATUS

ORASESSION-START_TIME table field - Start time ▼

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

See all SAP tables containing field START_TIME

ORASESSION-START_SCNB table field - Start System Change Number (SCN) Base ▼

Description: Start System Change Number (SCN) Base
Field Name: START_SCNB
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field START_SCNB

ORASESSION-START_UEXT table field - Start Extent Number ▼

Description: Start Extent Number
Field Name: START_UEXT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field START_UEXT

ORASESSION-START_UBAFIL table field - Start UBA File Number ▼

Description: Start UBA File Number
Field Name: START_UBAFIL
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field START_UBAFIL

ORASESSION-START_UBABLK table field - Start UBA Block Number ▼

Description: Start UBA Block Number
Field Name: START_UBABLK
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field START_UBABLK

ORASESSION-START_UBASQN table field - Start UBA Sequence Number ▼

Description: Start UBA Sequence Number
Field Name: START_UBASQN
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field START_UBASQN

ORASESSION-START_UBAREC table field - Start UBA Record Number ▼

Description: Start UBA Record Number
Field Name: START_UBAREC
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field START_UBAREC

ORASESSION-UBAFIL table field - Undo Block Address (UBA) File Number ▼

Description: Undo Block Address (UBA) File Number
Field Name: UBAFIL
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UBAFIL

ORASESSION-UBABLK table field - UBA Block Number ▼

Description: UBA Block Number
Field Name: UBABLK
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UBABLK

ORASESSION-UBASQN table field - UBA Sequence Number ▼

Description: UBA Sequence Number
Field Name: UBASQN
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UBASQN

ORASESSION-UBAREC table field - UBA Record Number ▼

Description: UBA Record Number
Field Name: UBAREC
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UBAREC

ORASESSION-XIDUSN table field - Undo Segment Number ▼

Description: Undo Segment Number
Field Name: XIDUSN
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field XIDUSN

ORASESSION-XIDSLOT table field - Slot Number ▼

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

See all SAP tables containing field XIDSLOT

ORASESSION-XIDSQN table field - Sequence number ▼

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

See all SAP tables containing field XIDSQN

View list of all SAP tables(S4H/ECC)

Select data from SAP table