ABAP Select data from SAP table MCBESTADD1 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 MCBESTADD1 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 MCBESTADD1. 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 MCBESTADD1 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_MCBESTADD1 TYPE STANDARD TABLE OF MCBESTADD1,
      WA_MCBESTADD1 TYPE MCBESTADD1,
      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: <MCBESTADD1> TYPE MCBESTADD1.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM MCBESTADD1
*  INTO TABLE @DATA(IT_MCBESTADD12).
*--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_MCBESTADD1 INDEX 1 INTO DATA(WA_MCBESTADD12).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<MCBESTADD1>-LABST = 1.
<MCBESTADD1>-UMLME = 1.
<MCBESTADD1>-INSME = 1.
<MCBESTADD1>-KLABS = 1.
<MCBESTADD1>-KINSM = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_MCBESTADD1-UMLMC, sy-vline,
  WA_MCBESTADD1-TRAME, sy-vline,
  WA_MCBESTADD1-BWESB, sy-vline,
  WA_MCBESTADD1-KSPEM, sy-vline,
  WA_MCBESTADD1-LBKUM, sy-vline,
  WA_MCBESTADD1-SALK3, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_MCBESTADD1 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_MCBESTADD1 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_MCBESTADD1 INTO WA_MCBESTADD1.


*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.
ENDFORM. 

*&---------------------------------------------------------------------*
*& Form process_as_string_field_values
*&---------------------------------------------------------------------*
FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO.

TYPES: BEGIN OF T_MCBESTADD1_STR, 
LABST TYPE STRING,
UMLME TYPE STRING,
INSME TYPE STRING,
KLABS TYPE STRING,
KINSM TYPE STRING,
UMLMC TYPE STRING,
TRAME TYPE STRING,
BWESB TYPE STRING,
KSPEM TYPE STRING,
LBKUM TYPE STRING,
SALK3 TYPE STRING,
SPEME TYPE STRING,
MBWBEST TYPE STRING,
MKOBEST TYPE STRING,
GSBEST TYPE STRING,
WBWBEST TYPE STRING,
EISBE TYPE STRING,
BESZUG TYPE STRING,
WBESZUG TYPE STRING,
BVBEW TYPE STRING,
BVKON TYPE STRING,
BWERTV TYPE STRING,
CMBWBEST TYPE STRING,
CMKOBEST TYPE STRING,
CWBWBEST TYPE STRING,
CGSBEST TYPE STRING,
KULAB TYPE STRING,
KUINS TYPE STRING,
LBLAB TYPE STRING,
LBINS TYPE STRING,
EINME TYPE STRING,
LBEIN TYPE STRING,
KUEIN TYPE STRING,
SEINM TYPE STRING,
CEINM TYPE STRING,
KEINM TYPE STRING,
SLABS TYPE STRING,
SINSM TYPE STRING,
SSPEM TYPE STRING,
CLABS TYPE STRING,
CINSM TYPE STRING,
CSPEM TYPE STRING,
CUMLM TYPE STRING,
GLGMG TYPE STRING,
RETME TYPE STRING,
CRETM TYPE STRING,
PRLAB TYPE STRING,
PRINS TYPE STRING,
PRSPE TYPE STRING,
PREIN TYPE STRING,
KALAB TYPE STRING,
KAINS TYPE STRING,
KASPE TYPE STRING,
KAEIN TYPE STRING,
MTV_L TYPE STRING,
MTV_I TYPE STRING,
MTV_S TYPE STRING,
MTV_E TYPE STRING,
SALK3_E TYPE STRING,
SALK3_Q TYPE STRING,
LBKUM_E TYPE STRING,
LBKUM_Q TYPE STRING,
MKABEST TYPE STRING,
MPRBEST TYPE STRING,
WKABEST TYPE STRING,
WPRBEST TYPE STRING,
BVKA TYPE STRING,
BVPR TYPE STRING,
BWERTVKA TYPE STRING,
BWERTVPR TYPE STRING,
BVLABST TYPE STRING,
BVUMLME TYPE STRING,
BVINSME TYPE STRING,
BVKLABS TYPE STRING,
BVKINSM TYPE STRING,
BVUMLMC TYPE STRING,
BVTRAME TYPE STRING,
BVBWESB TYPE STRING,
BVKSPEM TYPE STRING,
BVSPEME TYPE STRING,
BVKULAB TYPE STRING,
BVKUINS TYPE STRING,
BVLBLAB TYPE STRING,
BVLBINS TYPE STRING,
BVEINME TYPE STRING,
BVLBEIN TYPE STRING,
BVKUEIN TYPE STRING,
BVSEINM TYPE STRING,
BVCEINM TYPE STRING,
BVKEINM TYPE STRING,
BVSLABS TYPE STRING,
BVSINSM TYPE STRING,
BVSSPEM TYPE STRING,
BVCLABS TYPE STRING,
BVCINSM TYPE STRING,
BVCSPEM TYPE STRING,
BVCUMLM TYPE STRING,
BVGLGMG TYPE STRING,
BVRETME TYPE STRING,
BVCRETM TYPE STRING,
LBUML TYPE STRING,
KUUML TYPE STRING,
CWESB TYPE STRING,
EWESB TYPE STRING,
QWESB TYPE STRING,
BVSABWE TYPE STRING,
BVSQBWE TYPE STRING,END OF T_EKKO_STR.
DATA: WA_MCBESTADD1_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_MCBESTADD1_STR-LABST sy-vline 
WA_MCBESTADD1_STR-UMLME sy-vline 
WA_MCBESTADD1_STR-INSME sy-vline 
WA_MCBESTADD1_STR-KLABS sy-vline 
WA_MCBESTADD1_STR-KINSM sy-vline 
WA_MCBESTADD1_STR-UMLMC sy-vline 
WA_MCBESTADD1_STR-TRAME sy-vline 
WA_MCBESTADD1_STR-BWESB sy-vline 
WA_MCBESTADD1_STR-KSPEM sy-vline 
WA_MCBESTADD1_STR-LBKUM sy-vline 
WA_MCBESTADD1_STR-SALK3 sy-vline 
WA_MCBESTADD1_STR-SPEME sy-vline 
WA_MCBESTADD1_STR-MBWBEST sy-vline 
WA_MCBESTADD1_STR-MKOBEST sy-vline 
WA_MCBESTADD1_STR-GSBEST sy-vline 
WA_MCBESTADD1_STR-WBWBEST sy-vline 
WA_MCBESTADD1_STR-EISBE sy-vline 
WA_MCBESTADD1_STR-BESZUG sy-vline 
WA_MCBESTADD1_STR-WBESZUG sy-vline 
WA_MCBESTADD1_STR-BVBEW sy-vline 
WA_MCBESTADD1_STR-BVKON sy-vline 
WA_MCBESTADD1_STR-BWERTV sy-vline 
WA_MCBESTADD1_STR-CMBWBEST sy-vline 
WA_MCBESTADD1_STR-CMKOBEST sy-vline 
WA_MCBESTADD1_STR-CWBWBEST sy-vline 
WA_MCBESTADD1_STR-CGSBEST sy-vline 
WA_MCBESTADD1_STR-KULAB sy-vline 
WA_MCBESTADD1_STR-KUINS sy-vline 
WA_MCBESTADD1_STR-LBLAB sy-vline 
WA_MCBESTADD1_STR-LBINS sy-vline 
WA_MCBESTADD1_STR-EINME sy-vline 
WA_MCBESTADD1_STR-LBEIN sy-vline 
WA_MCBESTADD1_STR-KUEIN sy-vline 
WA_MCBESTADD1_STR-SEINM sy-vline 
WA_MCBESTADD1_STR-CEINM sy-vline 
WA_MCBESTADD1_STR-KEINM sy-vline 
WA_MCBESTADD1_STR-SLABS sy-vline 
WA_MCBESTADD1_STR-SINSM sy-vline 
WA_MCBESTADD1_STR-SSPEM sy-vline 
WA_MCBESTADD1_STR-CLABS sy-vline 
WA_MCBESTADD1_STR-CINSM sy-vline 
WA_MCBESTADD1_STR-CSPEM sy-vline 
WA_MCBESTADD1_STR-CUMLM sy-vline 
WA_MCBESTADD1_STR-GLGMG sy-vline 
WA_MCBESTADD1_STR-RETME sy-vline 
WA_MCBESTADD1_STR-CRETM sy-vline 
WA_MCBESTADD1_STR-PRLAB sy-vline 
WA_MCBESTADD1_STR-PRINS sy-vline 
WA_MCBESTADD1_STR-PRSPE sy-vline 
WA_MCBESTADD1_STR-PREIN sy-vline 
WA_MCBESTADD1_STR-KALAB sy-vline 
WA_MCBESTADD1_STR-KAINS sy-vline 
WA_MCBESTADD1_STR-KASPE sy-vline 
WA_MCBESTADD1_STR-KAEIN sy-vline 
WA_MCBESTADD1_STR-MTV_L sy-vline 
WA_MCBESTADD1_STR-MTV_I sy-vline 
WA_MCBESTADD1_STR-MTV_S sy-vline 
WA_MCBESTADD1_STR-MTV_E sy-vline 
WA_MCBESTADD1_STR-SALK3_E sy-vline 
WA_MCBESTADD1_STR-SALK3_Q sy-vline 
WA_MCBESTADD1_STR-LBKUM_E sy-vline 
WA_MCBESTADD1_STR-LBKUM_Q sy-vline 
WA_MCBESTADD1_STR-MKABEST sy-vline 
WA_MCBESTADD1_STR-MPRBEST sy-vline 
WA_MCBESTADD1_STR-WKABEST sy-vline 
WA_MCBESTADD1_STR-WPRBEST sy-vline 
WA_MCBESTADD1_STR-BVKA sy-vline 
WA_MCBESTADD1_STR-BVPR sy-vline 
WA_MCBESTADD1_STR-BWERTVKA sy-vline 
WA_MCBESTADD1_STR-BWERTVPR sy-vline 
WA_MCBESTADD1_STR-BVLABST sy-vline 
WA_MCBESTADD1_STR-BVUMLME sy-vline 
WA_MCBESTADD1_STR-BVINSME sy-vline 
WA_MCBESTADD1_STR-BVKLABS sy-vline 
WA_MCBESTADD1_STR-BVKINSM sy-vline 
WA_MCBESTADD1_STR-BVUMLMC sy-vline 
WA_MCBESTADD1_STR-BVTRAME sy-vline 
WA_MCBESTADD1_STR-BVBWESB sy-vline 
WA_MCBESTADD1_STR-BVKSPEM sy-vline 
WA_MCBESTADD1_STR-BVSPEME sy-vline 
WA_MCBESTADD1_STR-BVKULAB sy-vline 
WA_MCBESTADD1_STR-BVKUINS sy-vline 
WA_MCBESTADD1_STR-BVLBLAB sy-vline 
WA_MCBESTADD1_STR-BVLBINS sy-vline 
WA_MCBESTADD1_STR-BVEINME sy-vline 
WA_MCBESTADD1_STR-BVLBEIN sy-vline 
WA_MCBESTADD1_STR-BVKUEIN sy-vline 
WA_MCBESTADD1_STR-BVSEINM sy-vline 
WA_MCBESTADD1_STR-BVCEINM sy-vline 
WA_MCBESTADD1_STR-BVKEINM sy-vline 
WA_MCBESTADD1_STR-BVSLABS sy-vline 
WA_MCBESTADD1_STR-BVSINSM sy-vline 
WA_MCBESTADD1_STR-BVSSPEM sy-vline 
WA_MCBESTADD1_STR-BVCLABS sy-vline 
WA_MCBESTADD1_STR-BVCINSM sy-vline 
WA_MCBESTADD1_STR-BVCSPEM sy-vline 
WA_MCBESTADD1_STR-BVCUMLM sy-vline 
WA_MCBESTADD1_STR-BVGLGMG sy-vline 
WA_MCBESTADD1_STR-BVRETME sy-vline 
WA_MCBESTADD1_STR-BVCRETM sy-vline 
WA_MCBESTADD1_STR-LBUML sy-vline 
WA_MCBESTADD1_STR-KUUML sy-vline 
WA_MCBESTADD1_STR-CWESB sy-vline 
WA_MCBESTADD1_STR-EWESB sy-vline 
WA_MCBESTADD1_STR-QWESB sy-vline 
WA_MCBESTADD1_STR-BVSABWE sy-vline 
WA_MCBESTADD1_STR-BVSQBWE sy-vline      INTO ld_text SEPARATED BY SPACE.

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