ABAP Select data from SAP table T7INPEX3 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 T7INPEX3 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 T7INPEX3. 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 T7INPEX3 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_T7INPEX3 TYPE STANDARD TABLE OF T7INPEX3,
      WA_T7INPEX3 TYPE T7INPEX3,
      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: <T7INPEX3> TYPE T7INPEX3.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM T7INPEX3
*  INTO TABLE @DATA(IT_T7INPEX32).
*--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_T7INPEX3 INDEX 1 INTO DATA(WA_T7INPEX32).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<T7INPEX3>-MANDT = 1.
<T7INPEX3>-REGUI = 1.
<T7INPEX3>-SEQNM = 1.
<T7INPEX3>-ATIND = 1.
<T7INPEX3>-MDT01 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_T7INPEX3-MDT02, sy-vline,
  WA_T7INPEX3-MDT03, sy-vline,
  WA_T7INPEX3-MDT04, sy-vline,
  WA_T7INPEX3-MDT05, sy-vline,
  WA_T7INPEX3-MDT06, sy-vline,
  WA_T7INPEX3-MDT07, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_T7INPEX3 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_T7INPEX3 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_T7INPEX3 INTO WA_T7INPEX3.


*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_T7INPEX3_STR, 
MANDT TYPE STRING,
REGUI TYPE STRING,
SEQNM TYPE STRING,
ATIND TYPE STRING,
MDT01 TYPE STRING,
MDT02 TYPE STRING,
MDT03 TYPE STRING,
MDT04 TYPE STRING,
MDT05 TYPE STRING,
MDT06 TYPE STRING,
MDT07 TYPE STRING,
MDT08 TYPE STRING,
MDT09 TYPE STRING,
MDT10 TYPE STRING,
M01T1 TYPE STRING,
M01T2 TYPE STRING,
M01T3 TYPE STRING,
M01T4 TYPE STRING,
M01T5 TYPE STRING,
M03T1 TYPE STRING,
M03T2 TYPE STRING,
M03T3 TYPE STRING,
M03T4 TYPE STRING,
M03T5 TYPE STRING,
M10T1 TYPE STRING,
M10T2 TYPE STRING,
M10T3 TYPE STRING,
M10T4 TYPE STRING,
M10T5 TYPE STRING,
M20T1 TYPE STRING,
M20T2 TYPE STRING,
M20T3 TYPE STRING,
M20T4 TYPE STRING,
M20T5 TYPE STRING,
M40T1 TYPE STRING,
M40T2 TYPE STRING,
M40T3 TYPE STRING,
M40T4 TYPE STRING,
M40T5 TYPE STRING,
M40T6 TYPE STRING,
M40T7 TYPE STRING,
M40T8 TYPE STRING,
M40T9 TYPE STRING,
M40T0 TYPE STRING,
M41T1 TYPE STRING,
M41T2 TYPE STRING,
M41T3 TYPE STRING,
M41T4 TYPE STRING,
M41T5 TYPE STRING,
M02N1 TYPE STRING,
M02N2 TYPE STRING,
M02N3 TYPE STRING,
M02N4 TYPE STRING,
M02N5 TYPE STRING,
M05N1 TYPE STRING,
M05N2 TYPE STRING,
M05N3 TYPE STRING,
M05N4 TYPE STRING,
M05N5 TYPE STRING,
M10N1 TYPE STRING,
M10N2 TYPE STRING,
M10N3 TYPE STRING,
M10N4 TYPE STRING,
M10N5 TYPE STRING,
M20N1 TYPE STRING,
M20N2 TYPE STRING,
M20N3 TYPE STRING,
M20N4 TYPE STRING,
M20N5 TYPE STRING,
M16N1 TYPE STRING,
M16N2 TYPE STRING,
M16N3 TYPE STRING,
M16N4 TYPE STRING,
M16N5 TYPE STRING,
MKB01 TYPE STRING,
MKB02 TYPE STRING,
MKB03 TYPE STRING,
MKB04 TYPE STRING,
MKB05 TYPE STRING,
MKB06 TYPE STRING,
MKB07 TYPE STRING,
MKB08 TYPE STRING,
MKB09 TYPE STRING,
MKB10 TYPE STRING,
MMT01 TYPE STRING,
MMT02 TYPE STRING,
MMT03 TYPE STRING,
MMT04 TYPE STRING,
MMT05 TYPE STRING,
MAER1 TYPE STRING,
MAER2 TYPE STRING,
MAER3 TYPE STRING,
MAER4 TYPE STRING,
MAER5 TYPE STRING,
MEC01 TYPE STRING,
MEC02 TYPE STRING,
MEC03 TYPE STRING,
MEC04 TYPE STRING,
MEC05 TYPE STRING,
M04T1 TYPE STRING,
M04T2 TYPE STRING,
M04T3 TYPE STRING,
M04T4 TYPE STRING,
M04T5 TYPE STRING,
M80T1 TYPE STRING,
M80T2 TYPE STRING,
M80T3 TYPE STRING,
M80T4 TYPE STRING,
M80T5 TYPE STRING,
M200T1 TYPE STRING,
M200T2 TYPE STRING,
M200T3 TYPE STRING,
M500T1 TYPE STRING,
M500T2 TYPE STRING,
M1000T1 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_T7INPEX3_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_T7INPEX3_STR-MANDT sy-vline 
WA_T7INPEX3_STR-REGUI sy-vline 
WA_T7INPEX3_STR-SEQNM sy-vline 
WA_T7INPEX3_STR-ATIND sy-vline 
WA_T7INPEX3_STR-MDT01 sy-vline 
WA_T7INPEX3_STR-MDT02 sy-vline 
WA_T7INPEX3_STR-MDT03 sy-vline 
WA_T7INPEX3_STR-MDT04 sy-vline 
WA_T7INPEX3_STR-MDT05 sy-vline 
WA_T7INPEX3_STR-MDT06 sy-vline 
WA_T7INPEX3_STR-MDT07 sy-vline 
WA_T7INPEX3_STR-MDT08 sy-vline 
WA_T7INPEX3_STR-MDT09 sy-vline 
WA_T7INPEX3_STR-MDT10 sy-vline 
WA_T7INPEX3_STR-M01T1 sy-vline 
WA_T7INPEX3_STR-M01T2 sy-vline 
WA_T7INPEX3_STR-M01T3 sy-vline 
WA_T7INPEX3_STR-M01T4 sy-vline 
WA_T7INPEX3_STR-M01T5 sy-vline 
WA_T7INPEX3_STR-M03T1 sy-vline 
WA_T7INPEX3_STR-M03T2 sy-vline 
WA_T7INPEX3_STR-M03T3 sy-vline 
WA_T7INPEX3_STR-M03T4 sy-vline 
WA_T7INPEX3_STR-M03T5 sy-vline 
WA_T7INPEX3_STR-M10T1 sy-vline 
WA_T7INPEX3_STR-M10T2 sy-vline 
WA_T7INPEX3_STR-M10T3 sy-vline 
WA_T7INPEX3_STR-M10T4 sy-vline 
WA_T7INPEX3_STR-M10T5 sy-vline 
WA_T7INPEX3_STR-M20T1 sy-vline 
WA_T7INPEX3_STR-M20T2 sy-vline 
WA_T7INPEX3_STR-M20T3 sy-vline 
WA_T7INPEX3_STR-M20T4 sy-vline 
WA_T7INPEX3_STR-M20T5 sy-vline 
WA_T7INPEX3_STR-M40T1 sy-vline 
WA_T7INPEX3_STR-M40T2 sy-vline 
WA_T7INPEX3_STR-M40T3 sy-vline 
WA_T7INPEX3_STR-M40T4 sy-vline 
WA_T7INPEX3_STR-M40T5 sy-vline 
WA_T7INPEX3_STR-M40T6 sy-vline 
WA_T7INPEX3_STR-M40T7 sy-vline 
WA_T7INPEX3_STR-M40T8 sy-vline 
WA_T7INPEX3_STR-M40T9 sy-vline 
WA_T7INPEX3_STR-M40T0 sy-vline 
WA_T7INPEX3_STR-M41T1 sy-vline 
WA_T7INPEX3_STR-M41T2 sy-vline 
WA_T7INPEX3_STR-M41T3 sy-vline 
WA_T7INPEX3_STR-M41T4 sy-vline 
WA_T7INPEX3_STR-M41T5 sy-vline 
WA_T7INPEX3_STR-M02N1 sy-vline 
WA_T7INPEX3_STR-M02N2 sy-vline 
WA_T7INPEX3_STR-M02N3 sy-vline 
WA_T7INPEX3_STR-M02N4 sy-vline 
WA_T7INPEX3_STR-M02N5 sy-vline 
WA_T7INPEX3_STR-M05N1 sy-vline 
WA_T7INPEX3_STR-M05N2 sy-vline 
WA_T7INPEX3_STR-M05N3 sy-vline 
WA_T7INPEX3_STR-M05N4 sy-vline 
WA_T7INPEX3_STR-M05N5 sy-vline 
WA_T7INPEX3_STR-M10N1 sy-vline 
WA_T7INPEX3_STR-M10N2 sy-vline 
WA_T7INPEX3_STR-M10N3 sy-vline 
WA_T7INPEX3_STR-M10N4 sy-vline 
WA_T7INPEX3_STR-M10N5 sy-vline 
WA_T7INPEX3_STR-M20N1 sy-vline 
WA_T7INPEX3_STR-M20N2 sy-vline 
WA_T7INPEX3_STR-M20N3 sy-vline 
WA_T7INPEX3_STR-M20N4 sy-vline 
WA_T7INPEX3_STR-M20N5 sy-vline 
WA_T7INPEX3_STR-M16N1 sy-vline 
WA_T7INPEX3_STR-M16N2 sy-vline 
WA_T7INPEX3_STR-M16N3 sy-vline 
WA_T7INPEX3_STR-M16N4 sy-vline 
WA_T7INPEX3_STR-M16N5 sy-vline 
WA_T7INPEX3_STR-MKB01 sy-vline 
WA_T7INPEX3_STR-MKB02 sy-vline 
WA_T7INPEX3_STR-MKB03 sy-vline 
WA_T7INPEX3_STR-MKB04 sy-vline 
WA_T7INPEX3_STR-MKB05 sy-vline 
WA_T7INPEX3_STR-MKB06 sy-vline 
WA_T7INPEX3_STR-MKB07 sy-vline 
WA_T7INPEX3_STR-MKB08 sy-vline 
WA_T7INPEX3_STR-MKB09 sy-vline 
WA_T7INPEX3_STR-MKB10 sy-vline 
WA_T7INPEX3_STR-MMT01 sy-vline 
WA_T7INPEX3_STR-MMT02 sy-vline 
WA_T7INPEX3_STR-MMT03 sy-vline 
WA_T7INPEX3_STR-MMT04 sy-vline 
WA_T7INPEX3_STR-MMT05 sy-vline 
WA_T7INPEX3_STR-MAER1 sy-vline 
WA_T7INPEX3_STR-MAER2 sy-vline 
WA_T7INPEX3_STR-MAER3 sy-vline 
WA_T7INPEX3_STR-MAER4 sy-vline 
WA_T7INPEX3_STR-MAER5 sy-vline 
WA_T7INPEX3_STR-MEC01 sy-vline 
WA_T7INPEX3_STR-MEC02 sy-vline 
WA_T7INPEX3_STR-MEC03 sy-vline 
WA_T7INPEX3_STR-MEC04 sy-vline 
WA_T7INPEX3_STR-MEC05 sy-vline 
WA_T7INPEX3_STR-M04T1 sy-vline 
WA_T7INPEX3_STR-M04T2 sy-vline 
WA_T7INPEX3_STR-M04T3 sy-vline 
WA_T7INPEX3_STR-M04T4 sy-vline 
WA_T7INPEX3_STR-M04T5 sy-vline 
WA_T7INPEX3_STR-M80T1 sy-vline 
WA_T7INPEX3_STR-M80T2 sy-vline 
WA_T7INPEX3_STR-M80T3 sy-vline 
WA_T7INPEX3_STR-M80T4 sy-vline 
WA_T7INPEX3_STR-M80T5 sy-vline 
WA_T7INPEX3_STR-M200T1 sy-vline 
WA_T7INPEX3_STR-M200T2 sy-vline 
WA_T7INPEX3_STR-M200T3 sy-vline 
WA_T7INPEX3_STR-M500T1 sy-vline 
WA_T7INPEX3_STR-M500T2 sy-vline 
WA_T7INPEX3_STR-M1000T1 sy-vline      INTO ld_text SEPARATED BY SPACE.

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