ABAP Select data from SAP table MCWZUSKZ 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 MCWZUSKZ 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 MCWZUSKZ. 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 MCWZUSKZ 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_MCWZUSKZ TYPE STANDARD TABLE OF MCWZUSKZ,
      WA_MCWZUSKZ TYPE MCWZUSKZ,
      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: <MCWZUSKZ> TYPE MCWZUSKZ.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM MCWZUSKZ
*  INTO TABLE @DATA(IT_MCWZUSKZ2).
*--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_MCWZUSKZ INDEX 1 INTO DATA(WA_MCWZUSKZ2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<MCWZUSKZ>-WESMAO = 1.
<MCWZUSKZ>-UMSMAO = 1.
<MCWZUSKZ>-BVLMAO = 1.
<MCWZUSKZ>-BSTMAO = 1.
<MCWZUSKZ>-WESMAM = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_MCWZUSKZ-UMSMAM, sy-vline,
  WA_MCWZUSKZ-BVLMAM, sy-vline,
  WA_MCWZUSKZ-BSTMAM, sy-vline,
  WA_MCWZUSKZ-AUMMAO, sy-vline,
  WA_MCWZUSKZ-AUMMAM, sy-vline,
  WA_MCWZUSKZ-AUMMNG, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_MCWZUSKZ 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_MCWZUSKZ 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_MCWZUSKZ INTO WA_MCWZUSKZ.


*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 ALPHA, internal->external for field BWBELN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_MCWZUSKZ-BWBELN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCWZUSKZ-BWBELN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AUART, internal->external for field BWBELA
CALL FUNCTION 'CONVERSION_EXIT_AUART_OUTPUT'
  EXPORTING
    input =                      WA_MCWZUSKZ-BWBELA
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCWZUSKZ-BWBELA.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field TRJAHR
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_MCWZUSKZ-TRJAHR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCWZUSKZ-TRJAHR.
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_MCWZUSKZ_STR, 
WESMAO TYPE STRING,
UMSMAO TYPE STRING,
BVLMAO TYPE STRING,
BSTMAO TYPE STRING,
WESMAM TYPE STRING,
UMSMAM TYPE STRING,
BVLMAM TYPE STRING,
BSTMAM TYPE STRING,
AUMMAO TYPE STRING,
AUMMAM TYPE STRING,
AUMMNG TYPE STRING,
AUMGEO TYPE STRING,
AUMGVO TYPE STRING,
AUMGVP TYPE STRING,
BKIPMG TYPE STRING,
BKIPEO TYPE STRING,
BKIPVO TYPE STRING,
BKIPVP TYPE STRING,
BKIPGW TYPE STRING,
BKIPVL TYPE STRING,
BKIMMG TYPE STRING,
BKIMEO TYPE STRING,
BKIMVO TYPE STRING,
BKIMVP TYPE STRING,
BKIMGW TYPE STRING,
BKIMVL TYPE STRING,
BKSPMG TYPE STRING,
BKSPEO TYPE STRING,
BKSPVO TYPE STRING,
BKSPVP TYPE STRING,
BKSPGW TYPE STRING,
BKSPVL TYPE STRING,
BKSMMG TYPE STRING,
BKSMEO TYPE STRING,
BKSMVO TYPE STRING,
BKSMVP TYPE STRING,
BKSMGW TYPE STRING,
BKSMVL TYPE STRING,
UHMENG TYPE STRING,
UHWERT TYPE STRING,
JUMENG TYPE STRING,
JUWERT TYPE STRING,
RWMENG TYPE STRING,
RWWERT TYPE STRING,
GMROIO TYPE STRING,
GMROIM TYPE STRING,
BSTMNG TYPE STRING,
BSTGEO TYPE STRING,
BSTGVO TYPE STRING,
BSTGVP TYPE STRING,
BSTVOL TYPE STRING,
BSTGEW TYPE STRING,
BBSMNG TYPE STRING,
BBSGEO TYPE STRING,
BBSGVO TYPE STRING,
BBSGVP TYPE STRING,
BBSGEW TYPE STRING,
BBSVOL TYPE STRING,
ERSTZU TYPE STRING,
TAGEIV TYPE STRING,
URSPVP TYPE STRING,
FUMGVP TYPE STRING,
FBSGVP TYPE STRING,
BBSMAO TYPE STRING,
BBSMAM TYPE STRING,
AQMENG TYPE STRING,
AQWERT TYPE STRING,
SBSMNG TYPE STRING,
SBSGEO TYPE STRING,
SBSGVO TYPE STRING,
SBSGVP TYPE STRING,
SBSGEW TYPE STRING,
SBSVOL TYPE STRING,
BONUMS TYPE STRING,
BONRUE TYPE STRING,
BONERT TYPE STRING,
BONMAM TYPE STRING,
BONMAO TYPE STRING,
RAVMNG TYPE STRING,
RAVGEO TYPE STRING,
RAVGVO TYPE STRING,
RAVGVP TYPE STRING,
RAVGEW TYPE STRING,
RAVVOL TYPE STRING,
RLFMNG TYPE STRING,
RLFGEW TYPE STRING,
RLFVOL TYPE STRING,
GUTMNG TYPE STRING,
GUTGEO TYPE STRING,
GUTGVO TYPE STRING,
GUTGVP TYPE STRING,
UMAMNG TYPE STRING,
UMAGEO TYPE STRING,
UMAGVO TYPE STRING,
UMAGVP TYPE STRING,
PRSNLA TYPE STRING,
GUTNLS TYPE STRING,
KAVMAM TYPE STRING,
KAVMAO TYPE STRING,
SAVMNG TYPE STRING,
SAVGEO TYPE STRING,
SAVGVO TYPE STRING,
SAVGVP TYPE STRING,
SAVGEW TYPE STRING,
SAVVOL TYPE STRING,
SAVMAM TYPE STRING,
SAVMAO TYPE STRING,
OAVMNG TYPE STRING,
OAVWRT TYPE STRING,
UMSMNG TYPE STRING,
UMSGEO TYPE STRING,
UMSGVO TYPE STRING,
UMSGVP TYPE STRING,
PRSNLS TYPE STRING,
ULVMNG TYPE STRING,
ULVGEO TYPE STRING,
ULVGVO TYPE STRING,
ULVGVP TYPE STRING,
ULVGEW TYPE STRING,
ULVVOL TYPE STRING,
ULVMAM TYPE STRING,
ULVMAO TYPE STRING,
UAVMNG TYPE STRING,
UAVGEO TYPE STRING,
UAVGVO TYPE STRING,
UAVGVP TYPE STRING,
UAVGEW TYPE STRING,
UAVVOL TYPE STRING,
UAVMAM TYPE STRING,
UAVMAO TYPE STRING,
DBWMBE TYPE STRING,
BIWMBE TYPE STRING,
LFAMNG TYPE STRING,
LFAMNA TYPE STRING,
GRUND TYPE STRING,
BEDAT TYPE STRING,
ADDGEO TYPE STRING,
ADDGVO TYPE STRING,
ADDEPA TYPE STRING,
ADDMAM TYPE STRING,
ADDMAO TYPE STRING,
ADDDUA TYPE STRING,
ADDKGS TYPE STRING,
BWBELN TYPE STRING,
BELPOS TYPE STRING,
BWEINT TYPE STRING,
BWBELT TYPE STRING,
BWBELA TYPE STRING,
BWPOST TYPE STRING,
TRJAHR TYPE STRING,END OF T_EKKO_STR.
DATA: WA_MCWZUSKZ_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_MCWZUSKZ_STR-WESMAO sy-vline 
WA_MCWZUSKZ_STR-UMSMAO sy-vline 
WA_MCWZUSKZ_STR-BVLMAO sy-vline 
WA_MCWZUSKZ_STR-BSTMAO sy-vline 
WA_MCWZUSKZ_STR-WESMAM sy-vline 
WA_MCWZUSKZ_STR-UMSMAM sy-vline 
WA_MCWZUSKZ_STR-BVLMAM sy-vline 
WA_MCWZUSKZ_STR-BSTMAM sy-vline 
WA_MCWZUSKZ_STR-AUMMAO sy-vline 
WA_MCWZUSKZ_STR-AUMMAM sy-vline 
WA_MCWZUSKZ_STR-AUMMNG sy-vline 
WA_MCWZUSKZ_STR-AUMGEO sy-vline 
WA_MCWZUSKZ_STR-AUMGVO sy-vline 
WA_MCWZUSKZ_STR-AUMGVP sy-vline 
WA_MCWZUSKZ_STR-BKIPMG sy-vline 
WA_MCWZUSKZ_STR-BKIPEO sy-vline 
WA_MCWZUSKZ_STR-BKIPVO sy-vline 
WA_MCWZUSKZ_STR-BKIPVP sy-vline 
WA_MCWZUSKZ_STR-BKIPGW sy-vline 
WA_MCWZUSKZ_STR-BKIPVL sy-vline 
WA_MCWZUSKZ_STR-BKIMMG sy-vline 
WA_MCWZUSKZ_STR-BKIMEO sy-vline 
WA_MCWZUSKZ_STR-BKIMVO sy-vline 
WA_MCWZUSKZ_STR-BKIMVP sy-vline 
WA_MCWZUSKZ_STR-BKIMGW sy-vline 
WA_MCWZUSKZ_STR-BKIMVL sy-vline 
WA_MCWZUSKZ_STR-BKSPMG sy-vline 
WA_MCWZUSKZ_STR-BKSPEO sy-vline 
WA_MCWZUSKZ_STR-BKSPVO sy-vline 
WA_MCWZUSKZ_STR-BKSPVP sy-vline 
WA_MCWZUSKZ_STR-BKSPGW sy-vline 
WA_MCWZUSKZ_STR-BKSPVL sy-vline 
WA_MCWZUSKZ_STR-BKSMMG sy-vline 
WA_MCWZUSKZ_STR-BKSMEO sy-vline 
WA_MCWZUSKZ_STR-BKSMVO sy-vline 
WA_MCWZUSKZ_STR-BKSMVP sy-vline 
WA_MCWZUSKZ_STR-BKSMGW sy-vline 
WA_MCWZUSKZ_STR-BKSMVL sy-vline 
WA_MCWZUSKZ_STR-UHMENG sy-vline 
WA_MCWZUSKZ_STR-UHWERT sy-vline 
WA_MCWZUSKZ_STR-JUMENG sy-vline 
WA_MCWZUSKZ_STR-JUWERT sy-vline 
WA_MCWZUSKZ_STR-RWMENG sy-vline 
WA_MCWZUSKZ_STR-RWWERT sy-vline 
WA_MCWZUSKZ_STR-GMROIO sy-vline 
WA_MCWZUSKZ_STR-GMROIM sy-vline 
WA_MCWZUSKZ_STR-BSTMNG sy-vline 
WA_MCWZUSKZ_STR-BSTGEO sy-vline 
WA_MCWZUSKZ_STR-BSTGVO sy-vline 
WA_MCWZUSKZ_STR-BSTGVP sy-vline 
WA_MCWZUSKZ_STR-BSTVOL sy-vline 
WA_MCWZUSKZ_STR-BSTGEW sy-vline 
WA_MCWZUSKZ_STR-BBSMNG sy-vline 
WA_MCWZUSKZ_STR-BBSGEO sy-vline 
WA_MCWZUSKZ_STR-BBSGVO sy-vline 
WA_MCWZUSKZ_STR-BBSGVP sy-vline 
WA_MCWZUSKZ_STR-BBSGEW sy-vline 
WA_MCWZUSKZ_STR-BBSVOL sy-vline 
WA_MCWZUSKZ_STR-ERSTZU sy-vline 
WA_MCWZUSKZ_STR-TAGEIV sy-vline 
WA_MCWZUSKZ_STR-URSPVP sy-vline 
WA_MCWZUSKZ_STR-FUMGVP sy-vline 
WA_MCWZUSKZ_STR-FBSGVP sy-vline 
WA_MCWZUSKZ_STR-BBSMAO sy-vline 
WA_MCWZUSKZ_STR-BBSMAM sy-vline 
WA_MCWZUSKZ_STR-AQMENG sy-vline 
WA_MCWZUSKZ_STR-AQWERT sy-vline 
WA_MCWZUSKZ_STR-SBSMNG sy-vline 
WA_MCWZUSKZ_STR-SBSGEO sy-vline 
WA_MCWZUSKZ_STR-SBSGVO sy-vline 
WA_MCWZUSKZ_STR-SBSGVP sy-vline 
WA_MCWZUSKZ_STR-SBSGEW sy-vline 
WA_MCWZUSKZ_STR-SBSVOL sy-vline 
WA_MCWZUSKZ_STR-BONUMS sy-vline 
WA_MCWZUSKZ_STR-BONRUE sy-vline 
WA_MCWZUSKZ_STR-BONERT sy-vline 
WA_MCWZUSKZ_STR-BONMAM sy-vline 
WA_MCWZUSKZ_STR-BONMAO sy-vline 
WA_MCWZUSKZ_STR-RAVMNG sy-vline 
WA_MCWZUSKZ_STR-RAVGEO sy-vline 
WA_MCWZUSKZ_STR-RAVGVO sy-vline 
WA_MCWZUSKZ_STR-RAVGVP sy-vline 
WA_MCWZUSKZ_STR-RAVGEW sy-vline 
WA_MCWZUSKZ_STR-RAVVOL sy-vline 
WA_MCWZUSKZ_STR-RLFMNG sy-vline 
WA_MCWZUSKZ_STR-RLFGEW sy-vline 
WA_MCWZUSKZ_STR-RLFVOL sy-vline 
WA_MCWZUSKZ_STR-GUTMNG sy-vline 
WA_MCWZUSKZ_STR-GUTGEO sy-vline 
WA_MCWZUSKZ_STR-GUTGVO sy-vline 
WA_MCWZUSKZ_STR-GUTGVP sy-vline 
WA_MCWZUSKZ_STR-UMAMNG sy-vline 
WA_MCWZUSKZ_STR-UMAGEO sy-vline 
WA_MCWZUSKZ_STR-UMAGVO sy-vline 
WA_MCWZUSKZ_STR-UMAGVP sy-vline 
WA_MCWZUSKZ_STR-PRSNLA sy-vline 
WA_MCWZUSKZ_STR-GUTNLS sy-vline 
WA_MCWZUSKZ_STR-KAVMAM sy-vline 
WA_MCWZUSKZ_STR-KAVMAO sy-vline 
WA_MCWZUSKZ_STR-SAVMNG sy-vline 
WA_MCWZUSKZ_STR-SAVGEO sy-vline 
WA_MCWZUSKZ_STR-SAVGVO sy-vline 
WA_MCWZUSKZ_STR-SAVGVP sy-vline 
WA_MCWZUSKZ_STR-SAVGEW sy-vline 
WA_MCWZUSKZ_STR-SAVVOL sy-vline 
WA_MCWZUSKZ_STR-SAVMAM sy-vline 
WA_MCWZUSKZ_STR-SAVMAO sy-vline 
WA_MCWZUSKZ_STR-OAVMNG sy-vline 
WA_MCWZUSKZ_STR-OAVWRT sy-vline 
WA_MCWZUSKZ_STR-UMSMNG sy-vline 
WA_MCWZUSKZ_STR-UMSGEO sy-vline 
WA_MCWZUSKZ_STR-UMSGVO sy-vline 
WA_MCWZUSKZ_STR-UMSGVP sy-vline 
WA_MCWZUSKZ_STR-PRSNLS sy-vline 
WA_MCWZUSKZ_STR-ULVMNG sy-vline 
WA_MCWZUSKZ_STR-ULVGEO sy-vline 
WA_MCWZUSKZ_STR-ULVGVO sy-vline 
WA_MCWZUSKZ_STR-ULVGVP sy-vline 
WA_MCWZUSKZ_STR-ULVGEW sy-vline 
WA_MCWZUSKZ_STR-ULVVOL sy-vline 
WA_MCWZUSKZ_STR-ULVMAM sy-vline 
WA_MCWZUSKZ_STR-ULVMAO sy-vline 
WA_MCWZUSKZ_STR-UAVMNG sy-vline 
WA_MCWZUSKZ_STR-UAVGEO sy-vline 
WA_MCWZUSKZ_STR-UAVGVO sy-vline 
WA_MCWZUSKZ_STR-UAVGVP sy-vline 
WA_MCWZUSKZ_STR-UAVGEW sy-vline 
WA_MCWZUSKZ_STR-UAVVOL sy-vline 
WA_MCWZUSKZ_STR-UAVMAM sy-vline 
WA_MCWZUSKZ_STR-UAVMAO sy-vline 
WA_MCWZUSKZ_STR-DBWMBE sy-vline 
WA_MCWZUSKZ_STR-BIWMBE sy-vline 
WA_MCWZUSKZ_STR-LFAMNG sy-vline 
WA_MCWZUSKZ_STR-LFAMNA sy-vline 
WA_MCWZUSKZ_STR-GRUND sy-vline 
WA_MCWZUSKZ_STR-BEDAT sy-vline 
WA_MCWZUSKZ_STR-ADDGEO sy-vline 
WA_MCWZUSKZ_STR-ADDGVO sy-vline 
WA_MCWZUSKZ_STR-ADDEPA sy-vline 
WA_MCWZUSKZ_STR-ADDMAM sy-vline 
WA_MCWZUSKZ_STR-ADDMAO sy-vline 
WA_MCWZUSKZ_STR-ADDDUA sy-vline 
WA_MCWZUSKZ_STR-ADDKGS sy-vline 
WA_MCWZUSKZ_STR-BWBELN sy-vline 
WA_MCWZUSKZ_STR-BELPOS sy-vline 
WA_MCWZUSKZ_STR-BWEINT sy-vline 
WA_MCWZUSKZ_STR-BWBELT sy-vline 
WA_MCWZUSKZ_STR-BWBELA sy-vline 
WA_MCWZUSKZ_STR-BWPOST sy-vline 
WA_MCWZUSKZ_STR-TRJAHR sy-vline      INTO ld_text SEPARATED BY SPACE.

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