ABAP Select data from SAP table DBA_VIEW_JOB_WIZARD into internal table

Get Example source ABAP code based on a different SAP table
  Get ABAP code

Below is a number of ABAP code snippets to demonstrate how to select data from SAP DBA_VIEW_JOB_WIZARD table and store it within an internal table, including using the newer @DATA inline declaration methods. It also shows you various ways to process this data using ABAP work area, inline declaration or field symbols including executing all the relevant CONVERSION_EXIT routines specific to DBA_VIEW_JOB_WIZARD. See here for more generic Select statement tips.

Sometimes data within SAP is stored within the database table in a different format to what it is displayed to the user. These input/output conversation FM routines are what translates the data between the two formats.

There is also a full declaration of the DBA_VIEW_JOB_WIZARD table where each field has a char/string type for you to simply copy and paste. This allows you to use processing that is only available to these field types such as the CONCATENATE statement.

DATA: IT_DBA_VIEW_JOB_WIZARD TYPE STANDARD TABLE OF DBA_VIEW_JOB_WIZARD,
      WA_DBA_VIEW_JOB_WIZARD TYPE DBA_VIEW_JOB_WIZARD,
      GD_STR TYPE STRING.

DATA: lo_typedescr type REF TO cl_abap_typedescr.
DATA: lv_fieldname type fieldname.

FIELD-SYMBOLS: <FIELD> TYPE any.
FIELD-SYMBOLS: <DBA_VIEW_JOB_WIZARD> TYPE DBA_VIEW_JOB_WIZARD.

*Process all fields in table header/work area as string values
  PERFORM process_as_string_field_values CHANGING wa_DBA_VIEW_JOB_WIZARD.

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM DBA_VIEW_JOB_WIZARD
  INTO TABLE IT_DBA_VIEW_JOB_WIZARD.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM DBA_VIEW_JOB_WIZARD
*  INTO TABLE @DATA(IT_DBA_VIEW_JOB_WIZARD2).
*--Further methods of using ABAP code to  select data from SAP database tables

