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

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

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

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


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
</MDGMM/_S_MM_ES_MDMABASIC>-USMD_ACTIVE = 1.
</MDGMM/_S_MM_ES_MDMABASIC>-SEARCH_RANK = 1.
</MDGMM/_S_MM_ES_MDMABASIC>-WERKS = 1.
</MDGMM/_S_MM_ES_MDMABASIC>-BERID = 1.
</MDGMM/_S_MM_ES_MDMABASIC>-MATERIAL = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/MDGMM/_S_MM_ES_MDMABASIC-AHDISMDMA, sy-vline,
  WA_/MDGMM/_S_MM_ES_MDMABASIC-APOKZMDMA, sy-vline,
  WA_/MDGMM/_S_MM_ES_MDMABASIC-AUSSSMDMA, sy-vline,
  WA_/MDGMM/_S_MM_ES_MDMABASIC-BSTFEMDMA, sy-vline,
  WA_/MDGMM/_S_MM_ES_MDMABASIC-BSTMAMDMA, sy-vline,
  WA_/MDGMM/_S_MM_ES_MDMABASIC-BSTMIMDMA, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/MDGMM/_S_MM_ES_MDMABASIC 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_/MDGMM/_S_MM_ES_MDMABASIC 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_/MDGMM/_S_MM_ES_MDMABASIC INTO WA_/MDGMM/_S_MM_ES_MDMABASIC.


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

*Conversion exit TSTRG, internal->external for field SCMGIPRTM
CALL FUNCTION 'CONVERSION_EXIT_TSTRG_OUTPUT'
  EXPORTING
    input =                      WA_/MDGMM/_S_MM_ES_MDMABASIC-SCMGIPRTM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/MDGMM/_S_MM_ES_MDMABASIC-SCMGIPRTM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRG, internal->external for field SCMGRPRTM
CALL FUNCTION 'CONVERSION_EXIT_TSTRG_OUTPUT'
  EXPORTING
    input =                      WA_/MDGMM/_S_MM_ES_MDMABASIC-SCMGRPRTM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/MDGMM/_S_MM_ES_MDMABASIC-SCMGRPRTM.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit TSTRG, internal->external for field SCMRODURM
CALL FUNCTION 'CONVERSION_EXIT_TSTRG_OUTPUT'
  EXPORTING
    input =                      WA_/MDGMM/_S_MM_ES_MDMABASIC-SCMRODURM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/MDGMM/_S_MM_ES_MDMABASIC-SCMRODURM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRG, internal->external for field SCMTGDURM
CALL FUNCTION 'CONVERSION_EXIT_TSTRG_OUTPUT'
  EXPORTING
    input =                      WA_/MDGMM/_S_MM_ES_MDMABASIC-SCMTGDURM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/MDGMM/_S_MM_ES_MDMABASIC-SCMTGDURM.
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_/MDGMM/_S_MM_ES_MDMABASIC_STR, 
USMD_ACTIVE TYPE STRING,
SEARCH_RANK TYPE STRING,
WERKS TYPE STRING,
BERID TYPE STRING,
MATERIAL TYPE STRING,
AHDISMDMA TYPE STRING,
APOKZMDMA TYPE STRING,
AUSSSMDMA TYPE STRING,
BSTFEMDMA TYPE STRING,
BSTMAMDMA TYPE STRING,
BSTMIMDMA TYPE STRING,
BSTRFMDMA TYPE STRING,
DGRMDMA TYPE STRING,
DISLSMDMA TYPE STRING,
DISMDMA TYPE STRING,
DISMMMDMA TYPE STRING,
EISBEMDMA TYPE STRING,
FXHORMDMA TYPE STRING,
LAGMDMA TYPE STRING,
LFRMDMA TYPE STRING,
LGFMDMA TYPE STRING,
LGPMDMA TYPE STRING,
LGRADMDMA TYPE STRING,
LOEKZMDMA TYPE STRING,
LOSFXMDMA TYPE STRING,
MABSTMDMA TYPE STRING,
MINBEMDMA TYPE STRING,
MRPMDMA TYPE STRING,
PLIFZMDMA TYPE STRING,
PLIFZX TYPE STRING,
RDPMDMA TYPE STRING,
RWPMDMA TYPE STRING,
SCMCCHPM TYPE STRING,
SCMCHPOM TYPE STRING,
SCMGIPRTM TYPE STRING,
SCMGRPRTM TYPE STRING,
SCMHEUIDM TYPE STRING,
SCMHUNITM TYPE STRING,
SCMHUOTM TYPE STRING,
SCMLSUOMM TYPE STRING,
SCMPKGIDM TYPE STRING,
SCMRODURM TYPE STRING,
SCMRRPTPM TYPE STRING,
SCMRSGRPM TYPE STRING,
SCMTGDURM TYPE STRING,
SHFLGMDMA TYPE STRING,
SHPMDMA TYPE STRING,
SHZETMDMA TYPE STRING,
SOBMDMA TYPE STRING,
TAKZTMDMA TYPE STRING,
TSIDSCMDM TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/MDGMM/_S_MM_ES_MDMABASIC_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_/MDGMM/_S_MM_ES_MDMABASIC_STR-USMD_ACTIVE sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-SEARCH_RANK sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-WERKS sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-BERID sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-MATERIAL sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-AHDISMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-APOKZMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-AUSSSMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-BSTFEMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-BSTMAMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-BSTMIMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-BSTRFMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-DGRMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-DISLSMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-DISMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-DISMMMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-EISBEMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-FXHORMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-LAGMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-LFRMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-LGFMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-LGPMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-LGRADMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-LOEKZMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-LOSFXMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-MABSTMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-MINBEMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-MRPMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-PLIFZMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-PLIFZX sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-RDPMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-RWPMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-SCMCCHPM sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-SCMCHPOM sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-SCMGIPRTM sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-SCMGRPRTM sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-SCMHEUIDM sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-SCMHUNITM sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-SCMHUOTM sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-SCMLSUOMM sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-SCMPKGIDM sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-SCMRODURM sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-SCMRRPTPM sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-SCMRSGRPM sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-SCMTGDURM sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-SHFLGMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-SHPMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-SHZETMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-SOBMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-TAKZTMDMA sy-vline 
WA_/MDGMM/_S_MM_ES_MDMABASIC_STR-TSIDSCMDM sy-vline      INTO ld_text SEPARATED BY SPACE.

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