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

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

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

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


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
</MRSS/T_BW_EXTR_REQUEST>-GUID = 1.
</MRSS/T_BW_EXTR_REQUEST>-AUFNR = 1.
</MRSS/T_BW_EXTR_REQUEST>-AUTYP = 1.
</MRSS/T_BW_EXTR_REQUEST>-ERNAM = 1.
</MRSS/T_BW_EXTR_REQUEST>-ERDAT = 1.

ENDLOOP.

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

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


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

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

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

*Conversion exit ALPHA, internal->external for field PRCTR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_/MRSS/T_BW_EXTR_REQUEST-PRCTR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/MRSS/T_BW_EXTR_REQUEST-PRCTR.
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/T_BW_EXTR_REQUEST-/MRSS/DLVRY_ORG
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/MRSS/T_BW_EXTR_REQUEST-/MRSS/DLVRY_ORG.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit ALPHA, internal->external for field INVPARTN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_/MRSS/T_BW_EXTR_REQUEST-INVPARTN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/MRSS/T_BW_EXTR_REQUEST-INVPARTN.
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/T_BW_EXTR_REQUEST-/MRSS/SALES_ORGN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/MRSS/T_BW_EXTR_REQUEST-/MRSS/SALES_ORGN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field /MRSS/BILL_OBJ
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_/MRSS/T_BW_EXTR_REQUEST-/MRSS/BILL_OBJ
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/MRSS/T_BW_EXTR_REQUEST-/MRSS/BILL_OBJ.
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_BW_EXTR_REQUEST_STR, 
GUID TYPE STRING,
AUFNR TYPE STRING,
AUTYP TYPE STRING,
ERNAM TYPE STRING,
ERDAT TYPE STRING,
AENAM TYPE STRING,
AEDAT TYPE STRING,
APRIO TYPE STRING,
/MRSS/REQUESTER TYPE STRING,
/MRSS/REQ_LOB TYPE STRING,
/MRSS/REQ_REGION TYPE STRING,
SUB_REGION TYPE STRING,
/MRSS/REQ_CTRY TYPE STRING,
/MRSS/REQ_OWNER TYPE STRING,
/MRSS/PL_STRU_ID TYPE STRING,
/MRSS/CUSTOMER TYPE STRING,
USER0 TYPE STRING,
USER1 TYPE STRING,
/MRSS/CUST_CONTR TYPE STRING,
CUST_INDUSTRY TYPE STRING,
CUSTOMER_CLASS TYPE STRING,
/MRSS/CEM TYPE STRING,
/MRSS/CORP_COMP TYPE STRING,
/MRSS/CORP_ORG TYPE STRING,
GSTRP TYPE STRING,
GLTRP TYPE STRING,
/MRSS/PROJ_ID TYPE STRING,
/MRSS/PROJ_MGR TYPE STRING,
USER3 TYPE STRING,
/MRSS/CONTR_ID TYPE STRING,
/MRSS/BILL_O_TYP TYPE STRING,
AUFEX TYPE STRING,
/MRSS/ORIGIN TYPE STRING,
/MRSS/RC_MGR TYPE STRING,
/MRSS/CRM_PROB TYPE STRING,
/MRSS/RM_ORD_PRB TYPE STRING,
USER4 TYPE STRING,
WAERS TYPE STRING,
CONS_ENGAGE_DIR TYPE STRING,
PRCTR TYPE STRING,
/MRSS/DLVRY_ORG TYPE STRING,
USER9 TYPE STRING,
/MRSS/MUST_WIN TYPE STRING,
/MRSS/AGS_ESC TYPE STRING,
/MRSS/PRESALES TYPE STRING,
USER2 TYPE STRING,
SYSTEM_INFO TYPE STRING,
RM_SYSTEM TYPE STRING,
/MRSS/LOCATION TYPE STRING,
/MRSS/LANGUAGES TYPE STRING,
ASSIGNMENT_TYPE TYPE STRING,
DELKOSTL TYPE STRING,
DELVKORG TYPE STRING,
SALKOSTL TYPE STRING,
SALVKORG TYPE STRING,
INVPARTN TYPE STRING,
REQSTATUS TYPE STRING,
REQCLDAT TYPE STRING,
REQ_DATE TYPE STRING,
/MRSS/SALES_ORGN TYPE STRING,
/MRSS/CE_DIR TYPE STRING,
/MRSS/BILL_OBJ TYPE STRING,
/MRSS/RM_ASS_TYP TYPE STRING,
/MRSS/PRIMED_BY TYPE STRING,
/MRSS/INV_PART TYPE STRING,
/MRSS/REQ_PART TYPE STRING,
/MRSS/CUST_NAME2 TYPE STRING,
/MRSS/RM_FDTERMS TYPE STRING,
/MRSS/SYS_INFO TYPE STRING,
/MRSS/REQ_TYPE TYPE STRING,
/MRSS/CREATEDBY TYPE STRING,
/MRSS/RES_RM_ORG TYPE STRING,
/MRSS/PROJSERV TYPE STRING,
/MRSS/CD_OPPOR TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/MRSS/T_BW_EXTR_REQUEST_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_BW_EXTR_REQUEST_STR-GUID sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-AUFNR sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-AUTYP sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-ERNAM sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-ERDAT sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-AENAM sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-AEDAT sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-APRIO sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/REQUESTER sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/REQ_LOB sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/REQ_REGION sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-SUB_REGION sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/REQ_CTRY sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/REQ_OWNER sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/PL_STRU_ID sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/CUSTOMER sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-USER0 sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-USER1 sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/CUST_CONTR sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-CUST_INDUSTRY sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-CUSTOMER_CLASS sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/CEM sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/CORP_COMP sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/CORP_ORG sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-GSTRP sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-GLTRP sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/PROJ_ID sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/PROJ_MGR sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-USER3 sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/CONTR_ID sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/BILL_O_TYP sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-AUFEX sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/ORIGIN sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/RC_MGR sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/CRM_PROB sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/RM_ORD_PRB sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-USER4 sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-WAERS sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-CONS_ENGAGE_DIR sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-PRCTR sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/DLVRY_ORG sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-USER9 sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/MUST_WIN sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/AGS_ESC sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/PRESALES sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-USER2 sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-SYSTEM_INFO sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-RM_SYSTEM sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/LOCATION sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/LANGUAGES sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-ASSIGNMENT_TYPE sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-DELKOSTL sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-DELVKORG sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-SALKOSTL sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-SALVKORG sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-INVPARTN sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-REQSTATUS sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-REQCLDAT sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-REQ_DATE sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/SALES_ORGN sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/CE_DIR sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/BILL_OBJ sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/RM_ASS_TYP sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/PRIMED_BY sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/INV_PART sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/REQ_PART sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/CUST_NAME2 sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/RM_FDTERMS sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/SYS_INFO sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/REQ_TYPE sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/CREATEDBY sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/RES_RM_ORG sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/PROJSERV sy-vline 
WA_/MRSS/T_BW_EXTR_REQUEST_STR-/MRSS/CD_OPPOR sy-vline      INTO ld_text SEPARATED BY SPACE.

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