ABAP Select data from SAP table MBEFUM 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 MBEFUM 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 MBEFUM. 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 MBEFUM 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_MBEFUM TYPE STANDARD TABLE OF MBEFUM,
      WA_MBEFUM TYPE MBEFUM,
      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: <MBEFUM> TYPE MBEFUM.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM MBEFUM
*  INTO TABLE @DATA(IT_MBEFUM2).
*--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_MBEFUM INDEX 1 INTO DATA(WA_MBEFUM2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<MBEFUM>-MSEHI = 1.
<MBEFUM>-LABST = 1.
<MBEFUM>-UMLME = 1.
<MBEFUM>-INSME = 1.
<MBEFUM>-EINME = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_MBEFUM-SPEME, sy-vline,
  WA_MBEFUM-RETME, sy-vline,
  WA_MBEFUM-VMLAB, sy-vline,
  WA_MBEFUM-VMUML, sy-vline,
  WA_MBEFUM-VMINS, sy-vline,
  WA_MBEFUM-VMEIN, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_MBEFUM 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_MBEFUM 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_MBEFUM INTO WA_MBEFUM.


*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 CUNIT, internal->external for field MSEHI
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_MBEFUM-MSEHI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MBEFUM-MSEHI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field MARDQJ
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_MBEFUM-MARDQJ
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MBEFUM-MARDQJ.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field MARCQJ
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_MBEFUM-MARCQJ
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MBEFUM-MARCQJ.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field MCHBQJ
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_MBEFUM-MCHBQJ
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MBEFUM-MCHBQJ.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field MKOLQJ
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_MBEFUM-MKOLQJ
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MBEFUM-MKOLQJ.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field MSKUQJ
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_MBEFUM-MSKUQJ
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MBEFUM-MSKUQJ.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field MSKAQJ
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_MBEFUM-MSKAQJ
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MBEFUM-MSKAQJ.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field MSPRQJ
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_MBEFUM-MSPRQJ
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MBEFUM-MSPRQJ.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field MSLBQJ
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_MBEFUM-MSLBQJ
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MBEFUM-MSLBQJ.
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_MBEFUM_STR, 
MSEHI TYPE STRING,
LABST TYPE STRING,
UMLME TYPE STRING,
INSME TYPE STRING,
EINME TYPE STRING,
SPEME TYPE STRING,
RETME TYPE STRING,
VMLAB TYPE STRING,
VMUML TYPE STRING,
VMINS TYPE STRING,
VMEIN TYPE STRING,
VMSPE TYPE STRING,
VMRET TYPE STRING,
KLABS TYPE STRING,
KINSM TYPE STRING,
KEINM TYPE STRING,
KSPEM TYPE STRING,
UMLMC TYPE STRING,
TRAME TYPE STRING,
GLGMG TYPE STRING,
VMTRA TYPE STRING,
VMUMC TYPE STRING,
VMGLG TYPE STRING,
CLABS TYPE STRING,
CUMLM TYPE STRING,
CINSM TYPE STRING,
CEINM TYPE STRING,
CSPEM TYPE STRING,
CRETM TYPE STRING,
CVMLA TYPE STRING,
CVMUM TYPE STRING,
CVMIN TYPE STRING,
CVMEI TYPE STRING,
CVMSP TYPE STRING,
CVMRE TYPE STRING,
SLABS TYPE STRING,
SINSM TYPE STRING,
SEINM TYPE STRING,
SSPEM TYPE STRING,
SVMLA TYPE STRING,
SVMIN TYPE STRING,
SVMEI TYPE STRING,
SVMSP TYPE STRING,
KULAB TYPE STRING,
KUINS TYPE STRING,
KUEIN TYPE STRING,
KUVLA TYPE STRING,
KUVIN TYPE STRING,
KUVEI TYPE STRING,
KALAB TYPE STRING,
KAINS TYPE STRING,
KASPE TYPE STRING,
KAVLA TYPE STRING,
KAVIN TYPE STRING,
KAVSP TYPE STRING,
KAVEI TYPE STRING,
KAEIN TYPE STRING,
PRLAB TYPE STRING,
PRINS TYPE STRING,
PRSPE TYPE STRING,
PREIN TYPE STRING,
PRVLA TYPE STRING,
PRVIN TYPE STRING,
PRVSP TYPE STRING,
PRVEI TYPE STRING,
LBLAB TYPE STRING,
LBINS TYPE STRING,
LBVLA TYPE STRING,
LBVIN TYPE STRING,
LBEIN TYPE STRING,
LBVEI TYPE STRING,
MARDQM TYPE STRING,
MARDQJ TYPE STRING,
MARCQM TYPE STRING,
MARCQJ TYPE STRING,
MCHBQM TYPE STRING,
MCHBQJ TYPE STRING,
MKOLQM TYPE STRING,
MKOLQJ TYPE STRING,
MSKUQM TYPE STRING,
MSKUQJ TYPE STRING,
MSKAQM TYPE STRING,
MSKAQJ TYPE STRING,
MSPRQM TYPE STRING,
MSPRQJ TYPE STRING,
MSLBQM TYPE STRING,
MSLBQJ TYPE STRING,
RMARDQ TYPE STRING,
RMARDQH TYPE STRING,
RMARCQ TYPE STRING,
RMARCQH TYPE STRING,
RMCHBQ TYPE STRING,
RMCHBQH TYPE STRING,
RMKOLQ TYPE STRING,
RMKOLQH TYPE STRING,
RMSKUQ TYPE STRING,
RMSKUQH TYPE STRING,
RMSKAQ TYPE STRING,
RMSKAQH TYPE STRING,
RMSPRQ TYPE STRING,
RMSPRQH TYPE STRING,
RMSLBQ TYPE STRING,
RMSLBQH TYPE STRING,
MARDQRU TYPE STRING,
MARCQRU TYPE STRING,
MCHBQRU TYPE STRING,
MKOLQRU TYPE STRING,
MSKUQRU TYPE STRING,
MSKAQRU TYPE STRING,
MSPRQRU TYPE STRING,
MSLBQRU TYPE STRING,END OF T_EKKO_STR.
DATA: WA_MBEFUM_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_MBEFUM_STR-MSEHI sy-vline 
WA_MBEFUM_STR-LABST sy-vline 
WA_MBEFUM_STR-UMLME sy-vline 
WA_MBEFUM_STR-INSME sy-vline 
WA_MBEFUM_STR-EINME sy-vline 
WA_MBEFUM_STR-SPEME sy-vline 
WA_MBEFUM_STR-RETME sy-vline 
WA_MBEFUM_STR-VMLAB sy-vline 
WA_MBEFUM_STR-VMUML sy-vline 
WA_MBEFUM_STR-VMINS sy-vline 
WA_MBEFUM_STR-VMEIN sy-vline 
WA_MBEFUM_STR-VMSPE sy-vline 
WA_MBEFUM_STR-VMRET sy-vline 
WA_MBEFUM_STR-KLABS sy-vline 
WA_MBEFUM_STR-KINSM sy-vline 
WA_MBEFUM_STR-KEINM sy-vline 
WA_MBEFUM_STR-KSPEM sy-vline 
WA_MBEFUM_STR-UMLMC sy-vline 
WA_MBEFUM_STR-TRAME sy-vline 
WA_MBEFUM_STR-GLGMG sy-vline 
WA_MBEFUM_STR-VMTRA sy-vline 
WA_MBEFUM_STR-VMUMC sy-vline 
WA_MBEFUM_STR-VMGLG sy-vline 
WA_MBEFUM_STR-CLABS sy-vline 
WA_MBEFUM_STR-CUMLM sy-vline 
WA_MBEFUM_STR-CINSM sy-vline 
WA_MBEFUM_STR-CEINM sy-vline 
WA_MBEFUM_STR-CSPEM sy-vline 
WA_MBEFUM_STR-CRETM sy-vline 
WA_MBEFUM_STR-CVMLA sy-vline 
WA_MBEFUM_STR-CVMUM sy-vline 
WA_MBEFUM_STR-CVMIN sy-vline 
WA_MBEFUM_STR-CVMEI sy-vline 
WA_MBEFUM_STR-CVMSP sy-vline 
WA_MBEFUM_STR-CVMRE sy-vline 
WA_MBEFUM_STR-SLABS sy-vline 
WA_MBEFUM_STR-SINSM sy-vline 
WA_MBEFUM_STR-SEINM sy-vline 
WA_MBEFUM_STR-SSPEM sy-vline 
WA_MBEFUM_STR-SVMLA sy-vline 
WA_MBEFUM_STR-SVMIN sy-vline 
WA_MBEFUM_STR-SVMEI sy-vline 
WA_MBEFUM_STR-SVMSP sy-vline 
WA_MBEFUM_STR-KULAB sy-vline 
WA_MBEFUM_STR-KUINS sy-vline 
WA_MBEFUM_STR-KUEIN sy-vline 
WA_MBEFUM_STR-KUVLA sy-vline 
WA_MBEFUM_STR-KUVIN sy-vline 
WA_MBEFUM_STR-KUVEI sy-vline 
WA_MBEFUM_STR-KALAB sy-vline 
WA_MBEFUM_STR-KAINS sy-vline 
WA_MBEFUM_STR-KASPE sy-vline 
WA_MBEFUM_STR-KAVLA sy-vline 
WA_MBEFUM_STR-KAVIN sy-vline 
WA_MBEFUM_STR-KAVSP sy-vline 
WA_MBEFUM_STR-KAVEI sy-vline 
WA_MBEFUM_STR-KAEIN sy-vline 
WA_MBEFUM_STR-PRLAB sy-vline 
WA_MBEFUM_STR-PRINS sy-vline 
WA_MBEFUM_STR-PRSPE sy-vline 
WA_MBEFUM_STR-PREIN sy-vline 
WA_MBEFUM_STR-PRVLA sy-vline 
WA_MBEFUM_STR-PRVIN sy-vline 
WA_MBEFUM_STR-PRVSP sy-vline 
WA_MBEFUM_STR-PRVEI sy-vline 
WA_MBEFUM_STR-LBLAB sy-vline 
WA_MBEFUM_STR-LBINS sy-vline 
WA_MBEFUM_STR-LBVLA sy-vline 
WA_MBEFUM_STR-LBVIN sy-vline 
WA_MBEFUM_STR-LBEIN sy-vline 
WA_MBEFUM_STR-LBVEI sy-vline 
WA_MBEFUM_STR-MARDQM sy-vline 
WA_MBEFUM_STR-MARDQJ sy-vline 
WA_MBEFUM_STR-MARCQM sy-vline 
WA_MBEFUM_STR-MARCQJ sy-vline 
WA_MBEFUM_STR-MCHBQM sy-vline 
WA_MBEFUM_STR-MCHBQJ sy-vline 
WA_MBEFUM_STR-MKOLQM sy-vline 
WA_MBEFUM_STR-MKOLQJ sy-vline 
WA_MBEFUM_STR-MSKUQM sy-vline 
WA_MBEFUM_STR-MSKUQJ sy-vline 
WA_MBEFUM_STR-MSKAQM sy-vline 
WA_MBEFUM_STR-MSKAQJ sy-vline 
WA_MBEFUM_STR-MSPRQM sy-vline 
WA_MBEFUM_STR-MSPRQJ sy-vline 
WA_MBEFUM_STR-MSLBQM sy-vline 
WA_MBEFUM_STR-MSLBQJ sy-vline 
WA_MBEFUM_STR-RMARDQ sy-vline 
WA_MBEFUM_STR-RMARDQH sy-vline 
WA_MBEFUM_STR-RMARCQ sy-vline 
WA_MBEFUM_STR-RMARCQH sy-vline 
WA_MBEFUM_STR-RMCHBQ sy-vline 
WA_MBEFUM_STR-RMCHBQH sy-vline 
WA_MBEFUM_STR-RMKOLQ sy-vline 
WA_MBEFUM_STR-RMKOLQH sy-vline 
WA_MBEFUM_STR-RMSKUQ sy-vline 
WA_MBEFUM_STR-RMSKUQH sy-vline 
WA_MBEFUM_STR-RMSKAQ sy-vline 
WA_MBEFUM_STR-RMSKAQH sy-vline 
WA_MBEFUM_STR-RMSPRQ sy-vline 
WA_MBEFUM_STR-RMSPRQH sy-vline 
WA_MBEFUM_STR-RMSLBQ sy-vline 
WA_MBEFUM_STR-RMSLBQH sy-vline 
WA_MBEFUM_STR-MARDQRU sy-vline 
WA_MBEFUM_STR-MARCQRU sy-vline 
WA_MBEFUM_STR-MCHBQRU sy-vline 
WA_MBEFUM_STR-MKOLQRU sy-vline 
WA_MBEFUM_STR-MSKUQRU sy-vline 
WA_MBEFUM_STR-MSKAQRU sy-vline 
WA_MBEFUM_STR-MSPRQRU sy-vline 
WA_MBEFUM_STR-MSLBQRU sy-vline      INTO ld_text SEPARATED BY SPACE.

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