ABAP Select data from SAP table RFFBWE 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 RFFBWE 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 RFFBWE. 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 RFFBWE 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_RFFBWE TYPE STANDARD TABLE OF RFFBWE,
      WA_RFFBWE TYPE RFFBWE,
      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: <RFFBWE> TYPE RFFBWE.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM RFFBWE
*  INTO TABLE @DATA(IT_RFFBWE2).
*--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_RFFBWE INDEX 1 INTO DATA(WA_RFFBWE2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<RFFBWE>-ALTXB = 1.
<RFFBWE>-ANZAW = 1.
<RFFBWE>-ANZEW = 1.
<RFFBWE>-ADRID = 1.
<RFFBWE>-BANKG = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_RFFBWE-BANKN, sy-vline,
  WA_RFFBWE-BEBIS, sy-vline,
  WA_RFFBWE-BEVON, sy-vline,
  WA_RFFBWE-BELNR, sy-vline,
  WA_RFFBWE-BHOST, sy-vline,
  WA_RFFBWE-BILD1, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_RFFBWE 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_RFFBWE 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_RFFBWE INTO WA_RFFBWE.


*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 ALPHA, internal->external for field BEBIS
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_RFFBWE-BEBIS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RFFBWE-BEBIS.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit AU132, internal->external for field MINBT
CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT'
  EXPORTING
    input =                      WA_RFFBWE-MINBT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RFFBWE-MINBT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit SPDEV, internal->external for field PRINT
CALL FUNCTION 'CONVERSION_EXIT_SPDEV_OUTPUT'
  EXPORTING
    input =                      WA_RFFBWE-PRINT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RFFBWE-PRINT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU132, internal->external for field SUGEB
CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT'
  EXPORTING
    input =                      WA_RFFBWE-SUGEB
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RFFBWE-SUGEB.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU132, internal->external for field SUGED
CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT'
  EXPORTING
    input =                      WA_RFFBWE-SUGED
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RFFBWE-SUGED.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU152, internal->external for field SURES
CALL FUNCTION 'CONVERSION_EXIT_AU152_OUTPUT'
  EXPORTING
    input =                      WA_RFFBWE-SURES
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RFFBWE-SURES.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU152, internal->external for field SUZUG
CALL FUNCTION 'CONVERSION_EXIT_AU152_OUTPUT'
  EXPORTING
    input =                      WA_RFFBWE-SUZUG
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RFFBWE-SUZUG.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit AU132, internal->external for field WRBT1
CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT'
  EXPORTING
    input =                      WA_RFFBWE-WRBT1
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RFFBWE-WRBT1.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU132, internal->external for field WRBT2
CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT'
  EXPORTING
    input =                      WA_RFFBWE-WRBT2
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RFFBWE-WRBT2.
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_RFFBWE_STR, 
ALTXB TYPE STRING,
ANZAW TYPE STRING,
ANZEW TYPE STRING,
ADRID TYPE STRING,
BANKG TYPE STRING,
BANKN TYPE STRING,
BEBIS TYPE STRING,
BEVON TYPE STRING,
BELNR TYPE STRING,
BHOST TYPE STRING,
BILD1 TYPE STRING,
BISFK TYPE STRING,
BLART TYPE STRING,
BLAR1 TYPE STRING,
BLAR2 TYPE STRING,
BLAR3 TYPE STRING,
BLDAT TYPE STRING,
BUDAT TYPE STRING,
BUKRS TYPE STRING,
BWKT1 TYPE STRING,
BWKT2 TYPE STRING,
DMBTR TYPE STRING,
DIRBU TYPE STRING,
DTAFI TYPE STRING,
DTATY TYPE STRING,
EINDT TYPE STRING,
FORAC TYPE STRING,
FORID TYPE STRING,
FORNR TYPE STRING,
FWAER TYPE STRING,
GROUP TYPE STRING,
GSBE1 TYPE STRING,
HBKID TYPE STRING,
HKTID TYPE STRING,
IDNTB TYPE STRING,
IDNTK TYPE STRING,
JOBDT TYPE STRING,
JOBIM TYPE STRING,
JOBNA TYPE STRING,
JOBST TYPE STRING,
JOBTM TYPE STRING,
KOART TYPE STRING,
LAUFD TYPE STRING,
LAUFD1 TYPE STRING,
LAUFI TYPE STRING,
LAUFI1 TYPE STRING,
LFDNR TYPE STRING,
LIFNR TYPE STRING,
LISEP TYPE STRING,
LSZSL TYPE STRING,
MARKS TYPE STRING,
MET01 TYPE STRING,
MET02 TYPE STRING,
MET03 TYPE STRING,
MET04 TYPE STRING,
MET05 TYPE STRING,
MINBT TYPE STRING,
NATIO TYPE STRING,
PATH TYPE STRING,
PRIMM TYPE STRING,
PRINT TYPE STRING,
PROTO TYPE STRING,
PROXB TYPE STRING,
REGIO TYPE STRING,
REGI1 TYPE STRING,
SAMBU TYPE STRING,
SAPSC TYPE STRING,
SHKZ TYPE STRING,
STRIN TYPE STRING,
SUGEB TYPE STRING,
SUGED TYPE STRING,
SUMME TYPE STRING,
SURES TYPE STRING,
SUZUG TYPE STRING,
UMSKZ TYPE STRING,
VARIA TYPE STRING,
VARTI TYPE STRING,
VONFK TYPE STRING,
VERWE TYPE STRING,
WAERS TYPE STRING,
WBANK TYPE STRING,
WBZOG TYPE STRING,
WEDRU TYPE STRING,
WEKON TYPE STRING,
WORT2 TYPE STRING,
WPHYS TYPE STRING,
WRBTR TYPE STRING,
WRBT1 TYPE STRING,
WRBT2 TYPE STRING,
XBVON TYPE STRING,
XBLNR TYPE STRING,
XBBIS TYPE STRING,
XBUCH TYPE STRING,
XFEES TYPE STRING,
XGEBU TYPE STRING,
XSHKZ TYPE STRING,
XSWDR TYPE STRING,
XSWEX TYPE STRING,
ZFBDT TYPE STRING,
ZUONR TYPE STRING,
ZWEDD TYPE STRING,
ZWEDT TYPE STRING,
ZWELS TYPE STRING,
FORMT TYPE STRING,
MET06 TYPE STRING,
FORMI TYPE STRING,
ZLSCH TYPE STRING,END OF T_EKKO_STR.
DATA: WA_RFFBWE_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_RFFBWE_STR-ALTXB sy-vline 
WA_RFFBWE_STR-ANZAW sy-vline 
WA_RFFBWE_STR-ANZEW sy-vline 
WA_RFFBWE_STR-ADRID sy-vline 
WA_RFFBWE_STR-BANKG sy-vline 
WA_RFFBWE_STR-BANKN sy-vline 
WA_RFFBWE_STR-BEBIS sy-vline 
WA_RFFBWE_STR-BEVON sy-vline 
WA_RFFBWE_STR-BELNR sy-vline 
WA_RFFBWE_STR-BHOST sy-vline 
WA_RFFBWE_STR-BILD1 sy-vline 
WA_RFFBWE_STR-BISFK sy-vline 
WA_RFFBWE_STR-BLART sy-vline 
WA_RFFBWE_STR-BLAR1 sy-vline 
WA_RFFBWE_STR-BLAR2 sy-vline 
WA_RFFBWE_STR-BLAR3 sy-vline 
WA_RFFBWE_STR-BLDAT sy-vline 
WA_RFFBWE_STR-BUDAT sy-vline 
WA_RFFBWE_STR-BUKRS sy-vline 
WA_RFFBWE_STR-BWKT1 sy-vline 
WA_RFFBWE_STR-BWKT2 sy-vline 
WA_RFFBWE_STR-DMBTR sy-vline 
WA_RFFBWE_STR-DIRBU sy-vline 
WA_RFFBWE_STR-DTAFI sy-vline 
WA_RFFBWE_STR-DTATY sy-vline 
WA_RFFBWE_STR-EINDT sy-vline 
WA_RFFBWE_STR-FORAC sy-vline 
WA_RFFBWE_STR-FORID sy-vline 
WA_RFFBWE_STR-FORNR sy-vline 
WA_RFFBWE_STR-FWAER sy-vline 
WA_RFFBWE_STR-GROUP sy-vline 
WA_RFFBWE_STR-GSBE1 sy-vline 
WA_RFFBWE_STR-HBKID sy-vline 
WA_RFFBWE_STR-HKTID sy-vline 
WA_RFFBWE_STR-IDNTB sy-vline 
WA_RFFBWE_STR-IDNTK sy-vline 
WA_RFFBWE_STR-JOBDT sy-vline 
WA_RFFBWE_STR-JOBIM sy-vline 
WA_RFFBWE_STR-JOBNA sy-vline 
WA_RFFBWE_STR-JOBST sy-vline 
WA_RFFBWE_STR-JOBTM sy-vline 
WA_RFFBWE_STR-KOART sy-vline 
WA_RFFBWE_STR-LAUFD sy-vline 
WA_RFFBWE_STR-LAUFD1 sy-vline 
WA_RFFBWE_STR-LAUFI sy-vline 
WA_RFFBWE_STR-LAUFI1 sy-vline 
WA_RFFBWE_STR-LFDNR sy-vline 
WA_RFFBWE_STR-LIFNR sy-vline 
WA_RFFBWE_STR-LISEP sy-vline 
WA_RFFBWE_STR-LSZSL sy-vline 
WA_RFFBWE_STR-MARKS sy-vline 
WA_RFFBWE_STR-MET01 sy-vline 
WA_RFFBWE_STR-MET02 sy-vline 
WA_RFFBWE_STR-MET03 sy-vline 
WA_RFFBWE_STR-MET04 sy-vline 
WA_RFFBWE_STR-MET05 sy-vline 
WA_RFFBWE_STR-MINBT sy-vline 
WA_RFFBWE_STR-NATIO sy-vline 
WA_RFFBWE_STR-PATH sy-vline 
WA_RFFBWE_STR-PRIMM sy-vline 
WA_RFFBWE_STR-PRINT sy-vline 
WA_RFFBWE_STR-PROTO sy-vline 
WA_RFFBWE_STR-PROXB sy-vline 
WA_RFFBWE_STR-REGIO sy-vline 
WA_RFFBWE_STR-REGI1 sy-vline 
WA_RFFBWE_STR-SAMBU sy-vline 
WA_RFFBWE_STR-SAPSC sy-vline 
WA_RFFBWE_STR-SHKZ sy-vline 
WA_RFFBWE_STR-STRIN sy-vline 
WA_RFFBWE_STR-SUGEB sy-vline 
WA_RFFBWE_STR-SUGED sy-vline 
WA_RFFBWE_STR-SUMME sy-vline 
WA_RFFBWE_STR-SURES sy-vline 
WA_RFFBWE_STR-SUZUG sy-vline 
WA_RFFBWE_STR-UMSKZ sy-vline 
WA_RFFBWE_STR-VARIA sy-vline 
WA_RFFBWE_STR-VARTI sy-vline 
WA_RFFBWE_STR-VONFK sy-vline 
WA_RFFBWE_STR-VERWE sy-vline 
WA_RFFBWE_STR-WAERS sy-vline 
WA_RFFBWE_STR-WBANK sy-vline 
WA_RFFBWE_STR-WBZOG sy-vline 
WA_RFFBWE_STR-WEDRU sy-vline 
WA_RFFBWE_STR-WEKON sy-vline 
WA_RFFBWE_STR-WORT2 sy-vline 
WA_RFFBWE_STR-WPHYS sy-vline 
WA_RFFBWE_STR-WRBTR sy-vline 
WA_RFFBWE_STR-WRBT1 sy-vline 
WA_RFFBWE_STR-WRBT2 sy-vline 
WA_RFFBWE_STR-XBVON sy-vline 
WA_RFFBWE_STR-XBLNR sy-vline 
WA_RFFBWE_STR-XBBIS sy-vline 
WA_RFFBWE_STR-XBUCH sy-vline 
WA_RFFBWE_STR-XFEES sy-vline 
WA_RFFBWE_STR-XGEBU sy-vline 
WA_RFFBWE_STR-XSHKZ sy-vline 
WA_RFFBWE_STR-XSWDR sy-vline 
WA_RFFBWE_STR-XSWEX sy-vline 
WA_RFFBWE_STR-ZFBDT sy-vline 
WA_RFFBWE_STR-ZUONR sy-vline 
WA_RFFBWE_STR-ZWEDD sy-vline 
WA_RFFBWE_STR-ZWEDT sy-vline 
WA_RFFBWE_STR-ZWELS sy-vline 
WA_RFFBWE_STR-FORMT sy-vline 
WA_RFFBWE_STR-MET06 sy-vline 
WA_RFFBWE_STR-FORMI sy-vline 
WA_RFFBWE_STR-ZLSCH sy-vline      INTO ld_text SEPARATED BY SPACE.

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