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

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

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

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


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
</MRSS/T_RM_MCOOUT>-CUSTOMERNUMBER = 1.
</MRSS/T_RM_MCOOUT>-CUSTOMERNAME = 1.
</MRSS/T_RM_MCOOUT>-CUSTOMERINDUSTRY = 1.
</MRSS/T_RM_MCOOUT>-REQUESTNUMBER = 1.
</MRSS/T_RM_MCOOUT>-REQUESTNAME = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/MRSS/T_RM_MCOOUT-REQUESTSTATUS, sy-vline,
  WA_/MRSS/T_RM_MCOOUT-REQUESTTYPE, sy-vline,
  WA_/MRSS/T_RM_MCOOUT-ROLENUMBER, sy-vline,
  WA_/MRSS/T_RM_MCOOUT-ROLENAME, sy-vline,
  WA_/MRSS/T_RM_MCOOUT-ROLESTARTDATE, sy-vline,
  WA_/MRSS/T_RM_MCOOUT-ROLEENDDATE, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/MRSS/T_RM_MCOOUT 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_/MRSS/T_RM_MCOOUT 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_/MRSS/T_RM_MCOOUT INTO WA_/MRSS/T_RM_MCOOUT.


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

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

*Conversion exit NUMCV, internal->external for field ROLENUMBER
CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT'
  EXPORTING
    input =                      WA_/MRSS/T_RM_MCOOUT-ROLENUMBER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/MRSS/T_RM_MCOOUT-ROLENUMBER.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit ALPHA, internal->external for field PREFERREDNAMEDCONSULTANTID
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_/MRSS/T_RM_MCOOUT-PREFERREDNAMEDCONSULTANTID
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/MRSS/T_RM_MCOOUT-PREFERREDNAMEDCONSULTANTID.
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_/MRSS/T_RM_MCOOUT_STR, 
CUSTOMERNUMBER TYPE STRING,
CUSTOMERNAME TYPE STRING,
CUSTOMERINDUSTRY TYPE STRING,
REQUESTNUMBER TYPE STRING,
REQUESTNAME TYPE STRING,
REQUESTSTATUS TYPE STRING,
REQUESTTYPE TYPE STRING,
ROLENUMBER TYPE STRING,
ROLENAME TYPE STRING,
ROLESTARTDATE TYPE STRING,
ROLEENDDATE TYPE STRING,
CREATIONDATE TYPE STRING,
VALIDATIONDATE TYPE STRING,
BILLINGOBJECTTYPE TYPE STRING,
SONUMBER TYPE STRING,
REQUESTINGCOUNTRY TYPE STRING,
ROLESTATUS TYPE STRING,
ROLEPACECOMPETENCEPROFILE TYPE STRING,
ROLEPACESOLUTIONPROFILE TYPE STRING,
ROLEPACEINDUSTRYFOCUS TYPE STRING,
REQUESTER TYPE STRING,
PROFITCENTER TYPE STRING,
REQUESTINGORG TYPE STRING,
REQUESTOWNERHEADER TYPE STRING,
REQUESTOWNERROLE TYPE STRING,
SEARCHINGPARTY TYPE STRING,
REQUESTSTARTDATE TYPE STRING,
REQUESTENDDATE TYPE STRING,
REQUESTINGREGION TYPE STRING,
BACKGROUNDCHECK TYPE STRING,
CUSTOMERNAME2 TYPE STRING,
DURATION TYPE STRING,
CORPORATECOMPANY TYPE STRING,
CORPORATEORGANIZATION TYPE STRING,
CONTACTPERSON TYPE STRING,
ASSIGNMENTTYPE TYPE STRING,
PARTTIMEPOSSIBLE TYPE STRING,
ROLEPRIORITY TYPE STRING,
LASTBROADCASTDATE TYPE STRING,
ROLETYPE TYPE STRING,
REMOTEPOSSIBLE TYPE STRING,
ROLECREATIONDATE TYPE STRING,
ROLEVALIDATIONDATE TYPE STRING,
PREFERREDNAMEDCONSULTANTFLAG TYPE STRING,
PREFERREDNAMEDCONSULTANTID TYPE STRING,
PREFERREDNAMEDCONSULTANTNAME TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/MRSS/T_RM_MCOOUT_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_/MRSS/T_RM_MCOOUT_STR-CUSTOMERNUMBER sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-CUSTOMERNAME sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-CUSTOMERINDUSTRY sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-REQUESTNUMBER sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-REQUESTNAME sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-REQUESTSTATUS sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-REQUESTTYPE sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-ROLENUMBER sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-ROLENAME sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-ROLESTARTDATE sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-ROLEENDDATE sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-CREATIONDATE sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-VALIDATIONDATE sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-BILLINGOBJECTTYPE sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-SONUMBER sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-REQUESTINGCOUNTRY sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-ROLESTATUS sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-ROLEPACECOMPETENCEPROFILE sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-ROLEPACESOLUTIONPROFILE sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-ROLEPACEINDUSTRYFOCUS sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-REQUESTER sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-PROFITCENTER sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-REQUESTINGORG sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-REQUESTOWNERHEADER sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-REQUESTOWNERROLE sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-SEARCHINGPARTY sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-REQUESTSTARTDATE sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-REQUESTENDDATE sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-REQUESTINGREGION sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-BACKGROUNDCHECK sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-CUSTOMERNAME2 sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-DURATION sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-CORPORATECOMPANY sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-CORPORATEORGANIZATION sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-CONTACTPERSON sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-ASSIGNMENTTYPE sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-PARTTIMEPOSSIBLE sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-ROLEPRIORITY sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-LASTBROADCASTDATE sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-ROLETYPE sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-REMOTEPOSSIBLE sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-ROLECREATIONDATE sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-ROLEVALIDATIONDATE sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-PREFERREDNAMEDCONSULTANTFLAG sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-PREFERREDNAMEDCONSULTANTID sy-vline 
WA_/MRSS/T_RM_MCOOUT_STR-PREFERREDNAMEDCONSULTANTNAME sy-vline      INTO ld_text SEPARATED BY SPACE.

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