ABAP Select data from SAP table TRLC_DFT_ASSGN_E 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_DFT_ASSGN_E 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_DFT_ASSGN_E. 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_DFT_ASSGN_E 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_DFT_ASSGN_E TYPE STANDARD TABLE OF TRLC_DFT_ASSGN_E,
      WA_TRLC_DFT_ASSGN_E TYPE TRLC_DFT_ASSGN_E,
      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_DFT_ASSGN_E> TYPE TRLC_DFT_ASSGN_E.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM TRLC_DFT_ASSGN_E
*  INTO TABLE @DATA(IT_TRLC_DFT_ASSGN_E2).
*--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_DFT_ASSGN_E INDEX 1 INTO DATA(WA_TRLC_DFT_ASSGN_E2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<TRLC_DFT_ASSGN_E>-MANDT = 1.
<TRLC_DFT_ASSGN_E>-POS_MAN_PROC = 1.
<TRLC_DFT_ASSGN_E>-E001 = 1.
<TRLC_DFT_ASSGN_E>-E002 = 1.
<TRLC_DFT_ASSGN_E>-E003 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_TRLC_DFT_ASSGN_E-E004, sy-vline,
  WA_TRLC_DFT_ASSGN_E-E005, sy-vline,
  WA_TRLC_DFT_ASSGN_E-E006, sy-vline,
  WA_TRLC_DFT_ASSGN_E-E007, sy-vline,
  WA_TRLC_DFT_ASSGN_E-E008, sy-vline,
  WA_TRLC_DFT_ASSGN_E-E009, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_TRLC_DFT_ASSGN_E 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_DFT_ASSGN_E 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_DFT_ASSGN_E INTO WA_TRLC_DFT_ASSGN_E.


*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_DFT_ASSGN_E_STR, 
MANDT TYPE STRING,
POS_MAN_PROC TYPE STRING,
E001 TYPE STRING,
E002 TYPE STRING,
E003 TYPE STRING,
E004 TYPE STRING,
E005 TYPE STRING,
E006 TYPE STRING,
E007 TYPE STRING,
E008 TYPE STRING,
E009 TYPE STRING,
E010 TYPE STRING,
E011 TYPE STRING,
E012 TYPE STRING,
E013 TYPE STRING,
E014 TYPE STRING,
E015 TYPE STRING,
E016 TYPE STRING,
E017 TYPE STRING,
E018 TYPE STRING,
E019 TYPE STRING,
E020 TYPE STRING,
E021 TYPE STRING,
E022 TYPE STRING,
E023 TYPE STRING,
E024 TYPE STRING,
E025 TYPE STRING,
E026 TYPE STRING,
E027 TYPE STRING,
E028 TYPE STRING,
E029 TYPE STRING,
E030 TYPE STRING,
E031 TYPE STRING,
E032 TYPE STRING,
E033 TYPE STRING,
E034 TYPE STRING,
E035 TYPE STRING,
E036 TYPE STRING,
E037 TYPE STRING,
E038 TYPE STRING,
E039 TYPE STRING,
E040 TYPE STRING,
E041 TYPE STRING,
E042 TYPE STRING,
E043 TYPE STRING,
E044 TYPE STRING,
E045 TYPE STRING,
E046 TYPE STRING,
E047 TYPE STRING,
E048 TYPE STRING,
E049 TYPE STRING,
E050 TYPE STRING,
E051 TYPE STRING,
E052 TYPE STRING,
E053 TYPE STRING,
E054 TYPE STRING,
E055 TYPE STRING,
E056 TYPE STRING,
E057 TYPE STRING,
E058 TYPE STRING,
E059 TYPE STRING,
E060 TYPE STRING,
E061 TYPE STRING,
E062 TYPE STRING,
E063 TYPE STRING,
E064 TYPE STRING,
E065 TYPE STRING,
E066 TYPE STRING,
E067 TYPE STRING,
E068 TYPE STRING,
E069 TYPE STRING,
E070 TYPE STRING,
E071 TYPE STRING,
E072 TYPE STRING,
E073 TYPE STRING,
E074 TYPE STRING,
E075 TYPE STRING,
E076 TYPE STRING,
E077 TYPE STRING,
E078 TYPE STRING,
E079 TYPE STRING,
E080 TYPE STRING,
E081 TYPE STRING,
E082 TYPE STRING,
E083 TYPE STRING,
E084 TYPE STRING,
E085 TYPE STRING,
E086 TYPE STRING,
E087 TYPE STRING,
E088 TYPE STRING,
E089 TYPE STRING,
E090 TYPE STRING,
E091 TYPE STRING,
E092 TYPE STRING,
E093 TYPE STRING,
E094 TYPE STRING,
E101 TYPE STRING,
E102 TYPE STRING,
E103 TYPE STRING,
E104 TYPE STRING,
E105 TYPE STRING,
E106 TYPE STRING,
E135 TYPE STRING,
E136 TYPE STRING,
E137 TYPE STRING,
E138 TYPE STRING,
E139 TYPE STRING,
E140 TYPE STRING,
E141 TYPE STRING,
E142 TYPE STRING,
E200 TYPE STRING,
E201 TYPE STRING,
E202 TYPE STRING,
E203 TYPE STRING,
E204 TYPE STRING,
E205 TYPE STRING,
E206 TYPE STRING,
E207 TYPE STRING,
E208 TYPE STRING,
E209 TYPE STRING,
E210 TYPE STRING,
E211 TYPE STRING,
E212 TYPE STRING,
E213 TYPE STRING,
E214 TYPE STRING,
E215 TYPE STRING,
E216 TYPE STRING,
E217 TYPE STRING,
E218 TYPE STRING,
E219 TYPE STRING,
E220 TYPE STRING,
E221 TYPE STRING,
E097 TYPE STRING,
E098 TYPE STRING,
E301 TYPE STRING,
E302 TYPE STRING,
E303 TYPE STRING,
E304 TYPE STRING,
E311 TYPE STRING,
E312 TYPE STRING,
E313 TYPE STRING,
E314 TYPE STRING,
E401 TYPE STRING,
E402 TYPE STRING,
E403 TYPE STRING,
E404 TYPE STRING,
E405 TYPE STRING,
E406 TYPE STRING,
E165 TYPE STRING,
E166 TYPE STRING,
E150 TYPE STRING,
E151 TYPE STRING,
E152 TYPE STRING,
E153 TYPE STRING,
E222 TYPE STRING,
E223 TYPE STRING,
E224 TYPE STRING,
E225 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_TRLC_DFT_ASSGN_E_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_DFT_ASSGN_E_STR-MANDT sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-POS_MAN_PROC sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E001 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E002 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E003 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E004 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E005 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E006 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E007 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E008 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E009 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E010 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E011 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E012 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E013 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E014 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E015 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E016 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E017 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E018 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E019 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E020 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E021 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E022 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E023 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E024 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E025 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E026 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E027 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E028 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E029 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E030 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E031 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E032 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E033 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E034 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E035 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E036 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E037 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E038 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E039 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E040 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E041 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E042 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E043 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E044 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E045 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E046 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E047 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E048 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E049 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E050 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E051 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E052 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E053 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E054 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E055 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E056 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E057 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E058 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E059 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E060 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E061 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E062 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E063 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E064 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E065 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E066 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E067 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E068 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E069 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E070 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E071 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E072 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E073 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E074 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E075 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E076 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E077 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E078 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E079 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E080 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E081 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E082 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E083 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E084 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E085 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E086 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E087 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E088 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E089 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E090 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E091 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E092 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E093 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E094 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E101 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E102 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E103 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E104 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E105 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E106 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E135 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E136 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E137 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E138 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E139 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E140 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E141 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E142 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E200 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E201 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E202 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E203 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E204 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E205 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E206 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E207 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E208 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E209 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E210 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E211 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E212 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E213 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E214 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E215 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E216 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E217 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E218 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E219 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E220 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E221 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E097 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E098 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E301 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E302 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E303 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E304 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E311 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E312 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E313 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E314 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E401 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E402 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E403 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E404 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E405 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E406 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E165 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E166 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E150 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E151 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E152 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E153 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E222 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E223 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E224 sy-vline 
WA_TRLC_DFT_ASSGN_E_STR-E225 sy-vline      INTO ld_text SEPARATED BY SPACE.

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