ABAP Select data from SAP table TRDTV_DFT_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 TRDTV_DFT_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 TRDTV_DFT_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 TRDTV_DFT_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_TRDTV_DFT_ASSGN TYPE STANDARD TABLE OF TRDTV_DFT_ASSGN,
      WA_TRDTV_DFT_ASSGN TYPE TRDTV_DFT_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: <TRDTV_DFT_ASSGN> TYPE TRDTV_DFT_ASSGN.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM TRDTV_DFT_ASSGN
*  INTO TABLE @DATA(IT_TRDTV_DFT_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_TRDTV_DFT_ASSGN INDEX 1 INTO DATA(WA_TRDTV_DFT_ASSGN2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<TRDTV_DFT_ASSGN>-MANDT = 1.
<TRDTV_DFT_ASSGN>-PRODUCT_TYPE = 1.
<TRDTV_DFT_ASSGN>-LTX = 1.
<TRDTV_DFT_ASSGN>-T001 = 1.
<TRDTV_DFT_ASSGN>-T002 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_TRDTV_DFT_ASSGN-T003, sy-vline,
  WA_TRDTV_DFT_ASSGN-T004, sy-vline,
  WA_TRDTV_DFT_ASSGN-T005, sy-vline,
  WA_TRDTV_DFT_ASSGN-T006, sy-vline,
  WA_TRDTV_DFT_ASSGN-T007, sy-vline,
  WA_TRDTV_DFT_ASSGN-T008, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_TRDTV_DFT_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_TRDTV_DFT_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_TRDTV_DFT_ASSGN INTO WA_TRDTV_DFT_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_TRDTV_DFT_ASSGN_STR, 
MANDT TYPE STRING,
PRODUCT_TYPE TYPE STRING,
LTX TYPE STRING,
T001 TYPE STRING,
T002 TYPE STRING,
T003 TYPE STRING,
T004 TYPE STRING,
T005 TYPE STRING,
T006 TYPE STRING,
T007 TYPE STRING,
T008 TYPE STRING,
T009 TYPE STRING,
T010 TYPE STRING,
T011 TYPE STRING,
T012 TYPE STRING,
T013 TYPE STRING,
T014 TYPE STRING,
T015 TYPE STRING,
T016 TYPE STRING,
T017 TYPE STRING,
T018 TYPE STRING,
T019 TYPE STRING,
T020 TYPE STRING,
T021 TYPE STRING,
T022 TYPE STRING,
T023 TYPE STRING,
T024 TYPE STRING,
T025 TYPE STRING,
T026 TYPE STRING,
T027 TYPE STRING,
T028 TYPE STRING,
T029 TYPE STRING,
T030 TYPE STRING,
T031 TYPE STRING,
T032 TYPE STRING,
T033 TYPE STRING,
T034 TYPE STRING,
T035 TYPE STRING,
T036 TYPE STRING,
T037 TYPE STRING,
T038 TYPE STRING,
T039 TYPE STRING,
T040 TYPE STRING,
T041 TYPE STRING,
T042 TYPE STRING,
T043 TYPE STRING,
T044 TYPE STRING,
T045 TYPE STRING,
T046 TYPE STRING,
T047 TYPE STRING,
T048 TYPE STRING,
T049 TYPE STRING,
T050 TYPE STRING,
T051 TYPE STRING,
T052 TYPE STRING,
T053 TYPE STRING,
T054 TYPE STRING,
T055 TYPE STRING,
T056 TYPE STRING,
T057 TYPE STRING,
T058 TYPE STRING,
T061 TYPE STRING,
T062 TYPE STRING,
T063 TYPE STRING,
T064 TYPE STRING,
T065 TYPE STRING,
T066 TYPE STRING,
C001 TYPE STRING,
C002 TYPE STRING,
C003 TYPE STRING,
C004 TYPE STRING,
C005 TYPE STRING,
C006 TYPE STRING,
C007 TYPE STRING,
C008 TYPE STRING,
C009 TYPE STRING,
C010 TYPE STRING,
C011 TYPE STRING,
C012 TYPE STRING,
C013 TYPE STRING,
C014 TYPE STRING,
R005 TYPE STRING,
R006 TYPE STRING,
R007 TYPE STRING,
R008 TYPE STRING,
R009 TYPE STRING,
R010 TYPE STRING,
R013 TYPE STRING,
R014 TYPE STRING,
R015 TYPE STRING,
R016 TYPE STRING,
R017 TYPE STRING,
R018 TYPE STRING,
R019 TYPE STRING,
R020 TYPE STRING,
R021 TYPE STRING,
R022 TYPE STRING,
R023 TYPE STRING,
R024 TYPE STRING,
R025 TYPE STRING,
R026 TYPE STRING,
R027 TYPE STRING,
R028 TYPE STRING,
R029 TYPE STRING,
R030 TYPE STRING,
R033 TYPE STRING,
R034 TYPE STRING,
R035 TYPE STRING,
R036 TYPE STRING,
R037 TYPE STRING,
R038 TYPE STRING,
R039 TYPE STRING,
R040 TYPE STRING,
R041 TYPE STRING,
R042 TYPE STRING,
R047 TYPE STRING,
R048 TYPE STRING,
R053 TYPE STRING,
R054 TYPE STRING,
C015 TYPE STRING,
C016 TYPE STRING,
C017 TYPE STRING,
C018 TYPE STRING,
C019 TYPE STRING,
C020 TYPE STRING,
C021 TYPE STRING,
C022 TYPE STRING,
C023 TYPE STRING,
C024 TYPE STRING,
C025 TYPE STRING,
C026 TYPE STRING,
C027 TYPE STRING,
C028 TYPE STRING,
C029 TYPE STRING,
C030 TYPE STRING,
T070 TYPE STRING,
T071 TYPE STRING,
T072 TYPE STRING,
T073 TYPE STRING,
T074 TYPE STRING,
T075 TYPE STRING,
T076 TYPE STRING,
T077 TYPE STRING,
T078 TYPE STRING,
T079 TYPE STRING,
T080 TYPE STRING,
T081 TYPE STRING,
T082 TYPE STRING,
T083 TYPE STRING,
T084 TYPE STRING,
T085 TYPE STRING,
T106 TYPE STRING,
T107 TYPE STRING,
R106 TYPE STRING,
R107 TYPE STRING,
T086 TYPE STRING,
T087 TYPE STRING,
T088 TYPE STRING,
T089 TYPE STRING,
T090 TYPE STRING,
T091 TYPE STRING,
T092 TYPE STRING,
T093 TYPE STRING,
T094 TYPE STRING,
T095 TYPE STRING,
T096 TYPE STRING,
T097 TYPE STRING,
T098 TYPE STRING,
T099 TYPE STRING,
T100 TYPE STRING,
T101 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_TRDTV_DFT_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_TRDTV_DFT_ASSGN_STR-MANDT sy-vline 
WA_TRDTV_DFT_ASSGN_STR-PRODUCT_TYPE sy-vline 
WA_TRDTV_DFT_ASSGN_STR-LTX sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T001 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T002 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T003 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T004 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T005 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T006 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T007 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T008 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T009 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T010 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T011 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T012 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T013 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T014 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T015 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T016 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T017 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T018 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T019 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T020 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T021 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T022 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T023 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T024 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T025 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T026 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T027 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T028 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T029 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T030 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T031 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T032 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T033 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T034 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T035 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T036 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T037 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T038 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T039 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T040 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T041 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T042 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T043 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T044 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T045 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T046 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T047 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T048 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T049 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T050 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T051 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T052 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T053 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T054 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T055 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T056 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T057 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T058 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T061 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T062 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T063 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T064 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T065 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T066 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C001 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C002 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C003 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C004 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C005 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C006 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C007 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C008 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C009 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C010 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C011 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C012 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C013 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C014 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R005 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R006 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R007 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R008 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R009 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R010 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R013 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R014 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R015 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R016 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R017 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R018 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R019 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R020 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R021 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R022 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R023 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R024 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R025 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R026 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R027 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R028 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R029 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R030 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R033 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R034 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R035 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R036 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R037 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R038 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R039 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R040 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R041 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R042 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R047 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R048 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R053 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R054 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C015 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C016 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C017 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C018 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C019 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C020 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C021 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C022 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C023 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C024 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C025 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C026 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C027 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C028 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C029 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-C030 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T070 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T071 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T072 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T073 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T074 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T075 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T076 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T077 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T078 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T079 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T080 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T081 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T082 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T083 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T084 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T085 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T106 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T107 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R106 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-R107 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T086 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T087 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T088 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T089 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T090 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T091 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T092 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T093 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T094 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T095 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T096 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T097 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T098 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T099 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T100 sy-vline 
WA_TRDTV_DFT_ASSGN_STR-T101 sy-vline      INTO ld_text SEPARATED BY SPACE.

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