ABAP Select data from SAP table MSR_S_REP_GR_ITEM_ALV 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 MSR_S_REP_GR_ITEM_ALV 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 MSR_S_REP_GR_ITEM_ALV. 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 MSR_S_REP_GR_ITEM_ALV 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_MSR_S_REP_GR_ITEM_ALV TYPE STANDARD TABLE OF MSR_S_REP_GR_ITEM_ALV,
      WA_MSR_S_REP_GR_ITEM_ALV TYPE MSR_S_REP_GR_ITEM_ALV,
      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: <MSR_S_REP_GR_ITEM_ALV> TYPE MSR_S_REP_GR_ITEM_ALV.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM MSR_S_REP_GR_ITEM_ALV
*  INTO TABLE @DATA(IT_MSR_S_REP_GR_ITEM_ALV2).
*--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_MSR_S_REP_GR_ITEM_ALV INDEX 1 INTO DATA(WA_MSR_S_REP_GR_ITEM_ALV2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<MSR_S_REP_GR_ITEM_ALV>-EBELN = 1.
<MSR_S_REP_GR_ITEM_ALV>-EBELP = 1.
<MSR_S_REP_GR_ITEM_ALV>-REP_EBELP = 1.
<MSR_S_REP_GR_ITEM_ALV>-MATNR = 1.
<MSR_S_REP_GR_ITEM_ALV>-TXZ01 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_MSR_S_REP_GR_ITEM_ALV-MENGE, sy-vline,
  WA_MSR_S_REP_GR_ITEM_ALV-MEINS, sy-vline,
  WA_MSR_S_REP_GR_ITEM_ALV-WEMNG, sy-vline,
  WA_MSR_S_REP_GR_ITEM_ALV-MEINS_WEMNG, sy-vline,
  WA_MSR_S_REP_GR_ITEM_ALV-ARMNG, sy-vline,
  WA_MSR_S_REP_GR_ITEM_ALV-LMEIN_ARMNG, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_MSR_S_REP_GR_ITEM_ALV 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_MSR_S_REP_GR_ITEM_ALV 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_MSR_S_REP_GR_ITEM_ALV INTO WA_MSR_S_REP_GR_ITEM_ALV.


*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 EBELN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_MSR_S_REP_GR_ITEM_ALV-EBELN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MSR_S_REP_GR_ITEM_ALV-EBELN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN1, internal->external for field MATNR
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_MSR_S_REP_GR_ITEM_ALV-MATNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MSR_S_REP_GR_ITEM_ALV-MATNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit ALPHA, internal->external for field KDAUF
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_MSR_S_REP_GR_ITEM_ALV-KDAUF
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MSR_S_REP_GR_ITEM_ALV-KDAUF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN1, internal->external for field REP_MATNR
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_MSR_S_REP_GR_ITEM_ALV-REP_MATNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MSR_S_REP_GR_ITEM_ALV-REP_MATNR.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit ALPHA, internal->external for field MSR_ID
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_MSR_S_REP_GR_ITEM_ALV-MSR_ID
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MSR_S_REP_GR_ITEM_ALV-MSR_ID.
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_MSR_S_REP_GR_ITEM_ALV_STR, 
EBELN TYPE STRING,
EBELP TYPE STRING,
REP_EBELP TYPE STRING,
MATNR TYPE STRING,
TXZ01 TYPE STRING,
MENGE TYPE STRING,
MEINS TYPE STRING,
WEMNG TYPE STRING,
MEINS_WEMNG TYPE STRING,
ARMNG TYPE STRING,
LMEIN_ARMNG TYPE STRING,
REMNG TYPE STRING,
LMEIN TYPE STRING,
UMREN TYPE STRING,
UMREZ TYPE STRING,
WERKS TYPE STRING,
NAME1 TYPE STRING,
LGORT TYPE STRING,
LGOBE TYPE STRING,
CHARG TYPE STRING,
LICHA TYPE STRING,
KNTTP TYPE STRING,
KDAUF TYPE STRING,
KDPOS TYPE STRING,
KDEIN TYPE STRING,
INSMK TYPE STRING,
SOBKZ TYPE STRING,
BSGRU TYPE STRING,
REP_MATNR TYPE STRING,
REP_TXZ01 TYPE STRING,
REP_MENGE TYPE STRING,
REP_MEINS TYPE STRING,
REP_REP_MENGE TYPE STRING,
REP_LMEIN TYPE STRING,
REP_UMREN TYPE STRING,
REP_UMREZ TYPE STRING,
REP_BATCH TYPE STRING,
REP_LICHA TYPE STRING,
REP_WERKS TYPE STRING,
REP_NAME1 TYPE STRING,
REP_LGORT TYPE STRING,
REP_LGOBE TYPE STRING,
REP_INSMK TYPE STRING,
REP_COMPLETE TYPE STRING,
SGT_RCAT TYPE STRING,
SGT_SCAT TYPE STRING,
REP_SGT_SCAT TYPE STRING,
MSR_ID TYPE STRING,
ITEM TYPE STRING,
SPLIT_ID TYPE STRING,
ITEM_WITH_ERROR TYPE STRING,
DELETE_ROW TYPE STRING,
DETAIL_DISPLAY TYPE STRING,
COMPENSATION_STATUS_I TYPE STRING,
LINECOLOUR TYPE STRING,
CELLTAB TYPE STRING,END OF T_EKKO_STR.
DATA: WA_MSR_S_REP_GR_ITEM_ALV_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_MSR_S_REP_GR_ITEM_ALV_STR-EBELN sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-EBELP sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-REP_EBELP sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-MATNR sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-TXZ01 sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-MENGE sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-MEINS sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-WEMNG sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-MEINS_WEMNG sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-ARMNG sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-LMEIN_ARMNG sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-REMNG sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-LMEIN sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-UMREN sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-UMREZ sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-WERKS sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-NAME1 sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-LGORT sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-LGOBE sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-CHARG sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-LICHA sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-KNTTP sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-KDAUF sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-KDPOS sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-KDEIN sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-INSMK sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-SOBKZ sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-BSGRU sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-REP_MATNR sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-REP_TXZ01 sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-REP_MENGE sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-REP_MEINS sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-REP_REP_MENGE sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-REP_LMEIN sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-REP_UMREN sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-REP_UMREZ sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-REP_BATCH sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-REP_LICHA sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-REP_WERKS sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-REP_NAME1 sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-REP_LGORT sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-REP_LGOBE sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-REP_INSMK sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-REP_COMPLETE sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-SGT_RCAT sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-SGT_SCAT sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-REP_SGT_SCAT sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-MSR_ID sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-ITEM sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-SPLIT_ID sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-ITEM_WITH_ERROR sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-DELETE_ROW sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-DETAIL_DISPLAY sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-COMPENSATION_STATUS_I sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-LINECOLOUR sy-vline 
WA_MSR_S_REP_GR_ITEM_ALV_STR-CELLTAB sy-vline      INTO ld_text SEPARATED BY SPACE.

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