ABAP Select data from SAP table RNWAT_EDIVKA_DATA_OLD 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_OLD 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_OLD. 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_OLD 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_OLD TYPE STANDARD TABLE OF RNWAT_EDIVKA_DATA_OLD,
      WA_RNWAT_EDIVKA_DATA_OLD TYPE RNWAT_EDIVKA_DATA_OLD,
      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_OLD> TYPE RNWAT_EDIVKA_DATA_OLD.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM RNWAT_EDIVKA_DATA_OLD
*  INTO TABLE @DATA(IT_RNWAT_EDIVKA_DATA_OLD2).
*--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_OLD INDEX 1 INTO DATA(WA_RNWAT_EDIVKA_DATA_OLD2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<RNWAT_EDIVKA_DATA_OLD>-SDS01V01 = 1.
<RNWAT_EDIVKA_DATA_OLD>-SDS02V01 = 1.
<RNWAT_EDIVKA_DATA_OLD>-SDS03V01 = 1.
<RNWAT_EDIVKA_DATA_OLD>-SDS04V01 = 1.
<RNWAT_EDIVKA_DATA_OLD>-SDS05V01 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_RNWAT_EDIVKA_DATA_OLD-SDS06V01, sy-vline,
  WA_RNWAT_EDIVKA_DATA_OLD-SDS07V01, sy-vline,
  WA_RNWAT_EDIVKA_DATA_OLD-SDS08V01, sy-vline,
  WA_RNWAT_EDIVKA_DATA_OLD-SDS09V01, sy-vline,
  WA_RNWAT_EDIVKA_DATA_OLD-SDS10V01, sy-vline,
  WA_RNWAT_EDIVKA_DATA_OLD-SDS11V01, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_RNWAT_EDIVKA_DATA_OLD 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_OLD 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_OLD INTO WA_RNWAT_EDIVKA_DATA_OLD.


*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_OLD_STR, 
SDS01V01 TYPE STRING,
SDS02V01 TYPE STRING,
SDS03V01 TYPE STRING,
SDS04V01 TYPE STRING,
SDS05V01 TYPE STRING,
SDS06V01 TYPE STRING,
SDS07V01 TYPE STRING,
SDS08V01 TYPE STRING,
SDS09V01 TYPE STRING,
SDS10V01 TYPE STRING,
SDS11V01 TYPE STRING,
SDS12V01 TYPE STRING,
SDS13V01 TYPE STRING,
SDS14V01 TYPE STRING,
SDS15V01 TYPE STRING,
SDS16V01 TYPE STRING,
SDS17V01 TYPE STRING,
SDS18V01 TYPE STRING,
SDS19V01 TYPE STRING,
SDS20V01 TYPE STRING,
SDS21V01 TYPE STRING,
SDS22V01 TYPE STRING,
SDS23V01 TYPE STRING,
SDS24V01 TYPE STRING,
SDS25V01 TYPE STRING,
SDS26V01 TYPE STRING,
SDS27V01 TYPE STRING,
SDS28V01 TYPE STRING,
SDS29V01 TYPE STRING,
SDS30V01 TYPE STRING,
SDS40V01 TYPE STRING,
SDS41V01 TYPE STRING,
SDS42V01 TYPE STRING,
SDS43V01 TYPE STRING,
SDS44V01 TYPE STRING,
SDS45V01 TYPE STRING,
SDS46V01 TYPE STRING,
SDS47V01 TYPE STRING,
SDS48V01 TYPE STRING,
SDS49V01 TYPE STRING,
SDS50V01 TYPE STRING,
SDS51V01 TYPE STRING,
SDS52V01 TYPE STRING,
SDS53V01 TYPE STRING,
SDS54V01 TYPE STRING,
SDS55V01 TYPE STRING,
SDS56V01 TYPE STRING,
SDS57V01 TYPE STRING,
SDS58V01 TYPE STRING,
SDS59V01 TYPE STRING,
SDS60V01 TYPE STRING,
SDS61V01 TYPE STRING,
SDS62V01 TYPE STRING,
SDS63V01 TYPE STRING,
SDS64V01 TYPE STRING,
SDS65V01 TYPE STRING,
SDS66V01 TYPE STRING,
SDS67V01 TYPE STRING,
SDS68V01 TYPE STRING,
SDS69V01 TYPE STRING,
SDS70V01 TYPE STRING,
SDS71V01 TYPE STRING,
SDS72V01 TYPE STRING,
SDS73V01 TYPE STRING,
SDS74V01 TYPE STRING,
SDS75V01 TYPE STRING,
SDS76V01 TYPE STRING,
SDS77V01 TYPE STRING,
SDS78V01 TYPE STRING,
SDS79V01 TYPE STRING,
SDS80V01 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_RNWAT_EDIVKA_DATA_OLD_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_OLD_STR-SDS01V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS02V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS03V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS04V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS05V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS06V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS07V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS08V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS09V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS10V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS11V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS12V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS13V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS14V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS15V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS16V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS17V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS18V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS19V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS20V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS21V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS22V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS23V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS24V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS25V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS26V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS27V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS28V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS29V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS30V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS40V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS41V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS42V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS43V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS44V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS45V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS46V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS47V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS48V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS49V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS50V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS51V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS52V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS53V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS54V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS55V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS56V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS57V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS58V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS59V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS60V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS61V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS62V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS63V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS64V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS65V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS66V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS67V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS68V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS69V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS70V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS71V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS72V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS73V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS74V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS75V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS76V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS77V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS78V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS79V01 sy-vline 
WA_RNWAT_EDIVKA_DATA_OLD_STR-SDS80V01 sy-vline      INTO ld_text SEPARATED BY SPACE.

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