ABAP Select data from SAP table UMB_YS_TREE_NODES 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 UMB_YS_TREE_NODES 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 UMB_YS_TREE_NODES. 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 UMB_YS_TREE_NODES 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_UMB_YS_TREE_NODES TYPE STANDARD TABLE OF UMB_YS_TREE_NODES,
      WA_UMB_YS_TREE_NODES TYPE UMB_YS_TREE_NODES,
      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: <UMB_YS_TREE_NODES> TYPE UMB_YS_TREE_NODES.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM UMB_YS_TREE_NODES
*  INTO TABLE @DATA(IT_UMB_YS_TREE_NODES2).
*--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_UMB_YS_TREE_NODES INDEX 1 INTO DATA(WA_UMB_YS_TREE_NODES2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<UMB_YS_TREE_NODES>-NODE_KEY = 1.
<UMB_YS_TREE_NODES>-PARENT = 1.
<UMB_YS_TREE_NODES>-IS_LEAF = 1.
<UMB_YS_TREE_NODES>-IS_EXPANDED = 1.
<UMB_YS_TREE_NODES>-CHILDREN_LOADED = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_UMB_YS_TREE_NODES-C00TEXT, sy-vline,
  WA_UMB_YS_TREE_NODES-C00ICON, sy-vline,
  WA_UMB_YS_TREE_NODES-C00TOOL, sy-vline,
  WA_UMB_YS_TREE_NODES-C00STY, sy-vline,
  WA_UMB_YS_TREE_NODES-C00ACT, sy-vline,
  WA_UMB_YS_TREE_NODES-C00VAR, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_UMB_YS_TREE_NODES 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_UMB_YS_TREE_NODES 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_UMB_YS_TREE_NODES INTO WA_UMB_YS_TREE_NODES.


*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_UMB_YS_TREE_NODES_STR, 
NODE_KEY TYPE STRING,
PARENT TYPE STRING,
IS_LEAF TYPE STRING,
IS_EXPANDED TYPE STRING,
CHILDREN_LOADED TYPE STRING,
C00TEXT TYPE STRING,
C00ICON TYPE STRING,
C00TOOL TYPE STRING,
C00STY TYPE STRING,
C00ACT TYPE STRING,
C00VAR TYPE STRING,
C01TEXT TYPE STRING,
C01ICON TYPE STRING,
C01TOOL TYPE STRING,
C01STY TYPE STRING,
C01ACT TYPE STRING,
C01VAR TYPE STRING,
C02TEXT TYPE STRING,
C02ICON TYPE STRING,
C02TOOL TYPE STRING,
C02STY TYPE STRING,
C02ACT TYPE STRING,
C02VAR TYPE STRING,
C03TEXT TYPE STRING,
C03ICON TYPE STRING,
C03TOOL TYPE STRING,
C03STY TYPE STRING,
C03ACT TYPE STRING,
C03VAR TYPE STRING,
C04TEXT TYPE STRING,
C04ICON TYPE STRING,
C04TOOL TYPE STRING,
C04STY TYPE STRING,
C04ACT TYPE STRING,
C04VAR TYPE STRING,
C05TEXT TYPE STRING,
C05ICON TYPE STRING,
C05TOOL TYPE STRING,
C05STY TYPE STRING,
C05ACT TYPE STRING,
C05VAR TYPE STRING,
C06TEXT TYPE STRING,
C06ICON TYPE STRING,
C06TOOL TYPE STRING,
C06STY TYPE STRING,
C06ACT TYPE STRING,
C06VAR TYPE STRING,
C07TEXT TYPE STRING,
C07ICON TYPE STRING,
C07TOOL TYPE STRING,
C07STY TYPE STRING,
C07ACT TYPE STRING,
C07VAR TYPE STRING,
C08TEXT TYPE STRING,
C08ICON TYPE STRING,
C08TOOL TYPE STRING,
C08STY TYPE STRING,
C08ACT TYPE STRING,
C08VAR TYPE STRING,
C09TEXT TYPE STRING,
C09ICON TYPE STRING,
C09TOOL TYPE STRING,
C09STY TYPE STRING,
C09ACT TYPE STRING,
C09VAR TYPE STRING,
C10TEXT TYPE STRING,
C10ICON TYPE STRING,
C10TOOL TYPE STRING,
C10STY TYPE STRING,
C10ACT TYPE STRING,
C10VAR TYPE STRING,
C11TEXT TYPE STRING,
C11ICON TYPE STRING,
C11TOOL TYPE STRING,
C11STY TYPE STRING,
C11ACT TYPE STRING,
C11VAR TYPE STRING,
C12TEXT TYPE STRING,
C12ICON TYPE STRING,
C12TOOL TYPE STRING,
C12STY TYPE STRING,
C12ACT TYPE STRING,
C12VAR TYPE STRING,
C13TEXT TYPE STRING,
C13ICON TYPE STRING,
C13TOOL TYPE STRING,
C13STY TYPE STRING,
C13ACT TYPE STRING,
C13VAR TYPE STRING,
C14TEXT TYPE STRING,
C14ICON TYPE STRING,
C14TOOL TYPE STRING,
C14STY TYPE STRING,
C14ACT TYPE STRING,
C14VAR TYPE STRING,
C15TEXT TYPE STRING,
C15ICON TYPE STRING,
C15TOOL TYPE STRING,
C15STY TYPE STRING,
C15ACT TYPE STRING,
C15VAR TYPE STRING,
C16TEXT TYPE STRING,
C16ICON TYPE STRING,
C16TOOL TYPE STRING,
C16STY TYPE STRING,
C16ACT TYPE STRING,
C16VAR TYPE STRING,
C17TEXT TYPE STRING,
C17ICON TYPE STRING,
C17TOOL TYPE STRING,
C17STY TYPE STRING,
C17ACT TYPE STRING,
C17VAR TYPE STRING,
C18TEXT TYPE STRING,
C18ICON TYPE STRING,
C18TOOL TYPE STRING,
C18STY TYPE STRING,
C18ACT TYPE STRING,
C18VAR TYPE STRING,
C19TEXT TYPE STRING,
C19ICON TYPE STRING,
C19TOOL TYPE STRING,
C19STY TYPE STRING,
C19ACT TYPE STRING,
C19VAR TYPE STRING,
C20TEXT TYPE STRING,
C20ICON TYPE STRING,
C20TOOL TYPE STRING,
C20STY TYPE STRING,
C20ACT TYPE STRING,
C20VAR TYPE STRING,
C21TEXT TYPE STRING,
C21ICON TYPE STRING,
C21TOOL TYPE STRING,
C21STY TYPE STRING,
C21ACT TYPE STRING,
C21VAR TYPE STRING,
C22TEXT TYPE STRING,
C22ICON TYPE STRING,
C22TOOL TYPE STRING,
C22STY TYPE STRING,
C22ACT TYPE STRING,
C22VAR TYPE STRING,
C23TEXT TYPE STRING,
C23ICON TYPE STRING,
C23TOOL TYPE STRING,
C23STY TYPE STRING,
C23ACT TYPE STRING,
C23VAR TYPE STRING,
C24TEXT TYPE STRING,
C24ICON TYPE STRING,
C24TOOL TYPE STRING,
C24STY TYPE STRING,
C24ACT TYPE STRING,
C24VAR TYPE STRING,
C25TEXT TYPE STRING,
C25ICON TYPE STRING,
C25TOOL TYPE STRING,
C25STY TYPE STRING,
C25ACT TYPE STRING,
C25VAR TYPE STRING,END OF T_EKKO_STR.
DATA: WA_UMB_YS_TREE_NODES_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_UMB_YS_TREE_NODES_STR-NODE_KEY sy-vline 
WA_UMB_YS_TREE_NODES_STR-PARENT sy-vline 
WA_UMB_YS_TREE_NODES_STR-IS_LEAF sy-vline 
WA_UMB_YS_TREE_NODES_STR-IS_EXPANDED sy-vline 
WA_UMB_YS_TREE_NODES_STR-CHILDREN_LOADED sy-vline 
WA_UMB_YS_TREE_NODES_STR-C00TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C00ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C00TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C00STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C00ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C00VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C01TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C01ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C01TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C01STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C01ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C01VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C02TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C02ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C02TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C02STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C02ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C02VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C03TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C03ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C03TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C03STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C03ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C03VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C04TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C04ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C04TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C04STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C04ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C04VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C05TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C05ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C05TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C05STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C05ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C05VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C06TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C06ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C06TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C06STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C06ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C06VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C07TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C07ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C07TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C07STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C07ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C07VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C08TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C08ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C08TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C08STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C08ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C08VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C09TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C09ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C09TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C09STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C09ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C09VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C10TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C10ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C10TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C10STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C10ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C10VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C11TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C11ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C11TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C11STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C11ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C11VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C12TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C12ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C12TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C12STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C12ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C12VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C13TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C13ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C13TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C13STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C13ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C13VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C14TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C14ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C14TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C14STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C14ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C14VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C15TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C15ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C15TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C15STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C15ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C15VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C16TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C16ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C16TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C16STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C16ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C16VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C17TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C17ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C17TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C17STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C17ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C17VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C18TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C18ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C18TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C18STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C18ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C18VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C19TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C19ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C19TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C19STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C19ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C19VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C20TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C20ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C20TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C20STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C20ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C20VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C21TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C21ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C21TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C21STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C21ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C21VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C22TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C22ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C22TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C22STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C22ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C22VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C23TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C23ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C23TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C23STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C23ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C23VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C24TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C24ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C24TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C24STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C24ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C24VAR sy-vline 
WA_UMB_YS_TREE_NODES_STR-C25TEXT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C25ICON sy-vline 
WA_UMB_YS_TREE_NODES_STR-C25TOOL sy-vline 
WA_UMB_YS_TREE_NODES_STR-C25STY sy-vline 
WA_UMB_YS_TREE_NODES_STR-C25ACT sy-vline 
WA_UMB_YS_TREE_NODES_STR-C25VAR sy-vline      INTO ld_text SEPARATED BY SPACE.

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