ABAP Select data from SAP table HRDE_SVRVBEATRANSPORT_RESPONS2 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 HRDE_SVRVBEATRANSPORT_RESPONS2 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 HRDE_SVRVBEATRANSPORT_RESPONS2. 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 HRDE_SVRVBEATRANSPORT_RESPONS2 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_HRDE_SVRVBEATRANSPORT_RESPONS2 TYPE STANDARD TABLE OF HRDE_SVRVBEATRANSPORT_RESPONS2,
      WA_HRDE_SVRVBEATRANSPORT_RESPONS2 TYPE HRDE_SVRVBEATRANSPORT_RESPONS2,
      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: <HRDE_SVRVBEATRANSPORT_RESPONS2> TYPE HRDE_SVRVBEATRANSPORT_RESPONS2.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM HRDE_SVRVBEATRANSPORT_RESPONS2
*  INTO TABLE @DATA(IT_HRDE_SVRVBEATRANSPORT_RESPONS22).
*--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_HRDE_SVRVBEATRANSPORT_RESPONS2 INDEX 1 INTO DATA(WA_HRDE_SVRVBEATRANSPORT_RESPONS22).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<HRDE_SVRVBEATRANSPORT_RESPONS2>-CONTROLLER = 1.
<HRDE_SVRVBEATRANSPORT_RESPONS2>-BASE = 1.
<HRDE_SVRVBEATRANSPORT_RESPONS2>-CONTROLLER = 1.
<HRDE_SVRVBEATRANSPORT_RESPONS2>-VERSION = 1.
<HRDE_SVRVBEATRANSPORT_RESPONS2>-CHOICE = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_HRDE_SVRVBEATRANSPORT_RESPONS2-SELECTION, sy-vline,
  WA_HRDE_SVRVBEATRANSPORT_RESPONS2-CONTROLLER, sy-vline,
  WA_HRDE_SVRVBEATRANSPORT_RESPONS2-ENCRYPTED_DATA, sy-vline,
  WA_HRDE_SVRVBEATRANSPORT_RESPONS2-CONTROLLER, sy-vline,
  WA_HRDE_SVRVBEATRANSPORT_RESPONS2-BASE, sy-vline,
  WA_HRDE_SVRVBEATRANSPORT_RESPONS2-CONTROLLER, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_HRDE_SVRVBEATRANSPORT_RESPONS2 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_HRDE_SVRVBEATRANSPORT_RESPONS2 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_HRDE_SVRVBEATRANSPORT_RESPONS2 INTO WA_HRDE_SVRVBEATRANSPORT_RESPONS2.


*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_HRDE_SVRVBEATRANSPORT_RESPONS2_STR, 
CONTROLLER TYPE STRING,
BASE TYPE STRING,
CONTROLLER TYPE STRING,
VERSION TYPE STRING,
CHOICE TYPE STRING,
SELECTION TYPE STRING,
CONTROLLER TYPE STRING,
ENCRYPTED_DATA TYPE STRING,
CONTROLLER TYPE STRING,
BASE TYPE STRING,
CONTROLLER TYPE STRING,
ENCRYPTION_METHOD TYPE STRING,
KEY_INFO TYPE STRING,
CIPHER_DATA TYPE STRING,
CONTROLLER TYPE STRING,
CHOICE TYPE STRING,
SELECTION TYPE STRING,
CONTROLLER TYPE STRING,
CIPHER_VALUE TYPE STRING,
CIPHER_REFERENCE TYPE STRING,
CONTROLLER TYPE STRING,
CHOICE TYPE STRING,
SELECTION TYPE STRING,
CONTROLLER TYPE STRING,
TRANSFORMS TYPE STRING,
CONTROLLER TYPE STRING,
TRANSFORM TYPE STRING,
URI TYPE STRING,
ENCRYPTION_PROPERTIES TYPE STRING,
CONTROLLER TYPE STRING,
ENCRYPTION_PROPERTY TYPE STRING,
ID TYPE STRING,
ID TYPE STRING,
TYPE TYPE STRING,
MIME_TYPE TYPE STRING,
ENCODING TYPE STRING,
TRANSFORMED_DATA TYPE STRING,
CONTROLLER TYPE STRING,
TRANSFORMS TYPE STRING,
CONTENT TYPE STRING,
PACKAGE TYPE STRING,
MESSAGE TYPE STRING,
DATA TYPE STRING,
CONTROLLER TYPE STRING,
CHOICE TYPE STRING,
SELECTION TYPE STRING,
CONTROLLER TYPE STRING,
CHAR_SEQUENCE TYPE STRING,
CONTROLLER TYPE STRING,
CONTENT TYPE STRING,
BASE64CHAR_SEQUENCE TYPE STRING,
CONTROLLER TYPE STRING,
CONTENT TYPE STRING,
ELEMENT_SEQUENCE TYPE STRING,
CONTROLLER TYPE STRING,
DATA_REQUEST TYPE STRING,
CONTROLLER TYPE STRING,
QUERY TYPE STRING,
CONTROLLER TYPE STRING,
ARGUMENT TYPE STRING,
CONTROL TYPE STRING,
CONTROLLER TYPE STRING,
MAXIMUM_PACKAGES TYPE STRING,
MAXIMUM_MESSAGES TYPE STRING,
MAXIMUM_RESULTS TYPE STRING,
MAXIMUM_SIZE TYPE STRING,
VERSION TYPE STRING,
CONFIRMATION_OF_RECEIPT TYPE STRING,
CONTROLLER TYPE STRING,
PROPERTY TYPE STRING,
PROPERTY_SET TYPE STRING,
CONTROLLER TYPE STRING,
VALUE TYPE STRING,
NAME TYPE STRING,
TYPE TYPE STRING,
EVENT TYPE STRING,
VERSION TYPE STRING,
ANY_XML TYPE STRING,
CONTROLLER TYPE STRING,
CONTENT TYPE STRING,END OF T_EKKO_STR.
DATA: WA_HRDE_SVRVBEATRANSPORT_RESPONS2_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_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-BASE sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-VERSION sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CHOICE sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-SELECTION sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-ENCRYPTED_DATA sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-BASE sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-ENCRYPTION_METHOD sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-KEY_INFO sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CIPHER_DATA sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CHOICE sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-SELECTION sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CIPHER_VALUE sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CIPHER_REFERENCE sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CHOICE sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-SELECTION sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-TRANSFORMS sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-TRANSFORM sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-URI sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-ENCRYPTION_PROPERTIES sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-ENCRYPTION_PROPERTY sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-ID sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-ID sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-TYPE sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-MIME_TYPE sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-ENCODING sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-TRANSFORMED_DATA sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-TRANSFORMS sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTENT sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-PACKAGE sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-MESSAGE sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-DATA sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CHOICE sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-SELECTION sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CHAR_SEQUENCE sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTENT sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-BASE64CHAR_SEQUENCE sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTENT sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-ELEMENT_SEQUENCE sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-DATA_REQUEST sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-QUERY sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-ARGUMENT sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROL sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-MAXIMUM_PACKAGES sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-MAXIMUM_MESSAGES sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-MAXIMUM_RESULTS sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-MAXIMUM_SIZE sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-VERSION sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONFIRMATION_OF_RECEIPT sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-PROPERTY sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-PROPERTY_SET sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-VALUE sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-NAME sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-TYPE sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-EVENT sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-VERSION sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-ANY_XML sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTROLLER sy-vline 
WA_HRDE_SVRVBEATRANSPORT_RESPONS2_STR-CONTENT sy-vline      INTO ld_text SEPARATED BY SPACE.

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