ABAP Select data from SAP table FSH_SELECT_VALUES_S 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 FSH_SELECT_VALUES_S 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 FSH_SELECT_VALUES_S. 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 FSH_SELECT_VALUES_S 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_FSH_SELECT_VALUES_S TYPE STANDARD TABLE OF FSH_SELECT_VALUES_S,
      WA_FSH_SELECT_VALUES_S TYPE FSH_SELECT_VALUES_S,
      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: <FSH_SELECT_VALUES_S> TYPE FSH_SELECT_VALUES_S.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FSH_SELECT_VALUES_S
*  INTO TABLE @DATA(IT_FSH_SELECT_VALUES_S2).
*--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_FSH_SELECT_VALUES_S INDEX 1 INTO DATA(WA_FSH_SELECT_VALUES_S2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<FSH_SELECT_VALUES_S>-SVBELN = 1.
<FSH_SELECT_VALUES_S>-SAUART = 1.
<FSH_SELECT_VALUES_S>-PVBTYP = 1.
<FSH_SELECT_VALUES_S>-SKUNNR = 1.
<FSH_SELECT_VALUES_S>-SAUDAT = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FSH_SELECT_VALUES_S-SMATNR, sy-vline,
  WA_FSH_SELECT_VALUES_S-SWERKS, sy-vline,
  WA_FSH_SELECT_VALUES_S-PBSTKD, sy-vline,
  WA_FSH_SELECT_VALUES_S-SERDAT, sy-vline,
  WA_FSH_SELECT_VALUES_S-SERNAM, sy-vline,
  WA_FSH_SELECT_VALUES_S-PPAVW, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_FSH_SELECT_VALUES_S 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_FSH_SELECT_VALUES_S 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_FSH_SELECT_VALUES_S INTO WA_FSH_SELECT_VALUES_S.


*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.

*Conversion exit PARVW, internal->external for field PPAVW
CALL FUNCTION 'CONVERSION_EXIT_PARVW_OUTPUT'
  EXPORTING
    input =                      WA_FSH_SELECT_VALUES_S-PPAVW
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FSH_SELECT_VALUES_S-PPAVW.
WRITE:/ 'New Value:', ld_input.
ENDFORM. 

*&---------------------------------------------------------------------*
*& Form process_as_string_field_values
*&---------------------------------------------------------------------*
FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO.

TYPES: BEGIN OF T_FSH_SELECT_VALUES_S_STR, 
SVBELN TYPE STRING,
SAUART TYPE STRING,
PVBTYP TYPE STRING,
SKUNNR TYPE STRING,
SAUDAT TYPE STRING,
SMATNR TYPE STRING,
SWERKS TYPE STRING,
PBSTKD TYPE STRING,
SERDAT TYPE STRING,
SERNAM TYPE STRING,
PPAVW TYPE STRING,
SPARTNER TYPE STRING,
SVKORG TYPE STRING,
SVTWEG TYPE STRING,
SSPART TYPE STRING,
SVKBUR TYPE STRING,
SVKGRP TYPE STRING,
PPRTYP TYPE STRING,
PVBOFF TYPE STRING,
PVBALL TYPE STRING,
PDISPL TYPE STRING,
PSIMUL TYPE STRING,
PLG_ERR TYPE STRING,
PMAX_J TYPE STRING,
RB_PRC TYPE STRING,
RB_ATP TYPE STRING,
PDOCNO TYPE STRING,
PITEMNO TYPE STRING,
PDELPRI TYPE STRING,
PDATE TYPE STRING,
PEXTNUM TYPE STRING,
PDCREAT TYPE STRING,
PDDELIV TYPE STRING,
PLOG TYPE STRING,
P_SRVR_G TYPE STRING,
PBLOCKS TYPE STRING,
PABAP TYPE STRING,
PHANA TYPE STRING,
P_WPNUM TYPE STRING,
P_DATE1 TYPE STRING,
P_RES TYPE STRING,
P_PO TYPE STRING,
P_SO TYPE STRING,
P_STOCKS TYPE STRING,
P_INBDEL TYPE STRING,
P_PREQ TYPE STRING,
P_PLAF TYPE STRING,
PMATSEL TYPE STRING,
PORDSEL TYPE STRING,
P_WERKS TYPE STRING,
P_MACO_C TYPE STRING,
P_ATP_CF TYPE STRING,END OF T_EKKO_STR.
DATA: WA_FSH_SELECT_VALUES_S_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_FSH_SELECT_VALUES_S_STR-SVBELN sy-vline 
WA_FSH_SELECT_VALUES_S_STR-SAUART sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PVBTYP sy-vline 
WA_FSH_SELECT_VALUES_S_STR-SKUNNR sy-vline 
WA_FSH_SELECT_VALUES_S_STR-SAUDAT sy-vline 
WA_FSH_SELECT_VALUES_S_STR-SMATNR sy-vline 
WA_FSH_SELECT_VALUES_S_STR-SWERKS sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PBSTKD sy-vline 
WA_FSH_SELECT_VALUES_S_STR-SERDAT sy-vline 
WA_FSH_SELECT_VALUES_S_STR-SERNAM sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PPAVW sy-vline 
WA_FSH_SELECT_VALUES_S_STR-SPARTNER sy-vline 
WA_FSH_SELECT_VALUES_S_STR-SVKORG sy-vline 
WA_FSH_SELECT_VALUES_S_STR-SVTWEG sy-vline 
WA_FSH_SELECT_VALUES_S_STR-SSPART sy-vline 
WA_FSH_SELECT_VALUES_S_STR-SVKBUR sy-vline 
WA_FSH_SELECT_VALUES_S_STR-SVKGRP sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PPRTYP sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PVBOFF sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PVBALL sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PDISPL sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PSIMUL sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PLG_ERR sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PMAX_J sy-vline 
WA_FSH_SELECT_VALUES_S_STR-RB_PRC sy-vline 
WA_FSH_SELECT_VALUES_S_STR-RB_ATP sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PDOCNO sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PITEMNO sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PDELPRI sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PDATE sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PEXTNUM sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PDCREAT sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PDDELIV sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PLOG sy-vline 
WA_FSH_SELECT_VALUES_S_STR-P_SRVR_G sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PBLOCKS sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PABAP sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PHANA sy-vline 
WA_FSH_SELECT_VALUES_S_STR-P_WPNUM sy-vline 
WA_FSH_SELECT_VALUES_S_STR-P_DATE1 sy-vline 
WA_FSH_SELECT_VALUES_S_STR-P_RES sy-vline 
WA_FSH_SELECT_VALUES_S_STR-P_PO sy-vline 
WA_FSH_SELECT_VALUES_S_STR-P_SO sy-vline 
WA_FSH_SELECT_VALUES_S_STR-P_STOCKS sy-vline 
WA_FSH_SELECT_VALUES_S_STR-P_INBDEL sy-vline 
WA_FSH_SELECT_VALUES_S_STR-P_PREQ sy-vline 
WA_FSH_SELECT_VALUES_S_STR-P_PLAF sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PMATSEL sy-vline 
WA_FSH_SELECT_VALUES_S_STR-PORDSEL sy-vline 
WA_FSH_SELECT_VALUES_S_STR-P_WERKS sy-vline 
WA_FSH_SELECT_VALUES_S_STR-P_MACO_C sy-vline 
WA_FSH_SELECT_VALUES_S_STR-P_ATP_CF sy-vline      INTO ld_text SEPARATED BY SPACE.

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