ABAP Select data from SAP table WSAF_S_F1_HELP 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 WSAF_S_F1_HELP 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 WSAF_S_F1_HELP. 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 WSAF_S_F1_HELP 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_WSAF_S_F1_HELP TYPE STANDARD TABLE OF WSAF_S_F1_HELP,
      WA_WSAF_S_F1_HELP TYPE WSAF_S_F1_HELP,
      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: <WSAF_S_F1_HELP> TYPE WSAF_S_F1_HELP.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM WSAF_S_F1_HELP
*  INTO TABLE @DATA(IT_WSAF_S_F1_HELP2).
*--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_WSAF_S_F1_HELP INDEX 1 INTO DATA(WA_WSAF_S_F1_HELP2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<WSAF_S_F1_HELP>-ITEM = 1.
<WSAF_S_F1_HELP>-PREDECITEM = 1.
<WSAF_S_F1_HELP>-EXCLUDE = 1.
<WSAF_S_F1_HELP>-SUPPLIER = 1.
<WSAF_S_F1_HELP>-DELETED = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_WSAF_S_F1_HELP-VARIANT_SAF, sy-vline,
  WA_WSAF_S_F1_HELP-SCHEDVALUE, sy-vline,
  WA_WSAF_S_F1_HELP-WSAF_SCHEDVALUE, sy-vline,
  WA_WSAF_S_F1_HELP-SUBSUPPLIER, sy-vline,
  WA_WSAF_S_F1_HELP-PARAMGROUP, sy-vline,
  WA_WSAF_S_F1_HELP-MAXSTOCK, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_WSAF_S_F1_HELP 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_WSAF_S_F1_HELP 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_WSAF_S_F1_HELP INTO WA_WSAF_S_F1_HELP.


*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 MATN1, internal->external for field ITEM
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_WSAF_S_F1_HELP-ITEM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WSAF_S_F1_HELP-ITEM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN1, internal->external for field PREDECITEM
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_WSAF_S_F1_HELP-PREDECITEM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WSAF_S_F1_HELP-PREDECITEM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field SUPPLIER
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_WSAF_S_F1_HELP-SUPPLIER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WSAF_S_F1_HELP-SUPPLIER.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN1, internal->external for field VARIANT_SAF
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_WSAF_S_F1_HELP-VARIANT_SAF
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WSAF_S_F1_HELP-VARIANT_SAF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field SUBSUPPLIER
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_WSAF_S_F1_HELP-SUBSUPPLIER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WSAF_S_F1_HELP-SUBSUPPLIER.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN1, internal->external for field PREDECVARIANT
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_WSAF_S_F1_HELP-PREDECVARIANT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WSAF_S_F1_HELP-PREDECVARIANT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field WSAF_LOGUNITS
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_WSAF_S_F1_HELP-WSAF_LOGUNITS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_WSAF_S_F1_HELP-WSAF_LOGUNITS.
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_WSAF_S_F1_HELP_STR, 
ITEM TYPE STRING,
PREDECITEM TYPE STRING,
EXCLUDE TYPE STRING,
SUPPLIER TYPE STRING,
DELETED TYPE STRING,
VARIANT_SAF TYPE STRING,
SCHEDVALUE TYPE STRING,
WSAF_SCHEDVALUE TYPE STRING,
SUBSUPPLIER TYPE STRING,
PARAMGROUP TYPE STRING,
MAXSTOCK TYPE STRING,
PRESSTOCK TYPE STRING,
DYNPRESSTOCKAVG TYPE STRING,
DYNPRESSTOCKVAR TYPE STRING,
DELIVDAYS TYPE STRING,
AVAILDAYS TYPE STRING,
EXPIRATION TYPE STRING,
ORDCLASS TYPE STRING,
PREDECVARIANT TYPE STRING,
PURCHPRICE TYPE STRING,
SALEPRICE TYPE STRING,
WEIGHT TYPE STRING,
DISPOTYPE TYPE STRING,
SCALEFACTOR TYPE STRING,
ASSORTLEV TYPE STRING,
WSAF_ASSORTLEV TYPE STRING,
LOGUNITS TYPE STRING,
WSAF_LOGUNITS TYPE STRING,
PURCHUNIT TYPE STRING,
STOCKBASE TYPE STRING,
MINORDAMOUNT TYPE STRING,
ACTIVATIONDATE TYPE STRING,
TEMPACTIVE TYPE STRING,
DEACTIVATIONDATE TYPE STRING,
DATE_SAF TYPE STRING,
SALES TYPE STRING,
EVENTNO TYPE STRING,
DATEFROM TYPE STRING,
DATETO TYPE STRING,
PREDICTOR TYPE STRING,
VALIDFROM TYPE STRING,
VALIDTO TYPE STRING,
PREDICTVAL TYPE STRING,
SALESPERIOD TYPE STRING,
MINORDTYPE TYPE STRING,
MINORDSUBTYPE TYPE STRING,
MINORDVAL TYPE STRING,
BEGINHOLIDAY TYPE STRING,
WSAF_BEGINHOLIDAY TYPE STRING,
ENDHOLIDAY TYPE STRING,
WSAF_ENDHOLIDAY TYPE STRING,
BRACKETTYPE TYPE STRING,
BRACKETSUBTYPE TYPE STRING,
BRACKETFILLUPLIMIT TYPE STRING,
BRACKETLOW TYPE STRING,
BRACKETHIGH TYPE STRING,
BRACKETDISCOUNT TYPE STRING,
NUMSALESDAYS TYPE STRING,
WSAF_NUMSALESDAYS TYPE STRING,
CALEVNTN TYPE STRING,
CHECKSUM TYPE STRING,
ESTMETHOD TYPE STRING,
CLASSMEAN TYPE STRING,
FORECAST TYPE STRING,
VARIANCE TYPE STRING,
DAYWEIGHTMONDAY TYPE STRING,
DAYWEIGHTTUESDAY TYPE STRING,
DAYWEIGHTWEDNESDAY TYPE STRING,
DAYWEIGHTTHURSDAY TYPE STRING,
DAYWEIGHTFRIDAY TYPE STRING,
DAYWEIGHTSATURDAY TYPE STRING,
DAYWEIGHTSUNDAY TYPE STRING,
NUMZEROSTOCKS TYPE STRING,
EVERSTOCKED TYPE STRING,
VNUMZEROSTOCKS TYPE STRING,
ORDERDATE TYPE STRING,
AVAILDATE TYPE STRING,
ACCUMDMND TYPE STRING,
DELIVDATE TYPE STRING,
AVGSALES TYPE STRING,
MAXFRESHQTY TYPE STRING,
MAXSTOCKQTY TYPE STRING,
MAXTEMPQTY TYPE STRING,
CALCULATIONDATE TYPE STRING,
AVERAGE TYPE STRING,
STDDEV TYPE STRING,
CLASSINDEX TYPE STRING,
MINSALES TYPE STRING,
MAXSALES TYPE STRING,
CURRSALES TYPE STRING,
CURRFCST TYPE STRING,
NUMOBSERV TYPE STRING,
NUMOUTLIERS TYPE STRING,
NUMZEROSALES TYPE STRING,
EXCPTLEV TYPE STRING,
EXCEPTION_SAF TYPE STRING,
FCSTPERIOD TYPE STRING,
MEANFCST TYPE STRING,
MAXFCST TYPE STRING,
PREDHPER TYPE STRING,
FCSTDAY TYPE STRING,
DAYMEANFCST TYPE STRING,
PARAMINDEX TYPE STRING,
PREDIGNLASTRUN TYPE STRING,
DYNMINMEAN TYPE STRING,
DYNMINDEV TYPE STRING,
DYNPRESSTOCK TYPE STRING,
EFFPRESSTOCK TYPE STRING,
STOCKDATE TYPE STRING,
STOCK TYPE STRING,
DEMAND TYPE STRING,
DAYSALES TYPE STRING,
PASTMEANFCST TYPE STRING,
PASTFCSTPERIOD TYPE STRING,
LISTDATE TYPE STRING,
LISTOUT TYPE STRING,END OF T_EKKO_STR.
DATA: WA_WSAF_S_F1_HELP_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_WSAF_S_F1_HELP_STR-ITEM sy-vline 
WA_WSAF_S_F1_HELP_STR-PREDECITEM sy-vline 
WA_WSAF_S_F1_HELP_STR-EXCLUDE sy-vline 
WA_WSAF_S_F1_HELP_STR-SUPPLIER sy-vline 
WA_WSAF_S_F1_HELP_STR-DELETED sy-vline 
WA_WSAF_S_F1_HELP_STR-VARIANT_SAF sy-vline 
WA_WSAF_S_F1_HELP_STR-SCHEDVALUE sy-vline 
WA_WSAF_S_F1_HELP_STR-WSAF_SCHEDVALUE sy-vline 
WA_WSAF_S_F1_HELP_STR-SUBSUPPLIER sy-vline 
WA_WSAF_S_F1_HELP_STR-PARAMGROUP sy-vline 
WA_WSAF_S_F1_HELP_STR-MAXSTOCK sy-vline 
WA_WSAF_S_F1_HELP_STR-PRESSTOCK sy-vline 
WA_WSAF_S_F1_HELP_STR-DYNPRESSTOCKAVG sy-vline 
WA_WSAF_S_F1_HELP_STR-DYNPRESSTOCKVAR sy-vline 
WA_WSAF_S_F1_HELP_STR-DELIVDAYS sy-vline 
WA_WSAF_S_F1_HELP_STR-AVAILDAYS sy-vline 
WA_WSAF_S_F1_HELP_STR-EXPIRATION sy-vline 
WA_WSAF_S_F1_HELP_STR-ORDCLASS sy-vline 
WA_WSAF_S_F1_HELP_STR-PREDECVARIANT sy-vline 
WA_WSAF_S_F1_HELP_STR-PURCHPRICE sy-vline 
WA_WSAF_S_F1_HELP_STR-SALEPRICE sy-vline 
WA_WSAF_S_F1_HELP_STR-WEIGHT sy-vline 
WA_WSAF_S_F1_HELP_STR-DISPOTYPE sy-vline 
WA_WSAF_S_F1_HELP_STR-SCALEFACTOR sy-vline 
WA_WSAF_S_F1_HELP_STR-ASSORTLEV sy-vline 
WA_WSAF_S_F1_HELP_STR-WSAF_ASSORTLEV sy-vline 
WA_WSAF_S_F1_HELP_STR-LOGUNITS sy-vline 
WA_WSAF_S_F1_HELP_STR-WSAF_LOGUNITS sy-vline 
WA_WSAF_S_F1_HELP_STR-PURCHUNIT sy-vline 
WA_WSAF_S_F1_HELP_STR-STOCKBASE sy-vline 
WA_WSAF_S_F1_HELP_STR-MINORDAMOUNT sy-vline 
WA_WSAF_S_F1_HELP_STR-ACTIVATIONDATE sy-vline 
WA_WSAF_S_F1_HELP_STR-TEMPACTIVE sy-vline 
WA_WSAF_S_F1_HELP_STR-DEACTIVATIONDATE sy-vline 
WA_WSAF_S_F1_HELP_STR-DATE_SAF sy-vline 
WA_WSAF_S_F1_HELP_STR-SALES sy-vline 
WA_WSAF_S_F1_HELP_STR-EVENTNO sy-vline 
WA_WSAF_S_F1_HELP_STR-DATEFROM sy-vline 
WA_WSAF_S_F1_HELP_STR-DATETO sy-vline 
WA_WSAF_S_F1_HELP_STR-PREDICTOR sy-vline 
WA_WSAF_S_F1_HELP_STR-VALIDFROM sy-vline 
WA_WSAF_S_F1_HELP_STR-VALIDTO sy-vline 
WA_WSAF_S_F1_HELP_STR-PREDICTVAL sy-vline 
WA_WSAF_S_F1_HELP_STR-SALESPERIOD sy-vline 
WA_WSAF_S_F1_HELP_STR-MINORDTYPE sy-vline 
WA_WSAF_S_F1_HELP_STR-MINORDSUBTYPE sy-vline 
WA_WSAF_S_F1_HELP_STR-MINORDVAL sy-vline 
WA_WSAF_S_F1_HELP_STR-BEGINHOLIDAY sy-vline 
WA_WSAF_S_F1_HELP_STR-WSAF_BEGINHOLIDAY sy-vline 
WA_WSAF_S_F1_HELP_STR-ENDHOLIDAY sy-vline 
WA_WSAF_S_F1_HELP_STR-WSAF_ENDHOLIDAY sy-vline 
WA_WSAF_S_F1_HELP_STR-BRACKETTYPE sy-vline 
WA_WSAF_S_F1_HELP_STR-BRACKETSUBTYPE sy-vline 
WA_WSAF_S_F1_HELP_STR-BRACKETFILLUPLIMIT sy-vline 
WA_WSAF_S_F1_HELP_STR-BRACKETLOW sy-vline 
WA_WSAF_S_F1_HELP_STR-BRACKETHIGH sy-vline 
WA_WSAF_S_F1_HELP_STR-BRACKETDISCOUNT sy-vline 
WA_WSAF_S_F1_HELP_STR-NUMSALESDAYS sy-vline 
WA_WSAF_S_F1_HELP_STR-WSAF_NUMSALESDAYS sy-vline 
WA_WSAF_S_F1_HELP_STR-CALEVNTN sy-vline 
WA_WSAF_S_F1_HELP_STR-CHECKSUM sy-vline 
WA_WSAF_S_F1_HELP_STR-ESTMETHOD sy-vline 
WA_WSAF_S_F1_HELP_STR-CLASSMEAN sy-vline 
WA_WSAF_S_F1_HELP_STR-FORECAST sy-vline 
WA_WSAF_S_F1_HELP_STR-VARIANCE sy-vline 
WA_WSAF_S_F1_HELP_STR-DAYWEIGHTMONDAY sy-vline 
WA_WSAF_S_F1_HELP_STR-DAYWEIGHTTUESDAY sy-vline 
WA_WSAF_S_F1_HELP_STR-DAYWEIGHTWEDNESDAY sy-vline 
WA_WSAF_S_F1_HELP_STR-DAYWEIGHTTHURSDAY sy-vline 
WA_WSAF_S_F1_HELP_STR-DAYWEIGHTFRIDAY sy-vline 
WA_WSAF_S_F1_HELP_STR-DAYWEIGHTSATURDAY sy-vline 
WA_WSAF_S_F1_HELP_STR-DAYWEIGHTSUNDAY sy-vline 
WA_WSAF_S_F1_HELP_STR-NUMZEROSTOCKS sy-vline 
WA_WSAF_S_F1_HELP_STR-EVERSTOCKED sy-vline 
WA_WSAF_S_F1_HELP_STR-VNUMZEROSTOCKS sy-vline 
WA_WSAF_S_F1_HELP_STR-ORDERDATE sy-vline 
WA_WSAF_S_F1_HELP_STR-AVAILDATE sy-vline 
WA_WSAF_S_F1_HELP_STR-ACCUMDMND sy-vline 
WA_WSAF_S_F1_HELP_STR-DELIVDATE sy-vline 
WA_WSAF_S_F1_HELP_STR-AVGSALES sy-vline 
WA_WSAF_S_F1_HELP_STR-MAXFRESHQTY sy-vline 
WA_WSAF_S_F1_HELP_STR-MAXSTOCKQTY sy-vline 
WA_WSAF_S_F1_HELP_STR-MAXTEMPQTY sy-vline 
WA_WSAF_S_F1_HELP_STR-CALCULATIONDATE sy-vline 
WA_WSAF_S_F1_HELP_STR-AVERAGE sy-vline 
WA_WSAF_S_F1_HELP_STR-STDDEV sy-vline 
WA_WSAF_S_F1_HELP_STR-CLASSINDEX sy-vline 
WA_WSAF_S_F1_HELP_STR-MINSALES sy-vline 
WA_WSAF_S_F1_HELP_STR-MAXSALES sy-vline 
WA_WSAF_S_F1_HELP_STR-CURRSALES sy-vline 
WA_WSAF_S_F1_HELP_STR-CURRFCST sy-vline 
WA_WSAF_S_F1_HELP_STR-NUMOBSERV sy-vline 
WA_WSAF_S_F1_HELP_STR-NUMOUTLIERS sy-vline 
WA_WSAF_S_F1_HELP_STR-NUMZEROSALES sy-vline 
WA_WSAF_S_F1_HELP_STR-EXCPTLEV sy-vline 
WA_WSAF_S_F1_HELP_STR-EXCEPTION_SAF sy-vline 
WA_WSAF_S_F1_HELP_STR-FCSTPERIOD sy-vline 
WA_WSAF_S_F1_HELP_STR-MEANFCST sy-vline 
WA_WSAF_S_F1_HELP_STR-MAXFCST sy-vline 
WA_WSAF_S_F1_HELP_STR-PREDHPER sy-vline 
WA_WSAF_S_F1_HELP_STR-FCSTDAY sy-vline 
WA_WSAF_S_F1_HELP_STR-DAYMEANFCST sy-vline 
WA_WSAF_S_F1_HELP_STR-PARAMINDEX sy-vline 
WA_WSAF_S_F1_HELP_STR-PREDIGNLASTRUN sy-vline 
WA_WSAF_S_F1_HELP_STR-DYNMINMEAN sy-vline 
WA_WSAF_S_F1_HELP_STR-DYNMINDEV sy-vline 
WA_WSAF_S_F1_HELP_STR-DYNPRESSTOCK sy-vline 
WA_WSAF_S_F1_HELP_STR-EFFPRESSTOCK sy-vline 
WA_WSAF_S_F1_HELP_STR-STOCKDATE sy-vline 
WA_WSAF_S_F1_HELP_STR-STOCK sy-vline 
WA_WSAF_S_F1_HELP_STR-DEMAND sy-vline 
WA_WSAF_S_F1_HELP_STR-DAYSALES sy-vline 
WA_WSAF_S_F1_HELP_STR-PASTMEANFCST sy-vline 
WA_WSAF_S_F1_HELP_STR-PASTFCSTPERIOD sy-vline 
WA_WSAF_S_F1_HELP_STR-LISTDATE sy-vline 
WA_WSAF_S_F1_HELP_STR-LISTOUT sy-vline      INTO ld_text SEPARATED BY SPACE.

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