SAP MASS_FLAG_CLEAR ABAP Select data from SAP table
Below is a number of ABAP code snippets to demonstrate how to select data from SAP MASS_FLAG_CLEAR 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 MASS_FLAG_CLEAR. 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 MASS_FLAG_CLEAR 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_MASS_FLAG_CLEAR TYPE STANDARD TABLE OF MASS_FLAG_CLEAR,
WA_MASS_FLAG_CLEAR TYPE MASS_FLAG_CLEAR,
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: <MASS_FLAG_CLEAR> TYPE MASS_FLAG_CLEAR.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_MASS_FLAG_CLEAR.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM MASS_FLAG_CLEAR
INTO TABLE IT_MASS_FLAG_CLEAR.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM MASS_FLAG_CLEAR
* INTO TABLE @DATA(IT_MASS_FLAG_CLEAR2).
*--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_MASS_FLAG_CLEAR INDEX 1 INTO DATA(WA_MASS_FLAG_CLEAR2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_MASS_FLAG_CLEAR ASSIGNING <MASS_FLAG_CLEAR>.
*To update a field value using a field symbol simply change the value via the field symbol pointer<MASS_FLAG_CLEAR>-CHECK1 = 1.
<MASS_FLAG_CLEAR>-CHECK2 = 1.
<MASS_FLAG_CLEAR>-CHECK3 = 1.
<MASS_FLAG_CLEAR>-CHECK4 = 1.
<MASS_FLAG_CLEAR>-CHECK5 = 1.
ENDLOOP. LOOP AT IT_MASS_FLAG_CLEAR INTO WA_MASS_FLAG_CLEAR. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_MASS_FLAG_CLEAR-CHECK6, sy-vline,
WA_MASS_FLAG_CLEAR-CHECK7, sy-vline,
WA_MASS_FLAG_CLEAR-CHECK8, sy-vline,
WA_MASS_FLAG_CLEAR-CHECK9, sy-vline,
WA_MASS_FLAG_CLEAR-CHECK10, sy-vline,
WA_MASS_FLAG_CLEAR-CHECK11, sy-vline.
ENDLOOP. *Add any further fields from structure WA_MASS_FLAG_CLEAR 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_MASS_FLAG_CLEAR 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_MASS_FLAG_CLEAR INTO WA_MASS_FLAG_CLEAR. *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_MASS_FLAG_CLEAR_STR,
CHECK1 TYPE STRING,
CHECK2 TYPE STRING,
CHECK3 TYPE STRING,
CHECK4 TYPE STRING,
CHECK5 TYPE STRING,
CHECK6 TYPE STRING,
CHECK7 TYPE STRING,
CHECK8 TYPE STRING,
CHECK9 TYPE STRING,
CHECK10 TYPE STRING,
CHECK11 TYPE STRING,
CHECK12 TYPE STRING,
CHECK13 TYPE STRING,
CHECK14 TYPE STRING,
CHECK15 TYPE STRING,
CHECK16 TYPE STRING,
CHECK17 TYPE STRING,
CHECK18 TYPE STRING,
CHECK19 TYPE STRING,
CHECK20 TYPE STRING,
CHECK21 TYPE STRING,
CHECK22 TYPE STRING,
CHECK23 TYPE STRING,
CHECK24 TYPE STRING,
CHECK25 TYPE STRING,
CHECK26 TYPE STRING,
CHECK27 TYPE STRING,
CHECK28 TYPE STRING,
CHECK29 TYPE STRING,
CHECK30 TYPE STRING,
CHECK31 TYPE STRING,
CHECK32 TYPE STRING,
CHECK33 TYPE STRING,
CHECK34 TYPE STRING,
CHECK35 TYPE STRING,
CHECK36 TYPE STRING,
CHECK37 TYPE STRING,
CHECK38 TYPE STRING,
CHECK39 TYPE STRING,
CHECK40 TYPE STRING,
CHECK41 TYPE STRING,
CHECK42 TYPE STRING,
CHECK43 TYPE STRING,
CHECK44 TYPE STRING,
CHECK45 TYPE STRING,
CHECK46 TYPE STRING,
CHECK47 TYPE STRING,
CHECK48 TYPE STRING,
CHECK49 TYPE STRING,
CHECK50 TYPE STRING,
CHECK51 TYPE STRING,
CHECK52 TYPE STRING,
CHECK53 TYPE STRING,
CHECK54 TYPE STRING,
CHECK55 TYPE STRING,
CHECK56 TYPE STRING,
CHECK57 TYPE STRING,
CHECK58 TYPE STRING,
CHECK59 TYPE STRING,
CHECK60 TYPE STRING,
CHECK61 TYPE STRING,
CHECK62 TYPE STRING,
CHECK63 TYPE STRING,
CHECK64 TYPE STRING,
CHECK65 TYPE STRING,
CHECK66 TYPE STRING,
CHECK67 TYPE STRING,
CHECK68 TYPE STRING,
CHECK69 TYPE STRING,
CHECK70 TYPE STRING,
CHECK71 TYPE STRING,
CHECK72 TYPE STRING,
CHECK73 TYPE STRING,
CHECK74 TYPE STRING,
CHECK75 TYPE STRING,
CHECK76 TYPE STRING,
CHECK77 TYPE STRING,
CHECK78 TYPE STRING,
CHECK79 TYPE STRING,
CHECK80 TYPE STRING,
CHECK81 TYPE STRING,
CHECK82 TYPE STRING,
CHECK83 TYPE STRING,
CHECK84 TYPE STRING,
CHECK85 TYPE STRING,
CHECK86 TYPE STRING,
CHECK87 TYPE STRING,
CHECK88 TYPE STRING,
CHECK89 TYPE STRING,
CHECK90 TYPE STRING,
CHECK91 TYPE STRING,
CHECK92 TYPE STRING,
CHECK93 TYPE STRING,
CHECK94 TYPE STRING,
CHECK95 TYPE STRING,
CHECK96 TYPE STRING,
CHECK97 TYPE STRING,
CHECK98 TYPE STRING,
CHECK99 TYPE STRING,END OF T_EKKO_STR. DATA: WA_MASS_FLAG_CLEAR_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_MASS_FLAG_CLEAR_STR-CHECK1 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK2 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK3 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK4 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK5 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK6 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK7 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK8 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK9 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK10 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK11 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK12 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK13 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK14 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK15 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK16 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK17 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK18 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK19 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK20 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK21 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK22 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK23 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK24 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK25 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK26 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK27 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK28 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK29 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK30 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK31 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK32 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK33 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK34 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK35 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK36 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK37 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK38 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK39 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK40 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK41 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK42 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK43 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK44 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK45 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK46 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK47 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK48 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK49 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK50 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK51 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK52 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK53 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK54 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK55 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK56 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK57 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK58 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK59 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK60 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK61 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK62 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK63 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK64 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK65 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK66 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK67 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK68 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK69 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK70 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK71 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK72 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK73 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK74 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK75 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK76 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK77 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK78 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK79 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK80 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK81 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK82 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK83 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK84 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK85 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK86 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK87 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK88 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK89 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK90 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK91 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK92 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK93 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK94 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK95 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK96 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK97 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK98 sy-vline
WA_MASS_FLAG_CLEAR_STR-CHECK99 sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.
Search for further information about these or an SAP related objects