ABAP Select data from SAP table REAJ_RECORD_METH 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 REAJ_RECORD_METH 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 REAJ_RECORD_METH. 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 REAJ_RECORD_METH 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_REAJ_RECORD_METH TYPE STANDARD TABLE OF REAJ_RECORD_METH,
      WA_REAJ_RECORD_METH TYPE REAJ_RECORD_METH,
      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: <REAJ_RECORD_METH> TYPE REAJ_RECORD_METH.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM REAJ_RECORD_METH
*  INTO TABLE @DATA(IT_REAJ_RECORD_METH2).
*--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_REAJ_RECORD_METH INDEX 1 INTO DATA(WA_REAJ_RECORD_METH2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<REAJ_RECORD_METH>-CONDGUIDOLD = 1.
<REAJ_RECORD_METH>-CONDGUIDNEW = 1.
<REAJ_RECORD_METH>-CONDGUIDREF = 1.
<REAJ_RECORD_METH>-ADJMFROMOLD = 1.
<REAJ_RECORD_METH>-ADJMFROMCALC = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_REAJ_RECORD_METH-ADJMFROMMOD, sy-vline,
  WA_REAJ_RECORD_METH-UNITPRICEOLD, sy-vline,
  WA_REAJ_RECORD_METH-UNITPRICECALC, sy-vline,
  WA_REAJ_RECORD_METH-UNITPRICEMOD, sy-vline,
  WA_REAJ_RECORD_METH-ADJMCONDDELETE, sy-vline,
  WA_REAJ_RECORD_METH-METHREFGUID, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_REAJ_RECORD_METH 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_REAJ_RECORD_METH 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_REAJ_RECORD_METH INTO WA_REAJ_RECORD_METH.


*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 REDAT, internal->external for field CONDVALIDTOOLD
CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT'
  EXPORTING
    input =                      WA_REAJ_RECORD_METH-CONDVALIDTOOLD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REAJ_RECORD_METH-CONDVALIDTOOLD.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field TERMNOAJNEW
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_REAJ_RECORD_METH-TERMNOAJNEW
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REAJ_RECORD_METH-TERMNOAJNEW.
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_REAJ_RECORD_METH_STR, 
CONDGUIDOLD TYPE STRING,
CONDGUIDNEW TYPE STRING,
CONDGUIDREF TYPE STRING,
ADJMFROMOLD TYPE STRING,
ADJMFROMCALC TYPE STRING,
ADJMFROMMOD TYPE STRING,
UNITPRICEOLD TYPE STRING,
UNITPRICECALC TYPE STRING,
UNITPRICEMOD TYPE STRING,
ADJMCONDDELETE TYPE STRING,
METHREFGUID TYPE STRING,
ADJMFROMMODDATE TYPE STRING,
ADJMFROMMODUSER TYPE STRING,
UNITPRICEMODDATE TYPE STRING,
UNITPRICEMODUSER TYPE STRING,
CONDVALIDTOOLD TYPE STRING,
ADJMCONDNEW TYPE STRING,
UPBEFORECAPPING TYPE STRING,
MONTHCAPPING TYPE STRING,
DISSOLVEINGUID TYPE STRING,
ADJMREASON TYPE STRING,
CHGREASON TYPE STRING,
CHGREASONOLD TYPE STRING,
CARRYFROMGUID TYPE STRING,
CARRYOVERCT TYPE STRING,
RECGROUPGUID TYPE STRING,
INTRENODEPEND TYPE STRING,
RECORDUPDATE TYPE STRING,
UNITPRICEANN TYPE STRING,
ADJMFROMANN TYPE STRING,
CONDPURPOSENEW TYPE STRING,
CONDTYPECEA TYPE STRING,
CONDTYPENEW TYPE STRING,
TERMNOAJNEW TYPE STRING,
TAKETERMNO TYPE STRING,
MAXINCREL TYPE STRING,
UPLESSCAPMONTH TYPE STRING,
ADJMFROMLESSCM TYPE STRING,
UPPOSMARGIN TYPE STRING,
UPPOSMARGINUSED TYPE STRING,
UPINCALLOWED TYPE STRING,
UNITPRICEMODZERO TYPE STRING,END OF T_EKKO_STR.
DATA: WA_REAJ_RECORD_METH_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_REAJ_RECORD_METH_STR-CONDGUIDOLD sy-vline 
WA_REAJ_RECORD_METH_STR-CONDGUIDNEW sy-vline 
WA_REAJ_RECORD_METH_STR-CONDGUIDREF sy-vline 
WA_REAJ_RECORD_METH_STR-ADJMFROMOLD sy-vline 
WA_REAJ_RECORD_METH_STR-ADJMFROMCALC sy-vline 
WA_REAJ_RECORD_METH_STR-ADJMFROMMOD sy-vline 
WA_REAJ_RECORD_METH_STR-UNITPRICEOLD sy-vline 
WA_REAJ_RECORD_METH_STR-UNITPRICECALC sy-vline 
WA_REAJ_RECORD_METH_STR-UNITPRICEMOD sy-vline 
WA_REAJ_RECORD_METH_STR-ADJMCONDDELETE sy-vline 
WA_REAJ_RECORD_METH_STR-METHREFGUID sy-vline 
WA_REAJ_RECORD_METH_STR-ADJMFROMMODDATE sy-vline 
WA_REAJ_RECORD_METH_STR-ADJMFROMMODUSER sy-vline 
WA_REAJ_RECORD_METH_STR-UNITPRICEMODDATE sy-vline 
WA_REAJ_RECORD_METH_STR-UNITPRICEMODUSER sy-vline 
WA_REAJ_RECORD_METH_STR-CONDVALIDTOOLD sy-vline 
WA_REAJ_RECORD_METH_STR-ADJMCONDNEW sy-vline 
WA_REAJ_RECORD_METH_STR-UPBEFORECAPPING sy-vline 
WA_REAJ_RECORD_METH_STR-MONTHCAPPING sy-vline 
WA_REAJ_RECORD_METH_STR-DISSOLVEINGUID sy-vline 
WA_REAJ_RECORD_METH_STR-ADJMREASON sy-vline 
WA_REAJ_RECORD_METH_STR-CHGREASON sy-vline 
WA_REAJ_RECORD_METH_STR-CHGREASONOLD sy-vline 
WA_REAJ_RECORD_METH_STR-CARRYFROMGUID sy-vline 
WA_REAJ_RECORD_METH_STR-CARRYOVERCT sy-vline 
WA_REAJ_RECORD_METH_STR-RECGROUPGUID sy-vline 
WA_REAJ_RECORD_METH_STR-INTRENODEPEND sy-vline 
WA_REAJ_RECORD_METH_STR-RECORDUPDATE sy-vline 
WA_REAJ_RECORD_METH_STR-UNITPRICEANN sy-vline 
WA_REAJ_RECORD_METH_STR-ADJMFROMANN sy-vline 
WA_REAJ_RECORD_METH_STR-CONDPURPOSENEW sy-vline 
WA_REAJ_RECORD_METH_STR-CONDTYPECEA sy-vline 
WA_REAJ_RECORD_METH_STR-CONDTYPENEW sy-vline 
WA_REAJ_RECORD_METH_STR-TERMNOAJNEW sy-vline 
WA_REAJ_RECORD_METH_STR-TAKETERMNO sy-vline 
WA_REAJ_RECORD_METH_STR-MAXINCREL sy-vline 
WA_REAJ_RECORD_METH_STR-UPLESSCAPMONTH sy-vline 
WA_REAJ_RECORD_METH_STR-ADJMFROMLESSCM sy-vline 
WA_REAJ_RECORD_METH_STR-UPPOSMARGIN sy-vline 
WA_REAJ_RECORD_METH_STR-UPPOSMARGINUSED sy-vline 
WA_REAJ_RECORD_METH_STR-UPINCALLOWED sy-vline 
WA_REAJ_RECORD_METH_STR-UNITPRICEMODZERO sy-vline      INTO ld_text SEPARATED BY SPACE.

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