ABAP Select data from SAP table RISA0 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 RISA0 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 RISA0. 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 RISA0 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_RISA0 TYPE STANDARD TABLE OF RISA0,
      WA_RISA0 TYPE RISA0,
      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: <RISA0> TYPE RISA0.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM RISA0
*  INTO TABLE @DATA(IT_RISA02).
*--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_RISA0 INDEX 1 INTO DATA(WA_RISA02).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<RISA0>-ANZAHL = 1.
<RISA0>-MATNR = 1.
<RISA0>-REFMA = 1.
<RISA0>-REFSE = 1.
<RISA0>-SERNR = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_RISA0-SERBIS, sy-vline,
  WA_RISA0-SERVON, sy-vline,
  WA_RISA0-BUKRS, sy-vline,
  WA_RISA0-INDUPD, sy-vline,
  WA_RISA0-EQNUPD, sy-vline,
  WA_RISA0-SERALT, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_RISA0 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_RISA0 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_RISA0 INTO WA_RISA0.


*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 MATNR
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_RISA0-MATNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RISA0-MATNR.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit GERNR, internal->external for field REFSE
CALL FUNCTION 'CONVERSION_EXIT_GERNR_OUTPUT'
  EXPORTING
    input =                      WA_RISA0-REFSE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RISA0-REFSE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GERNR, internal->external for field SERNR
CALL FUNCTION 'CONVERSION_EXIT_GERNR_OUTPUT'
  EXPORTING
    input =                      WA_RISA0-SERNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RISA0-SERNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GERNR, internal->external for field SERBIS
CALL FUNCTION 'CONVERSION_EXIT_GERNR_OUTPUT'
  EXPORTING
    input =                      WA_RISA0-SERBIS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RISA0-SERBIS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GERNR, internal->external for field SERVON
CALL FUNCTION 'CONVERSION_EXIT_GERNR_OUTPUT'
  EXPORTING
    input =                      WA_RISA0-SERVON
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RISA0-SERVON.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GERNR, internal->external for field SERALT
CALL FUNCTION 'CONVERSION_EXIT_GERNR_OUTPUT'
  EXPORTING
    input =                      WA_RISA0-SERALT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RISA0-SERALT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GERNR, internal->external for field SERNEU
CALL FUNCTION 'CONVERSION_EXIT_GERNR_OUTPUT'
  EXPORTING
    input =                      WA_RISA0-SERNEU
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RISA0-SERNEU.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field BANFN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_RISA0-BANFN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RISA0-BANFN.
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_RISA0_STR, 
ANZAHL TYPE STRING,
MATNR TYPE STRING,
REFMA TYPE STRING,
REFSE TYPE STRING,
SERNR TYPE STRING,
SERBIS TYPE STRING,
SERVON TYPE STRING,
BUKRS TYPE STRING,
INDUPD TYPE STRING,
EQNUPD TYPE STRING,
SERALT TYPE STRING,
SERNEU TYPE STRING,
CURSO TYPE STRING,
STATEXT TYPE STRING,
EQUPD TYPE STRING,
SDBELN TYPE STRING,
MBLNR TYPE STRING,
MATALT TYPE STRING,
MATNEU TYPE STRING,
KORKZ TYPE STRING,
KRFKZ TYPE STRING,
KOMATE TYPE STRING,
KOMWE TYPE STRING,
STATUSLINE TYPE STRING,
TYMAT TYPE STRING,
TYWER TYPE STRING,
RSNUM TYPE STRING,
RSPOS TYPE STRING,
VBELN TYPE STRING,
POSNR TYPE STRING,
REFOB TYPE STRING,
V_TO_STOCK TYPE STRING,
V_OF_STOCK TYPE STRING,
V_TO_CUST TYPE STRING,
V_OF_CUST TYPE STRING,
ANZSERGES TYPE STRING,
EBELN TYPE STRING,
EBELP TYPE STRING,
BANFN TYPE STRING,
BNFPO TYPE STRING,
V_DEL_HU TYPE STRING,
V_DEL_INV TYPE STRING,
UII TYPE STRING,
UII_NEW TYPE STRING,
IUID_TYPE TYPE STRING,
UII_NUM TYPE STRING,
UII_NUMC TYPE STRING,
UII_PLANT TYPE STRING,END OF T_EKKO_STR.
DATA: WA_RISA0_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_RISA0_STR-ANZAHL sy-vline 
WA_RISA0_STR-MATNR sy-vline 
WA_RISA0_STR-REFMA sy-vline 
WA_RISA0_STR-REFSE sy-vline 
WA_RISA0_STR-SERNR sy-vline 
WA_RISA0_STR-SERBIS sy-vline 
WA_RISA0_STR-SERVON sy-vline 
WA_RISA0_STR-BUKRS sy-vline 
WA_RISA0_STR-INDUPD sy-vline 
WA_RISA0_STR-EQNUPD sy-vline 
WA_RISA0_STR-SERALT sy-vline 
WA_RISA0_STR-SERNEU sy-vline 
WA_RISA0_STR-CURSO sy-vline 
WA_RISA0_STR-STATEXT sy-vline 
WA_RISA0_STR-EQUPD sy-vline 
WA_RISA0_STR-SDBELN sy-vline 
WA_RISA0_STR-MBLNR sy-vline 
WA_RISA0_STR-MATALT sy-vline 
WA_RISA0_STR-MATNEU sy-vline 
WA_RISA0_STR-KORKZ sy-vline 
WA_RISA0_STR-KRFKZ sy-vline 
WA_RISA0_STR-KOMATE sy-vline 
WA_RISA0_STR-KOMWE sy-vline 
WA_RISA0_STR-STATUSLINE sy-vline 
WA_RISA0_STR-TYMAT sy-vline 
WA_RISA0_STR-TYWER sy-vline 
WA_RISA0_STR-RSNUM sy-vline 
WA_RISA0_STR-RSPOS sy-vline 
WA_RISA0_STR-VBELN sy-vline 
WA_RISA0_STR-POSNR sy-vline 
WA_RISA0_STR-REFOB sy-vline 
WA_RISA0_STR-V_TO_STOCK sy-vline 
WA_RISA0_STR-V_OF_STOCK sy-vline 
WA_RISA0_STR-V_TO_CUST sy-vline 
WA_RISA0_STR-V_OF_CUST sy-vline 
WA_RISA0_STR-ANZSERGES sy-vline 
WA_RISA0_STR-EBELN sy-vline 
WA_RISA0_STR-EBELP sy-vline 
WA_RISA0_STR-BANFN sy-vline 
WA_RISA0_STR-BNFPO sy-vline 
WA_RISA0_STR-V_DEL_HU sy-vline 
WA_RISA0_STR-V_DEL_INV sy-vline 
WA_RISA0_STR-UII sy-vline 
WA_RISA0_STR-UII_NEW sy-vline 
WA_RISA0_STR-IUID_TYPE sy-vline 
WA_RISA0_STR-UII_NUM sy-vline 
WA_RISA0_STR-UII_NUMC sy-vline 
WA_RISA0_STR-UII_PLANT sy-vline      INTO ld_text SEPARATED BY SPACE.

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