ABAP Select data from SAP table REP_EAPS_HU_STR_REP_21_22 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 REP_EAPS_HU_STR_REP_21_22 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 REP_EAPS_HU_STR_REP_21_22. 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 REP_EAPS_HU_STR_REP_21_22 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_REP_EAPS_HU_STR_REP_21_22 TYPE STANDARD TABLE OF REP_EAPS_HU_STR_REP_21_22,
      WA_REP_EAPS_HU_STR_REP_21_22 TYPE REP_EAPS_HU_STR_REP_21_22,
      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: <REP_EAPS_HU_STR_REP_21_22> TYPE REP_EAPS_HU_STR_REP_21_22.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM REP_EAPS_HU_STR_REP_21_22
*  INTO TABLE @DATA(IT_REP_EAPS_HU_STR_REP_21_222).
*--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_REP_EAPS_HU_STR_REP_21_22 INDEX 1 INTO DATA(WA_REP_EAPS_HU_STR_REP_21_222).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<REP_EAPS_HU_STR_REP_21_22>-INTKEY = 1.
<REP_EAPS_HU_STR_REP_21_22>-LINENR = 1.
<REP_EAPS_HU_STR_REP_21_22>-ACCOUNT = 1.
<REP_EAPS_HU_STR_REP_21_22>-LINEFACTOR = 1.
<REP_EAPS_HU_STR_REP_21_22>-LINETEXT = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_REP_EAPS_HU_STR_REP_21_22-ROWCOLOR, sy-vline,
  WA_REP_EAPS_HU_STR_REP_21_22-KSTAR, sy-vline,
  WA_REP_EAPS_HU_STR_REP_21_22-ACTIVITY_001, sy-vline,
  WA_REP_EAPS_HU_STR_REP_21_22-ACTIVITY_002, sy-vline,
  WA_REP_EAPS_HU_STR_REP_21_22-ACTIVITY_003, sy-vline,
  WA_REP_EAPS_HU_STR_REP_21_22-ACTIVITY_004, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_REP_EAPS_HU_STR_REP_21_22 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_REP_EAPS_HU_STR_REP_21_22 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_REP_EAPS_HU_STR_REP_21_22 INTO WA_REP_EAPS_HU_STR_REP_21_22.


*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.

*Conversion exit ALPHA, internal->external for field KSTAR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_REP_EAPS_HU_STR_REP_21_22-KSTAR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REP_EAPS_HU_STR_REP_21_22-KSTAR.
WRITE:/ 'New Value:', ld_input.
ENDFORM. 

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

