ABAP Select data from SAP table FSH_SELVALUES_S into internal table
Get Example source ABAP code based on a different SAP table
Below is a number of ABAP code snippets to demonstrate how to select data from SAP FSH_SELVALUES_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_SELVALUES_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_SELVALUES_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_SELVALUES_S TYPE STANDARD TABLE OF FSH_SELVALUES_S,
WA_FSH_SELVALUES_S TYPE FSH_SELVALUES_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_SELVALUES_S> TYPE FSH_SELVALUES_S.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_FSH_SELVALUES_S.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM FSH_SELVALUES_S
INTO TABLE IT_FSH_SELVALUES_S.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM FSH_SELVALUES_S
* INTO TABLE @DATA(IT_FSH_SELVALUES_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_SELVALUES_S INDEX 1 INTO DATA(WA_FSH_SELVALUES_S2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_FSH_SELVALUES_S ASSIGNING <FSH_SELVALUES_S>.
*To update a field value using a field symbol simply change the value via the field symbol pointer<FSH_SELVALUES_S>-P_ANZTG = 1.
<FSH_SELVALUES_S>-P_ARMOD = 1.
<FSH_SELVALUES_S>-P_ARTXT = 1.
<FSH_SELVALUES_S>-P_ARTYP = 1.
<FSH_SELVALUES_S>-P_AUART = 1.
ENDLOOP. LOOP AT IT_FSH_SELVALUES_S INTO WA_FSH_SELVALUES_S. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_FSH_SELVALUES_S-P_AUDAT, sy-vline,
WA_FSH_SELVALUES_S-P_AUFPA, sy-vline,
WA_FSH_SELVALUES_S-P_AUFPR, sy-vline,
WA_FSH_SELVALUES_S-P_AUGRU, sy-vline,
WA_FSH_SELVALUES_S-P_BANFN, sy-vline,
WA_FSH_SELVALUES_S-P_BASBA, sy-vline.
ENDLOOP. *Add any further fields from structure WA_FSH_SELVALUES_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_SELVALUES_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_SELVALUES_S INTO WA_FSH_SELVALUES_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.
ENDFORM. *&---------------------------------------------------------------------* *& Form process_as_string_field_values *&---------------------------------------------------------------------* FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO. TYPES: BEGIN OF T_FSH_SELVALUES_S_STR,
P_ANZTG TYPE STRING,
P_ARMOD TYPE STRING,
P_ARTXT TYPE STRING,
P_ARTYP TYPE STRING,
P_AUART TYPE STRING,
P_AUDAT TYPE STRING,
P_AUFPA TYPE STRING,
P_AUFPR TYPE STRING,
P_AUGRU TYPE STRING,
P_BANFN TYPE STRING,
P_BASBA TYPE STRING,
P_BASCO TYPE STRING,
P_BASDAT TYPE STRING,
P_BASPA TYPE STRING,
P_BASPO TYPE STRING,
P_BASPR TYPE STRING,
P_BSARK TYPE STRING,
P_BSTNK TYPE STRING,
P_CBELN TYPE STRING,
P_CHARG TYPE STRING,
P_SVTWEG TYPE STRING,
P_SSPART TYPE STRING,
P_SLPRIO TYPE STRING,
P_DTFRM TYPE STRING,
P_DYABA TYPE STRING,
P_DYACO TYPE STRING,
P_DYAPA TYPE STRING,
P_DYAPO TYPE STRING,
P_DYAPR TYPE STRING,
P_DYSBA TYPE STRING,
P_DYSCO TYPE STRING,
P_DYSPA TYPE STRING,
P_DYSPO TYPE STRING,
P_DYSPR TYPE STRING,
P_EBELN TYPE STRING,
P_EDATU TYPE STRING,
P_ERNAM TYPE STRING,
P_HIERID TYPE STRING,
P_HRZBA TYPE STRING,
P_HRZCO TYPE STRING,
P_HRZPA TYPE STRING,
P_HRZPO TYPE STRING,
P_HRZPR TYPE STRING,
P_CLASS TYPE STRING,
P_KUNNR TYPE STRING,
P_KDGRP TYPE STRING,
P_LDDAT TYPE STRING,
P_SLDDAT TYPE STRING,
P_LFSTA TYPE STRING,
P_LFSTK TYPE STRING,
P_LGORT TYPE STRING,
P_LIFSK TYPE STRING,
P_LIFSP TYPE STRING,
P_LSTAZ TYPE STRING,
P_MATKL TYPE STRING,
P_MATNR TYPE STRING,
P_MBDAT TYPE STRING,
P_SMBDAT TYPE STRING,
P_NODE TYPE STRING,
P_OTDDT TYPE STRING,
P_OTDSUB TYPE STRING,
P_EKGRP TYPE STRING,
P_EKORG TYPE STRING,
P_POSAZ TYPE STRING,
P_SEINDT TYPE STRING,
P_BASSTO TYPE STRING,
P_DYASTO TYPE STRING,
P_DYSSTO TYPE STRING,
P_SEREG TYPE STRING,
P_SVSTEL TYPE STRING,
P_SKUNAG TYPE STRING,
P_SVKORG TYPE STRING,
P_SPART TYPE STRING,
P_SEBELN TYPE STRING,
P_SBSART TYPE STRING,
P_TDDAT TYPE STRING,
P_STDDAT TYPE STRING,
P_VBELN TYPE STRING,
P_VBTYP TYPE STRING,
P_VDATU TYPE STRING,
P_SVDATU TYPE STRING,
P_VKBUR TYPE STRING,
P_VKGRP TYPE STRING,
P_VKORG TYPE STRING,
P_VTWEG TYPE STRING,
P_WADAT TYPE STRING,
P_SWADAT TYPE STRING,
P_WERKS TYPE STRING,
P_SOBKZ TYPE STRING,
P_SCAT TYPE STRING,
P_EINDT TYPE STRING,
P_BSART TYPE STRING,
P_SEKORG TYPE STRING,
P_SEKGRP TYPE STRING,
P_SAEDAT TYPE STRING,
P_KUNAG TYPE STRING,
P_VSTEL TYPE STRING,
P_LPRIO TYPE STRING,
P_LGOCO TYPE STRING,
P_STKCAT TYPE STRING,
P_LIFCO TYPE STRING,
P_KSCAT TYPE STRING,
P_CDATE TYPE STRING,
P_RDELDT TYPE STRING,
P_RCAT TYPE STRING,
P_CMPSO TYPE STRING,
P_CMPSTO TYPE STRING,
P_SGT_RCAT TYPE STRING,
P_SEAN TYPE STRING,
P_SYR TYPE STRING,
P_COLLN TYPE STRING,
P_THEME TYPE STRING,
P_SSEAN TYPE STRING,
P_SSYR TYPE STRING,
P_SCOLLN TYPE STRING,
P_STHEME TYPE STRING,
P_BATCH TYPE STRING,
P_BEDAT TYPE STRING,
P_EINDTS TYPE STRING,
P_OTDBS TYPE STRING,
P_MG_AT1 TYPE STRING,
P_MG_AT2 TYPE STRING,
P_MG_AT3 TYPE STRING,
P_COLOR TYPE STRING,
P_SIZE1 TYPE STRING,
P_SIZE2 TYPE STRING,
P_ARNUM TYPE STRING,
P_BSKZ TYPE STRING,
P_BSNR TYPE STRING,
P_ASTAT TYPE STRING,
P_WERKS1 TYPE STRING,
P_EORDR TYPE STRING,
P_STO TYPE STRING,
P_EXMTO TYPE STRING,
P_KUNWE TYPE STRING,
P_HRPO_R TYPE STRING,
P_EBELNR TYPE STRING,
P_BSARKR TYPE STRING,
P_LGOCOR TYPE STRING,
P_STKCTR TYPE STRING,
P_LIFCOR TYPE STRING,
P_BAPO_R TYPE STRING,
P_DYPO_R TYPE STRING,
P_DPO_R TYPE STRING,
P_ST_LOC TYPE STRING,
P_BDART TYPE STRING,
P_RETPO TYPE STRING,
P_PLGORT TYPE STRING,
P_PSCAT TYPE STRING,
P_PAUFNR TYPE STRING,
P_DGLTP TYPE STRING,
P_PHRZPO TYPE STRING,
P_PBASPO TYPE STRING,
P_PDYSPO TYPE STRING,
P_PDYAPO TYPE STRING,
P_SUBCPO TYPE STRING,
P_SUBNO TYPE STRING,
P_SUBVEN TYPE STRING,
P_SUBRQD TYPE STRING,
P_SUBLRQ TYPE STRING,
P_SUBSGT TYPE STRING,
P_SDOCTP TYPE STRING,
P_OS_ID TYPE STRING,
P_SOS_ID TYPE STRING,END OF T_EKKO_STR. DATA: WA_FSH_SELVALUES_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_SELVALUES_S_STR-P_ANZTG sy-vline
WA_FSH_SELVALUES_S_STR-P_ARMOD sy-vline
WA_FSH_SELVALUES_S_STR-P_ARTXT sy-vline
WA_FSH_SELVALUES_S_STR-P_ARTYP sy-vline
WA_FSH_SELVALUES_S_STR-P_AUART sy-vline
WA_FSH_SELVALUES_S_STR-P_AUDAT sy-vline
WA_FSH_SELVALUES_S_STR-P_AUFPA sy-vline
WA_FSH_SELVALUES_S_STR-P_AUFPR sy-vline
WA_FSH_SELVALUES_S_STR-P_AUGRU sy-vline
WA_FSH_SELVALUES_S_STR-P_BANFN sy-vline
WA_FSH_SELVALUES_S_STR-P_BASBA sy-vline
WA_FSH_SELVALUES_S_STR-P_BASCO sy-vline
WA_FSH_SELVALUES_S_STR-P_BASDAT sy-vline
WA_FSH_SELVALUES_S_STR-P_BASPA sy-vline
WA_FSH_SELVALUES_S_STR-P_BASPO sy-vline
WA_FSH_SELVALUES_S_STR-P_BASPR sy-vline
WA_FSH_SELVALUES_S_STR-P_BSARK sy-vline
WA_FSH_SELVALUES_S_STR-P_BSTNK sy-vline
WA_FSH_SELVALUES_S_STR-P_CBELN sy-vline
WA_FSH_SELVALUES_S_STR-P_CHARG sy-vline
WA_FSH_SELVALUES_S_STR-P_SVTWEG sy-vline
WA_FSH_SELVALUES_S_STR-P_SSPART sy-vline
WA_FSH_SELVALUES_S_STR-P_SLPRIO sy-vline
WA_FSH_SELVALUES_S_STR-P_DTFRM sy-vline
WA_FSH_SELVALUES_S_STR-P_DYABA sy-vline
WA_FSH_SELVALUES_S_STR-P_DYACO sy-vline
WA_FSH_SELVALUES_S_STR-P_DYAPA sy-vline
WA_FSH_SELVALUES_S_STR-P_DYAPO sy-vline
WA_FSH_SELVALUES_S_STR-P_DYAPR sy-vline
WA_FSH_SELVALUES_S_STR-P_DYSBA sy-vline
WA_FSH_SELVALUES_S_STR-P_DYSCO sy-vline
WA_FSH_SELVALUES_S_STR-P_DYSPA sy-vline
WA_FSH_SELVALUES_S_STR-P_DYSPO sy-vline
WA_FSH_SELVALUES_S_STR-P_DYSPR sy-vline
WA_FSH_SELVALUES_S_STR-P_EBELN sy-vline
WA_FSH_SELVALUES_S_STR-P_EDATU sy-vline
WA_FSH_SELVALUES_S_STR-P_ERNAM sy-vline
WA_FSH_SELVALUES_S_STR-P_HIERID sy-vline
WA_FSH_SELVALUES_S_STR-P_HRZBA sy-vline
WA_FSH_SELVALUES_S_STR-P_HRZCO sy-vline
WA_FSH_SELVALUES_S_STR-P_HRZPA sy-vline
WA_FSH_SELVALUES_S_STR-P_HRZPO sy-vline
WA_FSH_SELVALUES_S_STR-P_HRZPR sy-vline
WA_FSH_SELVALUES_S_STR-P_CLASS sy-vline
WA_FSH_SELVALUES_S_STR-P_KUNNR sy-vline
WA_FSH_SELVALUES_S_STR-P_KDGRP sy-vline
WA_FSH_SELVALUES_S_STR-P_LDDAT sy-vline
WA_FSH_SELVALUES_S_STR-P_SLDDAT sy-vline
WA_FSH_SELVALUES_S_STR-P_LFSTA sy-vline
WA_FSH_SELVALUES_S_STR-P_LFSTK sy-vline
WA_FSH_SELVALUES_S_STR-P_LGORT sy-vline
WA_FSH_SELVALUES_S_STR-P_LIFSK sy-vline
WA_FSH_SELVALUES_S_STR-P_LIFSP sy-vline
WA_FSH_SELVALUES_S_STR-P_LSTAZ sy-vline
WA_FSH_SELVALUES_S_STR-P_MATKL sy-vline
WA_FSH_SELVALUES_S_STR-P_MATNR sy-vline
WA_FSH_SELVALUES_S_STR-P_MBDAT sy-vline
WA_FSH_SELVALUES_S_STR-P_SMBDAT sy-vline
WA_FSH_SELVALUES_S_STR-P_NODE sy-vline
WA_FSH_SELVALUES_S_STR-P_OTDDT sy-vline
WA_FSH_SELVALUES_S_STR-P_OTDSUB sy-vline
WA_FSH_SELVALUES_S_STR-P_EKGRP sy-vline
WA_FSH_SELVALUES_S_STR-P_EKORG sy-vline
WA_FSH_SELVALUES_S_STR-P_POSAZ sy-vline
WA_FSH_SELVALUES_S_STR-P_SEINDT sy-vline
WA_FSH_SELVALUES_S_STR-P_BASSTO sy-vline
WA_FSH_SELVALUES_S_STR-P_DYASTO sy-vline
WA_FSH_SELVALUES_S_STR-P_DYSSTO sy-vline
WA_FSH_SELVALUES_S_STR-P_SEREG sy-vline
WA_FSH_SELVALUES_S_STR-P_SVSTEL sy-vline
WA_FSH_SELVALUES_S_STR-P_SKUNAG sy-vline
WA_FSH_SELVALUES_S_STR-P_SVKORG sy-vline
WA_FSH_SELVALUES_S_STR-P_SPART sy-vline
WA_FSH_SELVALUES_S_STR-P_SEBELN sy-vline
WA_FSH_SELVALUES_S_STR-P_SBSART sy-vline
WA_FSH_SELVALUES_S_STR-P_TDDAT sy-vline
WA_FSH_SELVALUES_S_STR-P_STDDAT sy-vline
WA_FSH_SELVALUES_S_STR-P_VBELN sy-vline
WA_FSH_SELVALUES_S_STR-P_VBTYP sy-vline
WA_FSH_SELVALUES_S_STR-P_VDATU sy-vline
WA_FSH_SELVALUES_S_STR-P_SVDATU sy-vline
WA_FSH_SELVALUES_S_STR-P_VKBUR sy-vline
WA_FSH_SELVALUES_S_STR-P_VKGRP sy-vline
WA_FSH_SELVALUES_S_STR-P_VKORG sy-vline
WA_FSH_SELVALUES_S_STR-P_VTWEG sy-vline
WA_FSH_SELVALUES_S_STR-P_WADAT sy-vline
WA_FSH_SELVALUES_S_STR-P_SWADAT sy-vline
WA_FSH_SELVALUES_S_STR-P_WERKS sy-vline
WA_FSH_SELVALUES_S_STR-P_SOBKZ sy-vline
WA_FSH_SELVALUES_S_STR-P_SCAT sy-vline
WA_FSH_SELVALUES_S_STR-P_EINDT sy-vline
WA_FSH_SELVALUES_S_STR-P_BSART sy-vline
WA_FSH_SELVALUES_S_STR-P_SEKORG sy-vline
WA_FSH_SELVALUES_S_STR-P_SEKGRP sy-vline
WA_FSH_SELVALUES_S_STR-P_SAEDAT sy-vline
WA_FSH_SELVALUES_S_STR-P_KUNAG sy-vline
WA_FSH_SELVALUES_S_STR-P_VSTEL sy-vline
WA_FSH_SELVALUES_S_STR-P_LPRIO sy-vline
WA_FSH_SELVALUES_S_STR-P_LGOCO sy-vline
WA_FSH_SELVALUES_S_STR-P_STKCAT sy-vline
WA_FSH_SELVALUES_S_STR-P_LIFCO sy-vline
WA_FSH_SELVALUES_S_STR-P_KSCAT sy-vline
WA_FSH_SELVALUES_S_STR-P_CDATE sy-vline
WA_FSH_SELVALUES_S_STR-P_RDELDT sy-vline
WA_FSH_SELVALUES_S_STR-P_RCAT sy-vline
WA_FSH_SELVALUES_S_STR-P_CMPSO sy-vline
WA_FSH_SELVALUES_S_STR-P_CMPSTO sy-vline
WA_FSH_SELVALUES_S_STR-P_SGT_RCAT sy-vline
WA_FSH_SELVALUES_S_STR-P_SEAN sy-vline
WA_FSH_SELVALUES_S_STR-P_SYR sy-vline
WA_FSH_SELVALUES_S_STR-P_COLLN sy-vline
WA_FSH_SELVALUES_S_STR-P_THEME sy-vline
WA_FSH_SELVALUES_S_STR-P_SSEAN sy-vline
WA_FSH_SELVALUES_S_STR-P_SSYR sy-vline
WA_FSH_SELVALUES_S_STR-P_SCOLLN sy-vline
WA_FSH_SELVALUES_S_STR-P_STHEME sy-vline
WA_FSH_SELVALUES_S_STR-P_BATCH sy-vline
WA_FSH_SELVALUES_S_STR-P_BEDAT sy-vline
WA_FSH_SELVALUES_S_STR-P_EINDTS sy-vline
WA_FSH_SELVALUES_S_STR-P_OTDBS sy-vline
WA_FSH_SELVALUES_S_STR-P_MG_AT1 sy-vline
WA_FSH_SELVALUES_S_STR-P_MG_AT2 sy-vline
WA_FSH_SELVALUES_S_STR-P_MG_AT3 sy-vline
WA_FSH_SELVALUES_S_STR-P_COLOR sy-vline
WA_FSH_SELVALUES_S_STR-P_SIZE1 sy-vline
WA_FSH_SELVALUES_S_STR-P_SIZE2 sy-vline
WA_FSH_SELVALUES_S_STR-P_ARNUM sy-vline
WA_FSH_SELVALUES_S_STR-P_BSKZ sy-vline
WA_FSH_SELVALUES_S_STR-P_BSNR sy-vline
WA_FSH_SELVALUES_S_STR-P_ASTAT sy-vline
WA_FSH_SELVALUES_S_STR-P_WERKS1 sy-vline
WA_FSH_SELVALUES_S_STR-P_EORDR sy-vline
WA_FSH_SELVALUES_S_STR-P_STO sy-vline
WA_FSH_SELVALUES_S_STR-P_EXMTO sy-vline
WA_FSH_SELVALUES_S_STR-P_KUNWE sy-vline
WA_FSH_SELVALUES_S_STR-P_HRPO_R sy-vline
WA_FSH_SELVALUES_S_STR-P_EBELNR sy-vline
WA_FSH_SELVALUES_S_STR-P_BSARKR sy-vline
WA_FSH_SELVALUES_S_STR-P_LGOCOR sy-vline
WA_FSH_SELVALUES_S_STR-P_STKCTR sy-vline
WA_FSH_SELVALUES_S_STR-P_LIFCOR sy-vline
WA_FSH_SELVALUES_S_STR-P_BAPO_R sy-vline
WA_FSH_SELVALUES_S_STR-P_DYPO_R sy-vline
WA_FSH_SELVALUES_S_STR-P_DPO_R sy-vline
WA_FSH_SELVALUES_S_STR-P_ST_LOC sy-vline
WA_FSH_SELVALUES_S_STR-P_BDART sy-vline
WA_FSH_SELVALUES_S_STR-P_RETPO sy-vline
WA_FSH_SELVALUES_S_STR-P_PLGORT sy-vline
WA_FSH_SELVALUES_S_STR-P_PSCAT sy-vline
WA_FSH_SELVALUES_S_STR-P_PAUFNR sy-vline
WA_FSH_SELVALUES_S_STR-P_DGLTP sy-vline
WA_FSH_SELVALUES_S_STR-P_PHRZPO sy-vline
WA_FSH_SELVALUES_S_STR-P_PBASPO sy-vline
WA_FSH_SELVALUES_S_STR-P_PDYSPO sy-vline
WA_FSH_SELVALUES_S_STR-P_PDYAPO sy-vline
WA_FSH_SELVALUES_S_STR-P_SUBCPO sy-vline
WA_FSH_SELVALUES_S_STR-P_SUBNO sy-vline
WA_FSH_SELVALUES_S_STR-P_SUBVEN sy-vline
WA_FSH_SELVALUES_S_STR-P_SUBRQD sy-vline
WA_FSH_SELVALUES_S_STR-P_SUBLRQ sy-vline
WA_FSH_SELVALUES_S_STR-P_SUBSGT sy-vline
WA_FSH_SELVALUES_S_STR-P_SDOCTP sy-vline
WA_FSH_SELVALUES_S_STR-P_OS_ID sy-vline
WA_FSH_SELVALUES_S_STR-P_SOS_ID sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.
