ABAP Select data from SAP table /SDF/E2E_LOADER_HEADER 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 /SDF/E2E_LOADER_HEADER 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 /SDF/E2E_LOADER_HEADER. 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 /SDF/E2E_LOADER_HEADER 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_/SDF/E2E_LOADER_HEADER TYPE STANDARD TABLE OF /SDF/E2E_LOADER_HEADER,
      WA_/SDF/E2E_LOADER_HEADER TYPE /SDF/E2E_LOADER_HEADER,
      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: </SDF/E2E_LOADER_HEADER> TYPE /SDF/E2E_LOADER_HEADER.

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

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM /SDF/E2E_LOADER_HEADER
  INTO TABLE IT_/SDF/E2E_LOADER_HEADER.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /SDF/E2E_LOADER_HEADER
*  INTO TABLE @DATA(IT_/SDF/E2E_LOADER_HEADER2).
*--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_/SDF/E2E_LOADER_HEADER INDEX 1 INTO DATA(WA_/SDF/E2E_LOADER_HEADER2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/SDF/E2E_LOADER_HEADER ASSIGNING </SDF/E2E_LOADER_HEADER>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
</SDF/E2E_LOADER_HEADER>-FIELD1 = 1.
</SDF/E2E_LOADER_HEADER>-FIELD2 = 1.
</SDF/E2E_LOADER_HEADER>-FIELD3 = 1.
</SDF/E2E_LOADER_HEADER>-FIELD4 = 1.
</SDF/E2E_LOADER_HEADER>-FIELD5 = 1.

ENDLOOP.

LOOP AT IT_/SDF/E2E_LOADER_HEADER INTO WA_/SDF/E2E_LOADER_HEADER.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/SDF/E2E_LOADER_HEADER-FIELD6, sy-vline,
  WA_/SDF/E2E_LOADER_HEADER-FIELD7, sy-vline,
  WA_/SDF/E2E_LOADER_HEADER-FIELD8, sy-vline,
  WA_/SDF/E2E_LOADER_HEADER-FIELD9, sy-vline,
  WA_/SDF/E2E_LOADER_HEADER-FIELD10, sy-vline,
  WA_/SDF/E2E_LOADER_HEADER-FIELD11, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/SDF/E2E_LOADER_HEADER 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_/SDF/E2E_LOADER_HEADER 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_/SDF/E2E_LOADER_HEADER INTO WA_/SDF/E2E_LOADER_HEADER.


*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_/SDF/E2E_LOADER_HEADER_STR, 
FIELD1 TYPE STRING,
FIELD2 TYPE STRING,
FIELD3 TYPE STRING,
FIELD4 TYPE STRING,
FIELD5 TYPE STRING,
FIELD6 TYPE STRING,
FIELD7 TYPE STRING,
FIELD8 TYPE STRING,
FIELD9 TYPE STRING,
FIELD10 TYPE STRING,
FIELD11 TYPE STRING,
FIELD12 TYPE STRING,
FIELD13 TYPE STRING,
FIELD14 TYPE STRING,
FIELD15 TYPE STRING,
FIELD16 TYPE STRING,
FIELD17 TYPE STRING,
FIELD18 TYPE STRING,
FIELD19 TYPE STRING,
FIELD20 TYPE STRING,
FIELD21 TYPE STRING,
FIELD22 TYPE STRING,
FIELD23 TYPE STRING,
FIELD24 TYPE STRING,
FIELD25 TYPE STRING,
FIELD26 TYPE STRING,
FIELD27 TYPE STRING,
FIELD28 TYPE STRING,
FIELD29 TYPE STRING,
FIELD30 TYPE STRING,
FIELD31 TYPE STRING,
FIELD32 TYPE STRING,
FIELD33 TYPE STRING,
FIELD34 TYPE STRING,
FIELD35 TYPE STRING,
FIELD36 TYPE STRING,
FIELD37 TYPE STRING,
FIELD38 TYPE STRING,
FIELD39 TYPE STRING,
FIELD40 TYPE STRING,
FIELD41 TYPE STRING,
FIELD42 TYPE STRING,
FIELD43 TYPE STRING,
FIELD44 TYPE STRING,
FIELD45 TYPE STRING,
FIELD46 TYPE STRING,
FIELD47 TYPE STRING,
FIELD48 TYPE STRING,
FIELD49 TYPE STRING,
FIELD50 TYPE STRING,
FIELD51 TYPE STRING,
FIELD52 TYPE STRING,
FIELD53 TYPE STRING,
FIELD54 TYPE STRING,
FIELD55 TYPE STRING,
FIELD56 TYPE STRING,
FIELD57 TYPE STRING,
FIELD58 TYPE STRING,
FIELD59 TYPE STRING,
FIELD60 TYPE STRING,
FIELD61 TYPE STRING,
FIELD62 TYPE STRING,
FIELD63 TYPE STRING,
FIELD64 TYPE STRING,
FIELD65 TYPE STRING,
FIELD66 TYPE STRING,
FIELD67 TYPE STRING,
FIELD68 TYPE STRING,
FIELD69 TYPE STRING,
FIELD70 TYPE STRING,
FIELD71 TYPE STRING,
FIELD72 TYPE STRING,
FIELD73 TYPE STRING,
FIELD74 TYPE STRING,
FIELD75 TYPE STRING,
FIELD76 TYPE STRING,
FIELD77 TYPE STRING,
FIELD78 TYPE STRING,
FIELD79 TYPE STRING,
FIELD80 TYPE STRING,
FIELD81 TYPE STRING,
FIELD82 TYPE STRING,
FIELD83 TYPE STRING,
FIELD84 TYPE STRING,
FIELD85 TYPE STRING,
FIELD86 TYPE STRING,
FIELD87 TYPE STRING,
FIELD88 TYPE STRING,
FIELD89 TYPE STRING,
FIELD90 TYPE STRING,
FIELD91 TYPE STRING,
FIELD92 TYPE STRING,
FIELD93 TYPE STRING,
FIELD94 TYPE STRING,
FIELD95 TYPE STRING,
FIELD96 TYPE STRING,
FIELD97 TYPE STRING,
FIELD98 TYPE STRING,
FIELD99 TYPE STRING,
FIELD100 TYPE STRING,
LONGFIELD1 TYPE STRING,
LONGFIELD2 TYPE STRING,
LONGFIELD3 TYPE STRING,
LONGFIELD4 TYPE STRING,
LONGFIELD5 TYPE STRING,
LONGFIELD6 TYPE STRING,
LONGFIELD7 TYPE STRING,
LONGFIELD8 TYPE STRING,
LONGFIELD9 TYPE STRING,
LONGFIELD10 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/SDF/E2E_LOADER_HEADER_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_/SDF/E2E_LOADER_HEADER_STR-FIELD1 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD2 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD3 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD4 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD5 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD6 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD7 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD8 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD9 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD10 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD11 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD12 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD13 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD14 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD15 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD16 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD17 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD18 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD19 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD20 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD21 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD22 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD23 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD24 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD25 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD26 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD27 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD28 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD29 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD30 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD31 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD32 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD33 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD34 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD35 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD36 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD37 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD38 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD39 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD40 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD41 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD42 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD43 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD44 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD45 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD46 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD47 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD48 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD49 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD50 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD51 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD52 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD53 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD54 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD55 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD56 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD57 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD58 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD59 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD60 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD61 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD62 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD63 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD64 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD65 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD66 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD67 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD68 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD69 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD70 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD71 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD72 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD73 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD74 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD75 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD76 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD77 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD78 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD79 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD80 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD81 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD82 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD83 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD84 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD85 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD86 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD87 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD88 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD89 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD90 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD91 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD92 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD93 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD94 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD95 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD96 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD97 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD98 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD99 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-FIELD100 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-LONGFIELD1 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-LONGFIELD2 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-LONGFIELD3 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-LONGFIELD4 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-LONGFIELD5 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-LONGFIELD6 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-LONGFIELD7 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-LONGFIELD8 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-LONGFIELD9 sy-vline 
WA_/SDF/E2E_LOADER_HEADER_STR-LONGFIELD10 sy-vline      INTO ld_text SEPARATED BY SPACE.

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