TYPES: BEGIN OF T_REP_EAPS_HU_STR_REP_21_22_STR, 
INTKEY TYPE STRING,
LINENR TYPE STRING,
ACCOUNT TYPE STRING,
LINEFACTOR TYPE STRING,
LINETEXT TYPE STRING,
ROWCOLOR TYPE STRING,
KSTAR TYPE STRING,
ACTIVITY_001 TYPE STRING,
ACTIVITY_002 TYPE STRING,
ACTIVITY_003 TYPE STRING,
ACTIVITY_004 TYPE STRING,
ACTIVITY_005 TYPE STRING,
ACTIVITY_006 TYPE STRING,
ACTIVITY_007 TYPE STRING,
ACTIVITY_008 TYPE STRING,
ACTIVITY_009 TYPE STRING,
ACTIVITY_010 TYPE STRING,
ACTIVITY_011 TYPE STRING,
ACTIVITY_012 TYPE STRING,
ACTIVITY_013 TYPE STRING,
ACTIVITY_014 TYPE STRING,
ACTIVITY_015 TYPE STRING,
ACTIVITY_016 TYPE STRING,
ACTIVITY_017 TYPE STRING,
ACTIVITY_018 TYPE STRING,
ACTIVITY_019 TYPE STRING,
ACTIVITY_020 TYPE STRING,
ACTIVITY_021 TYPE STRING,
ACTIVITY_022 TYPE STRING,
ACTIVITY_023 TYPE STRING,
ACTIVITY_024 TYPE STRING,
ACTIVITY_025 TYPE STRING,
ACTIVITY_026 TYPE STRING,
ACTIVITY_027 TYPE STRING,
ACTIVITY_028 TYPE STRING,
ACTIVITY_029 TYPE STRING,
ACTIVITY_030 TYPE STRING,
ACTIVITY_031 TYPE STRING,
ACTIVITY_032 TYPE STRING,
ACTIVITY_033 TYPE STRING,
ACTIVITY_034 TYPE STRING,
ACTIVITY_035 TYPE STRING,
ACTIVITY_036 TYPE STRING,
ACTIVITY_037 TYPE STRING,
ACTIVITY_038 TYPE STRING,
ACTIVITY_039 TYPE STRING,
ACTIVITY_040 TYPE STRING,
ACTIVITY_041 TYPE STRING,
ACTIVITY_042 TYPE STRING,
ACTIVITY_043 TYPE STRING,
ACTIVITY_044 TYPE STRING,
ACTIVITY_045 TYPE STRING,
ACTIVITY_046 TYPE STRING,
ACTIVITY_047 TYPE STRING,
ACTIVITY_048 TYPE STRING,
ACTIVITY_049 TYPE STRING,
ACTIVITY_050 TYPE STRING,
ACTIVITY_051 TYPE STRING,
ACTIVITY_052 TYPE STRING,
ACTIVITY_053 TYPE STRING,
ACTIVITY_054 TYPE STRING,
ACTIVITY_055 TYPE STRING,
ACTIVITY_056 TYPE STRING,
ACTIVITY_057 TYPE STRING,
ACTIVITY_058 TYPE STRING,
ACTIVITY_059 TYPE STRING,
ACTIVITY_060 TYPE STRING,
ACTIVITY_061 TYPE STRING,
ACTIVITY_062 TYPE STRING,
ACTIVITY_063 TYPE STRING,
ACTIVITY_064 TYPE STRING,
ACTIVITY_065 TYPE STRING,
ACTIVITY_066 TYPE STRING,
ACTIVITY_067 TYPE STRING,
ACTIVITY_068 TYPE STRING,
ACTIVITY_069 TYPE STRING,
ACTIVITY_070 TYPE STRING,
ACTIVITY_071 TYPE STRING,
ACTIVITY_072 TYPE STRING,
ACTIVITY_073 TYPE STRING,
ACTIVITY_074 TYPE STRING,
ACTIVITY_075 TYPE STRING,
ACTIVITY_076 TYPE STRING,
ACTIVITY_077 TYPE STRING,
ACTIVITY_078 TYPE STRING,
ACTIVITY_079 TYPE STRING,
ACTIVITY_080 TYPE STRING,
ACTIVITY_081 TYPE STRING,
ACTIVITY_082 TYPE STRING,
ACTIVITY_083 TYPE STRING,
ACTIVITY_084 TYPE STRING,
ACTIVITY_085 TYPE STRING,
ACTIVITY_086 TYPE STRING,
ACTIVITY_087 TYPE STRING,
ACTIVITY_088 TYPE STRING,
ACTIVITY_089 TYPE STRING,
ACTIVITY_090 TYPE STRING,
ACTIVITY_091 TYPE STRING,
ACTIVITY_092 TYPE STRING,
ACTIVITY_093 TYPE STRING,
ACTIVITY_094 TYPE STRING,
ACTIVITY_095 TYPE STRING,
ACTIVITY_096 TYPE STRING,
ACTIVITY_097 TYPE STRING,
ACTIVITY_098 TYPE STRING,
ACTIVITY_099 TYPE STRING,
ACTIVITY_100 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_REP_EAPS_HU_STR_REP_21_22_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_REP_EAPS_HU_STR_REP_21_22_STR-INTKEY sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-LINENR sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACCOUNT sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-LINEFACTOR sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-LINETEXT sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ROWCOLOR sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-KSTAR sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_001 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_002 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_003 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_004 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_005 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_006 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_007 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_008 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_009 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_010 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_011 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_012 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_013 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_014 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_015 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_016 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_017 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_018 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_019 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_020 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_021 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_022 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_023 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_024 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_025 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_026 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_027 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_028 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_029 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_030 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_031 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_032 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_033 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_034 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_035 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_036 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_037 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_038 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_039 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_040 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_041 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_042 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_043 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_044 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_045 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_046 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_047 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_048 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_049 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_050 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_051 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_052 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_053 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_054 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_055 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_056 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_057 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_058 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_059 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_060 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_061 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_062 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_063 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_064 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_065 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_066 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_067 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_068 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_069 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_070 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_071 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_072 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_073 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_074 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_075 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_076 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_077 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_078 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_079 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_080 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_081 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_082 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_083 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_084 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_085 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_086 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_087 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_088 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_089 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_090 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_091 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_092 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_093 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_094 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_095 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_096 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_097 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_098 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_099 sy-vline 
WA_REP_EAPS_HU_STR_REP_21_22_STR-ACTIVITY_100 sy-vline      INTO ld_text SEPARATED BY SPACE.

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