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

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

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

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


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
</SAPSRM/S_PDO_RFQ_COMMON>-PROC_ORG = 1.
</SAPSRM/S_PDO_RFQ_COMMON>-CURRENCY = 1.
</SAPSRM/S_PDO_RFQ_COMMON>-CATALOG_ID = 1.
</SAPSRM/S_PDO_RFQ_COMMON>-BIDDER_FCT = 1.
</SAPSRM/S_PDO_RFQ_COMMON>-CONTACT_FCT = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/SAPSRM/S_PDO_RFQ_COMMON-PORTAL_FCT, sy-vline,
  WA_/SAPSRM/S_PDO_RFQ_COMMON-RECIPIENT_FCT, sy-vline,
  WA_/SAPSRM/S_PDO_RFQ_COMMON-LOCATION_FCT, sy-vline,
  WA_/SAPSRM/S_PDO_RFQ_COMMON-REQUESTOR_FCT, sy-vline,
  WA_/SAPSRM/S_PDO_RFQ_COMMON-SHIP_TO_FCT, sy-vline,
  WA_/SAPSRM/S_PDO_RFQ_COMMON-ORDERING_FCT, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/SAPSRM/S_PDO_RFQ_COMMON 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_/SAPSRM/S_PDO_RFQ_COMMON 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_/SAPSRM/S_PDO_RFQ_COMMON INTO WA_/SAPSRM/S_PDO_RFQ_COMMON.


