DB4_JOBSTS SAP (iSeries: Jobs on iSeries Incl. the Job Status (s. WRKACTJOB)) Structure details

Dictionary Type: Structure
Description: iSeries: Jobs on iSeries Incl. the Job Status (s. WRKACTJOB)




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




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

DB4_JOBSTS 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 "iSeries: Jobs on iSeries Incl. the Job Status (s. WRKACTJOB)" 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_DB4_JOBSTS TYPE DB4_JOBSTS.

The DB4_JOBSTS table consists of various fields, each holding specific information or linking keys about iSeries: Jobs on iSeries Incl. the Job Status (s. WRKACTJOB) data available in SAP. These include JOBNAME (iSeries: Job Name (Database Monitor)), JOBUSER (iSeries: Job User (Database Monitor)), JOBNUM (iSeries: Job Number (Database Monitor)), PID (iSeries: Process ID of a Work Process).. 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: Not classified


SAP DB4_JOBSTS 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
JOBNAMEiSeries: Job Name (Database Monitor) QQJOBCHAR10QQJOB
JOBUSERiSeries: Job User (Database Monitor) QQUSERCHAR10QQUSER
JOBNUMiSeries: Job Number (Database Monitor) QQJNUMCHAR6QQJNUM
PIDiSeries: Process ID of a Work Process QQJOBPIDINT410INT4
STATUSiSeries: Job Status QQSTATUSCHAR4CHAR4

Key field Non-key field



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

As DB4_JOBSTS 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 DB4_JOBSTS as there is no data to select.

How to access SAP table DB4_JOBSTS

Within an ECC or HANA version of SAP you can also view further information about DB4_JOBSTS 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!