ABAP Select data from SAP table RNWAT_EDIVKA_DATA 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 RNWAT_EDIVKA_DATA 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 RNWAT_EDIVKA_DATA. 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 RNWAT_EDIVKA_DATA 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_RNWAT_EDIVKA_DATA TYPE STANDARD TABLE OF RNWAT_EDIVKA_DATA,
      WA_RNWAT_EDIVKA_DATA TYPE RNWAT_EDIVKA_DATA,
      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: <RNWAT_EDIVKA_DATA> TYPE RNWAT_EDIVKA_DATA.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM RNWAT_EDIVKA_DATA
*  INTO TABLE @DATA(IT_RNWAT_EDIVKA_DATA2).
*--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_RNWAT_EDIVKA_DATA INDEX 1 INTO DATA(WA_RNWAT_EDIVKA_DATA2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<RNWAT_EDIVKA_DATA>-SDS01V10 = 1.
<RNWAT_EDIVKA_DATA>-SDS02V10 = 1.
<RNWAT_EDIVKA_DATA>-SDS03V10 = 1.
<RNWAT_EDIVKA_DATA>-SDS04V10 = 1.
<RNWAT_EDIVKA_DATA>-SDS05V10 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_RNWAT_EDIVKA_DATA-SDS06V10, sy-vline,
  WA_RNWAT_EDIVKA_DATA-SDS07V10, sy-vline,
  WA_RNWAT_EDIVKA_DATA-SDS08V10, sy-vline,
  WA_RNWAT_EDIVKA_DATA-SDS09V10, sy-vline,
  WA_RNWAT_EDIVKA_DATA-SDS10V10, sy-vline,
  WA_RNWAT_EDIVKA_DATA-SDS11V10, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_RNWAT_EDIVKA_DATA 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_RNWAT_EDIVKA_DATA 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_RNWAT_EDIVKA_DATA INTO WA_RNWAT_EDIVKA_DATA.


*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_RNWAT_EDIVKA_DATA_STR, 
SDS01V10 TYPE STRING,
SDS02V10 TYPE STRING,
SDS03V10 TYPE STRING,
SDS04V10 TYPE STRING,
SDS05V10 TYPE STRING,
SDS06V10 TYPE STRING,
SDS07V10 TYPE STRING,
SDS08V10 TYPE STRING,
SDS09V10 TYPE STRING,
SDS10V10 TYPE STRING,
SDS11V10 TYPE STRING,
SDS12V10 TYPE STRING,
SDS13V10 TYPE STRING,
SDS14V10 TYPE STRING,
SDS15V10 TYPE STRING,
SDS16V10 TYPE STRING,
SDS17V10 TYPE STRING,
SDS18V10 TYPE STRING,
SDS19V10 TYPE STRING,
SDS20V10 TYPE STRING,
SDS21V10 TYPE STRING,
SDS22V10 TYPE STRING,
SDS23V10 TYPE STRING,
SDS24V10 TYPE STRING,
SDS25V10 TYPE STRING,
SDS26V10 TYPE STRING,
SDS27V10 TYPE STRING,
SDS28V10 TYPE STRING,
SDS29V10 TYPE STRING,
SDS30V10 TYPE STRING,
SDS40V10 TYPE STRING,
SDS41V10 TYPE STRING,
SDS42V10 TYPE STRING,
SDS43V10 TYPE STRING,
SDS44V10 TYPE STRING,
SDS45V10 TYPE STRING,
SDS46V10 TYPE STRING,
SDS47V10 TYPE STRING,
SDS48V10 TYPE STRING,
SDS49V10 TYPE STRING,
SDS50V10 TYPE STRING,
SDS51V10 TYPE STRING,
SDS52V10 TYPE STRING,
SDS53V10 TYPE STRING,
SDS54V10 TYPE STRING,
SDS55V10 TYPE STRING,
SDS56V10 TYPE STRING,
SDS57V10 TYPE STRING,
SDS58V10 TYPE STRING,
SDS59V10 TYPE STRING,
SDS60V10 TYPE STRING,
SDS61V10 TYPE STRING,
SDS62V10 TYPE STRING,
SDS63V10 TYPE STRING,
SDS64V10 TYPE STRING,
SDS65V10 TYPE STRING,
SDS66V10 TYPE STRING,
SDS67V10 TYPE STRING,
SDS68V10 TYPE STRING,
SDS69V10 TYPE STRING,
SDS70V10 TYPE STRING,
SDS71V10 TYPE STRING,
SDS72V10 TYPE STRING,
SDS73V10 TYPE STRING,
SDS74V10 TYPE STRING,
SDS75V10 TYPE STRING,
SDS76V10 TYPE STRING,
SDS77V10 TYPE STRING,
SDS78V10 TYPE STRING,
SDS79V10 TYPE STRING,
SDS80V10 TYPE STRING,
SDS81V10 TYPE STRING,
SDS82V10 TYPE STRING,
SDS83V10 TYPE STRING,
SDS84V10 TYPE STRING,
SDS85V10 TYPE STRING,
SDS86V10 TYPE STRING,
SDS87V10 TYPE STRING,
SDS88V10 TYPE STRING,
SDS98V10 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_RNWAT_EDIVKA_DATA_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_RNWAT_EDIVKA_DATA_STR-SDS01V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS02V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS03V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS04V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS05V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS06V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS07V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS08V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS09V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS10V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS11V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS12V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS13V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS14V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS15V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS16V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS17V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS18V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS19V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS20V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS21V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS22V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS23V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS24V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS25V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS26V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS27V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS28V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS29V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS30V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS40V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS41V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS42V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS43V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS44V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS45V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS46V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS47V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS48V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS49V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS50V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS51V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS52V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS53V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS54V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS55V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS56V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS57V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS58V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS59V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS60V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS61V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS62V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS63V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS64V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS65V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS66V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS67V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS68V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS69V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS70V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS71V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS72V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS73V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS74V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS75V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS76V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS77V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS78V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS79V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS80V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS81V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS82V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS83V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS84V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS85V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS86V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS87V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS88V10 sy-vline 
WA_RNWAT_EDIVKA_DATA_STR-SDS98V10 sy-vline      INTO ld_text SEPARATED BY SPACE.

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