*You can also declare the header/work area using the in-line DATA declaration method
READ TABLE IT_DBA_VIEW_JOB_WIZARD INDEX 1 INTO DATA(WA_DBA_VIEW_JOB_WIZARD2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_DBA_VIEW_JOB_WIZARD ASSIGNING <DBA_VIEW_JOB_WIZARD>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
<DBA_VIEW_JOB_WIZARD>-ACTION = 1.
<DBA_VIEW_JOB_WIZARD>-ACTION = 1.
<DBA_VIEW_JOB_WIZARD>-DESCRIPTION = 1.
<DBA_VIEW_JOB_WIZARD>-RB_START = 1.
<DBA_VIEW_JOB_WIZARD>-RB_START_IMMEDIATELY = 1.

ENDLOOP.

LOOP AT IT_DBA_VIEW_JOB_WIZARD INTO WA_DBA_VIEW_JOB_WIZARD.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_DBA_VIEW_JOB_WIZARD-RB_START_AT, sy-vline,
  WA_DBA_VIEW_JOB_WIZARD-RB_START_IN_DIALOG, sy-vline,
  WA_DBA_VIEW_JOB_WIZARD-RB_START_IN_DIALOG_TEST_MODE, sy-vline,
  WA_DBA_VIEW_JOB_WIZARD-PLANNED, sy-vline,
  WA_DBA_VIEW_JOB_WIZARD-DATE, sy-vline,
  WA_DBA_VIEW_JOB_WIZARD-TIME, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_DBA_VIEW_JOB_WIZARD you want to display...

  WRITE:/ sy-uline.
* Aternatively use generic code to Write field values (and NAME) to screen report
  DO.
    ASSIGN COMPONENT sy-index OF STRUCTURE wa_DBA_VIEW_JOB_WIZARD TO <field>.
    IF sy-subrc <> 0. EXIT. ENDIF.
    WRITE:/ 'Field Value', <field>, sy-vline.
    gd_str = <field> .
    lo_typedescr ?= CL_ABAP_DATADESCR=>DESCRIBE_BY_DATA( <field> ).
    lv_fieldname = lo_typedescr->GET_RELATIVE_NAME( ).
    WRITE:/ 'Field Name', lv_fieldname.
  ENDDO.

  
*Redo loop but convert all fields from internal to out value  
LOOP AT IT_DBA_VIEW_JOB_WIZARD INTO WA_DBA_VIEW_JOB_WIZARD.


*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Convert all fields to display/output versions using conversion routines
  PERFORM convert_all_field_values CHANGING wa_EKKO.
	 
ENDLOOP.

  
*&---------------------------------------------------------------------*
*& Form convert_all_field_values
*&---------------------------------------------------------------------*
FORM convert_all_field_values CHANGING p_EKKO LIKE wa_EKKO.
DATA: ld_input(1000) TYPE c, ld_output(1000) TYPE C.
ENDFORM. 

*&---------------------------------------------------------------------*
*& Form process_as_string_field_values
*&---------------------------------------------------------------------*
FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO.

TYPES: BEGIN OF T_DBA_VIEW_JOB_WIZARD_STR, 
ACTION TYPE STRING,
ACTION TYPE STRING,
DESCRIPTION TYPE STRING,
RB_START TYPE STRING,
RB_START_IMMEDIATELY TYPE STRING,
RB_START_AT TYPE STRING,
RB_START_IN_DIALOG TYPE STRING,
RB_START_IN_DIALOG_TEST_MODE TYPE STRING,
PLANNED TYPE STRING,
DATE TYPE STRING,
TIME TYPE STRING,
RB_START_RECURRENCE TYPE STRING,
READONLY_START_AT TYPE STRING,
WITH_PARAMETERS TYPE STRING,
WITH_RECURRENCE TYPE STRING,
ALLOW_SINGLE_MAINT TYPE STRING,
WITH_PROGLOG TYPE STRING,
WITH_JOBLOG TYPE STRING,
WITH_EXTSCREEN TYPE STRING,
WITH_PREVIEW TYPE STRING,
START TYPE STRING,
DATE TYPE STRING,
TIME TYPE STRING,
STOP TYPE STRING,
DATE TYPE STRING,
TIME TYPE STRING,
STATUS TYPE STRING,
HIDE_EXTENSIONS TYPE STRING,
VISIBLE_STARTED TYPE STRING,
VISIBLE_FINISHED TYPE STRING,
RECURRENCE TYPE STRING,
RB_PERIOD TYPE STRING,
RB_PERIOD_NONE TYPE STRING,
RB_PERIOD_HOUR TYPE STRING,
RB_PERIOD_DAY TYPE STRING,
RB_PERIOD_WEEK TYPE STRING,
READONLY_PERIOD_AT TYPE STRING,
READONLY_PERIOD_ON TYPE STRING,
PERIOD TYPE STRING,
PERIOD_AT_0 TYPE STRING,
PERIOD_AT_1 TYPE STRING,
PERIOD_AT_2 TYPE STRING,
PERIOD_AT_3 TYPE STRING,
PERIOD_AT_4 TYPE STRING,
PERIOD_AT_5 TYPE STRING,
PERIOD_AT_6 TYPE STRING,
PERIOD_AT_7 TYPE STRING,
PERIOD_AT_8 TYPE STRING,
PERIOD_AT_9 TYPE STRING,
PERIOD_AT_10 TYPE STRING,
PERIOD_AT_11 TYPE STRING,
PERIOD_AT_12 TYPE STRING,
PERIOD_AT_13 TYPE STRING,
PERIOD_AT_14 TYPE STRING,
PERIOD_AT_15 TYPE STRING,
PERIOD_AT_16 TYPE STRING,
PERIOD_AT_17 TYPE STRING,
PERIOD_AT_18 TYPE STRING,
PERIOD_AT_19 TYPE STRING,
PERIOD_AT_20 TYPE STRING,
PERIOD_AT_21 TYPE STRING,
PERIOD_AT_22 TYPE STRING,
PERIOD_AT_23 TYPE STRING,
PERIOD_ON_MONDAY TYPE STRING,
PERIOD_ON_TUESDAY TYPE STRING,
PERIOD_ON_WEDNESDAY TYPE STRING,
PERIOD_ON_THURSDAY TYPE STRING,
PERIOD_ON_FRIDAY TYPE STRING,
PERIOD_ON_SATURDAY TYPE STRING,
PERIOD_ON_SUNDAY TYPE STRING,
RANGE_BEGIN TYPE STRING,
DATE TYPE STRING,
TIME TYPE STRING,
RB_RANGE TYPE STRING,
RB_RANGE_NO_END TYPE STRING,
RB_RANGE_END_OCC TYPE STRING,
RB_RANGE_END_DATE TYPE STRING,
RANGE_OCCURRENCES TYPE STRING,
RANGE_END TYPE STRING,
DATE TYPE STRING,
TIME TYPE STRING,
RECURRENCE_EXPLANATION TYPE STRING,
READONLY_END_OCC TYPE STRING,
READONLY_END_DATE TYPE STRING,
READONLY_ALL TYPE STRING,
VISIBLE_STARTED TYPE STRING,
VISIBLE_FINISHED TYPE STRING,
READONLY_RB_RANGE TYPE STRING,
EXTSCREEN_INFO TYPE STRING,
TITLE TYPE STRING,
MSG TYPE STRING,
CURRENT_ACTION_INDEX TYPE STRING,
MAX_ACTION_INDEX TYPE STRING,
PAGING_BUTTONS_VISIBLE TYPE STRING,
MOD_BUTTONS_ENABLED TYPE STRING,
DEL_BUTTONS_ENABLED TYPE STRING,
EXEC_BUTTON_ENABLED TYPE STRING,
REFRESH_BUTTON_ENABLED TYPE STRING,
VARIANT TYPE STRING,
ID TYPE STRING,
SELECT TYPE STRING,
ACTIONS TYPE STRING,
NEXT_ACTION TYPE STRING,
START_TIME TYPE STRING,
NAME TYPE STRING,
MON TYPE STRING,
TUE TYPE STRING,
WED TYPE STRING,
THU TYPE STRING,
FRI TYPE STRING,
SAT TYPE STRING,
SUN TYPE STRING,
PROGLOG TYPE STRING,
EXTERNALLY_SCHEDULED TYPE STRING,END OF T_EKKO_STR.
DATA: WA_DBA_VIEW_JOB_WIZARD_STR type T_EKKO_STR.

DATA: ld_text TYPE string.

LOOP AT IT_EKKO INTO WA_EKKO.
  MOVE-CORRESPONDING wa_EKKO TO WA_EKKO_STR.
  CONCATENATE: sy-vline
WA_DBA_VIEW_JOB_WIZARD_STR-ACTION sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-ACTION sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-DESCRIPTION sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-RB_START sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-RB_START_IMMEDIATELY sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-RB_START_AT sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-RB_START_IN_DIALOG sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-RB_START_IN_DIALOG_TEST_MODE sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PLANNED sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-DATE sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-TIME sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-RB_START_RECURRENCE sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-READONLY_START_AT sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-WITH_PARAMETERS sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-WITH_RECURRENCE sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-ALLOW_SINGLE_MAINT sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-WITH_PROGLOG sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-WITH_JOBLOG sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-WITH_EXTSCREEN sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-WITH_PREVIEW sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-START sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-DATE sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-TIME sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-STOP sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-DATE sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-TIME sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-STATUS sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-HIDE_EXTENSIONS sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-VISIBLE_STARTED sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-VISIBLE_FINISHED sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-RECURRENCE sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-RB_PERIOD sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-RB_PERIOD_NONE sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-RB_PERIOD_HOUR sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-RB_PERIOD_DAY sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-RB_PERIOD_WEEK sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-READONLY_PERIOD_AT sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-READONLY_PERIOD_ON sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_0 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_1 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_2 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_3 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_4 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_5 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_6 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_7 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_8 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_9 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_10 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_11 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_12 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_13 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_14 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_15 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_16 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_17 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_18 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_19 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_20 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_21 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_22 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_AT_23 sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_ON_MONDAY sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_ON_TUESDAY sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_ON_WEDNESDAY sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_ON_THURSDAY sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_ON_FRIDAY sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_ON_SATURDAY sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PERIOD_ON_SUNDAY sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-RANGE_BEGIN sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-DATE sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-TIME sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-RB_RANGE sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-RB_RANGE_NO_END sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-RB_RANGE_END_OCC sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-RB_RANGE_END_DATE sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-RANGE_OCCURRENCES sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-RANGE_END sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-DATE sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-TIME sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-RECURRENCE_EXPLANATION sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-READONLY_END_OCC sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-READONLY_END_DATE sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-READONLY_ALL sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-VISIBLE_STARTED sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-VISIBLE_FINISHED sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-READONLY_RB_RANGE sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-EXTSCREEN_INFO sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-TITLE sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-MSG sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-CURRENT_ACTION_INDEX sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-MAX_ACTION_INDEX sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PAGING_BUTTONS_VISIBLE sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-MOD_BUTTONS_ENABLED sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-DEL_BUTTONS_ENABLED sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-EXEC_BUTTON_ENABLED sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-REFRESH_BUTTON_ENABLED sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-VARIANT sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-ID sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-SELECT sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-ACTIONS sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-NEXT_ACTION sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-START_TIME sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-NAME sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-MON sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-TUE sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-WED sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-THU sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-FRI sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-SAT sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-SUN sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-PROGLOG sy-vline 
WA_DBA_VIEW_JOB_WIZARD_STR-EXTERNALLY_SCHEDULED sy-vline      INTO ld_text SEPARATED BY SPACE.

*Add any further fields from structure WA_EKKO_STR you want to CONCATENATE...
ENDLOOP.
ENDFORM.