ABAP Select data from SAP table E3KEVA5 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 E3KEVA5 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 E3KEVA5. 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 E3KEVA5 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_E3KEVA5 TYPE STANDARD TABLE OF E3KEVA5,
      WA_E3KEVA5 TYPE E3KEVA5,
      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: <E3KEVA5> TYPE E3KEVA5.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM E3KEVA5
*  INTO TABLE @DATA(IT_E3KEVA52).
*--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_E3KEVA5 INDEX 1 INTO DATA(WA_E3KEVA52).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<E3KEVA5>-VAL201 = 1.
<E3KEVA5>-VAL202 = 1.
<E3KEVA5>-VAL203 = 1.
<E3KEVA5>-VAL204 = 1.
<E3KEVA5>-VAL205 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_E3KEVA5-VAL206, sy-vline,
  WA_E3KEVA5-VAL207, sy-vline,
  WA_E3KEVA5-VAL208, sy-vline,
  WA_E3KEVA5-VAL209, sy-vline,
  WA_E3KEVA5-VAL210, sy-vline,
  WA_E3KEVA5-VAL211, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_E3KEVA5 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_E3KEVA5 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_E3KEVA5 INTO WA_E3KEVA5.


*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_E3KEVA5_STR, 
VAL201 TYPE STRING,
VAL202 TYPE STRING,
VAL203 TYPE STRING,
VAL204 TYPE STRING,
VAL205 TYPE STRING,
VAL206 TYPE STRING,
VAL207 TYPE STRING,
VAL208 TYPE STRING,
VAL209 TYPE STRING,
VAL210 TYPE STRING,
VAL211 TYPE STRING,
VAL212 TYPE STRING,
VAL213 TYPE STRING,
VAL214 TYPE STRING,
VAL215 TYPE STRING,
VAL216 TYPE STRING,
VAL217 TYPE STRING,
VAL218 TYPE STRING,
VAL219 TYPE STRING,
VAL220 TYPE STRING,
VAL221 TYPE STRING,
VAL222 TYPE STRING,
VAL223 TYPE STRING,
VAL224 TYPE STRING,
VAL225 TYPE STRING,
VAL226 TYPE STRING,
VAL227 TYPE STRING,
VAL228 TYPE STRING,
VAL229 TYPE STRING,
VAL230 TYPE STRING,
VAL231 TYPE STRING,
VAL232 TYPE STRING,
VAL233 TYPE STRING,
VAL234 TYPE STRING,
VAL235 TYPE STRING,
VAL236 TYPE STRING,
VAL237 TYPE STRING,
VAL238 TYPE STRING,
VAL239 TYPE STRING,
VAL240 TYPE STRING,
VAL241 TYPE STRING,
VAL242 TYPE STRING,
VAL243 TYPE STRING,
VAL244 TYPE STRING,
VAL245 TYPE STRING,
VAL246 TYPE STRING,
VAL247 TYPE STRING,
VAL248 TYPE STRING,
VAL249 TYPE STRING,
VAL250 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_E3KEVA5_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_E3KEVA5_STR-VAL201 sy-vline 
WA_E3KEVA5_STR-VAL202 sy-vline 
WA_E3KEVA5_STR-VAL203 sy-vline 
WA_E3KEVA5_STR-VAL204 sy-vline 
WA_E3KEVA5_STR-VAL205 sy-vline 
WA_E3KEVA5_STR-VAL206 sy-vline 
WA_E3KEVA5_STR-VAL207 sy-vline 
WA_E3KEVA5_STR-VAL208 sy-vline 
WA_E3KEVA5_STR-VAL209 sy-vline 
WA_E3KEVA5_STR-VAL210 sy-vline 
WA_E3KEVA5_STR-VAL211 sy-vline 
WA_E3KEVA5_STR-VAL212 sy-vline 
WA_E3KEVA5_STR-VAL213 sy-vline 
WA_E3KEVA5_STR-VAL214 sy-vline 
WA_E3KEVA5_STR-VAL215 sy-vline 
WA_E3KEVA5_STR-VAL216 sy-vline 
WA_E3KEVA5_STR-VAL217 sy-vline 
WA_E3KEVA5_STR-VAL218 sy-vline 
WA_E3KEVA5_STR-VAL219 sy-vline 
WA_E3KEVA5_STR-VAL220 sy-vline 
WA_E3KEVA5_STR-VAL221 sy-vline 
WA_E3KEVA5_STR-VAL222 sy-vline 
WA_E3KEVA5_STR-VAL223 sy-vline 
WA_E3KEVA5_STR-VAL224 sy-vline 
WA_E3KEVA5_STR-VAL225 sy-vline 
WA_E3KEVA5_STR-VAL226 sy-vline 
WA_E3KEVA5_STR-VAL227 sy-vline 
WA_E3KEVA5_STR-VAL228 sy-vline 
WA_E3KEVA5_STR-VAL229 sy-vline 
WA_E3KEVA5_STR-VAL230 sy-vline 
WA_E3KEVA5_STR-VAL231 sy-vline 
WA_E3KEVA5_STR-VAL232 sy-vline 
WA_E3KEVA5_STR-VAL233 sy-vline 
WA_E3KEVA5_STR-VAL234 sy-vline 
WA_E3KEVA5_STR-VAL235 sy-vline 
WA_E3KEVA5_STR-VAL236 sy-vline 
WA_E3KEVA5_STR-VAL237 sy-vline 
WA_E3KEVA5_STR-VAL238 sy-vline 
WA_E3KEVA5_STR-VAL239 sy-vline 
WA_E3KEVA5_STR-VAL240 sy-vline 
WA_E3KEVA5_STR-VAL241 sy-vline 
WA_E3KEVA5_STR-VAL242 sy-vline 
WA_E3KEVA5_STR-VAL243 sy-vline 
WA_E3KEVA5_STR-VAL244 sy-vline 
WA_E3KEVA5_STR-VAL245 sy-vline 
WA_E3KEVA5_STR-VAL246 sy-vline 
WA_E3KEVA5_STR-VAL247 sy-vline 
WA_E3KEVA5_STR-VAL248 sy-vline 
WA_E3KEVA5_STR-VAL249 sy-vline 
WA_E3KEVA5_STR-VAL250 sy-vline      INTO ld_text SEPARATED BY SPACE.

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