ABAP Select data from SAP table ORA_S_SQLC_RESULT 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 ORA_S_SQLC_RESULT 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 ORA_S_SQLC_RESULT. 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 ORA_S_SQLC_RESULT 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_ORA_S_SQLC_RESULT TYPE STANDARD TABLE OF ORA_S_SQLC_RESULT,
WA_ORA_S_SQLC_RESULT TYPE ORA_S_SQLC_RESULT,
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: <ORA_S_SQLC_RESULT> TYPE ORA_S_SQLC_RESULT.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_ORA_S_SQLC_RESULT.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM ORA_S_SQLC_RESULT
INTO TABLE IT_ORA_S_SQLC_RESULT.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM ORA_S_SQLC_RESULT
* INTO TABLE @DATA(IT_ORA_S_SQLC_RESULT2).
*--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_ORA_S_SQLC_RESULT INDEX 1 INTO DATA(WA_ORA_S_SQLC_RESULT2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_ORA_S_SQLC_RESULT ASSIGNING <ORA_S_SQLC_RESULT>.
*To update a field value using a field symbol simply change the value via the field symbol pointer<ORA_S_SQLC_RESULT>-C1 = 1.
<ORA_S_SQLC_RESULT>-C2 = 1.
<ORA_S_SQLC_RESULT>-C3 = 1.
<ORA_S_SQLC_RESULT>-C4 = 1.
<ORA_S_SQLC_RESULT>-C5 = 1.
ENDLOOP. LOOP AT IT_ORA_S_SQLC_RESULT INTO WA_ORA_S_SQLC_RESULT. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_ORA_S_SQLC_RESULT-C6, sy-vline,
WA_ORA_S_SQLC_RESULT-C7, sy-vline,
WA_ORA_S_SQLC_RESULT-C8, sy-vline,
WA_ORA_S_SQLC_RESULT-C9, sy-vline,
WA_ORA_S_SQLC_RESULT-C10, sy-vline,
WA_ORA_S_SQLC_RESULT-C11, sy-vline.
ENDLOOP. *Add any further fields from structure WA_ORA_S_SQLC_RESULT 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_ORA_S_SQLC_RESULT 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_ORA_S_SQLC_RESULT INTO WA_ORA_S_SQLC_RESULT. *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_ORA_S_SQLC_RESULT_STR,
C1 TYPE STRING,
C2 TYPE STRING,
C3 TYPE STRING,
C4 TYPE STRING,
C5 TYPE STRING,
C6 TYPE STRING,
C7 TYPE STRING,
C8 TYPE STRING,
C9 TYPE STRING,
C10 TYPE STRING,
C11 TYPE STRING,
C12 TYPE STRING,
C13 TYPE STRING,
C14 TYPE STRING,
C15 TYPE STRING,
C16 TYPE STRING,
C17 TYPE STRING,
C18 TYPE STRING,
C19 TYPE STRING,
C20 TYPE STRING,
C21 TYPE STRING,
C22 TYPE STRING,
C23 TYPE STRING,
C24 TYPE STRING,
C25 TYPE STRING,
C26 TYPE STRING,
C27 TYPE STRING,
C28 TYPE STRING,
C29 TYPE STRING,
C30 TYPE STRING,
C31 TYPE STRING,
C32 TYPE STRING,
C33 TYPE STRING,
C34 TYPE STRING,
C35 TYPE STRING,
C36 TYPE STRING,
C37 TYPE STRING,
C38 TYPE STRING,
C39 TYPE STRING,
C40 TYPE STRING,
C41 TYPE STRING,
C42 TYPE STRING,
C43 TYPE STRING,
C44 TYPE STRING,
C45 TYPE STRING,
C46 TYPE STRING,
C47 TYPE STRING,
C48 TYPE STRING,
C49 TYPE STRING,
C50 TYPE STRING,
C51 TYPE STRING,
C52 TYPE STRING,
C53 TYPE STRING,
C54 TYPE STRING,
C55 TYPE STRING,
C56 TYPE STRING,
C57 TYPE STRING,
C58 TYPE STRING,
C59 TYPE STRING,
C60 TYPE STRING,
C61 TYPE STRING,
C62 TYPE STRING,
C63 TYPE STRING,
C64 TYPE STRING,
C65 TYPE STRING,
C66 TYPE STRING,
C67 TYPE STRING,
C68 TYPE STRING,
C69 TYPE STRING,
C70 TYPE STRING,
C71 TYPE STRING,
C72 TYPE STRING,
C73 TYPE STRING,
C74 TYPE STRING,
C75 TYPE STRING,
C76 TYPE STRING,
C77 TYPE STRING,
C78 TYPE STRING,
C79 TYPE STRING,
C80 TYPE STRING,
C81 TYPE STRING,
C82 TYPE STRING,
C83 TYPE STRING,
C84 TYPE STRING,
C85 TYPE STRING,
C86 TYPE STRING,
C87 TYPE STRING,
C88 TYPE STRING,
C89 TYPE STRING,
C90 TYPE STRING,
C91 TYPE STRING,
C92 TYPE STRING,
C93 TYPE STRING,
C94 TYPE STRING,
C95 TYPE STRING,
C96 TYPE STRING,
C97 TYPE STRING,
C98 TYPE STRING,
C99 TYPE STRING,
P1 TYPE STRING,
P2 TYPE STRING,
P3 TYPE STRING,
P4 TYPE STRING,
P5 TYPE STRING,
P6 TYPE STRING,
P7 TYPE STRING,
P8 TYPE STRING,
P9 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,
P31 TYPE STRING,
P32 TYPE STRING,
P33 TYPE STRING,
P34 TYPE STRING,
P35 TYPE STRING,
P36 TYPE STRING,
P37 TYPE STRING,
P38 TYPE STRING,
P39 TYPE STRING,
P40 TYPE STRING,
P41 TYPE STRING,
P42 TYPE STRING,
P43 TYPE STRING,
P44 TYPE STRING,
P45 TYPE STRING,
P46 TYPE STRING,
P47 TYPE STRING,
P48 TYPE STRING,
P49 TYPE STRING,
P50 TYPE STRING,
P51 TYPE STRING,
P52 TYPE STRING,
P53 TYPE STRING,
P54 TYPE STRING,
P55 TYPE STRING,
P56 TYPE STRING,
P57 TYPE STRING,
P58 TYPE STRING,
P59 TYPE STRING,
P60 TYPE STRING,
P61 TYPE STRING,
P62 TYPE STRING,
P63 TYPE STRING,
P64 TYPE STRING,
P65 TYPE STRING,
P66 TYPE STRING,
P67 TYPE STRING,
P68 TYPE STRING,
P69 TYPE STRING,
P70 TYPE STRING,
P71 TYPE STRING,
P72 TYPE STRING,
P73 TYPE STRING,
P74 TYPE STRING,
P75 TYPE STRING,
P76 TYPE STRING,
P77 TYPE STRING,
P78 TYPE STRING,
P79 TYPE STRING,
P80 TYPE STRING,
P81 TYPE STRING,
P82 TYPE STRING,
P83 TYPE STRING,
P84 TYPE STRING,
P85 TYPE STRING,
P86 TYPE STRING,
P87 TYPE STRING,
P88 TYPE STRING,
P89 TYPE STRING,
P90 TYPE STRING,
P91 TYPE STRING,
P92 TYPE STRING,
P93 TYPE STRING,
P94 TYPE STRING,
P95 TYPE STRING,
P96 TYPE STRING,
P97 TYPE STRING,
P98 TYPE STRING,
P99 TYPE STRING,END OF T_EKKO_STR. DATA: WA_ORA_S_SQLC_RESULT_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_ORA_S_SQLC_RESULT_STR-C1 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C2 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C3 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C4 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C5 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C6 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C7 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C8 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C9 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C10 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C11 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C12 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C13 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C14 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C15 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C16 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C17 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C18 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C19 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C20 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C21 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C22 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C23 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C24 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C25 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C26 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C27 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C28 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C29 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C30 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C31 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C32 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C33 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C34 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C35 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C36 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C37 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C38 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C39 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C40 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C41 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C42 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C43 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C44 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C45 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C46 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C47 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C48 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C49 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C50 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C51 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C52 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C53 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C54 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C55 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C56 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C57 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C58 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C59 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C60 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C61 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C62 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C63 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C64 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C65 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C66 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C67 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C68 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C69 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C70 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C71 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C72 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C73 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C74 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C75 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C76 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C77 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C78 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C79 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C80 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C81 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C82 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C83 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C84 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C85 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C86 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C87 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C88 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C89 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C90 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C91 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C92 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C93 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C94 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C95 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C96 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C97 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C98 sy-vline
WA_ORA_S_SQLC_RESULT_STR-C99 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P1 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P2 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P3 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P4 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P5 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P6 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P7 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P8 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P9 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P10 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P11 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P12 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P13 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P14 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P15 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P16 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P17 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P18 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P19 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P20 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P21 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P22 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P23 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P24 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P25 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P26 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P27 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P28 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P29 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P30 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P31 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P32 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P33 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P34 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P35 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P36 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P37 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P38 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P39 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P40 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P41 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P42 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P43 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P44 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P45 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P46 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P47 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P48 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P49 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P50 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P51 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P52 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P53 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P54 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P55 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P56 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P57 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P58 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P59 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P60 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P61 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P62 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P63 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P64 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P65 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P66 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P67 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P68 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P69 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P70 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P71 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P72 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P73 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P74 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P75 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P76 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P77 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P78 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P79 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P80 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P81 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P82 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P83 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P84 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P85 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P86 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P87 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P88 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P89 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P90 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P91 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P92 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P93 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P94 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P95 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P96 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P97 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P98 sy-vline
WA_ORA_S_SQLC_RESULT_STR-P99 sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.