ABAP Select data from SAP table RMF67PF 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 RMF67PF 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 RMF67PF. 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 RMF67PF 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_RMF67PF TYPE STANDARD TABLE OF RMF67PF,
      WA_RMF67PF TYPE RMF67PF,
      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: <RMF67PF> TYPE RMF67PF.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM RMF67PF
*  INTO TABLE @DATA(IT_RMF67PF2).
*--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_RMF67PF INDEX 1 INTO DATA(WA_RMF67PF2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<RMF67PF>-SFGKZ = 1.
<RMF67PF>-SKSTYP = 1.
<RMF67PF>-XEINTRAG = 1.
<RMF67PF>-XENTRACT = 1.
<RMF67PF>-XENTRSUM = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_RMF67PF-XVLG, sy-vline,
  WA_RMF67PF-BUKRS, sy-vline,
  WA_RMF67PF-RHORD, sy-vline,
  WA_RMF67PF-SVYM, sy-vline,
  WA_RMF67PF-SVNR, sy-vline,
  WA_RMF67PF-RORD, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_RMF67PF 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_RMF67PF 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_RMF67PF INTO WA_RMF67PF.


*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 RANL
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_RMF67PF-RANL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RMF67PF-RANL.
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_RMF67PF_STR, 
SFGKZ TYPE STRING,
SKSTYP TYPE STRING,
XEINTRAG TYPE STRING,
XENTRACT TYPE STRING,
XENTRSUM TYPE STRING,
XVLG TYPE STRING,
BUKRS TYPE STRING,
RHORD TYPE STRING,
SVYM TYPE STRING,
SVNR TYPE STRING,
RORD TYPE STRING,
ASTK TYPE STRING,
ASTKR TYPE STRING,
SREG TYPE STRING,
RANL TYPE STRING,
RPNR TYPE STRING,
XNEXTCB TYPE STRING,
XLBEZ TYPE STRING,
XNOTIZ TYPE STRING,
XHOO TYPE STRING,
XORDF TYPE STRING,
XREGIF TYPE STRING,
XORF TYPE STRING,
XREGF TYPE STRING,
XDARF TYPE STRING,
XDARINFO TYPE STRING,
XDIREKT TYPE STRING,
XORDLF TYPE STRING,
XDARLV TYPE STRING,
XRESTV TYPE STRING,
XHAWBED TYPE STRING,
XERF TYPE STRING,
JROLL TYPE STRING,
JZUF TYPE STRING,
JDED TYPE STRING,
XSTEXT TYPE STRING,
XSBUT TYPE STRING,
XRBREG TYPE STRING,
XRBDAR TYPE STRING,
XCBDAR TYPE STRING,
XCBHAW TYPE STRING,
XCBAW TYPE STRING,
XRBORD TYPE STRING,
XRBONL TYPE STRING,
XPBONL TYPE STRING,
XRBSFT TYPE STRING,
XPBSFT TYPE STRING,
XRBPLN TYPE STRING,
XPBPLN TYPE STRING,
XCBDAT TYPE STRING,
XCBDDAT TYPE STRING,
DATUM TYPE STRING,
PDATUM TYPE STRING,
DDATUM TYPE STRING,
XRBZDT TYPE STRING,
XRBPDT TYPE STRING,
XCBTST TYPE STRING,
XCBEND TYPE STRING,
XCBDR1 TYPE STRING,
XCBDR2 TYPE STRING,
XCBDR3 TYPE STRING,
XCBDR4 TYPE STRING,
XCBDR5 TYPE STRING,
XPBDRK TYPE STRING,
XCBDRK TYPE STRING,
XPBPAV TYPE STRING,
XCBPAV TYPE STRING,
NPROT TYPE STRING,
XRMET TYPE STRING,
XRORD TYPE STRING,
XRRUM TYPE STRING,
XRDRK TYPE STRING,
XRPRT TYPE STRING,
XRDAT TYPE STRING,
XRBFSEL TYPE STRING,
XRFUNC TYPE STRING,
STYP TYPE STRING,
SBWHR TYPE STRING,
WAERS TYPE STRING,
BVKWR TYPE STRING,
BVKW2 TYPE STRING,
BZKWR TYPE STRING,
BZKW2 TYPE STRING,
BRPWR TYPE STRING,
BRPW2 TYPE STRING,
BRIWR TYPE STRING,
BRIW2 TYPE STRING,
BMIWR TYPE STRING,
BMIW2 TYPE STRING,
BATWR TYPE STRING,
BATW2 TYPE STRING,
BATZWR TYPE STRING,
BATZW2 TYPE STRING,
BPTWR TYPE STRING,
BPTW2 TYPE STRING,
BPTZWR TYPE STRING,
BPTZW2 TYPE STRING,
BAVWR TYPE STRING,
BAVW2 TYPE STRING,
BVAWR TYPE STRING,
BVAW2 TYPE STRING,
XSUMME TYPE STRING,
SDATUM TYPE STRING,
XRBASDT TYPE STRING,
XRBESDT TYPE STRING,
XCORR_PRIMM TYPE STRING,END OF T_EKKO_STR.
DATA: WA_RMF67PF_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_RMF67PF_STR-SFGKZ sy-vline 
WA_RMF67PF_STR-SKSTYP sy-vline 
WA_RMF67PF_STR-XEINTRAG sy-vline 
WA_RMF67PF_STR-XENTRACT sy-vline 
WA_RMF67PF_STR-XENTRSUM sy-vline 
WA_RMF67PF_STR-XVLG sy-vline 
WA_RMF67PF_STR-BUKRS sy-vline 
WA_RMF67PF_STR-RHORD sy-vline 
WA_RMF67PF_STR-SVYM sy-vline 
WA_RMF67PF_STR-SVNR sy-vline 
WA_RMF67PF_STR-RORD sy-vline 
WA_RMF67PF_STR-ASTK sy-vline 
WA_RMF67PF_STR-ASTKR sy-vline 
WA_RMF67PF_STR-SREG sy-vline 
WA_RMF67PF_STR-RANL sy-vline 
WA_RMF67PF_STR-RPNR sy-vline 
WA_RMF67PF_STR-XNEXTCB sy-vline 
WA_RMF67PF_STR-XLBEZ sy-vline 
WA_RMF67PF_STR-XNOTIZ sy-vline 
WA_RMF67PF_STR-XHOO sy-vline 
WA_RMF67PF_STR-XORDF sy-vline 
WA_RMF67PF_STR-XREGIF sy-vline 
WA_RMF67PF_STR-XORF sy-vline 
WA_RMF67PF_STR-XREGF sy-vline 
WA_RMF67PF_STR-XDARF sy-vline 
WA_RMF67PF_STR-XDARINFO sy-vline 
WA_RMF67PF_STR-XDIREKT sy-vline 
WA_RMF67PF_STR-XORDLF sy-vline 
WA_RMF67PF_STR-XDARLV sy-vline 
WA_RMF67PF_STR-XRESTV sy-vline 
WA_RMF67PF_STR-XHAWBED sy-vline 
WA_RMF67PF_STR-XERF sy-vline 
WA_RMF67PF_STR-JROLL sy-vline 
WA_RMF67PF_STR-JZUF sy-vline 
WA_RMF67PF_STR-JDED sy-vline 
WA_RMF67PF_STR-XSTEXT sy-vline 
WA_RMF67PF_STR-XSBUT sy-vline 
WA_RMF67PF_STR-XRBREG sy-vline 
WA_RMF67PF_STR-XRBDAR sy-vline 
WA_RMF67PF_STR-XCBDAR sy-vline 
WA_RMF67PF_STR-XCBHAW sy-vline 
WA_RMF67PF_STR-XCBAW sy-vline 
WA_RMF67PF_STR-XRBORD sy-vline 
WA_RMF67PF_STR-XRBONL sy-vline 
WA_RMF67PF_STR-XPBONL sy-vline 
WA_RMF67PF_STR-XRBSFT sy-vline 
WA_RMF67PF_STR-XPBSFT sy-vline 
WA_RMF67PF_STR-XRBPLN sy-vline 
WA_RMF67PF_STR-XPBPLN sy-vline 
WA_RMF67PF_STR-XCBDAT sy-vline 
WA_RMF67PF_STR-XCBDDAT sy-vline 
WA_RMF67PF_STR-DATUM sy-vline 
WA_RMF67PF_STR-PDATUM sy-vline 
WA_RMF67PF_STR-DDATUM sy-vline 
WA_RMF67PF_STR-XRBZDT sy-vline 
WA_RMF67PF_STR-XRBPDT sy-vline 
WA_RMF67PF_STR-XCBTST sy-vline 
WA_RMF67PF_STR-XCBEND sy-vline 
WA_RMF67PF_STR-XCBDR1 sy-vline 
WA_RMF67PF_STR-XCBDR2 sy-vline 
WA_RMF67PF_STR-XCBDR3 sy-vline 
WA_RMF67PF_STR-XCBDR4 sy-vline 
WA_RMF67PF_STR-XCBDR5 sy-vline 
WA_RMF67PF_STR-XPBDRK sy-vline 
WA_RMF67PF_STR-XCBDRK sy-vline 
WA_RMF67PF_STR-XPBPAV sy-vline 
WA_RMF67PF_STR-XCBPAV sy-vline 
WA_RMF67PF_STR-NPROT sy-vline 
WA_RMF67PF_STR-XRMET sy-vline 
WA_RMF67PF_STR-XRORD sy-vline 
WA_RMF67PF_STR-XRRUM sy-vline 
WA_RMF67PF_STR-XRDRK sy-vline 
WA_RMF67PF_STR-XRPRT sy-vline 
WA_RMF67PF_STR-XRDAT sy-vline 
WA_RMF67PF_STR-XRBFSEL sy-vline 
WA_RMF67PF_STR-XRFUNC sy-vline 
WA_RMF67PF_STR-STYP sy-vline 
WA_RMF67PF_STR-SBWHR sy-vline 
WA_RMF67PF_STR-WAERS sy-vline 
WA_RMF67PF_STR-BVKWR sy-vline 
WA_RMF67PF_STR-BVKW2 sy-vline 
WA_RMF67PF_STR-BZKWR sy-vline 
WA_RMF67PF_STR-BZKW2 sy-vline 
WA_RMF67PF_STR-BRPWR sy-vline 
WA_RMF67PF_STR-BRPW2 sy-vline 
WA_RMF67PF_STR-BRIWR sy-vline 
WA_RMF67PF_STR-BRIW2 sy-vline 
WA_RMF67PF_STR-BMIWR sy-vline 
WA_RMF67PF_STR-BMIW2 sy-vline 
WA_RMF67PF_STR-BATWR sy-vline 
WA_RMF67PF_STR-BATW2 sy-vline 
WA_RMF67PF_STR-BATZWR sy-vline 
WA_RMF67PF_STR-BATZW2 sy-vline 
WA_RMF67PF_STR-BPTWR sy-vline 
WA_RMF67PF_STR-BPTW2 sy-vline 
WA_RMF67PF_STR-BPTZWR sy-vline 
WA_RMF67PF_STR-BPTZW2 sy-vline 
WA_RMF67PF_STR-BAVWR sy-vline 
WA_RMF67PF_STR-BAVW2 sy-vline 
WA_RMF67PF_STR-BVAWR sy-vline 
WA_RMF67PF_STR-BVAW2 sy-vline 
WA_RMF67PF_STR-XSUMME sy-vline 
WA_RMF67PF_STR-SDATUM sy-vline 
WA_RMF67PF_STR-XRBASDT sy-vline 
WA_RMF67PF_STR-XRBESDT sy-vline 
WA_RMF67PF_STR-XCORR_PRIMM sy-vline      INTO ld_text SEPARATED BY SPACE.

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