ABAP Select data from SAP table /CWM/MBEFU 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 /CWM/MBEFU 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 /CWM/MBEFU. 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 /CWM/MBEFU 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_/CWM/MBEFU TYPE STANDARD TABLE OF /CWM/MBEFU,
      WA_/CWM/MBEFU TYPE /CWM/MBEFU,
      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: </CWM/MBEFU> TYPE /CWM/MBEFU.

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

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM /CWM/MBEFU
  INTO TABLE IT_/CWM/MBEFU.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /CWM/MBEFU
*  INTO TABLE @DATA(IT_/CWM/MBEFU2).
*--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_/CWM/MBEFU INDEX 1 INTO DATA(WA_/CWM/MBEFU2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/CWM/MBEFU ASSIGNING </CWM/MBEFU>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
</CWM/MBEFU>-/CWM/XCWMAT = 1.
</CWM/MBEFU>-/CWM/XCWMAT = 1.
</CWM/MBEFU>-/CWM/VALUM = 1.
</CWM/MBEFU>-/CWM/VALUM = 1.
</CWM/MBEFU>-/CWM/TY2TQ = 1.

ENDLOOP.

LOOP AT IT_/CWM/MBEFU INTO WA_/CWM/MBEFU.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/CWM/MBEFU-/CWM/TY2TQ, sy-vline,
  WA_/CWM/MBEFU-/CWM/TOLGR, sy-vline,
  WA_/CWM/MBEFU-/CWM/TOLGR, sy-vline,
  WA_/CWM/MBEFU-/CWM/MEINS, sy-vline,
  WA_/CWM/MBEFU-/CWM/MEINS, sy-vline,
  WA_/CWM/MBEFU-/CWM/UMREZ, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/CWM/MBEFU 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_/CWM/MBEFU 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_/CWM/MBEFU INTO WA_/CWM/MBEFU.


*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 /CWM/VALUM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_/CWM/MBEFU-/CWM/VALUM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/CWM/MBEFU-/CWM/VALUM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field /CWM/VALUM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_/CWM/MBEFU-/CWM/VALUM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/CWM/MBEFU-/CWM/VALUM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field /CWM/MEINS
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_/CWM/MBEFU-/CWM/MEINS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/CWM/MBEFU-/CWM/MEINS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field /CWM/MEINS
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_/CWM/MBEFU-/CWM/MEINS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/CWM/MBEFU-/CWM/MEINS.
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_/CWM/MBEFU_STR, 
/CWM/XCWMAT TYPE STRING,
/CWM/XCWMAT TYPE STRING,
/CWM/VALUM TYPE STRING,
/CWM/VALUM TYPE STRING,
/CWM/TY2TQ TYPE STRING,
/CWM/TY2TQ TYPE STRING,
/CWM/TOLGR TYPE STRING,
/CWM/TOLGR TYPE STRING,
/CWM/MEINS TYPE STRING,
/CWM/MEINS TYPE STRING,
/CWM/UMREZ TYPE STRING,
/CWM/UMREZ TYPE STRING,
/CWM/UMREN TYPE STRING,
/CWM/UMREN TYPE STRING,
/CWM/LBKUM TYPE STRING,
/CWM/LBKUM TYPE STRING,
/CWM/SALK3 TYPE STRING,
/CWM/SALK3 TYPE STRING,
/CWM/UMLMC TYPE STRING,
/CWM/TRAME TYPE STRING,
/CWM/BWESB TYPE STRING,
/CWM/LABST TYPE STRING,
/CWM/INSME TYPE STRING,
/CWM/EINME TYPE STRING,
/CWM/SPEME TYPE STRING,
/CWM/RETME TYPE STRING,
/CWM/UMLME TYPE STRING,
/CWM/KLABS TYPE STRING,
/CWM/KINSM TYPE STRING,
/CWM/KEINM TYPE STRING,
/CWM/KSPEM TYPE STRING,
/CWM/VMLAB TYPE STRING,
/CWM/VMINS TYPE STRING,
/CWM/VMEIN TYPE STRING,
/CWM/VMSPE TYPE STRING,
/CWM/VMRET TYPE STRING,
/CWM/VMUML TYPE STRING,
/CWM/CLABS TYPE STRING,
/CWM/CINSM TYPE STRING,
/CWM/CEINM TYPE STRING,
/CWM/CSPEM TYPE STRING,
/CWM/CRETM TYPE STRING,
/CWM/CUMLM TYPE STRING,
/CWM/CVMLA TYPE STRING,
/CWM/CVMIN TYPE STRING,
/CWM/CVMEI TYPE STRING,
/CWM/CVMSP TYPE STRING,
/CWM/CVMRE TYPE STRING,
/CWM/CVMUM TYPE STRING,
/CWM/SLABS TYPE STRING,
/CWM/SINSM TYPE STRING,
/CWM/SEINM TYPE STRING,
/CWM/SSPEM TYPE STRING,
/CWM/SVMLA TYPE STRING,
/CWM/SVMIN TYPE STRING,
/CWM/SVMEI TYPE STRING,
/CWM/SVMSP TYPE STRING,
/CWM/KALAB TYPE STRING,
/CWM/KAINS TYPE STRING,
/CWM/KASPE TYPE STRING,
/CWM/KAEIN TYPE STRING,
/CWM/KAVLA TYPE STRING,
/CWM/KAVIN TYPE STRING,
/CWM/KAVSP TYPE STRING,
/CWM/KAVEI TYPE STRING,
/CWM/SALAB TYPE STRING,
/CWM/SAINS TYPE STRING,
/CWM/SASPE TYPE STRING,
/CWM/SAEIN TYPE STRING,
/CWM/SATRA TYPE STRING,
/CWM/SABWE TYPE STRING,
/CWM/KULAB TYPE STRING,
/CWM/KUINS TYPE STRING,
/CWM/KUEIN TYPE STRING,
/CWM/KUUML TYPE STRING,
/CWM/KUVLA TYPE STRING,
/CWM/KUVIN TYPE STRING,
/CWM/KUVEI TYPE STRING,
/CWM/KUVUM TYPE STRING,
/CWM/LBLAB TYPE STRING,
/CWM/LBINS TYPE STRING,
/CWM/LBEIN TYPE STRING,
/CWM/LBUML TYPE STRING,
/CWM/LBVLA TYPE STRING,
/CWM/LBVIN TYPE STRING,
/CWM/LBVEI TYPE STRING,
/CWM/LBVUM TYPE STRING,
/CWM/SLLAB TYPE STRING,
/CWM/SLINS TYPE STRING,
/CWM/SLEIN TYPE STRING,
/CWM/SLUML TYPE STRING,
/CWM/PRLAB TYPE STRING,
/CWM/PRINS TYPE STRING,
/CWM/PRSPE TYPE STRING,
/CWM/PREIN TYPE STRING,
/CWM/PRVLA TYPE STRING,
/CWM/PRVIN TYPE STRING,
/CWM/PRVSP TYPE STRING,
/CWM/PRVEI TYPE STRING,
/CWM/SQLAB TYPE STRING,
/CWM/SQINS TYPE STRING,
/CWM/SQSPE TYPE STRING,
/CWM/SQEIN TYPE STRING,
/CWM/SQTRA TYPE STRING,
/CWM/SQBWE TYPE STRING,
/CWM/VMTRA TYPE STRING,
/CWM/VMUMC TYPE STRING,
/CWM/VMBWE TYPE STRING,
/CWM/SAVTR TYPE STRING,
/CWM/SAVBW TYPE STRING,
/CWM/SQVTR TYPE STRING,
/CWM/SQVBW TYPE STRING,
/CWM/CWESB TYPE STRING,
/CWM/VMCSB TYPE STRING,
/CWM/EWESB TYPE STRING,
/CWM/VMESB TYPE STRING,
/CWM/QWESB TYPE STRING,
/CWM/VMQSB TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/CWM/MBEFU_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_/CWM/MBEFU_STR-/CWM/XCWMAT sy-vline 
WA_/CWM/MBEFU_STR-/CWM/XCWMAT sy-vline 
WA_/CWM/MBEFU_STR-/CWM/VALUM sy-vline 
WA_/CWM/MBEFU_STR-/CWM/VALUM sy-vline 
WA_/CWM/MBEFU_STR-/CWM/TY2TQ sy-vline 
WA_/CWM/MBEFU_STR-/CWM/TY2TQ sy-vline 
WA_/CWM/MBEFU_STR-/CWM/TOLGR sy-vline 
WA_/CWM/MBEFU_STR-/CWM/TOLGR sy-vline 
WA_/CWM/MBEFU_STR-/CWM/MEINS sy-vline 
WA_/CWM/MBEFU_STR-/CWM/MEINS sy-vline 
WA_/CWM/MBEFU_STR-/CWM/UMREZ sy-vline 
WA_/CWM/MBEFU_STR-/CWM/UMREZ sy-vline 
WA_/CWM/MBEFU_STR-/CWM/UMREN sy-vline 
WA_/CWM/MBEFU_STR-/CWM/UMREN sy-vline 
WA_/CWM/MBEFU_STR-/CWM/LBKUM sy-vline 
WA_/CWM/MBEFU_STR-/CWM/LBKUM sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SALK3 sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SALK3 sy-vline 
WA_/CWM/MBEFU_STR-/CWM/UMLMC sy-vline 
WA_/CWM/MBEFU_STR-/CWM/TRAME sy-vline 
WA_/CWM/MBEFU_STR-/CWM/BWESB sy-vline 
WA_/CWM/MBEFU_STR-/CWM/LABST sy-vline 
WA_/CWM/MBEFU_STR-/CWM/INSME sy-vline 
WA_/CWM/MBEFU_STR-/CWM/EINME sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SPEME sy-vline 
WA_/CWM/MBEFU_STR-/CWM/RETME sy-vline 
WA_/CWM/MBEFU_STR-/CWM/UMLME sy-vline 
WA_/CWM/MBEFU_STR-/CWM/KLABS sy-vline 
WA_/CWM/MBEFU_STR-/CWM/KINSM sy-vline 
WA_/CWM/MBEFU_STR-/CWM/KEINM sy-vline 
WA_/CWM/MBEFU_STR-/CWM/KSPEM sy-vline 
WA_/CWM/MBEFU_STR-/CWM/VMLAB sy-vline 
WA_/CWM/MBEFU_STR-/CWM/VMINS sy-vline 
WA_/CWM/MBEFU_STR-/CWM/VMEIN sy-vline 
WA_/CWM/MBEFU_STR-/CWM/VMSPE sy-vline 
WA_/CWM/MBEFU_STR-/CWM/VMRET sy-vline 
WA_/CWM/MBEFU_STR-/CWM/VMUML sy-vline 
WA_/CWM/MBEFU_STR-/CWM/CLABS sy-vline 
WA_/CWM/MBEFU_STR-/CWM/CINSM sy-vline 
WA_/CWM/MBEFU_STR-/CWM/CEINM sy-vline 
WA_/CWM/MBEFU_STR-/CWM/CSPEM sy-vline 
WA_/CWM/MBEFU_STR-/CWM/CRETM sy-vline 
WA_/CWM/MBEFU_STR-/CWM/CUMLM sy-vline 
WA_/CWM/MBEFU_STR-/CWM/CVMLA sy-vline 
WA_/CWM/MBEFU_STR-/CWM/CVMIN sy-vline 
WA_/CWM/MBEFU_STR-/CWM/CVMEI sy-vline 
WA_/CWM/MBEFU_STR-/CWM/CVMSP sy-vline 
WA_/CWM/MBEFU_STR-/CWM/CVMRE sy-vline 
WA_/CWM/MBEFU_STR-/CWM/CVMUM sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SLABS sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SINSM sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SEINM sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SSPEM sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SVMLA sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SVMIN sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SVMEI sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SVMSP sy-vline 
WA_/CWM/MBEFU_STR-/CWM/KALAB sy-vline 
WA_/CWM/MBEFU_STR-/CWM/KAINS sy-vline 
WA_/CWM/MBEFU_STR-/CWM/KASPE sy-vline 
WA_/CWM/MBEFU_STR-/CWM/KAEIN sy-vline 
WA_/CWM/MBEFU_STR-/CWM/KAVLA sy-vline 
WA_/CWM/MBEFU_STR-/CWM/KAVIN sy-vline 
WA_/CWM/MBEFU_STR-/CWM/KAVSP sy-vline 
WA_/CWM/MBEFU_STR-/CWM/KAVEI sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SALAB sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SAINS sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SASPE sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SAEIN sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SATRA sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SABWE sy-vline 
WA_/CWM/MBEFU_STR-/CWM/KULAB sy-vline 
WA_/CWM/MBEFU_STR-/CWM/KUINS sy-vline 
WA_/CWM/MBEFU_STR-/CWM/KUEIN sy-vline 
WA_/CWM/MBEFU_STR-/CWM/KUUML sy-vline 
WA_/CWM/MBEFU_STR-/CWM/KUVLA sy-vline 
WA_/CWM/MBEFU_STR-/CWM/KUVIN sy-vline 
WA_/CWM/MBEFU_STR-/CWM/KUVEI sy-vline 
WA_/CWM/MBEFU_STR-/CWM/KUVUM sy-vline 
WA_/CWM/MBEFU_STR-/CWM/LBLAB sy-vline 
WA_/CWM/MBEFU_STR-/CWM/LBINS sy-vline 
WA_/CWM/MBEFU_STR-/CWM/LBEIN sy-vline 
WA_/CWM/MBEFU_STR-/CWM/LBUML sy-vline 
WA_/CWM/MBEFU_STR-/CWM/LBVLA sy-vline 
WA_/CWM/MBEFU_STR-/CWM/LBVIN sy-vline 
WA_/CWM/MBEFU_STR-/CWM/LBVEI sy-vline 
WA_/CWM/MBEFU_STR-/CWM/LBVUM sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SLLAB sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SLINS sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SLEIN sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SLUML sy-vline 
WA_/CWM/MBEFU_STR-/CWM/PRLAB sy-vline 
WA_/CWM/MBEFU_STR-/CWM/PRINS sy-vline 
WA_/CWM/MBEFU_STR-/CWM/PRSPE sy-vline 
WA_/CWM/MBEFU_STR-/CWM/PREIN sy-vline 
WA_/CWM/MBEFU_STR-/CWM/PRVLA sy-vline 
WA_/CWM/MBEFU_STR-/CWM/PRVIN sy-vline 
WA_/CWM/MBEFU_STR-/CWM/PRVSP sy-vline 
WA_/CWM/MBEFU_STR-/CWM/PRVEI sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SQLAB sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SQINS sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SQSPE sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SQEIN sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SQTRA sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SQBWE sy-vline 
WA_/CWM/MBEFU_STR-/CWM/VMTRA sy-vline 
WA_/CWM/MBEFU_STR-/CWM/VMUMC sy-vline 
WA_/CWM/MBEFU_STR-/CWM/VMBWE sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SAVTR sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SAVBW sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SQVTR sy-vline 
WA_/CWM/MBEFU_STR-/CWM/SQVBW sy-vline 
WA_/CWM/MBEFU_STR-/CWM/CWESB sy-vline 
WA_/CWM/MBEFU_STR-/CWM/VMCSB sy-vline 
WA_/CWM/MBEFU_STR-/CWM/EWESB sy-vline 
WA_/CWM/MBEFU_STR-/CWM/VMESB sy-vline 
WA_/CWM/MBEFU_STR-/CWM/QWESB sy-vline 
WA_/CWM/MBEFU_STR-/CWM/VMQSB sy-vline      INTO ld_text SEPARATED BY SPACE.

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