ABAP Select data from SAP table T702N 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 T702N 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 T702N. 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 T702N 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_T702N TYPE STANDARD TABLE OF T702N,
WA_T702N TYPE T702N,
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: <T702N> TYPE T702N.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_T702N.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM T702N
INTO TABLE IT_T702N.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM T702N
* INTO TABLE @DATA(IT_T702N2).
*--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_T702N INDEX 1 INTO DATA(WA_T702N2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_T702N ASSIGNING <T702N>.
*To update a field value using a field symbol simply change the value via the field symbol pointer<T702N>-MANDT = 1.
<T702N>-MOREI = 1.
<T702N>-B01 = 1.
<T702N>-B02 = 1.
<T702N>-B03 = 1.
ENDLOOP. LOOP AT IT_T702N INTO WA_T702N. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_T702N-B04, sy-vline,
WA_T702N-B05, sy-vline,
WA_T702N-B06, sy-vline,
WA_T702N-B07, sy-vline,
WA_T702N-B08, sy-vline,
WA_T702N-B09, sy-vline.
ENDLOOP. *Add any further fields from structure WA_T702N 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_T702N 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_T702N INTO WA_T702N. *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_T702N_STR,
MANDT TYPE STRING,
MOREI TYPE STRING,
B01 TYPE STRING,
B02 TYPE STRING,
B03 TYPE STRING,
B04 TYPE STRING,
B05 TYPE STRING,
B06 TYPE STRING,
B07 TYPE STRING,
B08 TYPE STRING,
B09 TYPE STRING,
B10 TYPE STRING,
B11 TYPE STRING,
B12 TYPE STRING,
B13 TYPE STRING,
B14 TYPE STRING,
B15 TYPE STRING,
B16 TYPE STRING,
B17 TYPE STRING,
B18 TYPE STRING,
B19 TYPE STRING,
B20 TYPE STRING,
B21 TYPE STRING,
B22 TYPE STRING,
B23 TYPE STRING,
B24 TYPE STRING,
B25 TYPE STRING,
B26 TYPE STRING,
B27 TYPE STRING,
B28 TYPE STRING,
B29 TYPE STRING,
B30 TYPE STRING,
V01 TYPE STRING,
V02 TYPE STRING,
V03 TYPE STRING,
V04 TYPE STRING,
V05 TYPE STRING,
V06 TYPE STRING,
V07 TYPE STRING,
V08 TYPE STRING,
V09 TYPE STRING,
V10 TYPE STRING,
V11 TYPE STRING,
V12 TYPE STRING,
V13 TYPE STRING,
V14 TYPE STRING,
V15 TYPE STRING,
V16 TYPE STRING,
V17 TYPE STRING,
V18 TYPE STRING,
V19 TYPE STRING,
V20 TYPE STRING,
V21 TYPE STRING,
V22 TYPE STRING,
V23 TYPE STRING,
V24 TYPE STRING,
V25 TYPE STRING,
V26 TYPE STRING,
V27 TYPE STRING,
V28 TYPE STRING,
V29 TYPE STRING,
V30 TYPE STRING,
U01 TYPE STRING,
U02 TYPE STRING,
U03 TYPE STRING,
U04 TYPE STRING,
U05 TYPE STRING,
U06 TYPE STRING,
U07 TYPE STRING,
U08 TYPE STRING,
U09 TYPE STRING,
U10 TYPE STRING,
U11 TYPE STRING,
U12 TYPE STRING,
U13 TYPE STRING,
U14 TYPE STRING,
U15 TYPE STRING,
U16 TYPE STRING,
U17 TYPE STRING,
U18 TYPE STRING,
U19 TYPE STRING,
U20 TYPE STRING,
U21 TYPE STRING,
U22 TYPE STRING,
U23 TYPE STRING,
U24 TYPE STRING,
U25 TYPE STRING,
U26 TYPE STRING,
U27 TYPE STRING,
U28 TYPE STRING,
U29 TYPE STRING,
U30 TYPE STRING,
F01 TYPE STRING,
F02 TYPE STRING,
F03 TYPE STRING,
F04 TYPE STRING,
F05 TYPE STRING,
F06 TYPE STRING,
F07 TYPE STRING,
F08 TYPE STRING,
F09 TYPE STRING,
F10 TYPE STRING,
F11 TYPE STRING,
F12 TYPE STRING,
F13 TYPE STRING,
F14 TYPE STRING,
F15 TYPE STRING,
F16 TYPE STRING,
F17 TYPE STRING,
F18 TYPE STRING,
F19 TYPE STRING,
F20 TYPE STRING,
F21 TYPE STRING,
F22 TYPE STRING,
F23 TYPE STRING,
F24 TYPE STRING,
F25 TYPE STRING,
F26 TYPE STRING,
F27 TYPE STRING,
F28 TYPE STRING,
F29 TYPE STRING,
F30 TYPE STRING,
R01 TYPE STRING,
R02 TYPE STRING,
R03 TYPE STRING,
R04 TYPE STRING,
R05 TYPE STRING,
R06 TYPE STRING,
R07 TYPE STRING,
R08 TYPE STRING,
R09 TYPE STRING,
R10 TYPE STRING,
R11 TYPE STRING,
R12 TYPE STRING,
R13 TYPE STRING,
R14 TYPE STRING,
R15 TYPE STRING,
R16 TYPE STRING,
R17 TYPE STRING,
R18 TYPE STRING,
R19 TYPE STRING,
R20 TYPE STRING,
R21 TYPE STRING,
R22 TYPE STRING,
R23 TYPE STRING,
R24 TYPE STRING,
R25 TYPE STRING,
R26 TYPE STRING,
R27 TYPE STRING,
R28 TYPE STRING,
R29 TYPE STRING,
R30 TYPE STRING,
P01 TYPE STRING,
P02 TYPE STRING,
P03 TYPE STRING,
P04 TYPE STRING,
P05 TYPE STRING,
P06 TYPE STRING,
P07 TYPE STRING,
P08 TYPE STRING,
P09 TYPE STRING,
P10 TYPE STRING,
P11 TYPE STRING,
P12 TYPE STRING,
P13 TYPE STRING,
P14 TYPE STRING,
P15 TYPE STRING,
P16 TYPE STRING,
P17 TYPE STRING,
P18 TYPE STRING,
P19 TYPE STRING,
P20 TYPE STRING,
P21 TYPE STRING,
P22 TYPE STRING,
P23 TYPE STRING,
P24 TYPE STRING,
P25 TYPE STRING,
P26 TYPE STRING,
P27 TYPE STRING,
P28 TYPE STRING,
P29 TYPE STRING,
P30 TYPE STRING,END OF T_EKKO_STR. DATA: WA_T702N_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_T702N_STR-MANDT sy-vline
WA_T702N_STR-MOREI sy-vline
WA_T702N_STR-B01 sy-vline
WA_T702N_STR-B02 sy-vline
WA_T702N_STR-B03 sy-vline
WA_T702N_STR-B04 sy-vline
WA_T702N_STR-B05 sy-vline
WA_T702N_STR-B06 sy-vline
WA_T702N_STR-B07 sy-vline
WA_T702N_STR-B08 sy-vline
WA_T702N_STR-B09 sy-vline
WA_T702N_STR-B10 sy-vline
WA_T702N_STR-B11 sy-vline
WA_T702N_STR-B12 sy-vline
WA_T702N_STR-B13 sy-vline
WA_T702N_STR-B14 sy-vline
WA_T702N_STR-B15 sy-vline
WA_T702N_STR-B16 sy-vline
WA_T702N_STR-B17 sy-vline
WA_T702N_STR-B18 sy-vline
WA_T702N_STR-B19 sy-vline
WA_T702N_STR-B20 sy-vline
WA_T702N_STR-B21 sy-vline
WA_T702N_STR-B22 sy-vline
WA_T702N_STR-B23 sy-vline
WA_T702N_STR-B24 sy-vline
WA_T702N_STR-B25 sy-vline
WA_T702N_STR-B26 sy-vline
WA_T702N_STR-B27 sy-vline
WA_T702N_STR-B28 sy-vline
WA_T702N_STR-B29 sy-vline
WA_T702N_STR-B30 sy-vline
WA_T702N_STR-V01 sy-vline
WA_T702N_STR-V02 sy-vline
WA_T702N_STR-V03 sy-vline
WA_T702N_STR-V04 sy-vline
WA_T702N_STR-V05 sy-vline
WA_T702N_STR-V06 sy-vline
WA_T702N_STR-V07 sy-vline
WA_T702N_STR-V08 sy-vline
WA_T702N_STR-V09 sy-vline
WA_T702N_STR-V10 sy-vline
WA_T702N_STR-V11 sy-vline
WA_T702N_STR-V12 sy-vline
WA_T702N_STR-V13 sy-vline
WA_T702N_STR-V14 sy-vline
WA_T702N_STR-V15 sy-vline
WA_T702N_STR-V16 sy-vline
WA_T702N_STR-V17 sy-vline
WA_T702N_STR-V18 sy-vline
WA_T702N_STR-V19 sy-vline
WA_T702N_STR-V20 sy-vline
WA_T702N_STR-V21 sy-vline
WA_T702N_STR-V22 sy-vline
WA_T702N_STR-V23 sy-vline
WA_T702N_STR-V24 sy-vline
WA_T702N_STR-V25 sy-vline
WA_T702N_STR-V26 sy-vline
WA_T702N_STR-V27 sy-vline
WA_T702N_STR-V28 sy-vline
WA_T702N_STR-V29 sy-vline
WA_T702N_STR-V30 sy-vline
WA_T702N_STR-U01 sy-vline
WA_T702N_STR-U02 sy-vline
WA_T702N_STR-U03 sy-vline
WA_T702N_STR-U04 sy-vline
WA_T702N_STR-U05 sy-vline
WA_T702N_STR-U06 sy-vline
WA_T702N_STR-U07 sy-vline
WA_T702N_STR-U08 sy-vline
WA_T702N_STR-U09 sy-vline
WA_T702N_STR-U10 sy-vline
WA_T702N_STR-U11 sy-vline
WA_T702N_STR-U12 sy-vline
WA_T702N_STR-U13 sy-vline
WA_T702N_STR-U14 sy-vline
WA_T702N_STR-U15 sy-vline
WA_T702N_STR-U16 sy-vline
WA_T702N_STR-U17 sy-vline
WA_T702N_STR-U18 sy-vline
WA_T702N_STR-U19 sy-vline
WA_T702N_STR-U20 sy-vline
WA_T702N_STR-U21 sy-vline
WA_T702N_STR-U22 sy-vline
WA_T702N_STR-U23 sy-vline
WA_T702N_STR-U24 sy-vline
WA_T702N_STR-U25 sy-vline
WA_T702N_STR-U26 sy-vline
WA_T702N_STR-U27 sy-vline
WA_T702N_STR-U28 sy-vline
WA_T702N_STR-U29 sy-vline
WA_T702N_STR-U30 sy-vline
WA_T702N_STR-F01 sy-vline
WA_T702N_STR-F02 sy-vline
WA_T702N_STR-F03 sy-vline
WA_T702N_STR-F04 sy-vline
WA_T702N_STR-F05 sy-vline
WA_T702N_STR-F06 sy-vline
WA_T702N_STR-F07 sy-vline
WA_T702N_STR-F08 sy-vline
WA_T702N_STR-F09 sy-vline
WA_T702N_STR-F10 sy-vline
WA_T702N_STR-F11 sy-vline
WA_T702N_STR-F12 sy-vline
WA_T702N_STR-F13 sy-vline
WA_T702N_STR-F14 sy-vline
WA_T702N_STR-F15 sy-vline
WA_T702N_STR-F16 sy-vline
WA_T702N_STR-F17 sy-vline
WA_T702N_STR-F18 sy-vline
WA_T702N_STR-F19 sy-vline
WA_T702N_STR-F20 sy-vline
WA_T702N_STR-F21 sy-vline
WA_T702N_STR-F22 sy-vline
WA_T702N_STR-F23 sy-vline
WA_T702N_STR-F24 sy-vline
WA_T702N_STR-F25 sy-vline
WA_T702N_STR-F26 sy-vline
WA_T702N_STR-F27 sy-vline
WA_T702N_STR-F28 sy-vline
WA_T702N_STR-F29 sy-vline
WA_T702N_STR-F30 sy-vline
WA_T702N_STR-R01 sy-vline
WA_T702N_STR-R02 sy-vline
WA_T702N_STR-R03 sy-vline
WA_T702N_STR-R04 sy-vline
WA_T702N_STR-R05 sy-vline
WA_T702N_STR-R06 sy-vline
WA_T702N_STR-R07 sy-vline
WA_T702N_STR-R08 sy-vline
WA_T702N_STR-R09 sy-vline
WA_T702N_STR-R10 sy-vline
WA_T702N_STR-R11 sy-vline
WA_T702N_STR-R12 sy-vline
WA_T702N_STR-R13 sy-vline
WA_T702N_STR-R14 sy-vline
WA_T702N_STR-R15 sy-vline
WA_T702N_STR-R16 sy-vline
WA_T702N_STR-R17 sy-vline
WA_T702N_STR-R18 sy-vline
WA_T702N_STR-R19 sy-vline
WA_T702N_STR-R20 sy-vline
WA_T702N_STR-R21 sy-vline
WA_T702N_STR-R22 sy-vline
WA_T702N_STR-R23 sy-vline
WA_T702N_STR-R24 sy-vline
WA_T702N_STR-R25 sy-vline
WA_T702N_STR-R26 sy-vline
WA_T702N_STR-R27 sy-vline
WA_T702N_STR-R28 sy-vline
WA_T702N_STR-R29 sy-vline
WA_T702N_STR-R30 sy-vline
WA_T702N_STR-P01 sy-vline
WA_T702N_STR-P02 sy-vline
WA_T702N_STR-P03 sy-vline
WA_T702N_STR-P04 sy-vline
WA_T702N_STR-P05 sy-vline
WA_T702N_STR-P06 sy-vline
WA_T702N_STR-P07 sy-vline
WA_T702N_STR-P08 sy-vline
WA_T702N_STR-P09 sy-vline
WA_T702N_STR-P10 sy-vline
WA_T702N_STR-P11 sy-vline
WA_T702N_STR-P12 sy-vline
WA_T702N_STR-P13 sy-vline
WA_T702N_STR-P14 sy-vline
WA_T702N_STR-P15 sy-vline
WA_T702N_STR-P16 sy-vline
WA_T702N_STR-P17 sy-vline
WA_T702N_STR-P18 sy-vline
WA_T702N_STR-P19 sy-vline
WA_T702N_STR-P20 sy-vline
WA_T702N_STR-P21 sy-vline
WA_T702N_STR-P22 sy-vline
WA_T702N_STR-P23 sy-vline
WA_T702N_STR-P24 sy-vline
WA_T702N_STR-P25 sy-vline
WA_T702N_STR-P26 sy-vline
WA_T702N_STR-P27 sy-vline
WA_T702N_STR-P28 sy-vline
WA_T702N_STR-P29 sy-vline
WA_T702N_STR-P30 sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.
