ORA_GV_PX_SESSION_STRUCTURE SAP (Table Structure of GV$PX_SESSION) Structure details

Dictionary Type: Structure
Description: Table Structure of GV$PX_SESSION




ABAP Code to SELECT data from ORA_GV_PX_SESSION_STRUCTURE
Related tables to ORA_GV_PX_SESSION_STRUCTURE
Access table ORA_GV_PX_SESSION_STRUCTURE




Structure field list including key, data, relationships and ABAP select examples

ORA_GV_PX_SESSION_STRUCTURE is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Table Structure of GV$PX_SESSION" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_ORA_GV_PX_SESSION_STRUCTURE TYPE ORA_GV_PX_SESSION_STRUCTURE.

The ORA_GV_PX_SESSION_STRUCTURE table consists of various fields, each holding specific information or linking keys about Table Structure of GV$PX_SESSION data available in SAP. These include SADDR (Column SADDR from GV$PX_SESSION), SID (Column SID from GV$PX_SESSION), USERNAME (Column SESSION from GV$PX_SESSION), SERIAL (Column SERIAL# from GV$PX_SESSION).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP ORA_GV_PX_SESSION_STRUCTURE structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
INST_IDColumn INST_ID from GV$PX_SESSION ORA_GV_PX_SESSION_INST_IDNUMC22ORA_GV_PX_SESSION_INST_ID
SADDRColumn SADDR from GV$PX_SESSION ORA_GV_PX_SESSION_SADDRRAW4ORA_GV_PX_SESSION_SADDR
SIDColumn SID from GV$PX_SESSION ORA_GV_PX_SESSION_SIDNUMC22ORA_GV_PX_SESSION_SID
USERNAMEColumn SESSION from GV$PX_SESSION ORA_GV_PX_SESSION_USERNAMECHAR30ORA_GV_PX_SESSION_USERNAME
SERIALColumn SERIAL# from GV$PX_SESSION ORA_GV_PX_SESSION_SERIALNUMC22ORA_GV_PX_SESSION_SERIAL
QCSIDColumn QCSID from GV$PX_SESSION ORA_GV_PX_SESSION_QCSIDNUMC22ORA_GV_PX_SESSION_QCSID
QCSERIALColumn QCSERIAL# from GV$PX_SESSION ORA_GV_PX_SESSION_QCSERIALNUMC22ORA_GV_PX_SESSION_QCSERIAL
QCINST_IDColumn QCINST_ID from GV$PX_SESSION ORA_GV_PX_SESSION_QCINST_IDNUMC22ORA_GV_PX_SESSION_QCINST_ID
SERVER_GROUPColumn SERVER_GROUP from GV$PX_SESSION ORA_GV_PX_SESSION_SERVER_GROUPNUMC22ORA_GV_PX_SESSION_SERVER_GROUP
SERVER_SETColumn SERVER_SET from GV$PX_SESSION ORA_GV_PX_SESSION_SERVER_SETNUMC22ORA_GV_PX_SESSION_SERVER_SET
SERVERColumn SERVER# from GV$PX_SESSION ORA_GV_PX_SESSION_SERVERNUMC22ORA_GV_PX_SESSION_SERVER
DEGREEColumn DEGREE from GV$PX_SESSION ORA_GV_PX_SESSION_DEGREENUMC22ORA_GV_PX_SESSION_DEGREE
REQ_DEGREEColumn REQ_DEGREE from GV$PX_SESSION ORA_GV_PX_SESSION_REQ_DEGREENUMC22ORA_GV_PX_SESSION_REQ_DEGREE
LINECOLORInclude the alv color of the row ORA_GV_PX_SESSION_LINE_COLORCHAR4ORA_GV_PX_SESSION_LINE_COLOR

Key field Non-key field



How do I retrieve data from SAP structure ORA_GV_PX_SESSION_STRUCTURE using ABAP code?

As ORA_GV_PX_SESSION_STRUCTURE is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ORA_GV_PX_SESSION_STRUCTURE as there is no data to select.

How to access SAP table ORA_GV_PX_SESSION_STRUCTURE

Within an ECC or HANA version of SAP you can also view further information about ORA_GV_PX_SESSION_STRUCTURE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!