ABAP Select data from SAP table T5HSE 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 T5HSE 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 T5HSE. 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 T5HSE 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_T5HSE TYPE STANDARD TABLE OF T5HSE,
      WA_T5HSE TYPE T5HSE,
      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: <T5HSE> TYPE T5HSE.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM T5HSE
*  INTO TABLE @DATA(IT_T5HSE2).
*--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_T5HSE INDEX 1 INTO DATA(WA_T5HSE2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<T5HSE>-MANDT = 1.
<T5HSE>-BUKRS = 1.
<T5HSE>-INPER = 1.
<T5HSE>-FPPER = 1.
<T5HSE>-M0D0001B004 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_T5HSE-M0D0001B005, sy-vline,
  WA_T5HSE-WAERS, sy-vline,
  WA_T5HSE-M0D0001C0301C, sy-vline,
  WA_T5HSE-M0D0001C0301D, sy-vline,
  WA_T5HSE-M0D0001C0302C, sy-vline,
  WA_T5HSE-M0D0001C0302D, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_T5HSE 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_T5HSE 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_T5HSE INTO WA_T5HSE.


*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_T5HSE_STR, 
MANDT TYPE STRING,
BUKRS TYPE STRING,
INPER TYPE STRING,
FPPER TYPE STRING,
M0D0001B004 TYPE STRING,
M0D0001B005 TYPE STRING,
WAERS TYPE STRING,
M0D0001C0301C TYPE STRING,
M0D0001C0301D TYPE STRING,
M0D0001C0302C TYPE STRING,
M0D0001C0302D TYPE STRING,
M0D0001C0303C TYPE STRING,
M0D0001C0303D TYPE STRING,
M0D0001C0304C TYPE STRING,
M0D0001C0304D TYPE STRING,
M0D0001C0305C TYPE STRING,
M0D0001C0305D TYPE STRING,
M0D0001C0306C TYPE STRING,
M0D0001C0306D TYPE STRING,
M0D0001C0307C TYPE STRING,
M0D0001C0307D TYPE STRING,
M0D0001C0308C TYPE STRING,
M0D0001C0308D TYPE STRING,
M0D0001C0309C TYPE STRING,
M0D0001C0309D TYPE STRING,
M0D0001C0310C TYPE STRING,
M0D0001C0310D TYPE STRING,
M0D0001C0311C TYPE STRING,
M0D0001C0311D TYPE STRING,
M0D0001C0312C TYPE STRING,
M0D0001C0312D TYPE STRING,
M0D0001C0313C TYPE STRING,
M0D0001C0313D TYPE STRING,
M0D0001C0314C TYPE STRING,
M0D0001C0314D TYPE STRING,
M0D0001C0315C TYPE STRING,
M0D0001C0315D TYPE STRING,
M0D0001C0316C TYPE STRING,
M0D0001C0316D TYPE STRING,
M0D0001C0317C TYPE STRING,
M0D0001C0317D TYPE STRING,
M0D0001C0318C TYPE STRING,
M0D0001C0318D TYPE STRING,
M0D0001C0319C TYPE STRING,
M0D0001C0319D TYPE STRING,
M0D0001C0320C TYPE STRING,
M0D0001C0320D TYPE STRING,
M0D0001C0321C TYPE STRING,
M0D0001C0321D TYPE STRING,
M0D0001C0322C TYPE STRING,
M0D0001C0322D TYPE STRING,
M0D0001D0323B TYPE STRING,
M0E0001C50066 TYPE STRING,
M0E0001D50072 TYPE STRING,
M0E0001D50074 TYPE STRING,
M0E0001E50076 TYPE STRING,
M0E0001E50078 TYPE STRING,
M0E0001F50080 TYPE STRING,
M0E0001F50082 TYPE STRING,
M0E0001G50084 TYPE STRING,
M0E0001H50086 TYPE STRING,
M0E0001H50088 TYPE STRING,
M0E0001H50090 TYPE STRING,
M0E0001I50092 TYPE STRING,
M0E0001I50094 TYPE STRING,
M0F0001C50116 TYPE STRING,
M0F0001D50122 TYPE STRING,
M0F0001D50123 TYPE STRING,
M0F0001E50124 TYPE STRING,
M0F0001E50125 TYPE STRING,
M0F0001E50126 TYPE STRING,
M0F0001E50127 TYPE STRING,
M0F0001E50128 TYPE STRING,
M0F0001E50129 TYPE STRING,
M0F0001E50130 TYPE STRING,
M0F0001E50131 TYPE STRING,
M0F0001E50132 TYPE STRING,
M0F0001E50133 TYPE STRING,
M0F0001E50134 TYPE STRING,
M0F0001E50135 TYPE STRING,
M0F0001E50136 TYPE STRING,
M0F0001E50137 TYPE STRING,
M0F0001E50138 TYPE STRING,
M0F0001E50139 TYPE STRING,
M0F0001E50140 TYPE STRING,
M0F0001E50141 TYPE STRING,
M0F0001E50142 TYPE STRING,
M0F0001E50143 TYPE STRING,
M0F0001E50144 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_T5HSE_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_T5HSE_STR-MANDT sy-vline 
WA_T5HSE_STR-BUKRS sy-vline 
WA_T5HSE_STR-INPER sy-vline 
WA_T5HSE_STR-FPPER sy-vline 
WA_T5HSE_STR-M0D0001B004 sy-vline 
WA_T5HSE_STR-M0D0001B005 sy-vline 
WA_T5HSE_STR-WAERS sy-vline 
WA_T5HSE_STR-M0D0001C0301C sy-vline 
WA_T5HSE_STR-M0D0001C0301D sy-vline 
WA_T5HSE_STR-M0D0001C0302C sy-vline 
WA_T5HSE_STR-M0D0001C0302D sy-vline 
WA_T5HSE_STR-M0D0001C0303C sy-vline 
WA_T5HSE_STR-M0D0001C0303D sy-vline 
WA_T5HSE_STR-M0D0001C0304C sy-vline 
WA_T5HSE_STR-M0D0001C0304D sy-vline 
WA_T5HSE_STR-M0D0001C0305C sy-vline 
WA_T5HSE_STR-M0D0001C0305D sy-vline 
WA_T5HSE_STR-M0D0001C0306C sy-vline 
WA_T5HSE_STR-M0D0001C0306D sy-vline 
WA_T5HSE_STR-M0D0001C0307C sy-vline 
WA_T5HSE_STR-M0D0001C0307D sy-vline 
WA_T5HSE_STR-M0D0001C0308C sy-vline 
WA_T5HSE_STR-M0D0001C0308D sy-vline 
WA_T5HSE_STR-M0D0001C0309C sy-vline 
WA_T5HSE_STR-M0D0001C0309D sy-vline 
WA_T5HSE_STR-M0D0001C0310C sy-vline 
WA_T5HSE_STR-M0D0001C0310D sy-vline 
WA_T5HSE_STR-M0D0001C0311C sy-vline 
WA_T5HSE_STR-M0D0001C0311D sy-vline 
WA_T5HSE_STR-M0D0001C0312C sy-vline 
WA_T5HSE_STR-M0D0001C0312D sy-vline 
WA_T5HSE_STR-M0D0001C0313C sy-vline 
WA_T5HSE_STR-M0D0001C0313D sy-vline 
WA_T5HSE_STR-M0D0001C0314C sy-vline 
WA_T5HSE_STR-M0D0001C0314D sy-vline 
WA_T5HSE_STR-M0D0001C0315C sy-vline 
WA_T5HSE_STR-M0D0001C0315D sy-vline 
WA_T5HSE_STR-M0D0001C0316C sy-vline 
WA_T5HSE_STR-M0D0001C0316D sy-vline 
WA_T5HSE_STR-M0D0001C0317C sy-vline 
WA_T5HSE_STR-M0D0001C0317D sy-vline 
WA_T5HSE_STR-M0D0001C0318C sy-vline 
WA_T5HSE_STR-M0D0001C0318D sy-vline 
WA_T5HSE_STR-M0D0001C0319C sy-vline 
WA_T5HSE_STR-M0D0001C0319D sy-vline 
WA_T5HSE_STR-M0D0001C0320C sy-vline 
WA_T5HSE_STR-M0D0001C0320D sy-vline 
WA_T5HSE_STR-M0D0001C0321C sy-vline 
WA_T5HSE_STR-M0D0001C0321D sy-vline 
WA_T5HSE_STR-M0D0001C0322C sy-vline 
WA_T5HSE_STR-M0D0001C0322D sy-vline 
WA_T5HSE_STR-M0D0001D0323B sy-vline 
WA_T5HSE_STR-M0E0001C50066 sy-vline 
WA_T5HSE_STR-M0E0001D50072 sy-vline 
WA_T5HSE_STR-M0E0001D50074 sy-vline 
WA_T5HSE_STR-M0E0001E50076 sy-vline 
WA_T5HSE_STR-M0E0001E50078 sy-vline 
WA_T5HSE_STR-M0E0001F50080 sy-vline 
WA_T5HSE_STR-M0E0001F50082 sy-vline 
WA_T5HSE_STR-M0E0001G50084 sy-vline 
WA_T5HSE_STR-M0E0001H50086 sy-vline 
WA_T5HSE_STR-M0E0001H50088 sy-vline 
WA_T5HSE_STR-M0E0001H50090 sy-vline 
WA_T5HSE_STR-M0E0001I50092 sy-vline 
WA_T5HSE_STR-M0E0001I50094 sy-vline 
WA_T5HSE_STR-M0F0001C50116 sy-vline 
WA_T5HSE_STR-M0F0001D50122 sy-vline 
WA_T5HSE_STR-M0F0001D50123 sy-vline 
WA_T5HSE_STR-M0F0001E50124 sy-vline 
WA_T5HSE_STR-M0F0001E50125 sy-vline 
WA_T5HSE_STR-M0F0001E50126 sy-vline 
WA_T5HSE_STR-M0F0001E50127 sy-vline 
WA_T5HSE_STR-M0F0001E50128 sy-vline 
WA_T5HSE_STR-M0F0001E50129 sy-vline 
WA_T5HSE_STR-M0F0001E50130 sy-vline 
WA_T5HSE_STR-M0F0001E50131 sy-vline 
WA_T5HSE_STR-M0F0001E50132 sy-vline 
WA_T5HSE_STR-M0F0001E50133 sy-vline 
WA_T5HSE_STR-M0F0001E50134 sy-vline 
WA_T5HSE_STR-M0F0001E50135 sy-vline 
WA_T5HSE_STR-M0F0001E50136 sy-vline 
WA_T5HSE_STR-M0F0001E50137 sy-vline 
WA_T5HSE_STR-M0F0001E50138 sy-vline 
WA_T5HSE_STR-M0F0001E50139 sy-vline 
WA_T5HSE_STR-M0F0001E50140 sy-vline 
WA_T5HSE_STR-M0F0001E50141 sy-vline 
WA_T5HSE_STR-M0F0001E50142 sy-vline 
WA_T5HSE_STR-M0F0001E50143 sy-vline 
WA_T5HSE_STR-M0F0001E50144 sy-vline      INTO ld_text SEPARATED BY SPACE.

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