ABAP Select data from SAP table DPR_MSPREQUEST_RESPONSE 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 DPR_MSPREQUEST_RESPONSE 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 DPR_MSPREQUEST_RESPONSE. 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 DPR_MSPREQUEST_RESPONSE 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_DPR_MSPREQUEST_RESPONSE TYPE STANDARD TABLE OF DPR_MSPREQUEST_RESPONSE,
      WA_DPR_MSPREQUEST_RESPONSE TYPE DPR_MSPREQUEST_RESPONSE,
      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: <DPR_MSPREQUEST_RESPONSE> TYPE DPR_MSPREQUEST_RESPONSE.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM DPR_MSPREQUEST_RESPONSE
*  INTO TABLE @DATA(IT_DPR_MSPREQUEST_RESPONSE2).
*--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_DPR_MSPREQUEST_RESPONSE INDEX 1 INTO DATA(WA_DPR_MSPREQUEST_RESPONSE2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<DPR_MSPREQUEST_RESPONSE>-PROJECT = 1.
<DPR_MSPREQUEST_RESPONSE>-SAVE_VERSION = 1.
<DPR_MSPREQUEST_RESPONSE>-UID = 1.
<DPR_MSPREQUEST_RESPONSE>-NAME = 1.
<DPR_MSPREQUEST_RESPONSE>-TITLE = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_DPR_MSPREQUEST_RESPONSE-SUBJECT, sy-vline,
  WA_DPR_MSPREQUEST_RESPONSE-CATEGORY, sy-vline,
  WA_DPR_MSPREQUEST_RESPONSE-COMPANY, sy-vline,
  WA_DPR_MSPREQUEST_RESPONSE-MANAGER, sy-vline,
  WA_DPR_MSPREQUEST_RESPONSE-AUTHOR, sy-vline,
  WA_DPR_MSPREQUEST_RESPONSE-CREATION_DATE, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_DPR_MSPREQUEST_RESPONSE 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_DPR_MSPREQUEST_RESPONSE 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_DPR_MSPREQUEST_RESPONSE INTO WA_DPR_MSPREQUEST_RESPONSE.


*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.
ENDFORM. 

*&---------------------------------------------------------------------*
*& Form process_as_string_field_values
*&---------------------------------------------------------------------*
FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO.

TYPES: BEGIN OF T_DPR_MSPREQUEST_RESPONSE_STR, 
PROJECT TYPE STRING,
SAVE_VERSION TYPE STRING,
UID TYPE STRING,
NAME TYPE STRING,
TITLE TYPE STRING,
SUBJECT TYPE STRING,
CATEGORY TYPE STRING,
COMPANY TYPE STRING,
MANAGER TYPE STRING,
AUTHOR TYPE STRING,
CREATION_DATE TYPE STRING,
REVISION TYPE STRING,
LAST_SAVED TYPE STRING,
SCHEDULE_FROM_START TYPE STRING,
START_DATE TYPE STRING,
FINISH_DATE TYPE STRING,
FYSTART_DATE TYPE STRING,
CRITICAL_SLACK_LIMIT TYPE STRING,
CURRENCY_DIGITS TYPE STRING,
CURRENCY_SYMBOL TYPE STRING,
CURRENCY_CODE TYPE STRING,
CURRENCY_SYMBOL_POSITION TYPE STRING,
CALENDAR_UID TYPE STRING,
DEFAULT_START_TIME TYPE STRING,
DEFAULT_FINISH_TIME TYPE STRING,
MINUTES_PER_DAY TYPE STRING,
MINUTES_PER_WEEK TYPE STRING,
DAYS_PER_MONTH TYPE STRING,
DEFAULT_TASK_TYPE TYPE STRING,
DEFAULT_FIXED_COST_ACCRUAL TYPE STRING,
DEFAULT_STANDARD_RATE TYPE STRING,
DEFAULT_OVERTIME_RATE TYPE STRING,
DURATION_FORMAT TYPE STRING,
WORK_FORMAT TYPE STRING,
EDITABLE_ACTUAL_COSTS TYPE STRING,
HONOR_CONSTRAINTS TYPE STRING,
EARNED_VALUE_METHOD TYPE STRING,
INSERTED_PROJECTS_LIKE_SUMMARY TYPE STRING,
MULTIPLE_CRITICAL_PATHS TYPE STRING,
NEW_TASKS_EFFORT_DRIVEN TYPE STRING,
NEW_TASKS_ESTIMATED TYPE STRING,
SPLITS_IN_PROGRESS_TASKS TYPE STRING,
SPREAD_ACTUAL_COST TYPE STRING,
SPREAD_PERCENT_COMPLETE TYPE STRING,
TASK_UPDATES_RESOURCE TYPE STRING,
FISCAL_YEAR_START TYPE STRING,
WEEK_START_DAY TYPE STRING,
MOVE_COMPLETED_ENDS_BACK TYPE STRING,
MOVE_REMAINING_STARTS_BACK TYPE STRING,
MOVE_REMAINING_STARTS_FORWARD TYPE STRING,
MOVE_COMPLETED_ENDS_FORWARD TYPE STRING,
BASELINE_FOR_EARNED_VALUE TYPE STRING,
AUTO_ADD_NEW_RESOURCES_AND_TA TYPE STRING,
STATUS_DATE TYPE STRING,
CURRENT_DATE TYPE STRING,
MICROSOFT_PROJECT_SERVER_URL TYPE STRING,
AUTOLINK TYPE STRING,
NEW_TASK_START_DATE TYPE STRING,
NEW_TASKS_ARE_MANUAL TYPE STRING,
DEFAULT_TASK_EVMETHOD TYPE STRING,
PROJECT_EXTERNALLY_EDITED TYPE STRING,
EXTENDED_CREATION_DATE TYPE STRING,
ACTUALS_IN_SYNC TYPE STRING,
REMOVE_FILE_PROPERTIES TYPE STRING,
ADMIN_PROJECT TYPE STRING,
UPDATE_MANUALLY_SCHEDULED_TASK TYPE STRING,
KEEP_TASK_ON_NEAREST_WORKING_T TYPE STRING,
OUTLINE_CODES TYPE STRING,
OUTLINE_CODE TYPE STRING,
WBSMASKS TYPE STRING,
VERIFY_UNIQUE_CODES TYPE STRING,
GENERATE_CODES TYPE STRING,
PREFIX TYPE STRING,
WBSMASK TYPE STRING,
EXTENDED_ATTRIBUTES TYPE STRING,
EXTENDED_ATTRIBUTE TYPE STRING,
CALENDARS TYPE STRING,
CALENDAR TYPE STRING,
TASKS TYPE STRING,
TASK TYPE STRING,
RESOURCES TYPE STRING,
RESOURCE TYPE STRING,
ASSIGNMENTS TYPE STRING,
ASSIGNMENT TYPE STRING,END OF T_EKKO_STR.
DATA: WA_DPR_MSPREQUEST_RESPONSE_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_DPR_MSPREQUEST_RESPONSE_STR-PROJECT sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-SAVE_VERSION sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-UID sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-NAME sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-TITLE sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-SUBJECT sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-CATEGORY sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-COMPANY sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-MANAGER sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-AUTHOR sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-CREATION_DATE sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-REVISION sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-LAST_SAVED sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-SCHEDULE_FROM_START sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-START_DATE sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-FINISH_DATE sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-FYSTART_DATE sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-CRITICAL_SLACK_LIMIT sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-CURRENCY_DIGITS sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-CURRENCY_SYMBOL sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-CURRENCY_CODE sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-CURRENCY_SYMBOL_POSITION sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-CALENDAR_UID sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-DEFAULT_START_TIME sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-DEFAULT_FINISH_TIME sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-MINUTES_PER_DAY sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-MINUTES_PER_WEEK sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-DAYS_PER_MONTH sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-DEFAULT_TASK_TYPE sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-DEFAULT_FIXED_COST_ACCRUAL sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-DEFAULT_STANDARD_RATE sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-DEFAULT_OVERTIME_RATE sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-DURATION_FORMAT sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-WORK_FORMAT sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-EDITABLE_ACTUAL_COSTS sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-HONOR_CONSTRAINTS sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-EARNED_VALUE_METHOD sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-INSERTED_PROJECTS_LIKE_SUMMARY sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-MULTIPLE_CRITICAL_PATHS sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-NEW_TASKS_EFFORT_DRIVEN sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-NEW_TASKS_ESTIMATED sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-SPLITS_IN_PROGRESS_TASKS sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-SPREAD_ACTUAL_COST sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-SPREAD_PERCENT_COMPLETE sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-TASK_UPDATES_RESOURCE sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-FISCAL_YEAR_START sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-WEEK_START_DAY sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-MOVE_COMPLETED_ENDS_BACK sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-MOVE_REMAINING_STARTS_BACK sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-MOVE_REMAINING_STARTS_FORWARD sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-MOVE_COMPLETED_ENDS_FORWARD sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-BASELINE_FOR_EARNED_VALUE sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-AUTO_ADD_NEW_RESOURCES_AND_TA sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-STATUS_DATE sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-CURRENT_DATE sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-MICROSOFT_PROJECT_SERVER_URL sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-AUTOLINK sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-NEW_TASK_START_DATE sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-NEW_TASKS_ARE_MANUAL sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-DEFAULT_TASK_EVMETHOD sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-PROJECT_EXTERNALLY_EDITED sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-EXTENDED_CREATION_DATE sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-ACTUALS_IN_SYNC sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-REMOVE_FILE_PROPERTIES sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-ADMIN_PROJECT sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-UPDATE_MANUALLY_SCHEDULED_TASK sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-KEEP_TASK_ON_NEAREST_WORKING_T sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-OUTLINE_CODES sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-OUTLINE_CODE sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-WBSMASKS sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-VERIFY_UNIQUE_CODES sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-GENERATE_CODES sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-PREFIX sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-WBSMASK sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-EXTENDED_ATTRIBUTES sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-EXTENDED_ATTRIBUTE sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-CALENDARS sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-CALENDAR sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-TASKS sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-TASK sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-RESOURCES sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-RESOURCE sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-ASSIGNMENTS sy-vline 
WA_DPR_MSPREQUEST_RESPONSE_STR-ASSIGNMENT sy-vline      INTO ld_text SEPARATED BY SPACE.

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