ABAP Select data from SAP table T77PADRU_TAXPRI1 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 T77PADRU_TAXPRI1 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 T77PADRU_TAXPRI1. 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 T77PADRU_TAXPRI1 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_T77PADRU_TAXPRI1 TYPE STANDARD TABLE OF T77PADRU_TAXPRI1,
      WA_T77PADRU_TAXPRI1 TYPE T77PADRU_TAXPRI1,
      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: <T77PADRU_TAXPRI1> TYPE T77PADRU_TAXPRI1.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM T77PADRU_TAXPRI1
*  INTO TABLE @DATA(IT_T77PADRU_TAXPRI12).
*--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_T77PADRU_TAXPRI1 INDEX 1 INTO DATA(WA_T77PADRU_TAXPRI12).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<T77PADRU_TAXPRI1>-MANDT = 1.
<T77PADRU_TAXPRI1>-LAND = 1.
<T77PADRU_TAXPRI1>-TAXNUM = 1.
<T77PADRU_TAXPRI1>-ENDDA = 1.
<T77PADRU_TAXPRI1>-PRIRR = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_T77PADRU_TAXPRI1-TAXL11, sy-vline,
  WA_T77PADRU_TAXPRI1-TAXL12, sy-vline,
  WA_T77PADRU_TAXPRI1-TAXL13, sy-vline,
  WA_T77PADRU_TAXPRI1-TAXL14, sy-vline,
  WA_T77PADRU_TAXPRI1-TAXL15, sy-vline,
  WA_T77PADRU_TAXPRI1-TAXL16, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_T77PADRU_TAXPRI1 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_T77PADRU_TAXPRI1 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_T77PADRU_TAXPRI1 INTO WA_T77PADRU_TAXPRI1.


*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_T77PADRU_TAXPRI1_STR, 
MANDT TYPE STRING,
LAND TYPE STRING,
TAXNUM TYPE STRING,
ENDDA TYPE STRING,
PRIRR TYPE STRING,
TAXL11 TYPE STRING,
TAXL12 TYPE STRING,
TAXL13 TYPE STRING,
TAXL14 TYPE STRING,
TAXL15 TYPE STRING,
TAXL16 TYPE STRING,
TAXL17 TYPE STRING,
TAXL18 TYPE STRING,
TAXL19 TYPE STRING,
TAXL20 TYPE STRING,
TAXL21 TYPE STRING,
TAXL22 TYPE STRING,
TAXL23 TYPE STRING,
TAXL24 TYPE STRING,
TAXL25 TYPE STRING,
TAXL26 TYPE STRING,
TAXL27 TYPE STRING,
TAXL28 TYPE STRING,
TAXL29 TYPE STRING,
TAXL30 TYPE STRING,
TAXL31 TYPE STRING,
TAXL32 TYPE STRING,
TAXL33 TYPE STRING,
TAXL34 TYPE STRING,
TAXL35 TYPE STRING,
TAXL36 TYPE STRING,
TAXL37 TYPE STRING,
TAXL38 TYPE STRING,
TAXL39 TYPE STRING,
TAXL40 TYPE STRING,
TAXL41 TYPE STRING,
TAXL42 TYPE STRING,
TAXL43 TYPE STRING,
TAXL44 TYPE STRING,
TAXL45 TYPE STRING,
TAXL46 TYPE STRING,
TAXL47 TYPE STRING,
TAXL48 TYPE STRING,
TAXL49 TYPE STRING,
TAXL50 TYPE STRING,
TAXL51 TYPE STRING,
TAXL52 TYPE STRING,
TAXL53 TYPE STRING,
TAXL54 TYPE STRING,
TAXL55 TYPE STRING,
TAXL56 TYPE STRING,
TAXL57 TYPE STRING,
TAXL58 TYPE STRING,
TAXL59 TYPE STRING,
TAXL60 TYPE STRING,
TAXL61 TYPE STRING,
TAXL62 TYPE STRING,
TAXL63 TYPE STRING,
TAXL64 TYPE STRING,
TAXL65 TYPE STRING,
TAXL66 TYPE STRING,
TAXL67 TYPE STRING,
TAXL68 TYPE STRING,
TAXL69 TYPE STRING,
TAXL70 TYPE STRING,
TAXL71 TYPE STRING,
TAXL72 TYPE STRING,
TAXL73 TYPE STRING,
TAXL74 TYPE STRING,
TAXL75 TYPE STRING,
TAXL76 TYPE STRING,
TAXL77 TYPE STRING,
TAXL78 TYPE STRING,
TAXL79 TYPE STRING,
TAXL80 TYPE STRING,
TAXL81 TYPE STRING,
TAXL82 TYPE STRING,
TAXL83 TYPE STRING,
TAXL84 TYPE STRING,
TAXL85 TYPE STRING,
TAXL86 TYPE STRING,
TAXL87 TYPE STRING,
TAXL88 TYPE STRING,
TAXL89 TYPE STRING,
TAXL90 TYPE STRING,
TAXL91 TYPE STRING,
TAXL92 TYPE STRING,
TAXL93 TYPE STRING,
TAXL94 TYPE STRING,
TAXL95 TYPE STRING,
TAXL96 TYPE STRING,
TAXL97 TYPE STRING,
TAXL98 TYPE STRING,
TAXL99 TYPE STRING,
TAXL100 TYPE STRING,
TAXL101 TYPE STRING,
TAXL102 TYPE STRING,
TAXL103 TYPE STRING,
TAXL104 TYPE STRING,
TAXL105 TYPE STRING,
TAXL106 TYPE STRING,
TAXL107 TYPE STRING,
TAXL108 TYPE STRING,
TAXL109 TYPE STRING,
TAXL110 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_T77PADRU_TAXPRI1_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_T77PADRU_TAXPRI1_STR-MANDT sy-vline 
WA_T77PADRU_TAXPRI1_STR-LAND sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXNUM sy-vline 
WA_T77PADRU_TAXPRI1_STR-ENDDA sy-vline 
WA_T77PADRU_TAXPRI1_STR-PRIRR sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL11 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL12 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL13 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL14 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL15 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL16 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL17 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL18 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL19 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL20 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL21 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL22 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL23 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL24 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL25 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL26 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL27 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL28 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL29 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL30 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL31 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL32 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL33 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL34 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL35 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL36 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL37 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL38 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL39 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL40 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL41 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL42 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL43 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL44 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL45 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL46 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL47 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL48 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL49 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL50 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL51 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL52 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL53 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL54 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL55 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL56 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL57 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL58 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL59 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL60 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL61 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL62 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL63 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL64 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL65 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL66 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL67 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL68 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL69 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL70 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL71 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL72 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL73 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL74 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL75 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL76 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL77 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL78 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL79 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL80 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL81 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL82 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL83 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL84 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL85 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL86 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL87 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL88 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL89 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL90 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL91 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL92 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL93 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL94 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL95 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL96 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL97 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL98 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL99 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL100 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL101 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL102 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL103 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL104 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL105 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL106 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL107 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL108 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL109 sy-vline 
WA_T77PADRU_TAXPRI1_STR-TAXL110 sy-vline      INTO ld_text SEPARATED BY SPACE.

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