ABAP Select data from SAP table TRLC_IFT_ASSGN 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 TRLC_IFT_ASSGN 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 TRLC_IFT_ASSGN. 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 TRLC_IFT_ASSGN 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_TRLC_IFT_ASSGN TYPE STANDARD TABLE OF TRLC_IFT_ASSGN,
      WA_TRLC_IFT_ASSGN TYPE TRLC_IFT_ASSGN,
      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: <TRLC_IFT_ASSGN> TYPE TRLC_IFT_ASSGN.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM TRLC_IFT_ASSGN
*  INTO TABLE @DATA(IT_TRLC_IFT_ASSGN2).
*--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_TRLC_IFT_ASSGN INDEX 1 INTO DATA(WA_TRLC_IFT_ASSGN2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<TRLC_IFT_ASSGN>-MANDT = 1.
<TRLC_IFT_ASSGN>-PRODUCT_TYPE = 1.
<TRLC_IFT_ASSGN>-I001 = 1.
<TRLC_IFT_ASSGN>-I002 = 1.
<TRLC_IFT_ASSGN>-I003 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_TRLC_IFT_ASSGN-I004, sy-vline,
  WA_TRLC_IFT_ASSGN-I005, sy-vline,
  WA_TRLC_IFT_ASSGN-I006, sy-vline,
  WA_TRLC_IFT_ASSGN-I007, sy-vline,
  WA_TRLC_IFT_ASSGN-I008, sy-vline,
  WA_TRLC_IFT_ASSGN-I009, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_TRLC_IFT_ASSGN 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_TRLC_IFT_ASSGN 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_TRLC_IFT_ASSGN INTO WA_TRLC_IFT_ASSGN.


*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_TRLC_IFT_ASSGN_STR, 
MANDT TYPE STRING,
PRODUCT_TYPE TYPE STRING,
I001 TYPE STRING,
I002 TYPE STRING,
I003 TYPE STRING,
I004 TYPE STRING,
I005 TYPE STRING,
I006 TYPE STRING,
I007 TYPE STRING,
I008 TYPE STRING,
I009 TYPE STRING,
I010 TYPE STRING,
I011 TYPE STRING,
I012 TYPE STRING,
I013 TYPE STRING,
I014 TYPE STRING,
I015 TYPE STRING,
I016 TYPE STRING,
I017 TYPE STRING,
I018 TYPE STRING,
I019 TYPE STRING,
I020 TYPE STRING,
I021 TYPE STRING,
I022 TYPE STRING,
I023 TYPE STRING,
I024 TYPE STRING,
I025 TYPE STRING,
I026 TYPE STRING,
I027 TYPE STRING,
I028 TYPE STRING,
I029 TYPE STRING,
I030 TYPE STRING,
I031 TYPE STRING,
I032 TYPE STRING,
I033 TYPE STRING,
I034 TYPE STRING,
I035 TYPE STRING,
I036 TYPE STRING,
I037 TYPE STRING,
I038 TYPE STRING,
I039 TYPE STRING,
I040 TYPE STRING,
I041 TYPE STRING,
I042 TYPE STRING,
I043 TYPE STRING,
I044 TYPE STRING,
I045 TYPE STRING,
I046 TYPE STRING,
I047 TYPE STRING,
I048 TYPE STRING,
I049 TYPE STRING,
I050 TYPE STRING,
I051 TYPE STRING,
I052 TYPE STRING,
I053 TYPE STRING,
I054 TYPE STRING,
I055 TYPE STRING,
I056 TYPE STRING,
I057 TYPE STRING,
I058 TYPE STRING,
I059 TYPE STRING,
I060 TYPE STRING,
I061 TYPE STRING,
I062 TYPE STRING,
I063 TYPE STRING,
I064 TYPE STRING,
I065 TYPE STRING,
I066 TYPE STRING,
M001 TYPE STRING,
M002 TYPE STRING,
M003 TYPE STRING,
M004 TYPE STRING,
M005 TYPE STRING,
M006 TYPE STRING,
M007 TYPE STRING,
M008 TYPE STRING,
M009 TYPE STRING,
M010 TYPE STRING,
M011 TYPE STRING,
M012 TYPE STRING,
M013 TYPE STRING,
M014 TYPE STRING,
M015 TYPE STRING,
M016 TYPE STRING,
M017 TYPE STRING,
M018 TYPE STRING,
M019 TYPE STRING,
M020 TYPE STRING,
M021 TYPE STRING,
M022 TYPE STRING,
M023 TYPE STRING,
M024 TYPE STRING,
M025 TYPE STRING,
M026 TYPE STRING,
M027 TYPE STRING,
M028 TYPE STRING,
M029 TYPE STRING,
M030 TYPE STRING,
M031 TYPE STRING,
M032 TYPE STRING,
M033 TYPE STRING,
M034 TYPE STRING,
M035 TYPE STRING,
M036 TYPE STRING,
M037 TYPE STRING,
M038 TYPE STRING,
M039 TYPE STRING,
M040 TYPE STRING,
M041 TYPE STRING,
M042 TYPE STRING,
M043 TYPE STRING,
M044 TYPE STRING,
M045 TYPE STRING,
M046 TYPE STRING,
M047 TYPE STRING,
M048 TYPE STRING,
M049 TYPE STRING,
M050 TYPE STRING,
I070 TYPE STRING,
I071 TYPE STRING,
I072 TYPE STRING,
I073 TYPE STRING,
I074 TYPE STRING,
I075 TYPE STRING,
I076 TYPE STRING,
I077 TYPE STRING,
I078 TYPE STRING,
I079 TYPE STRING,
I080 TYPE STRING,
I081 TYPE STRING,
I082 TYPE STRING,
I083 TYPE STRING,
I084 TYPE STRING,
I085 TYPE STRING,
I086 TYPE STRING,
I087 TYPE STRING,
I088 TYPE STRING,
I089 TYPE STRING,
I090 TYPE STRING,
I091 TYPE STRING,
I092 TYPE STRING,
I093 TYPE STRING,
I094 TYPE STRING,
I095 TYPE STRING,
I096 TYPE STRING,
I097 TYPE STRING,
I098 TYPE STRING,
I099 TYPE STRING,
I100 TYPE STRING,
I101 TYPE STRING,
I102 TYPE STRING,
I103 TYPE STRING,
I104 TYPE STRING,
I105 TYPE STRING,
H001 TYPE STRING,
H002 TYPE STRING,
H003 TYPE STRING,
H004 TYPE STRING,
H005 TYPE STRING,
H006 TYPE STRING,
H007 TYPE STRING,
H008 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_TRLC_IFT_ASSGN_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_TRLC_IFT_ASSGN_STR-MANDT sy-vline 
WA_TRLC_IFT_ASSGN_STR-PRODUCT_TYPE sy-vline 
WA_TRLC_IFT_ASSGN_STR-I001 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I002 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I003 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I004 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I005 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I006 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I007 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I008 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I009 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I010 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I011 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I012 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I013 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I014 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I015 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I016 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I017 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I018 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I019 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I020 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I021 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I022 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I023 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I024 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I025 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I026 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I027 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I028 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I029 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I030 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I031 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I032 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I033 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I034 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I035 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I036 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I037 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I038 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I039 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I040 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I041 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I042 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I043 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I044 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I045 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I046 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I047 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I048 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I049 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I050 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I051 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I052 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I053 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I054 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I055 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I056 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I057 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I058 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I059 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I060 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I061 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I062 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I063 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I064 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I065 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I066 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M001 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M002 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M003 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M004 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M005 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M006 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M007 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M008 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M009 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M010 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M011 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M012 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M013 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M014 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M015 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M016 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M017 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M018 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M019 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M020 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M021 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M022 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M023 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M024 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M025 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M026 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M027 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M028 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M029 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M030 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M031 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M032 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M033 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M034 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M035 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M036 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M037 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M038 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M039 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M040 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M041 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M042 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M043 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M044 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M045 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M046 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M047 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M048 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M049 sy-vline 
WA_TRLC_IFT_ASSGN_STR-M050 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I070 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I071 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I072 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I073 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I074 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I075 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I076 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I077 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I078 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I079 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I080 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I081 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I082 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I083 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I084 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I085 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I086 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I087 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I088 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I089 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I090 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I091 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I092 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I093 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I094 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I095 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I096 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I097 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I098 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I099 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I100 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I101 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I102 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I103 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I104 sy-vline 
WA_TRLC_IFT_ASSGN_STR-I105 sy-vline 
WA_TRLC_IFT_ASSGN_STR-H001 sy-vline 
WA_TRLC_IFT_ASSGN_STR-H002 sy-vline 
WA_TRLC_IFT_ASSGN_STR-H003 sy-vline 
WA_TRLC_IFT_ASSGN_STR-H004 sy-vline 
WA_TRLC_IFT_ASSGN_STR-H005 sy-vline 
WA_TRLC_IFT_ASSGN_STR-H006 sy-vline 
WA_TRLC_IFT_ASSGN_STR-H007 sy-vline 
WA_TRLC_IFT_ASSGN_STR-H008 sy-vline      INTO ld_text SEPARATED BY SPACE.

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