ABAP Select data from SAP table TRLV_DFT_ASSIGNN 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 TRLV_DFT_ASSIGNN 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 TRLV_DFT_ASSIGNN. 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 TRLV_DFT_ASSIGNN 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_TRLV_DFT_ASSIGNN TYPE STANDARD TABLE OF TRLV_DFT_ASSIGNN,
      WA_TRLV_DFT_ASSIGNN TYPE TRLV_DFT_ASSIGNN,
      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: <TRLV_DFT_ASSIGNN> TYPE TRLV_DFT_ASSIGNN.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM TRLV_DFT_ASSIGNN
*  INTO TABLE @DATA(IT_TRLV_DFT_ASSIGNN2).
*--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_TRLV_DFT_ASSIGNN INDEX 1 INTO DATA(WA_TRLV_DFT_ASSIGNN2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<TRLV_DFT_ASSIGNN>-MANDT = 1.
<TRLV_DFT_ASSIGNN>-POS_MAN_PROC = 1.
<TRLV_DFT_ASSIGNN>-N001 = 1.
<TRLV_DFT_ASSIGNN>-N002 = 1.
<TRLV_DFT_ASSIGNN>-N003 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_TRLV_DFT_ASSIGNN-N004, sy-vline,
  WA_TRLV_DFT_ASSIGNN-N005, sy-vline,
  WA_TRLV_DFT_ASSIGNN-N006, sy-vline,
  WA_TRLV_DFT_ASSIGNN-N007, sy-vline,
  WA_TRLV_DFT_ASSIGNN-N008, sy-vline,
  WA_TRLV_DFT_ASSIGNN-N009, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_TRLV_DFT_ASSIGNN 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_TRLV_DFT_ASSIGNN 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_TRLV_DFT_ASSIGNN INTO WA_TRLV_DFT_ASSIGNN.


*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_TRLV_DFT_ASSIGNN_STR, 
MANDT TYPE STRING,
POS_MAN_PROC TYPE STRING,
N001 TYPE STRING,
N002 TYPE STRING,
N003 TYPE STRING,
N004 TYPE STRING,
N005 TYPE STRING,
N006 TYPE STRING,
N007 TYPE STRING,
N008 TYPE STRING,
N009 TYPE STRING,
N010 TYPE STRING,
N011 TYPE STRING,
N012 TYPE STRING,
N013 TYPE STRING,
N014 TYPE STRING,
N015 TYPE STRING,
N016 TYPE STRING,
N017 TYPE STRING,
N018 TYPE STRING,
N019 TYPE STRING,
N020 TYPE STRING,
N021 TYPE STRING,
N022 TYPE STRING,
N023 TYPE STRING,
N024 TYPE STRING,
N025 TYPE STRING,
N026 TYPE STRING,
N027 TYPE STRING,
N028 TYPE STRING,
N029 TYPE STRING,
N030 TYPE STRING,
N031 TYPE STRING,
N032 TYPE STRING,
N033 TYPE STRING,
N034 TYPE STRING,
N035 TYPE STRING,
N036 TYPE STRING,
N037 TYPE STRING,
N038 TYPE STRING,
N039 TYPE STRING,
N040 TYPE STRING,
N041 TYPE STRING,
N042 TYPE STRING,
N043 TYPE STRING,
N044 TYPE STRING,
N045 TYPE STRING,
N046 TYPE STRING,
N047 TYPE STRING,
N048 TYPE STRING,
N049 TYPE STRING,
N050 TYPE STRING,
N051 TYPE STRING,
N052 TYPE STRING,
N053 TYPE STRING,
N054 TYPE STRING,
N055 TYPE STRING,
N056 TYPE STRING,
N057 TYPE STRING,
N058 TYPE STRING,
N059 TYPE STRING,
N060 TYPE STRING,
N061 TYPE STRING,
N062 TYPE STRING,
N063 TYPE STRING,
N064 TYPE STRING,
N065 TYPE STRING,
N066 TYPE STRING,
N067 TYPE STRING,
N068 TYPE STRING,
N069 TYPE STRING,
N070 TYPE STRING,
N071 TYPE STRING,
N072 TYPE STRING,
N073 TYPE STRING,
N074 TYPE STRING,
N075 TYPE STRING,
N076 TYPE STRING,
N077 TYPE STRING,
N078 TYPE STRING,
N079 TYPE STRING,
N080 TYPE STRING,
N081 TYPE STRING,
N082 TYPE STRING,
N083 TYPE STRING,
N084 TYPE STRING,
N085 TYPE STRING,
N086 TYPE STRING,
N087 TYPE STRING,
N088 TYPE STRING,
N089 TYPE STRING,
N090 TYPE STRING,
N091 TYPE STRING,
N092 TYPE STRING,
N093 TYPE STRING,
N094 TYPE STRING,
N095 TYPE STRING,
N096 TYPE STRING,
N097 TYPE STRING,
N098 TYPE STRING,
N099 TYPE STRING,
N100 TYPE STRING,
N101 TYPE STRING,
N102 TYPE STRING,
N103 TYPE STRING,
N104 TYPE STRING,
N105 TYPE STRING,
N106 TYPE STRING,
N107 TYPE STRING,
N108 TYPE STRING,
N109 TYPE STRING,
N110 TYPE STRING,
N111 TYPE STRING,
N112 TYPE STRING,
N113 TYPE STRING,
N114 TYPE STRING,
N115 TYPE STRING,
N116 TYPE STRING,
N117 TYPE STRING,
N118 TYPE STRING,
N119 TYPE STRING,
N120 TYPE STRING,
N121 TYPE STRING,
N122 TYPE STRING,
N123 TYPE STRING,
N124 TYPE STRING,
N125 TYPE STRING,
N126 TYPE STRING,
N127 TYPE STRING,
N128 TYPE STRING,
N129 TYPE STRING,
N130 TYPE STRING,
N131 TYPE STRING,
N132 TYPE STRING,
N133 TYPE STRING,
N134 TYPE STRING,
N135 TYPE STRING,
N136 TYPE STRING,
N137 TYPE STRING,
N138 TYPE STRING,
N139 TYPE STRING,
N140 TYPE STRING,
N141 TYPE STRING,
N142 TYPE STRING,
N143 TYPE STRING,
N144 TYPE STRING,
N145 TYPE STRING,
N146 TYPE STRING,
N147 TYPE STRING,
N148 TYPE STRING,
N149 TYPE STRING,
N150 TYPE STRING,
N151 TYPE STRING,
N152 TYPE STRING,
N153 TYPE STRING,
N154 TYPE STRING,
N155 TYPE STRING,
N156 TYPE STRING,
N157 TYPE STRING,
N158 TYPE STRING,
N159 TYPE STRING,
N160 TYPE STRING,
N161 TYPE STRING,
N162 TYPE STRING,
N163 TYPE STRING,
N164 TYPE STRING,
N165 TYPE STRING,
N166 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_TRLV_DFT_ASSIGNN_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_TRLV_DFT_ASSIGNN_STR-MANDT sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-POS_MAN_PROC sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N001 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N002 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N003 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N004 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N005 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N006 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N007 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N008 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N009 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N010 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N011 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N012 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N013 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N014 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N015 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N016 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N017 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N018 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N019 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N020 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N021 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N022 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N023 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N024 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N025 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N026 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N027 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N028 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N029 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N030 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N031 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N032 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N033 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N034 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N035 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N036 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N037 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N038 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N039 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N040 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N041 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N042 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N043 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N044 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N045 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N046 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N047 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N048 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N049 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N050 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N051 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N052 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N053 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N054 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N055 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N056 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N057 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N058 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N059 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N060 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N061 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N062 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N063 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N064 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N065 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N066 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N067 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N068 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N069 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N070 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N071 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N072 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N073 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N074 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N075 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N076 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N077 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N078 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N079 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N080 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N081 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N082 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N083 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N084 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N085 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N086 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N087 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N088 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N089 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N090 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N091 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N092 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N093 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N094 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N095 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N096 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N097 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N098 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N099 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N100 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N101 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N102 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N103 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N104 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N105 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N106 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N107 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N108 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N109 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N110 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N111 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N112 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N113 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N114 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N115 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N116 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N117 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N118 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N119 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N120 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N121 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N122 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N123 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N124 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N125 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N126 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N127 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N128 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N129 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N130 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N131 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N132 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N133 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N134 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N135 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N136 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N137 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N138 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N139 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N140 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N141 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N142 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N143 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N144 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N145 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N146 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N147 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N148 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N149 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N150 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N151 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N152 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N153 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N154 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N155 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N156 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N157 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N158 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N159 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N160 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N161 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N162 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N163 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N164 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N165 sy-vline 
WA_TRLV_DFT_ASSIGNN_STR-N166 sy-vline      INTO ld_text SEPARATED BY SPACE.

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