ORA_WPTOTALINFROW SAP (Oracle Monitoring: WP information: row) Structure details
Description: Oracle Monitoring: WP information: row
Related tables to ORA_WPTOTALINFROW
Access table ORA_WPTOTALINFROW
Structure field list including key, data, relationships and ABAP select examples
ORA_WPTOTALINFROW 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 "Oracle Monitoring: WP information: row" 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_WPTOTALINFROW TYPE ORA_WPTOTALINFROW.
The ORA_WPTOTALINFROW table consists of various fields, each holding specific information or linking keys about Oracle Monitoring: WP information: row data available in SAP. These include WP_ITYPE (Oracle Monitoring: WPITYPE : Internal work process type), WP_TYP (Oracle Monitoring: WPTYP: Type), WP_PID (Oracle Monitoring : WPPID: Work process PID), WP_ISTATUS (Oracle Monitoring: WPISTATUS: Work process status).. 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_WPTOTALINFROW 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 |
WP_NO | Oracle Monitoring: WPNO: Work process number | ORA_WPNO | CHAR | 2 | ORA_WPNO | ||||
WP_ITYPE | Oracle Monitoring: WPITYPE : Internal work process type | ORA_WPITYPE | INT1 | 3 | ORA_WPITYPE | ||||
WP_TYP | Oracle Monitoring: WPTYP: Type | ORA_WPTYP | CHAR | 3 | ORA_WPTYP | ||||
WP_PID | Oracle Monitoring : WPPID: Work process PID | ORA_WPPID | CHAR | 8 | ORA_WPPID | ||||
WP_ISTATUS | Oracle Monitoring: WPISTATUS: Work process status | ORA_WPISTATUS | INT1 | 3 | ORA_WPISTATUS | ||||
WP_STATUS | Oracle Monitoring: WPSTATUS: Work process status | ORA_WPSTATUS | CHAR | 7 | ORA_WPSTATUS | ||||
WP_IWAIT | Oracle Monitorign: WPIWAITING: Reason for wait | ORA_WPIWAITING | INT1 | 3 | ORA_WPIWAITING | ||||
WP_WAITING | Oracle Monitoring: WPWAITING: Work process is waiting | ORA_WPWAITING | CHAR | 5 | ORA_WPWAITING | ||||
WP_SEM | Oracle Monitoring: WPSEM: Semaphore, for which the work proc | ORA_WPSEM | CHAR | 2 | ORA_WPSEM | ||||
WP_IRESTRT | Oracle Monitoring: WPIRESTART : Restart after error? | ORA_WPIRESTART | INT1 | 3 | ORA_WPIRESTART | ||||
WP_RESTART | Oracle Monitoring: WPRESTART: Restart work process after dum | ORA_WPRESTART | CHAR | 4 | ORA_WPRESTART | ||||
WP_DUMPS | Oracle Monitoring: WPDUMPS: Number of dumps. | ORA_WPDUMPS | CHAR | 2 | ORA_WPDUMPS | ||||
WP_CPU | Oracle Monitoring: WPCPU: CPU | ORA_WPCPU | CHAR | 8 | ORA_WPCPU | ||||
WP_ELTIME | Oracle Monitoring: WPELZEIT: Previous execution time of requ | ORA_WPELZEIT | CHAR | 6 | ORA_WPELZEIT | ||||
WP_MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
WP_BNAME | Oracle Monitoring: WPBNAME: User currently served | ORA_WPBNAME | CHAR | 12 | ORA_WPBNAME | ||||
WP_REPORT | Oracle Monitoring: WPREPORT: Report currently being executed | ORA_WPREPORT | CHAR | 40 | ORA_WPREPORT | ||||
WP_IACTION | Oracle Monitoring: WPIACTION: Current activity of the work p | ORA_WPIACTION | INT1 | 3 | ORA_WPIACTION | ||||
WP_ACTION | Oracle Monitoring: WPACTION: Currently activity of WP | ORA_WPACTION | CHAR | 25 | ORA_WPACTION | ||||
WP_TABLE | Oracle Monitoring: WPTABLE: DB table last accessed by the WP | ORA_WPTABLE | CHAR | 30 | ORA_WPTABLE | ||||
WP_SERVER | Oracle Monitoring: MSNAME: Servername | ORA_MSNAME | CHAR | 20 | ORA_MSNAME | ||||
WP_WAITINF | Oracle Monitoring: WPWAITINF: add. wait information | ORA_WPWAITINF | CHAR | 40 | ORA_WPWAITINF | ||||
WP_WAITTIM | Oracle Monitoring: WPWAITTIME: Time when waiting started | ORA_WPWAITTIME | CHAR | 8 | ORA_WPWAITTIME | ||||
WP_SEMSTAT | Oracle Monitoring: WPITYPE : Internal work process type | ORA_WPITYPE | INT1 | 3 | ORA_WPITYPE | ||||
WP_INDEX | Oracle Monitoring: ORA_WPINDEX: Index of work process | ORA_WPINDEX | INT4 | 10 | ORA_WPINDEX | ||||
STARTDATE | Oracle Monitoring: Start date for dialog step | ORA_WPTOTINFSD | DATS | 8 | SYDATS | ||||
STARTTIME | Oracle Monitoring: Start time for dialog step | ORA_WPTOTINFST | TIMS | 6 | SYTIME | ||||
DYNPRONR | Oracle Monitoring: Screen number or transaction name | ORA_STA_DYNPNO | CHAR | 4 | STAT_DYNPR | ||||
TCODE | Oracle Monitoring: Transaction code | ORA_STA_TCODE4 | CHAR | 20 | Assigned to domain | TCODE | |||
CUAPROGRAM | Oracle Monitoring: CUA program name | ORA_WPTOTINFCP | CHAR | 40 | PROGNAME | ||||
FCODE | Oracle Monitoring: WPTOTINFFC:Function code | ORA_WPTOTINFFC | CHAR | 4 | ORA_WPTOTINFFC | ||||
BTCJOBNAME | Oracle Monitoring:BTCJOB: Background job name | ORA_BTCJOB | CHAR | 32 | ORA_BTCJOB | ||||
BTCJOBCNT | Oracle Monitoring:_BTCJOBCNT:Job ID | ORA_BTCJOBCNT | CHAR | 8 | ORA_BTCJOBCNT | ||||
MEMSUM | Oracle Monitoring: MEMSUM: Extended memory | ORA_MEMSUM | DEC | 10 | WPMEM | ||||
PRIVSUM | Oracle Monitoring:Heap (private) Memory | ORA_PRIVSUM | DEC | 10 | WPMEM |
Key field | Non-key field |
How do I retrieve data from SAP structure ORA_WPTOTALINFROW using ABAP code?
As ORA_WPTOTALINFROW 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_WPTOTALINFROW as there is no data to select.How to access SAP table ORA_WPTOTALINFROW
Within an ECC or HANA version of SAP you can also view further information about ORA_WPTOTALINFROW and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects