ABAP Select data from SAP table MCHX_BINCO_CL into internal table

Get Example source ABAP code based on a different SAP table
  

Below is a number of ABAP code snippets to demonstrate how to select data from SAP MCHX_BINCO_CL 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 MCHX_BINCO_CL. 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 MCHX_BINCO_CL 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_MCHX_BINCO_CL TYPE STANDARD TABLE OF MCHX_BINCO_CL,
      WA_MCHX_BINCO_CL TYPE MCHX_BINCO_CL,
      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: <MCHX_BINCO_CL> TYPE MCHX_BINCO_CL.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM MCHX_BINCO_CL
*  INTO TABLE @DATA(IT_MCHX_BINCO_CL2).
*--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_MCHX_BINCO_CL INDEX 1 INTO DATA(WA_MCHX_BINCO_CL2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_MCHX_BINCO_CL ASSIGNING <MCHX_BINCO_CL>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<MCHX_BINCO_CL>-CLASS = 1.
<MCHX_BINCO_CL>-CLSTATUS = 1.
<MCHX_BINCO_CL>-NOT_CLASSIFIED = 1.
<MCHX_BINCO_CL>-XC_KLAH_BKP = 1.
<MCHX_BINCO_CL>-ICON_CLSTATUS = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_MCHX_BINCO_CL-ICON_MULTICLASS, sy-vline,
WA_MCHX_BINCO_CL-ATWTB_01, sy-vline,
WA_MCHX_BINCO_CL-ATWTB_02, sy-vline,
WA_MCHX_BINCO_CL-ATWTB_03, sy-vline,
WA_MCHX_BINCO_CL-ATWTB_04, sy-vline,
WA_MCHX_BINCO_CL-ATWTB_05, sy-vline.
ENDLOOP. *Add any further fields from structure WA_MCHX_BINCO_CL 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_MCHX_BINCO_CL 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_MCHX_BINCO_CL INTO WA_MCHX_BINCO_CL. *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_MCHX_BINCO_CL_STR,
CLASS TYPE STRING,
CLSTATUS TYPE STRING,
NOT_CLASSIFIED TYPE STRING,
XC_KLAH_BKP TYPE STRING,
ICON_CLSTATUS TYPE STRING,
ICON_MULTICLASS TYPE STRING,
ATWTB_01 TYPE STRING,
ATWTB_02 TYPE STRING,
ATWTB_03 TYPE STRING,
ATWTB_04 TYPE STRING,
ATWTB_05 TYPE STRING,
ATWTB_06 TYPE STRING,
ATWTB_07 TYPE STRING,
ATWTB_08 TYPE STRING,
ATWTB_09 TYPE STRING,
ATWTB_10 TYPE STRING,
ATWTB_11 TYPE STRING,
ATWTB_12 TYPE STRING,
ATWTB_13 TYPE STRING,
ATWTB_14 TYPE STRING,
ATWTB_15 TYPE STRING,
ATWTB_16 TYPE STRING,
ATWTB_17 TYPE STRING,
ATWTB_18 TYPE STRING,
ATWTB_19 TYPE STRING,
ATWTB_20 TYPE STRING,
ATMTB_01 TYPE STRING,
ATMTB_02 TYPE STRING,
ATMTB_03 TYPE STRING,
ATMTB_04 TYPE STRING,
ATMTB_05 TYPE STRING,
ATMTB_06 TYPE STRING,
ATMTB_07 TYPE STRING,
ATMTB_08 TYPE STRING,
ATMTB_09 TYPE STRING,
ATMTB_10 TYPE STRING,
ATMTB_11 TYPE STRING,
ATMTB_12 TYPE STRING,
ATMTB_13 TYPE STRING,
ATMTB_14 TYPE STRING,
ATMTB_15 TYPE STRING,
ATMTB_16 TYPE STRING,
ATMTB_17 TYPE STRING,
ATMTB_18 TYPE STRING,
ATMTB_19 TYPE STRING,
ATMTB_20 TYPE STRING,
ATDTB_01 TYPE STRING,
ATDTB_02 TYPE STRING,
ATDTB_03 TYPE STRING,
ATDTB_04 TYPE STRING,
ATDTB_05 TYPE STRING,
ATDTB_06 TYPE STRING,
ATDTB_07 TYPE STRING,
ATDTB_08 TYPE STRING,
ATDTB_09 TYPE STRING,
ATDTB_10 TYPE STRING,
ATTTB_01 TYPE STRING,
ATTTB_02 TYPE STRING,
ATTTB_03 TYPE STRING,
ATTTB_04 TYPE STRING,
ATTTB_05 TYPE STRING,
ATTTB_06 TYPE STRING,
ATTTB_07 TYPE STRING,
ATTTB_08 TYPE STRING,
ATTTB_09 TYPE STRING,
ATTTB_10 TYPE STRING,END OF T_EKKO_STR. DATA: WA_MCHX_BINCO_CL_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_MCHX_BINCO_CL_STR-CLASS sy-vline
WA_MCHX_BINCO_CL_STR-CLSTATUS sy-vline
WA_MCHX_BINCO_CL_STR-NOT_CLASSIFIED sy-vline
WA_MCHX_BINCO_CL_STR-XC_KLAH_BKP sy-vline
WA_MCHX_BINCO_CL_STR-ICON_CLSTATUS sy-vline
WA_MCHX_BINCO_CL_STR-ICON_MULTICLASS sy-vline
WA_MCHX_BINCO_CL_STR-ATWTB_01 sy-vline
WA_MCHX_BINCO_CL_STR-ATWTB_02 sy-vline
WA_MCHX_BINCO_CL_STR-ATWTB_03 sy-vline
WA_MCHX_BINCO_CL_STR-ATWTB_04 sy-vline
WA_MCHX_BINCO_CL_STR-ATWTB_05 sy-vline
WA_MCHX_BINCO_CL_STR-ATWTB_06 sy-vline
WA_MCHX_BINCO_CL_STR-ATWTB_07 sy-vline
WA_MCHX_BINCO_CL_STR-ATWTB_08 sy-vline
WA_MCHX_BINCO_CL_STR-ATWTB_09 sy-vline
WA_MCHX_BINCO_CL_STR-ATWTB_10 sy-vline
WA_MCHX_BINCO_CL_STR-ATWTB_11 sy-vline
WA_MCHX_BINCO_CL_STR-ATWTB_12 sy-vline
WA_MCHX_BINCO_CL_STR-ATWTB_13 sy-vline
WA_MCHX_BINCO_CL_STR-ATWTB_14 sy-vline
WA_MCHX_BINCO_CL_STR-ATWTB_15 sy-vline
WA_MCHX_BINCO_CL_STR-ATWTB_16 sy-vline
WA_MCHX_BINCO_CL_STR-ATWTB_17 sy-vline
WA_MCHX_BINCO_CL_STR-ATWTB_18 sy-vline
WA_MCHX_BINCO_CL_STR-ATWTB_19 sy-vline
WA_MCHX_BINCO_CL_STR-ATWTB_20 sy-vline
WA_MCHX_BINCO_CL_STR-ATMTB_01 sy-vline
WA_MCHX_BINCO_CL_STR-ATMTB_02 sy-vline
WA_MCHX_BINCO_CL_STR-ATMTB_03 sy-vline
WA_MCHX_BINCO_CL_STR-ATMTB_04 sy-vline
WA_MCHX_BINCO_CL_STR-ATMTB_05 sy-vline
WA_MCHX_BINCO_CL_STR-ATMTB_06 sy-vline
WA_MCHX_BINCO_CL_STR-ATMTB_07 sy-vline
WA_MCHX_BINCO_CL_STR-ATMTB_08 sy-vline
WA_MCHX_BINCO_CL_STR-ATMTB_09 sy-vline
WA_MCHX_BINCO_CL_STR-ATMTB_10 sy-vline
WA_MCHX_BINCO_CL_STR-ATMTB_11 sy-vline
WA_MCHX_BINCO_CL_STR-ATMTB_12 sy-vline
WA_MCHX_BINCO_CL_STR-ATMTB_13 sy-vline
WA_MCHX_BINCO_CL_STR-ATMTB_14 sy-vline
WA_MCHX_BINCO_CL_STR-ATMTB_15 sy-vline
WA_MCHX_BINCO_CL_STR-ATMTB_16 sy-vline
WA_MCHX_BINCO_CL_STR-ATMTB_17 sy-vline
WA_MCHX_BINCO_CL_STR-ATMTB_18 sy-vline
WA_MCHX_BINCO_CL_STR-ATMTB_19 sy-vline
WA_MCHX_BINCO_CL_STR-ATMTB_20 sy-vline
WA_MCHX_BINCO_CL_STR-ATDTB_01 sy-vline
WA_MCHX_BINCO_CL_STR-ATDTB_02 sy-vline
WA_MCHX_BINCO_CL_STR-ATDTB_03 sy-vline
WA_MCHX_BINCO_CL_STR-ATDTB_04 sy-vline
WA_MCHX_BINCO_CL_STR-ATDTB_05 sy-vline
WA_MCHX_BINCO_CL_STR-ATDTB_06 sy-vline
WA_MCHX_BINCO_CL_STR-ATDTB_07 sy-vline
WA_MCHX_BINCO_CL_STR-ATDTB_08 sy-vline
WA_MCHX_BINCO_CL_STR-ATDTB_09 sy-vline
WA_MCHX_BINCO_CL_STR-ATDTB_10 sy-vline
WA_MCHX_BINCO_CL_STR-ATTTB_01 sy-vline
WA_MCHX_BINCO_CL_STR-ATTTB_02 sy-vline
WA_MCHX_BINCO_CL_STR-ATTTB_03 sy-vline
WA_MCHX_BINCO_CL_STR-ATTTB_04 sy-vline
WA_MCHX_BINCO_CL_STR-ATTTB_05 sy-vline
WA_MCHX_BINCO_CL_STR-ATTTB_06 sy-vline
WA_MCHX_BINCO_CL_STR-ATTTB_07 sy-vline
WA_MCHX_BINCO_CL_STR-ATTTB_08 sy-vline
WA_MCHX_BINCO_CL_STR-ATTTB_09 sy-vline
WA_MCHX_BINCO_CL_STR-ATTTB_10 sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.