ABAP Select data from SAP table LTR2_UI_S_ES_ITEM 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 LTR2_UI_S_ES_ITEM 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 LTR2_UI_S_ES_ITEM. 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 LTR2_UI_S_ES_ITEM 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_LTR2_UI_S_ES_ITEM TYPE STANDARD TABLE OF LTR2_UI_S_ES_ITEM,
      WA_LTR2_UI_S_ES_ITEM TYPE LTR2_UI_S_ES_ITEM,
      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: <LTR2_UI_S_ES_ITEM> TYPE LTR2_UI_S_ES_ITEM.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM LTR2_UI_S_ES_ITEM
*  INTO TABLE @DATA(IT_LTR2_UI_S_ES_ITEM2).
*--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_LTR2_UI_S_ES_ITEM INDEX 1 INTO DATA(WA_LTR2_UI_S_ES_ITEM2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<LTR2_UI_S_ES_ITEM>-USE_IOBTIOB = 1.
<LTR2_UI_S_ES_ITEM>-IOBT_METHODIOB = 1.
<LTR2_UI_S_ES_ITEM>-WSGUID = 1.
<LTR2_UI_S_ES_ITEM>-WSPOS = 1.
<LTR2_UI_S_ES_ITEM>-ROBJ_GUID = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_LTR2_UI_S_ES_ITEM-WSPOS_PARENT, sy-vline,
  WA_LTR2_UI_S_ES_ITEM-ROBJ_GUID_PARENT, sy-vline,
  WA_LTR2_UI_S_ES_ITEM-ROBJ_NAME_PARENT, sy-vline,
  WA_LTR2_UI_S_ES_ITEM-ROBJ_TYPE_PARENT, sy-vline,
  WA_LTR2_UI_S_ES_ITEM-ACTIVE, sy-vline,
  WA_LTR2_UI_S_ES_ITEM-DATA_FLAG, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_LTR2_UI_S_ES_ITEM 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_LTR2_UI_S_ES_ITEM 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_LTR2_UI_S_ES_ITEM INTO WA_LTR2_UI_S_ES_ITEM.


*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_LTR2_UI_S_ES_ITEM_STR, 
USE_IOBTIOB TYPE STRING,
IOBT_METHODIOB TYPE STRING,
WSGUID TYPE STRING,
WSPOS TYPE STRING,
ROBJ_GUID TYPE STRING,
WSPOS_PARENT TYPE STRING,
ROBJ_GUID_PARENT TYPE STRING,
ROBJ_NAME_PARENT TYPE STRING,
ROBJ_TYPE_PARENT TYPE STRING,
ACTIVE TYPE STRING,
DATA_FLAG TYPE STRING,
ROBJ_TYPE TYPE STRING,
ROBJ_NAME TYPE STRING,
WSPOS_LINK_TGT TYPE STRING,
SEL_ONLY TYPE STRING,
TB_STATUS TYPE STRING,
TMETHOD TYPE STRING,
ALIAS_NAME TYPE STRING,
ALIAS_NAME_PARENT TYPE STRING,
WSPOSMWB TYPE STRING,
MWBOBJNAMEMWB TYPE STRING,
MWBOBJ_SEQNOMWB TYPE STRING,
READ_TYPEMWB TYPE STRING,
WRT_BEHAVMWB TYPE STRING,
TAB_PARALLMWB TYPE STRING,
MAX_PORTIONMWB TYPE STRING,
TRF_PRESEL_TABMWB TYPE STRING,
MWB_MON TYPE STRING,
CONV TYPE STRING,
TECH_TSEL TYPE STRING,
SHOW_TECHSEL TYPE STRING,
SHOW_MWBGEN TYPE STRING,
SHOW_CONV TYPE STRING,
COMMENT TYPE STRING,
TECH_SKIP_FSEL TYPE STRING,
DESCRIPTION TYPE STRING,
SHOW_PRESEL TYPE STRING,
SHOW_PE TYPE STRING,
PE_MON TYPE STRING,
PE_AREA_NAME TYPE STRING,
SHOW_PM TYPE STRING,
PM_BUS_OWNER TYPE STRING,
PM_STATUS TYPE STRING,
PM_STATUS_ICON TYPE STRING,
PM_IMP_OWNER TYPE STRING,
PM_RULE_STATUS TYPE STRING,
PM_TECHSEL_STATUS TYPE STRING,
TRULE_HTSP TYPE STRING,
TRULE_HAS_TRULE TYPE STRING,
SHOW_TRULE TYPE STRING,
SHOW_SEL_ONLY TYPE STRING,
TMETHOD_DRN TYPE STRING,
SHOW_TMETHOD TYPE STRING,
WSPOSTSL TYPE STRING,
SELECTIONTSL TYPE STRING,
PRESEL_TABTSL TYPE STRING,
EXTLINKTSL TYPE STRING,
DATA_FLAG_VISIBLE TYPE STRING,
AREA_ID_TPLPE TYPE STRING,
AREA_ID_PRODPE TYPE STRING,
DM_TAB_ID_TPLPE TYPE STRING,
DM_TAB_ID_PRODPE TYPE STRING,
NOFA_TABLE TYPE STRING,
SHOW_NOFA_TABLE TYPE STRING,
HAS_SELECTION TYPE STRING,
ES_SPECIFIC TYPE STRING,
SHOW_IOBT TYPE STRING,
NAMESPACE_ICON TYPE STRING,END OF T_EKKO_STR.
DATA: WA_LTR2_UI_S_ES_ITEM_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_LTR2_UI_S_ES_ITEM_STR-USE_IOBTIOB sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-IOBT_METHODIOB sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-WSGUID sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-WSPOS sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-ROBJ_GUID sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-WSPOS_PARENT sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-ROBJ_GUID_PARENT sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-ROBJ_NAME_PARENT sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-ROBJ_TYPE_PARENT sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-ACTIVE sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-DATA_FLAG sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-ROBJ_TYPE sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-ROBJ_NAME sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-WSPOS_LINK_TGT sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-SEL_ONLY sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-TB_STATUS sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-TMETHOD sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-ALIAS_NAME sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-ALIAS_NAME_PARENT sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-WSPOSMWB sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-MWBOBJNAMEMWB sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-MWBOBJ_SEQNOMWB sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-READ_TYPEMWB sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-WRT_BEHAVMWB sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-TAB_PARALLMWB sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-MAX_PORTIONMWB sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-TRF_PRESEL_TABMWB sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-MWB_MON sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-CONV sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-TECH_TSEL sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-SHOW_TECHSEL sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-SHOW_MWBGEN sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-SHOW_CONV sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-COMMENT sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-TECH_SKIP_FSEL sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-DESCRIPTION sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-SHOW_PRESEL sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-SHOW_PE sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-PE_MON sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-PE_AREA_NAME sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-SHOW_PM sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-PM_BUS_OWNER sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-PM_STATUS sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-PM_STATUS_ICON sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-PM_IMP_OWNER sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-PM_RULE_STATUS sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-PM_TECHSEL_STATUS sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-TRULE_HTSP sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-TRULE_HAS_TRULE sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-SHOW_TRULE sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-SHOW_SEL_ONLY sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-TMETHOD_DRN sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-SHOW_TMETHOD sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-WSPOSTSL sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-SELECTIONTSL sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-PRESEL_TABTSL sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-EXTLINKTSL sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-DATA_FLAG_VISIBLE sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-AREA_ID_TPLPE sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-AREA_ID_PRODPE sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-DM_TAB_ID_TPLPE sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-DM_TAB_ID_PRODPE sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-NOFA_TABLE sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-SHOW_NOFA_TABLE sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-HAS_SELECTION sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-ES_SPECIFIC sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-SHOW_IOBT sy-vline 
WA_LTR2_UI_S_ES_ITEM_STR-NAMESPACE_ICON sy-vline      INTO ld_text SEPARATED BY SPACE.

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