ABAP Select data from SAP table /SCWM/S_RF_DYNAMIC into internal table
Get Example source ABAP code based on a different SAP table
Below is a number of ABAP code snippets to demonstrate how to select data from SAP /SCWM/S_RF_DYNAMIC 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 /SCWM/S_RF_DYNAMIC. 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 /SCWM/S_RF_DYNAMIC 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_/SCWM/S_RF_DYNAMIC TYPE STANDARD TABLE OF /SCWM/S_RF_DYNAMIC,
WA_/SCWM/S_RF_DYNAMIC TYPE /SCWM/S_RF_DYNAMIC,
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: </SCWM/S_RF_DYNAMIC> TYPE /SCWM/S_RF_DYNAMIC.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_/SCWM/S_RF_DYNAMIC.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM /SCWM/S_RF_DYNAMIC
INTO TABLE IT_/SCWM/S_RF_DYNAMIC.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM /SCWM/S_RF_DYNAMIC
* INTO TABLE @DATA(IT_/SCWM/S_RF_DYNAMIC2).
*--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_/SCWM/S_RF_DYNAMIC INDEX 1 INTO DATA(WA_/SCWM/S_RF_DYNAMIC2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/SCWM/S_RF_DYNAMIC ASSIGNING </SCWM/S_RF_DYNAMIC>.
*To update a field value using a field symbol simply change the value via the field symbol pointer</SCWM/S_RF_DYNAMIC>-FLG_INIT = 1.
</SCWM/S_RF_DYNAMIC>-LTRANS = 1.
</SCWM/S_RF_DYNAMIC>-TRANS = 1.
</SCWM/S_RF_DYNAMIC>-STEP = 1.
</SCWM/S_RF_DYNAMIC>-FCODE = 1.
ENDLOOP. LOOP AT IT_/SCWM/S_RF_DYNAMIC INTO WA_/SCWM/S_RF_DYNAMIC. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_/SCWM/S_RF_DYNAMIC-PRMOD, sy-vline,
WA_/SCWM/S_RF_DYNAMIC-MENU, sy-vline,
WA_/SCWM/S_RF_DYNAMIC-MENU_PAGE_ROW, sy-vline,
WA_/SCWM/S_RF_DYNAMIC-LISTBOX_PAGE_ROW, sy-vline,
WA_/SCWM/S_RF_DYNAMIC-STATE, sy-vline,
WA_/SCWM/S_RF_DYNAMIC-SQNCE, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/SCWM/S_RF_DYNAMIC 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_/SCWM/S_RF_DYNAMIC 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_/SCWM/S_RF_DYNAMIC INTO WA_/SCWM/S_RF_DYNAMIC. *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_/SCWM/S_RF_DYNAMIC_STR,
FLG_INIT TYPE STRING,
LTRANS TYPE STRING,
TRANS TYPE STRING,
STEP TYPE STRING,
FCODE TYPE STRING,
PRMOD TYPE STRING,
MENU TYPE STRING,
MENU_PAGE_ROW TYPE STRING,
LISTBOX_PAGE_ROW TYPE STRING,
STATE TYPE STRING,
SQNCE TYPE STRING,
SCR_SQNCE TYPE STRING,
SCRELM TYPE STRING,
MENU1 TYPE STRING,
MENU2 TYPE STRING,
MENU3 TYPE STRING,
MENU4 TYPE STRING,
MENU5 TYPE STRING,
MENU6 TYPE STRING,
MENU7 TYPE STRING,
MENU8 TYPE STRING,
MENU9 TYPE STRING,
MENU10 TYPE STRING,
MENU11 TYPE STRING,
MENU12 TYPE STRING,
MENU13 TYPE STRING,
MENU14 TYPE STRING,
MENU15 TYPE STRING,
MENU16 TYPE STRING,
MENU17 TYPE STRING,
MENU18 TYPE STRING,
MENU19 TYPE STRING,
MENU20 TYPE STRING,
MENU TYPE STRING,
PGUP TYPE STRING,
PGDN TYPE STRING,
PB1 TYPE STRING,
PB2 TYPE STRING,
PB3 TYPE STRING,
PB4 TYPE STRING,
PB5 TYPE STRING,
PB6 TYPE STRING,
PB7 TYPE STRING,
PB8 TYPE STRING,
PB9 TYPE STRING,
PB10 TYPE STRING,
PB11 TYPE STRING,
PB12 TYPE STRING,
PB13 TYPE STRING,
PB14 TYPE STRING,
PB15 TYPE STRING,
PB16 TYPE STRING,
MSGTX TYPE STRING,
MSG TYPE STRING,
MSGT1 TYPE STRING,
MSGT2 TYPE STRING,
MSGT3 TYPE STRING,
MSGT4 TYPE STRING,
SHORTCUT TYPE STRING,
REASON_CODE TYPE STRING,
LISTVAL1 TYPE STRING,
LISTVAL2 TYPE STRING,
LISTVAL3 TYPE STRING,
LISTVAL4 TYPE STRING,
LISTVAL5 TYPE STRING,
LISTVAL6 TYPE STRING,
LISTVAL7 TYPE STRING,
LISTVAL8 TYPE STRING,
LISTVAL9 TYPE STRING,
LISTVAL10 TYPE STRING,
LISTVAL11 TYPE STRING,
LISTVAL12 TYPE STRING,
LISTVAL13 TYPE STRING,
LISTVAL14 TYPE STRING,
LISTVAL15 TYPE STRING,
LISTVAL16 TYPE STRING,
LISTVAL17 TYPE STRING,
LISTVAL18 TYPE STRING,
LISTVAL19 TYPE STRING,
LISTVAL20 TYPE STRING,
LISTVAL TYPE STRING,
FLG_MORE TYPE STRING,
MSGT5 TYPE STRING,
MSGT6 TYPE STRING,
MSGT7 TYPE STRING,
MSGT8 TYPE STRING,
PB17 TYPE STRING,
PB18 TYPE STRING,
PB19 TYPE STRING,
PB20 TYPE STRING,
PB21 TYPE STRING,
PB22 TYPE STRING,
PB23 TYPE STRING,
PB24 TYPE STRING,
PB25 TYPE STRING,
PB26 TYPE STRING,
PB27 TYPE STRING,
PB28 TYPE STRING,
PB29 TYPE STRING,
PB30 TYPE STRING,
PB31 TYPE STRING,
PB32 TYPE STRING,
MSG_ANSWER TYPE STRING,
MSG_ANSWER_DEFAULT TYPE STRING,
LINE TYPE STRING,
CURSOR_LINE TYPE STRING,
FIELD TYPE STRING,
FIELD_AUTONAV TYPE STRING,
SCR_TABNAME TYPE STRING,
MSG_POST TYPE STRING,
MSG_PREV TYPE STRING,
BELL_SIGNAL TYPE STRING,
FLG_INPUT_POSSIBLE TYPE STRING,
FLG_INPUT_REQUIRED TYPE STRING,
FIELD_REQUIRED TYPE STRING,
FLG_DEQUEUE_ALL TYPE STRING,
LAST_LTRANS TYPE STRING,
LTRANS_SIMU TYPE STRING,END OF T_EKKO_STR. DATA: WA_/SCWM/S_RF_DYNAMIC_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_/SCWM/S_RF_DYNAMIC_STR-FLG_INIT sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LTRANS sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-TRANS sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-STEP sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-FCODE sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PRMOD sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU_PAGE_ROW sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTBOX_PAGE_ROW sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-STATE sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-SQNCE sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-SCR_SQNCE sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-SCRELM sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU1 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU2 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU3 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU4 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU5 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU6 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU7 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU8 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU9 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU10 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU11 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU12 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU13 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU14 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU15 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU16 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU17 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU18 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU19 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU20 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MENU sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PGUP sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PGDN sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB1 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB2 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB3 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB4 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB5 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB6 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB7 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB8 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB9 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB10 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB11 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB12 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB13 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB14 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB15 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB16 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MSGTX sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MSG sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MSGT1 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MSGT2 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MSGT3 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MSGT4 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-SHORTCUT sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-REASON_CODE sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL1 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL2 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL3 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL4 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL5 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL6 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL7 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL8 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL9 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL10 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL11 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL12 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL13 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL14 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL15 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL16 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL17 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL18 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL19 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL20 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LISTVAL sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-FLG_MORE sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MSGT5 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MSGT6 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MSGT7 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MSGT8 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB17 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB18 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB19 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB20 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB21 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB22 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB23 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB24 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB25 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB26 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB27 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB28 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB29 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB30 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB31 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-PB32 sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MSG_ANSWER sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MSG_ANSWER_DEFAULT sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LINE sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-CURSOR_LINE sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-FIELD sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-FIELD_AUTONAV sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-SCR_TABNAME sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MSG_POST sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-MSG_PREV sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-BELL_SIGNAL sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-FLG_INPUT_POSSIBLE sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-FLG_INPUT_REQUIRED sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-FIELD_REQUIRED sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-FLG_DEQUEUE_ALL sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LAST_LTRANS sy-vline
WA_/SCWM/S_RF_DYNAMIC_STR-LTRANS_SIMU sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.
