SAP Table GVD_WPTOTALINFO
Oracle Monitoring: Workprocess Information snapshot table
GVD_WPTOTALINFO (Oracle Monitoring: Workprocess Information snapshot table) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link GVD_WPTOTALINFO to other SAP tables.
GVD_WPTOTALINFO table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| SNAPSHOT_ID | Oracle monitor: snapshot ID | ORA_SNAPSHOT_ID | NUMC | 10 | 0 | |||
| WP_SERVER | Oracle Monitoring: MSNAME: Servername | ORA_MSNAME | CHAR | 20 | 0 | |||
| WP_NO | Oracle Monitoring: WPNO: Work process number | ORA_WPNO | CHAR | 2 | 0 | |||
| WP_ITYPE | Oracle Monitoring: WPITYPE : Internal work process type | ORA_WPITYPE | INT1 | 3 | 0 | |||
| WP_TYP | Oracle Monitoring: WPTYP: Type | ORA_WPTYP | CHAR | 3 | 0 | |||
| WP_PID | Oracle Monitoring : WPPID: Work process PID | ORA_WPPID | CHAR | 8 | 0 | |||
| WP_ISTATUS | Oracle Monitoring: WPISTATUS: Work process status | ORA_WPISTATUS | INT1 | 3 | 0 | |||
| WP_STATUS | Oracle Monitoring: WPSTATUS: Work process status | ORA_WPSTATUS | CHAR | 7 | 0 | |||
| WP_IWAIT | Oracle Monitorign: WPIWAITING: Reason for wait | ORA_WPIWAITING | INT1 | 3 | 0 | |||
| WP_WAITING | Oracle Monitoring: WPWAITING: Work process is waiting | ORA_WPWAITING | CHAR | 5 | 0 | |||
| WP_SEM | Oracle Monitoring: WPSEM: Semaphore, for which the work proc | ORA_WPSEM | CHAR | 2 | 0 | |||
| WP_IRESTRT | Oracle Monitoring: WPIRESTART : Restart after error? | ORA_WPIRESTART | INT1 | 3 | 0 | |||
| WP_RESTART | Oracle Monitoring: WPRESTART: Restart work process after dum | ORA_WPRESTART | CHAR | 4 | 0 | |||
| WP_DUMPS | Oracle Monitoring: WPDUMPS: Number of dumps. | ORA_WPDUMPS | CHAR | 2 | 0 | |||
| WP_CPU | Oracle Monitoring: WPCPU: CPU | ORA_WPCPU | CHAR | 8 | 0 | |||
| WP_ELTIME | Oracle Monitoring: WPELZEIT: Previous execution time of requ | ORA_WPELZEIT | CHAR | 6 | 0 | |||
| WP_MANDT | Client | MANDT | CLNT | 3 | 0 | |||
| WP_BNAME | Oracle Monitoring: WPBNAME: User currently served | ORA_WPBNAME | CHAR | 12 | 0 | |||
| WP_REPORT | Oracle Monitoring: WPREPORT: Report currently being executed | ORA_WPREPORT | CHAR | 40 | 0 | |||
| WP_IACTION | Oracle Monitoring: WPIACTION: Current activity of the work p | ORA_WPIACTION | INT1 | 3 | 0 | |||
| WP_ACTION | Oracle Monitoring: WPACTION: Currently activity of WP | ORA_WPACTION | CHAR | 25 | 0 | |||
| WP_TABLE | Oracle Monitoring: WPTABLE: DB table last accessed by the WP | ORA_WPTABLE | CHAR | 30 | 0 | |||
| WP_WAITINF | Oracle Monitoring: WPWAITINF: add. wait information | ORA_WPWAITINF | CHAR | 40 | 0 | |||
| WP_WAITTIM | Oracle Monitoring: WPWAITTIME: Time when waiting started | ORA_WPWAITTIME | CHAR | 8 | 0 | |||
| WP_SEMSTAT | Oracle Monitoring: WPITYPE : Internal work process type | ORA_WPITYPE | INT1 | 3 | 0 | |||
| WP_INDEX | Oracle Monitoring: ORA_WPINDEX: Index of work process | ORA_WPINDEX | INT4 | 10 | 0 | |||
| STARTDATE | Oracle Monitoring: Start date for dialog step | ORA_WPTOTINFSD | DATS | 8 | 0 | |||
| STARTTIME | Oracle Monitoring: Start time for dialog step | ORA_WPTOTINFST | TIMS | 6 | 0 | |||
| DYNPRONR | Oracle Monitoring: Screen number or transaction name | ORA_STA_DYNPNO | CHAR | 4 | 0 | |||
| TCODE | Oracle Monitoring: Transaction code | ORA_STA_TCODE4 | CHAR | 20 | 0 | |||
| CUAPROGRAM | Oracle Monitoring: CUA program name | ORA_WPTOTINFCP | CHAR | 40 | 0 | |||
| FCODE | Oracle Monitoring: WPTOTINFFC:Function code | ORA_WPTOTINFFC | CHAR | 4 | 0 | |||
| BTCJOBNAME | Oracle Monitoring:BTCJOB: Background job name | ORA_BTCJOB | CHAR | 32 | 0 | |||
| BTCJOBCNT | Oracle Monitoring:_BTCJOBCNT:Job ID | ORA_BTCJOBCNT | CHAR | 8 | 0 | |||
| MEMSUM | Oracle Monitoring: MEMSUM: Extended memory | ORA_MEMSUM | DEC | 10 | 0 | |||
| PRIVSUM | Oracle Monitoring:Heap (private) Memory | ORA_PRIVSUM | DEC | 10 | 0 | |||
