ABAP Select data from SAP table RFVIFUEBI 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 RFVIFUEBI 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 RFVIFUEBI. 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 RFVIFUEBI 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_RFVIFUEBI TYPE STANDARD TABLE OF RFVIFUEBI,
      WA_RFVIFUEBI TYPE RFVIFUEBI,
      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: <RFVIFUEBI> TYPE RFVIFUEBI.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM RFVIFUEBI
*  INTO TABLE @DATA(IT_RFVIFUEBI2).
*--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_RFVIFUEBI INDEX 1 INTO DATA(WA_RFVIFUEBI2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<RFVIFUEBI>-ALZBSPFB = 1.
<RFVIFUEBI>-ALZBBSTA = 1.
<RFVIFUEBI>-BKBSSPFB = 1.
<RFVIFUEBI>-BKBSBSTA = 1.
<RFVIFUEBI>-GMVASPFB = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_RFVIFUEBI-GMVABSTA, sy-vline,
  WA_RFVIFUEBI-GAMVSPFB, sy-vline,
  WA_RFVIFUEBI-GAMVBSTA, sy-vline,
  WA_RFVIFUEBI-NKABSPFB, sy-vline,
  WA_RFVIFUEBI-NKABBSTA, sy-vline,
  WA_RFVIFUEBI-NKANSPFB, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_RFVIFUEBI 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_RFVIFUEBI 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_RFVIFUEBI INTO WA_RFVIFUEBI.


*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_RFVIFUEBI_STR, 
ALZBSPFB TYPE STRING,
ALZBBSTA TYPE STRING,
BKBSSPFB TYPE STRING,
BKBSBSTA TYPE STRING,
GMVASPFB TYPE STRING,
GMVABSTA TYPE STRING,
GAMVSPFB TYPE STRING,
GAMVBSTA TYPE STRING,
NKABSPFB TYPE STRING,
NKABBSTA TYPE STRING,
NKANSPFB TYPE STRING,
NKANBSTA TYPE STRING,
PEBSSPFB TYPE STRING,
PEBSBSTA TYPE STRING,
WMVASPFB TYPE STRING,
WMVABSTA TYPE STRING,
WOMVSPFB TYPE STRING,
WOMVBSTA TYPE STRING,
BAEMSPFB TYPE STRING,
BAEMBSTA TYPE STRING,
BAENSPFB TYPE STRING,
BAENBSTA TYPE STRING,
MSPMSPFB TYPE STRING,
MSPMBSTA TYPE STRING,
VMIMSPFB TYPE STRING,
VMIMBSTA TYPE STRING,
SOSTSPFB TYPE STRING,
SOSTBSTA TYPE STRING,
FGEWSPFB TYPE STRING,
FGEWBSTA TYPE STRING,
FWHNSPFB TYPE STRING,
FWHNBSTA TYPE STRING,
ANPGSPFB TYPE STRING,
ANPGBSTA TYPE STRING,
MKWDSPFB TYPE STRING,
MKWDBSTA TYPE STRING,
MKNWSPFB TYPE STRING,
MKNWBSTA TYPE STRING,
ANPISPFB TYPE STRING,
ANPIBSTA TYPE STRING,
ANPNBSTA TYPE STRING,
GEMVSPFB TYPE STRING,
GEMVBSTA TYPE STRING,
GEMASPFB TYPE STRING,
GEMABSTA TYPE STRING,
ANPZSPFB TYPE STRING,
ANPZBSTA TYPE STRING,
AGUTSPFB TYPE STRING,
AGUTBSTA TYPE STRING,
MWFKSPFB TYPE STRING,
MWFKBSTA TYPE STRING,
ANGASPFB TYPE STRING,
ANGABSTA TYPE STRING,
INTRSPFB TYPE STRING,
INTRBSTA TYPE STRING,
KOBLSPFB TYPE STRING,
KOBLBSTA TYPE STRING,
MVAGSPFB TYPE STRING,
MVAGBSTA TYPE STRING,
WBNLSPFB TYPE STRING,
WBNLBSTA TYPE STRING,
MKVMSPFB TYPE STRING,
MKVMBSTA TYPE STRING,
RADJSPFB TYPE STRING,
RADJBSTA TYPE STRING,
SLSTSPFB TYPE STRING,
SLSTBSTA TYPE STRING,
WB4_SPFB TYPE STRING,
WB4_BSTA TYPE STRING,
EABRSPFB TYPE STRING,
EABRBSTA TYPE STRING,
F001SPFB TYPE STRING,
F001BSTA TYPE STRING,
EAABSPFB TYPE STRING,
EAABBSTA TYPE STRING,
RACCSPFB TYPE STRING,
RACCBSTA TYPE STRING,
MEABSPFB TYPE STRING,
MEABBSTA TYPE STRING,
RADJDUNNSPFB TYPE STRING,
RADJDUNNBSTA TYPE STRING,
RCCOLLATERALSPFB TYPE STRING,
RCCOLLATERALBSTA TYPE STRING,END OF T_EKKO_STR.
DATA: WA_RFVIFUEBI_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_RFVIFUEBI_STR-ALZBSPFB sy-vline 
WA_RFVIFUEBI_STR-ALZBBSTA sy-vline 
WA_RFVIFUEBI_STR-BKBSSPFB sy-vline 
WA_RFVIFUEBI_STR-BKBSBSTA sy-vline 
WA_RFVIFUEBI_STR-GMVASPFB sy-vline 
WA_RFVIFUEBI_STR-GMVABSTA sy-vline 
WA_RFVIFUEBI_STR-GAMVSPFB sy-vline 
WA_RFVIFUEBI_STR-GAMVBSTA sy-vline 
WA_RFVIFUEBI_STR-NKABSPFB sy-vline 
WA_RFVIFUEBI_STR-NKABBSTA sy-vline 
WA_RFVIFUEBI_STR-NKANSPFB sy-vline 
WA_RFVIFUEBI_STR-NKANBSTA sy-vline 
WA_RFVIFUEBI_STR-PEBSSPFB sy-vline 
WA_RFVIFUEBI_STR-PEBSBSTA sy-vline 
WA_RFVIFUEBI_STR-WMVASPFB sy-vline 
WA_RFVIFUEBI_STR-WMVABSTA sy-vline 
WA_RFVIFUEBI_STR-WOMVSPFB sy-vline 
WA_RFVIFUEBI_STR-WOMVBSTA sy-vline 
WA_RFVIFUEBI_STR-BAEMSPFB sy-vline 
WA_RFVIFUEBI_STR-BAEMBSTA sy-vline 
WA_RFVIFUEBI_STR-BAENSPFB sy-vline 
WA_RFVIFUEBI_STR-BAENBSTA sy-vline 
WA_RFVIFUEBI_STR-MSPMSPFB sy-vline 
WA_RFVIFUEBI_STR-MSPMBSTA sy-vline 
WA_RFVIFUEBI_STR-VMIMSPFB sy-vline 
WA_RFVIFUEBI_STR-VMIMBSTA sy-vline 
WA_RFVIFUEBI_STR-SOSTSPFB sy-vline 
WA_RFVIFUEBI_STR-SOSTBSTA sy-vline 
WA_RFVIFUEBI_STR-FGEWSPFB sy-vline 
WA_RFVIFUEBI_STR-FGEWBSTA sy-vline 
WA_RFVIFUEBI_STR-FWHNSPFB sy-vline 
WA_RFVIFUEBI_STR-FWHNBSTA sy-vline 
WA_RFVIFUEBI_STR-ANPGSPFB sy-vline 
WA_RFVIFUEBI_STR-ANPGBSTA sy-vline 
WA_RFVIFUEBI_STR-MKWDSPFB sy-vline 
WA_RFVIFUEBI_STR-MKWDBSTA sy-vline 
WA_RFVIFUEBI_STR-MKNWSPFB sy-vline 
WA_RFVIFUEBI_STR-MKNWBSTA sy-vline 
WA_RFVIFUEBI_STR-ANPISPFB sy-vline 
WA_RFVIFUEBI_STR-ANPIBSTA sy-vline 
WA_RFVIFUEBI_STR-ANPNBSTA sy-vline 
WA_RFVIFUEBI_STR-GEMVSPFB sy-vline 
WA_RFVIFUEBI_STR-GEMVBSTA sy-vline 
WA_RFVIFUEBI_STR-GEMASPFB sy-vline 
WA_RFVIFUEBI_STR-GEMABSTA sy-vline 
WA_RFVIFUEBI_STR-ANPZSPFB sy-vline 
WA_RFVIFUEBI_STR-ANPZBSTA sy-vline 
WA_RFVIFUEBI_STR-AGUTSPFB sy-vline 
WA_RFVIFUEBI_STR-AGUTBSTA sy-vline 
WA_RFVIFUEBI_STR-MWFKSPFB sy-vline 
WA_RFVIFUEBI_STR-MWFKBSTA sy-vline 
WA_RFVIFUEBI_STR-ANGASPFB sy-vline 
WA_RFVIFUEBI_STR-ANGABSTA sy-vline 
WA_RFVIFUEBI_STR-INTRSPFB sy-vline 
WA_RFVIFUEBI_STR-INTRBSTA sy-vline 
WA_RFVIFUEBI_STR-KOBLSPFB sy-vline 
WA_RFVIFUEBI_STR-KOBLBSTA sy-vline 
WA_RFVIFUEBI_STR-MVAGSPFB sy-vline 
WA_RFVIFUEBI_STR-MVAGBSTA sy-vline 
WA_RFVIFUEBI_STR-WBNLSPFB sy-vline 
WA_RFVIFUEBI_STR-WBNLBSTA sy-vline 
WA_RFVIFUEBI_STR-MKVMSPFB sy-vline 
WA_RFVIFUEBI_STR-MKVMBSTA sy-vline 
WA_RFVIFUEBI_STR-RADJSPFB sy-vline 
WA_RFVIFUEBI_STR-RADJBSTA sy-vline 
WA_RFVIFUEBI_STR-SLSTSPFB sy-vline 
WA_RFVIFUEBI_STR-SLSTBSTA sy-vline 
WA_RFVIFUEBI_STR-WB4_SPFB sy-vline 
WA_RFVIFUEBI_STR-WB4_BSTA sy-vline 
WA_RFVIFUEBI_STR-EABRSPFB sy-vline 
WA_RFVIFUEBI_STR-EABRBSTA sy-vline 
WA_RFVIFUEBI_STR-F001SPFB sy-vline 
WA_RFVIFUEBI_STR-F001BSTA sy-vline 
WA_RFVIFUEBI_STR-EAABSPFB sy-vline 
WA_RFVIFUEBI_STR-EAABBSTA sy-vline 
WA_RFVIFUEBI_STR-RACCSPFB sy-vline 
WA_RFVIFUEBI_STR-RACCBSTA sy-vline 
WA_RFVIFUEBI_STR-MEABSPFB sy-vline 
WA_RFVIFUEBI_STR-MEABBSTA sy-vline 
WA_RFVIFUEBI_STR-RADJDUNNSPFB sy-vline 
WA_RFVIFUEBI_STR-RADJDUNNBSTA sy-vline 
WA_RFVIFUEBI_STR-RCCOLLATERALSPFB sy-vline 
WA_RFVIFUEBI_STR-RCCOLLATERALBSTA sy-vline      INTO ld_text SEPARATED BY SPACE.

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