ABAP Select data from SAP table TRLC_DFT_ASSGN_G 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_G 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_G. 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_G 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_G TYPE STANDARD TABLE OF TRLC_DFT_ASSGN_G,
      WA_TRLC_DFT_ASSGN_G TYPE TRLC_DFT_ASSGN_G,
      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_G> TYPE TRLC_DFT_ASSGN_G.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM TRLC_DFT_ASSGN_G
*  INTO TABLE @DATA(IT_TRLC_DFT_ASSGN_G2).
*--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_G INDEX 1 INTO DATA(WA_TRLC_DFT_ASSGN_G2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<TRLC_DFT_ASSGN_G>-MANDT = 1.
<TRLC_DFT_ASSGN_G>-POS_MAN_PROC = 1.
<TRLC_DFT_ASSGN_G>-G001 = 1.
<TRLC_DFT_ASSGN_G>-G002 = 1.
<TRLC_DFT_ASSGN_G>-G003 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_TRLC_DFT_ASSGN_G-G004, sy-vline,
  WA_TRLC_DFT_ASSGN_G-G005, sy-vline,
  WA_TRLC_DFT_ASSGN_G-G006, sy-vline,
  WA_TRLC_DFT_ASSGN_G-G007, sy-vline,
  WA_TRLC_DFT_ASSGN_G-G008, sy-vline,
  WA_TRLC_DFT_ASSGN_G-G009, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_TRLC_DFT_ASSGN_G 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_G 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_G INTO WA_TRLC_DFT_ASSGN_G.


*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_G_STR, 
MANDT TYPE STRING,
POS_MAN_PROC TYPE STRING,
G001 TYPE STRING,
G002 TYPE STRING,
G003 TYPE STRING,
G004 TYPE STRING,
G005 TYPE STRING,
G006 TYPE STRING,
G007 TYPE STRING,
G008 TYPE STRING,
G009 TYPE STRING,
G010 TYPE STRING,
G011 TYPE STRING,
G012 TYPE STRING,
G013 TYPE STRING,
G014 TYPE STRING,
G015 TYPE STRING,
G016 TYPE STRING,
G017 TYPE STRING,
G018 TYPE STRING,
G019 TYPE STRING,
G020 TYPE STRING,
G021 TYPE STRING,
G022 TYPE STRING,
G023 TYPE STRING,
G024 TYPE STRING,
G025 TYPE STRING,
G026 TYPE STRING,
G027 TYPE STRING,
G028 TYPE STRING,
G029 TYPE STRING,
G030 TYPE STRING,
G031 TYPE STRING,
G032 TYPE STRING,
G033 TYPE STRING,
G034 TYPE STRING,
G035 TYPE STRING,
G036 TYPE STRING,
G037 TYPE STRING,
G038 TYPE STRING,
G039 TYPE STRING,
G040 TYPE STRING,
G041 TYPE STRING,
G042 TYPE STRING,
G043 TYPE STRING,
G044 TYPE STRING,
G045 TYPE STRING,
G046 TYPE STRING,
G047 TYPE STRING,
G048 TYPE STRING,
G049 TYPE STRING,
G050 TYPE STRING,
G051 TYPE STRING,
G052 TYPE STRING,
G053 TYPE STRING,
G054 TYPE STRING,
G055 TYPE STRING,
G056 TYPE STRING,
G057 TYPE STRING,
G058 TYPE STRING,
G059 TYPE STRING,
G060 TYPE STRING,
G061 TYPE STRING,
G062 TYPE STRING,
G063 TYPE STRING,
G064 TYPE STRING,
G065 TYPE STRING,
G066 TYPE STRING,
G067 TYPE STRING,
G068 TYPE STRING,
G069 TYPE STRING,
G070 TYPE STRING,
G071 TYPE STRING,
G072 TYPE STRING,
G073 TYPE STRING,
G074 TYPE STRING,
G075 TYPE STRING,
G076 TYPE STRING,
G077 TYPE STRING,
G078 TYPE STRING,
G079 TYPE STRING,
G080 TYPE STRING,
G081 TYPE STRING,
G082 TYPE STRING,
G083 TYPE STRING,
G084 TYPE STRING,
G085 TYPE STRING,
G086 TYPE STRING,
G087 TYPE STRING,
G088 TYPE STRING,
G089 TYPE STRING,
G090 TYPE STRING,
G091 TYPE STRING,
G092 TYPE STRING,
G093 TYPE STRING,
G094 TYPE STRING,
G095 TYPE STRING,
G096 TYPE STRING,
G097 TYPE STRING,
G098 TYPE STRING,
G099 TYPE STRING,
G100 TYPE STRING,
G101 TYPE STRING,
G102 TYPE STRING,
G103 TYPE STRING,
G104 TYPE STRING,
G105 TYPE STRING,
G106 TYPE STRING,
G107 TYPE STRING,
G108 TYPE STRING,
G109 TYPE STRING,
G110 TYPE STRING,
G111 TYPE STRING,
G112 TYPE STRING,
G113 TYPE STRING,
G114 TYPE STRING,
G115 TYPE STRING,
G116 TYPE STRING,
G117 TYPE STRING,
G118 TYPE STRING,
G119 TYPE STRING,
G120 TYPE STRING,
G121 TYPE STRING,
G122 TYPE STRING,
G181 TYPE STRING,
G182 TYPE STRING,
G183 TYPE STRING,
G184 TYPE STRING,
G185 TYPE STRING,
G186 TYPE STRING,
G187 TYPE STRING,
G188 TYPE STRING,
G191 TYPE STRING,
G192 TYPE STRING,
G193 TYPE STRING,
G194 TYPE STRING,
G195 TYPE STRING,
G196 TYPE STRING,
G197 TYPE STRING,
G198 TYPE STRING,
G201 TYPE STRING,
G202 TYPE STRING,
G203 TYPE STRING,
G204 TYPE STRING,
G205 TYPE STRING,
G206 TYPE STRING,
G207 TYPE STRING,
G208 TYPE STRING,
G209 TYPE STRING,
G210 TYPE STRING,
G211 TYPE STRING,
G212 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_TRLC_DFT_ASSGN_G_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_G_STR-MANDT sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-POS_MAN_PROC sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G001 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G002 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G003 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G004 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G005 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G006 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G007 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G008 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G009 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G010 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G011 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G012 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G013 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G014 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G015 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G016 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G017 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G018 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G019 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G020 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G021 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G022 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G023 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G024 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G025 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G026 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G027 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G028 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G029 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G030 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G031 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G032 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G033 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G034 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G035 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G036 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G037 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G038 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G039 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G040 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G041 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G042 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G043 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G044 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G045 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G046 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G047 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G048 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G049 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G050 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G051 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G052 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G053 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G054 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G055 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G056 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G057 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G058 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G059 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G060 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G061 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G062 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G063 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G064 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G065 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G066 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G067 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G068 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G069 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G070 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G071 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G072 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G073 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G074 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G075 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G076 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G077 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G078 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G079 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G080 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G081 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G082 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G083 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G084 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G085 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G086 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G087 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G088 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G089 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G090 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G091 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G092 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G093 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G094 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G095 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G096 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G097 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G098 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G099 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G100 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G101 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G102 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G103 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G104 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G105 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G106 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G107 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G108 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G109 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G110 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G111 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G112 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G113 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G114 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G115 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G116 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G117 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G118 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G119 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G120 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G121 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G122 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G181 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G182 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G183 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G184 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G185 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G186 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G187 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G188 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G191 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G192 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G193 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G194 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G195 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G196 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G197 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G198 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G201 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G202 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G203 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G204 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G205 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G206 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G207 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G208 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G209 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G210 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G211 sy-vline 
WA_TRLC_DFT_ASSGN_G_STR-G212 sy-vline      INTO ld_text SEPARATED BY SPACE.

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