ABAP Select data from SAP table TRLV_DFT_ASSIGNJ 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_ASSIGNJ 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_ASSIGNJ. 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_ASSIGNJ 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_ASSIGNJ TYPE STANDARD TABLE OF TRLV_DFT_ASSIGNJ,
      WA_TRLV_DFT_ASSIGNJ TYPE TRLV_DFT_ASSIGNJ,
      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_ASSIGNJ> TYPE TRLV_DFT_ASSIGNJ.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM TRLV_DFT_ASSIGNJ
*  INTO TABLE @DATA(IT_TRLV_DFT_ASSIGNJ2).
*--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_ASSIGNJ INDEX 1 INTO DATA(WA_TRLV_DFT_ASSIGNJ2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<TRLV_DFT_ASSIGNJ>-MANDT = 1.
<TRLV_DFT_ASSIGNJ>-POS_MAN_PROC = 1.
<TRLV_DFT_ASSIGNJ>-J001 = 1.
<TRLV_DFT_ASSIGNJ>-J002 = 1.
<TRLV_DFT_ASSIGNJ>-J003 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_TRLV_DFT_ASSIGNJ-J004, sy-vline,
  WA_TRLV_DFT_ASSIGNJ-J005, sy-vline,
  WA_TRLV_DFT_ASSIGNJ-J006, sy-vline,
  WA_TRLV_DFT_ASSIGNJ-J007, sy-vline,
  WA_TRLV_DFT_ASSIGNJ-J008, sy-vline,
  WA_TRLV_DFT_ASSIGNJ-J009, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_TRLV_DFT_ASSIGNJ 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_ASSIGNJ 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_ASSIGNJ INTO WA_TRLV_DFT_ASSIGNJ.


*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_ASSIGNJ_STR, 
MANDT TYPE STRING,
POS_MAN_PROC TYPE STRING,
J001 TYPE STRING,
J002 TYPE STRING,
J003 TYPE STRING,
J004 TYPE STRING,
J005 TYPE STRING,
J006 TYPE STRING,
J007 TYPE STRING,
J008 TYPE STRING,
J009 TYPE STRING,
J010 TYPE STRING,
J011 TYPE STRING,
J012 TYPE STRING,
J013 TYPE STRING,
J014 TYPE STRING,
J015 TYPE STRING,
J016 TYPE STRING,
J017 TYPE STRING,
J018 TYPE STRING,
J019 TYPE STRING,
J020 TYPE STRING,
J021 TYPE STRING,
J022 TYPE STRING,
J023 TYPE STRING,
J024 TYPE STRING,
J025 TYPE STRING,
J026 TYPE STRING,
J027 TYPE STRING,
J028 TYPE STRING,
J029 TYPE STRING,
J030 TYPE STRING,
J031 TYPE STRING,
J032 TYPE STRING,
J033 TYPE STRING,
J034 TYPE STRING,
J035 TYPE STRING,
J036 TYPE STRING,
J037 TYPE STRING,
J038 TYPE STRING,
J039 TYPE STRING,
J040 TYPE STRING,
J041 TYPE STRING,
J042 TYPE STRING,
J043 TYPE STRING,
J044 TYPE STRING,
J045 TYPE STRING,
J046 TYPE STRING,
J047 TYPE STRING,
J048 TYPE STRING,
J049 TYPE STRING,
J050 TYPE STRING,
J051 TYPE STRING,
J052 TYPE STRING,
J053 TYPE STRING,
J054 TYPE STRING,
J055 TYPE STRING,
J056 TYPE STRING,
J057 TYPE STRING,
J058 TYPE STRING,
J059 TYPE STRING,
J060 TYPE STRING,
J061 TYPE STRING,
J062 TYPE STRING,
J063 TYPE STRING,
J064 TYPE STRING,
J070 TYPE STRING,
J071 TYPE STRING,
J072 TYPE STRING,
J073 TYPE STRING,
J074 TYPE STRING,
J075 TYPE STRING,
J076 TYPE STRING,
J077 TYPE STRING,
J078 TYPE STRING,
J079 TYPE STRING,
J080 TYPE STRING,
J081 TYPE STRING,
J082 TYPE STRING,
J083 TYPE STRING,
J084 TYPE STRING,
J085 TYPE STRING,
J086 TYPE STRING,
J087 TYPE STRING,
J088 TYPE STRING,
J089 TYPE STRING,
J090 TYPE STRING,
J091 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_TRLV_DFT_ASSIGNJ_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_ASSIGNJ_STR-MANDT sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-POS_MAN_PROC sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J001 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J002 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J003 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J004 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J005 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J006 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J007 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J008 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J009 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J010 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J011 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J012 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J013 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J014 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J015 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J016 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J017 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J018 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J019 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J020 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J021 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J022 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J023 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J024 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J025 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J026 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J027 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J028 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J029 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J030 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J031 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J032 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J033 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J034 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J035 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J036 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J037 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J038 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J039 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J040 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J041 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J042 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J043 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J044 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J045 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J046 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J047 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J048 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J049 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J050 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J051 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J052 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J053 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J054 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J055 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J056 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J057 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J058 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J059 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J060 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J061 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J062 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J063 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J064 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J070 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J071 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J072 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J073 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J074 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J075 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J076 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J077 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J078 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J079 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J080 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J081 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J082 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J083 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J084 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J085 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J086 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J087 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J088 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J089 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J090 sy-vline 
WA_TRLV_DFT_ASSIGNJ_STR-J091 sy-vline      INTO ld_text SEPARATED BY SPACE.

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