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

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

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

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


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
</MRSS/D_RM_HEADR>-MANDT = 1.
</MRSS/D_RM_HEADR>-GUID = 1.
</MRSS/D_RM_HEADR>-REQUEST_NUMBER = 1.
</MRSS/D_RM_HEADR>-DEMAND_TYPE = 1.
</MRSS/D_RM_HEADR>-ERNAM = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/MRSS/D_RM_HEADR-ERDAT, sy-vline,
  WA_/MRSS/D_RM_HEADR-AENAM, sy-vline,
  WA_/MRSS/D_RM_HEADR-AEDAT, sy-vline,
  WA_/MRSS/D_RM_HEADR-OBJNR, sy-vline,
  WA_/MRSS/D_RM_HEADR-/MRSS/REQ_TYPE, sy-vline,
  WA_/MRSS/D_RM_HEADR-/MRSS/REQ_LOB, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/MRSS/D_RM_HEADR 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/D_RM_HEADR 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/D_RM_HEADR INTO WA_/MRSS/D_RM_HEADR.


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

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

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

*Conversion exit ALPHA, internal->external for field /MRSS/SALES_ORGN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_/MRSS/D_RM_HEADR-/MRSS/SALES_ORGN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/MRSS/D_RM_HEADR-/MRSS/SALES_ORGN.
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/D_RM_HEADR_STR, 
MANDT TYPE STRING,
GUID TYPE STRING,
REQUEST_NUMBER TYPE STRING,
DEMAND_TYPE TYPE STRING,
ERNAM TYPE STRING,
ERDAT TYPE STRING,
AENAM TYPE STRING,
AEDAT TYPE STRING,
OBJNR TYPE STRING,
/MRSS/REQ_TYPE TYPE STRING,
/MRSS/REQ_LOB TYPE STRING,
/MRSS/REQ_REGION TYPE STRING,
/MRSS/REQ_CTRY TYPE STRING,
/MRSS/REQ_OWNER TYPE STRING,
/MRSS/REQUESTER TYPE STRING,
/MRSS/CUSTOMER TYPE STRING,
/MRSS/CEM TYPE STRING,
/MRSS/CORP_COMP TYPE STRING,
/MRSS/CORP_ORG TYPE STRING,
/MRSS/PROJ_ID TYPE STRING,
/MRSS/PROJ_MGR TYPE STRING,
/MRSS/ORIGIN TYPE STRING,
/MRSS/RC_MGR TYPE STRING,
/MRSS/CRM_PROB TYPE STRING,
/MRSS/CE_DIR TYPE STRING,
/MRSS/DLVRY_ORG TYPE STRING,
/MRSS/MUST_WIN TYPE STRING,
/MRSS/AGS_ESC TYPE STRING,
/MRSS/PRESALES TYPE STRING,
/MRSS/SYS_INFO TYPE STRING,
/MRSS/LOCATION TYPE STRING,
/MRSS/LANGUAGES TYPE STRING,
/MRSS/BILL_O_TYP TYPE STRING,
/MRSS/CONTR_ID TYPE STRING,
/MRSS/RM_ORD_PRB TYPE STRING,
/MRSS/STATUS_IND TYPE STRING,
/MRSS/PRIMED_BY TYPE STRING,
/MRSS/RM_FDTERMS TYPE STRING,
/MRSS/CREATEDBY TYPE STRING,
/MRSS/RL_ASS_TYP TYPE STRING,
/MRSS/SALES_ORGN TYPE STRING,
/MRSS/DEAL_CURR TYPE STRING,
/MRSS/INV_PART TYPE STRING,
/MRSS/REQ_PART TYPE STRING,
/MRSS/CUST_NAME2 TYPE STRING,
/MRSS/BILL_OBJ TYPE STRING,
/MRSS/CUST_CONTR TYPE STRING,
/MRSS/CHCKS_REQD TYPE STRING,
/MRSS/DEAL_VAL TYPE STRING,
/MRSS/CHANGED_AT TYPE STRING,
/MRSS/VERSION TYPE STRING,
/MRSS/PROJ_STATE TYPE STRING,
/MRSS/PROJ_CTRY TYPE STRING,
/MRSS/CREATEDON TYPE STRING,
/MRSS/PROJSERV TYPE STRING,
/MRSS/CD_OPPOR TYPE STRING,
/MRSS/RES_RM_ORG TYPE STRING,
/MRSS/SERV_PHASE TYPE STRING,
/MRSS/CN_SF_BK TYPE STRING,
/MRSS/REQ_CATEG TYPE STRING,
EXT_SYS_ID TYPE STRING,
EXT_SYS_TYPE TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/MRSS/D_RM_HEADR_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/D_RM_HEADR_STR-MANDT sy-vline 
WA_/MRSS/D_RM_HEADR_STR-GUID sy-vline 
WA_/MRSS/D_RM_HEADR_STR-REQUEST_NUMBER sy-vline 
WA_/MRSS/D_RM_HEADR_STR-DEMAND_TYPE sy-vline 
WA_/MRSS/D_RM_HEADR_STR-ERNAM sy-vline 
WA_/MRSS/D_RM_HEADR_STR-ERDAT sy-vline 
WA_/MRSS/D_RM_HEADR_STR-AENAM sy-vline 
WA_/MRSS/D_RM_HEADR_STR-AEDAT sy-vline 
WA_/MRSS/D_RM_HEADR_STR-OBJNR sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/REQ_TYPE sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/REQ_LOB sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/REQ_REGION sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/REQ_CTRY sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/REQ_OWNER sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/REQUESTER sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/CUSTOMER sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/CEM sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/CORP_COMP sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/CORP_ORG sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/PROJ_ID sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/PROJ_MGR sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/ORIGIN sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/RC_MGR sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/CRM_PROB sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/CE_DIR sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/DLVRY_ORG sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/MUST_WIN sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/AGS_ESC sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/PRESALES sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/SYS_INFO sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/LOCATION sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/LANGUAGES sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/BILL_O_TYP sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/CONTR_ID sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/RM_ORD_PRB sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/STATUS_IND sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/PRIMED_BY sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/RM_FDTERMS sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/CREATEDBY sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/RL_ASS_TYP sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/SALES_ORGN sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/DEAL_CURR sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/INV_PART sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/REQ_PART sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/CUST_NAME2 sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/BILL_OBJ sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/CUST_CONTR sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/CHCKS_REQD sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/DEAL_VAL sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/CHANGED_AT sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/VERSION sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/PROJ_STATE sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/PROJ_CTRY sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/CREATEDON sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/PROJSERV sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/CD_OPPOR sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/RES_RM_ORG sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/SERV_PHASE sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/CN_SF_BK sy-vline 
WA_/MRSS/D_RM_HEADR_STR-/MRSS/REQ_CATEG sy-vline 
WA_/MRSS/D_RM_HEADR_STR-EXT_SYS_ID sy-vline 
WA_/MRSS/D_RM_HEADR_STR-EXT_SYS_TYPE sy-vline      INTO ld_text SEPARATED BY SPACE.

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