*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 LOGSYS_FI
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_/SAPSRM/S_PDO_RFQ_COMMON-LOGSYS_FI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/SAPSRM/S_PDO_RFQ_COMMON-LOGSYS_FI.
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_/SAPSRM/S_PDO_RFQ_COMMON_STR, 
PROC_ORG TYPE STRING,
CURRENCY TYPE STRING,
CATALOG_ID TYPE STRING,
BIDDER_FCT TYPE STRING,
CONTACT_FCT TYPE STRING,
PORTAL_FCT TYPE STRING,
RECIPIENT_FCT TYPE STRING,
LOCATION_FCT TYPE STRING,
REQUESTOR_FCT TYPE STRING,
SHIP_TO_FCT TYPE STRING,
ORDERING_FCT TYPE STRING,
EXTERNAL_AUCT TYPE STRING,
LOGSYS_FI TYPE STRING,
CO_CODE TYPE STRING,
SRM_AUC_SERVER_ID TYPE STRING,
SRM_AUC_SERVER TYPE STRING,
SRM_AUC_SSL TYPE STRING,
PROC_GROUP TYPE STRING,
HISTORIC_VERSION TYPE STRING,
SERVICE_AGENT_FCT TYPE STRING,
SRM_AUC_SERVER_ID_EXT TYPE STRING,
SRM_AUC_SERVER_EXT TYPE STRING,
SUS_AUC_SERVER_ID TYPE STRING,
SUS_AUC_SERVER TYPE STRING,
SUS_AUC_SSL TYPE STRING,
SUS_AUC TYPE STRING,
CLIENT TYPE STRING,
PROCESS_TYPE TYPE STRING,
P_DESCRIPTION_20 TYPE STRING,
NUMBER_RANGE_INT TYPE STRING,
NUMBER_RANGE_EXT TYPE STRING,
PROCESS_BLOCKED TYPE STRING,
BUP_SCHEMA_ID TYPE STRING,
TEXT_SCHEME_ID TYPE STRING,
EVENT_SCHEMA_ID TYPE STRING,
SIG_CONF_OPT TYPE STRING,
USER_STAT_PROC TYPE STRING,
OBJECT_TYPE TYPE STRING,
S_DESCRIPTION_20 TYPE STRING,
SUBTYPE TYPE STRING,
CTR_IND TYPE STRING,
PO_IND TYPE STRING,
BID_TYPE TYPE STRING,
USE_CONDITIONS TYPE STRING,
QUAN_CONTROL TYPE STRING,
ADD_ITEMS_IND TYPE STRING,
SHOW_WEIGHIN_IND TYPE STRING,
BID_ALL_ITMS_IND TYPE STRING,
BID_VALIDATION TYPE STRING,
DECR_TYPE TYPE STRING,
BID_CHG_ALLOWED TYPE STRING,
INRPRC TYPE STRING,
INRANK TYPE STRING,
INCRNK TYPE STRING,
INBSBD TYPE STRING,
INCBSB TYPE STRING,
INNXBD TYPE STRING,
INFRST TYPE STRING,
INHUFB TYPE STRING,
INCOMP TYPE STRING,
INBIDN TYPE STRING,
INBDPR TYPE STRING,
INAEXT TYPE STRING,
INNMBD TYPE STRING,
INCBID TYPE STRING,
CTBDNR TYPE STRING,
CTBDVL TYPE STRING,
CTBDBS TYPE STRING,
RNOTIE TYPE STRING,
RWTTIE TYPE STRING,
SNDCHT TYPE STRING,
COMP_MULTI_BID TYPE STRING,
FULL_QTY_IND TYPE STRING,
INCLPR TYPE STRING,
ALLOW_TEAM_PURCH TYPE STRING,
BEGDA TYPE STRING,
ENDDA TYPE STRING,
TP_CRSORG_ASSGMT TYPE STRING,
OFFLINE_IND TYPE STRING,
BIDDING_SYSTEM TYPE STRING,
LIMIT_CTRL_FLAG TYPE STRING,
BBP_MENV_SCHEMA TYPE STRING,
DEFAULT_DESC TYPE STRING,
GUID_COUNTER TYPE STRING,
CHANGED TYPE STRING,
HIGHLIGHT TYPE STRING,
ACTION_PARK TYPE STRING,
ACTION_SAVE TYPE STRING,
ORG_DATA TYPE STRING,
CLIENT TYPE STRING,
GUID TYPE STRING,
P_GUID TYPE STRING,
DEL_IND TYPE STRING,
PROC_ORG_RESP_OT TYPE STRING,
PROC_ORG_RESP_ID TYPE STRING,
PROC_ORG_OT TYPE STRING,
PROC_ORG_ID TYPE STRING,
PROC_GROUP_OT TYPE STRING,
PROC_GROUP_ID TYPE STRING,
SAVED TYPE STRING,
BOB_MODE TYPE STRING,
PROC_ORG_DESC TYPE STRING,
PROC_GROUP_DESC TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/SAPSRM/S_PDO_RFQ_COMMON_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_/SAPSRM/S_PDO_RFQ_COMMON_STR-PROC_ORG sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-CURRENCY sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-CATALOG_ID sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-BIDDER_FCT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-CONTACT_FCT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-PORTAL_FCT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-RECIPIENT_FCT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-LOCATION_FCT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-REQUESTOR_FCT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-SHIP_TO_FCT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-ORDERING_FCT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-EXTERNAL_AUCT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-LOGSYS_FI sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-CO_CODE sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-SRM_AUC_SERVER_ID sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-SRM_AUC_SERVER sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-SRM_AUC_SSL sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-PROC_GROUP sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-HISTORIC_VERSION sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-SERVICE_AGENT_FCT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-SRM_AUC_SERVER_ID_EXT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-SRM_AUC_SERVER_EXT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-SUS_AUC_SERVER_ID sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-SUS_AUC_SERVER sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-SUS_AUC_SSL sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-SUS_AUC sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-CLIENT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-PROCESS_TYPE sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-P_DESCRIPTION_20 sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-NUMBER_RANGE_INT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-NUMBER_RANGE_EXT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-PROCESS_BLOCKED sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-BUP_SCHEMA_ID sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-TEXT_SCHEME_ID sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-EVENT_SCHEMA_ID sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-SIG_CONF_OPT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-USER_STAT_PROC sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-OBJECT_TYPE sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-S_DESCRIPTION_20 sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-SUBTYPE sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-CTR_IND sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-PO_IND sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-BID_TYPE sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-USE_CONDITIONS sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-QUAN_CONTROL sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-ADD_ITEMS_IND sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-SHOW_WEIGHIN_IND sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-BID_ALL_ITMS_IND sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-BID_VALIDATION sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-DECR_TYPE sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-BID_CHG_ALLOWED sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-INRPRC sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-INRANK sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-INCRNK sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-INBSBD sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-INCBSB sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-INNXBD sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-INFRST sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-INHUFB sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-INCOMP sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-INBIDN sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-INBDPR sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-INAEXT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-INNMBD sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-INCBID sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-CTBDNR sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-CTBDVL sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-CTBDBS sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-RNOTIE sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-RWTTIE sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-SNDCHT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-COMP_MULTI_BID sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-FULL_QTY_IND sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-INCLPR sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-ALLOW_TEAM_PURCH sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-BEGDA sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-ENDDA sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-TP_CRSORG_ASSGMT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-OFFLINE_IND sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-BIDDING_SYSTEM sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-LIMIT_CTRL_FLAG sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-BBP_MENV_SCHEMA sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-DEFAULT_DESC sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-GUID_COUNTER sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-CHANGED sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-HIGHLIGHT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-ACTION_PARK sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-ACTION_SAVE sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-ORG_DATA sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-CLIENT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-GUID sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-P_GUID sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-DEL_IND sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-PROC_ORG_RESP_OT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-PROC_ORG_RESP_ID sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-PROC_ORG_OT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-PROC_ORG_ID sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-PROC_GROUP_OT sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-PROC_GROUP_ID sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-SAVED sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-BOB_MODE sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-PROC_ORG_DESC sy-vline 
WA_/SAPSRM/S_PDO_RFQ_COMMON_STR-PROC_GROUP_DESC sy-vline      INTO ld_text SEPARATED BY SPACE.

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