ABAP Select data from SAP table CRMT_CIC_CSEARCH_SS_METHODS 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 CRMT_CIC_CSEARCH_SS_METHODS 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 CRMT_CIC_CSEARCH_SS_METHODS. 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 CRMT_CIC_CSEARCH_SS_METHODS 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_CRMT_CIC_CSEARCH_SS_METHODS TYPE STANDARD TABLE OF CRMT_CIC_CSEARCH_SS_METHODS,
      WA_CRMT_CIC_CSEARCH_SS_METHODS TYPE CRMT_CIC_CSEARCH_SS_METHODS,
      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: <CRMT_CIC_CSEARCH_SS_METHODS> TYPE CRMT_CIC_CSEARCH_SS_METHODS.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CRMT_CIC_CSEARCH_SS_METHODS
*  INTO TABLE @DATA(IT_CRMT_CIC_CSEARCH_SS_METHODS2).
*--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_CRMT_CIC_CSEARCH_SS_METHODS INDEX 1 INTO DATA(WA_CRMT_CIC_CSEARCH_SS_METHODS2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<CRMT_CIC_CSEARCH_SS_METHODS>-CREATE = 1.
<CRMT_CIC_CSEARCH_SS_METHODS>-CLOSE = 1.
<CRMT_CIC_CSEARCH_SS_METHODS>-INIT = 1.
<CRMT_CIC_CSEARCH_SS_METHODS>-POPULATE = 1.
<CRMT_CIC_CSEARCH_SS_METHODS>-DETAIL = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CRMT_CIC_CSEARCH_SS_METHODS-INFO, sy-vline,
  WA_CRMT_CIC_CSEARCH_SS_METHODS-MAPSEARCH, sy-vline,
  WA_CRMT_CIC_CSEARCH_SS_METHODS-PUBLISH, sy-vline,
  WA_CRMT_CIC_CSEARCH_SS_METHODS-CLEAR, sy-vline,
  WA_CRMT_CIC_CSEARCH_SS_METHODS-SEARCH, sy-vline,
  WA_CRMT_CIC_CSEARCH_SS_METHODS-CREATETARGET, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_CRMT_CIC_CSEARCH_SS_METHODS 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_CRMT_CIC_CSEARCH_SS_METHODS 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_CRMT_CIC_CSEARCH_SS_METHODS INTO WA_CRMT_CIC_CSEARCH_SS_METHODS.


*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_CRMT_CIC_CSEARCH_SS_METHODS_STR, 
CREATE TYPE STRING,
CLOSE TYPE STRING,
INIT TYPE STRING,
POPULATE TYPE STRING,
DETAIL TYPE STRING,
INFO TYPE STRING,
MAPSEARCH TYPE STRING,
PUBLISH TYPE STRING,
CLEAR TYPE STRING,
SEARCH TYPE STRING,
CREATETARGET TYPE STRING,
CREATECONTACT TYPE STRING,
FILTER_ADDR TYPE STRING,
RELCATDISP TYPE STRING,
EXCOL TYPE STRING,
MULT_HIT TYPE STRING,
ENTER TYPE STRING,
SEARCH_RULES TYPE STRING,
LEAN_SAVE TYPE STRING,
LEAN_CREATE TYPE STRING,
COMP_SEARCH TYPE STRING,
BP_CONTROL TYPE STRING,
BP_ADDR_CONTROL TYPE STRING,
BP_COMP_CONTROL TYPE STRING,
BP_ADDR_CNT_MAIN TYPE STRING,
ADDR_SEARCH TYPE STRING,
BP_COMM_CONTROL TYPE STRING,
SEARCH_COMPLETE TYPE STRING,
LEAN_SAVE_MAIN TYPE STRING,
BP_CONF_PUBLISH TYPE STRING,
SEARCH_DECISION TYPE STRING,
FETCH_COMP_STR TYPE STRING,
VALIDATE_BP_CONF TYPE STRING,
FLUSH_DATA TYPE STRING,
CONSIST_CHECK TYPE STRING,
GEN_SEARCH_CHECK TYPE STRING,
RELATIONS TYPE STRING,
GET_PTNR_FUNC TYPE STRING,
REQ_DATA_FOR_EVT TYPE STRING,
SET_STRUCT_VALU TYPE STRING,
CHECK_SEARCH TYPE STRING,
UPDATE_DISPLAY TYPE STRING,
CHECK_EXCL_PFT TYPE STRING,
M_ANI_SET_FLAG TYPE STRING,
SET_PTNR_FUNCS TYPE STRING,END OF T_EKKO_STR.
DATA: WA_CRMT_CIC_CSEARCH_SS_METHODS_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_CRMT_CIC_CSEARCH_SS_METHODS_STR-CREATE sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-CLOSE sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-INIT sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-POPULATE sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-DETAIL sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-INFO sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-MAPSEARCH sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-PUBLISH sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-CLEAR sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-SEARCH sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-CREATETARGET sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-CREATECONTACT sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-FILTER_ADDR sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-RELCATDISP sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-EXCOL sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-MULT_HIT sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-ENTER sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-SEARCH_RULES sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-LEAN_SAVE sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-LEAN_CREATE sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-COMP_SEARCH sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-BP_CONTROL sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-BP_ADDR_CONTROL sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-BP_COMP_CONTROL sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-BP_ADDR_CNT_MAIN sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-ADDR_SEARCH sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-BP_COMM_CONTROL sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-SEARCH_COMPLETE sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-LEAN_SAVE_MAIN sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-BP_CONF_PUBLISH sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-SEARCH_DECISION sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-FETCH_COMP_STR sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-VALIDATE_BP_CONF sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-FLUSH_DATA sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-CONSIST_CHECK sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-GEN_SEARCH_CHECK sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-RELATIONS sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-GET_PTNR_FUNC sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-REQ_DATA_FOR_EVT sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-SET_STRUCT_VALU sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-CHECK_SEARCH sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-UPDATE_DISPLAY sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-CHECK_EXCL_PFT sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-M_ANI_SET_FLAG sy-vline 
WA_CRMT_CIC_CSEARCH_SS_METHODS_STR-SET_PTNR_FUNCS sy-vline      INTO ld_text SEPARATED BY SPACE.

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