ABAP Select data from SAP table ROIJ_MASSCHANGE_FIELDS 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 ROIJ_MASSCHANGE_FIELDS 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 ROIJ_MASSCHANGE_FIELDS. 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 ROIJ_MASSCHANGE_FIELDS 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_ROIJ_MASSCHANGE_FIELDS TYPE STANDARD TABLE OF ROIJ_MASSCHANGE_FIELDS,
      WA_ROIJ_MASSCHANGE_FIELDS TYPE ROIJ_MASSCHANGE_FIELDS,
      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: <ROIJ_MASSCHANGE_FIELDS> TYPE ROIJ_MASSCHANGE_FIELDS.

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

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM ROIJ_MASSCHANGE_FIELDS
  INTO TABLE IT_ROIJ_MASSCHANGE_FIELDS.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM ROIJ_MASSCHANGE_FIELDS
*  INTO TABLE @DATA(IT_ROIJ_MASSCHANGE_FIELDS2).
*--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_ROIJ_MASSCHANGE_FIELDS INDEX 1 INTO DATA(WA_ROIJ_MASSCHANGE_FIELDS2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_ROIJ_MASSCHANGE_FIELDS ASSIGNING <ROIJ_MASSCHANGE_FIELDS>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<ROIJ_MASSCHANGE_FIELDS>-NOMNR = 1.
<ROIJ_MASSCHANGE_FIELDS>-NOMTYP = 1.
<ROIJ_MASSCHANGE_FIELDS>-NMSHTYPE = 1.
<ROIJ_MASSCHANGE_FIELDS>-TSYST = 1.
<ROIJ_MASSCHANGE_FIELDS>-NMSHIPPER = 1.
ENDLOOP.

LOOP AT IT_ROIJ_MASSCHANGE_FIELDS INTO WA_ROIJ_MASSCHANGE_FIELDS.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_ROIJ_MASSCHANGE_FIELDS-NMCARRIER, sy-vline,
WA_ROIJ_MASSCHANGE_FIELDS-CYCLE, sy-vline,
WA_ROIJ_MASSCHANGE_FIELDS-NMVEHICLE, sy-vline,
WA_ROIJ_MASSCHANGE_FIELDS-NMVESSEL, sy-vline,
WA_ROIJ_MASSCHANGE_FIELDS-ROUTE, sy-vline,
WA_ROIJ_MASSCHANGE_FIELDS-DOCIND_FCC, sy-vline.
ENDLOOP. *Add any further fields from structure WA_ROIJ_MASSCHANGE_FIELDS 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_ROIJ_MASSCHANGE_FIELDS 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_ROIJ_MASSCHANGE_FIELDS INTO WA_ROIJ_MASSCHANGE_FIELDS. *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 NMSHIPPER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-NMSHIPPER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-NMSHIPPER.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field NMCARRIER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-NMCARRIER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-NMCARRIER.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field NMVEHICLE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-NMVEHICLE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-NMVEHICLE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field DOCNR_FCC CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-DOCNR_FCC IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-DOCNR_FCC.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN1, internal->external for field S_MATNR_I CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-S_MATNR_I IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-S_MATNR_I.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN1, internal->external for field MATNR_I CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-MATNR_I IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-MATNR_I.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field UNIT_I CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-UNIT_I IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-UNIT_I.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field UNIT_I_T CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-UNIT_I_T IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-UNIT_I_T.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field DOCNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-DOCNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-DOCNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field TANK CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-TANK IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-TANK.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field CONS CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-CONS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-CONS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field PARTNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-PARTNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-PARTNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field CONPAT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-CONPAT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-CONPAT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field INSPE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-INSPE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-INSPE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field IMPOEXPO CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-IMPOEXPO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-IMPOEXPO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field SHNUM CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-SHNUM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-SHNUM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field LDQUOM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-LDQUOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-LDQUOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field LDTUOM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-LDTUOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-LDTUOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field DOCNR_FC CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-DOCNR_FC IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-DOCNR_FC.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field CO_CARR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-CO_CARR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-CO_CARR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field CO_SHIP CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-CO_SHIP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-CO_SHIP.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field GA_CONF_UOM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-GA_CONF_UOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-GA_CONF_UOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field GA_TECHSCH_UOM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ROIJ_MASSCHANGE_FIELDS-GA_TECHSCH_UOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJ_MASSCHANGE_FIELDS-GA_TECHSCH_UOM.
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_ROIJ_MASSCHANGE_FIELDS_STR,
NOMNR TYPE STRING,
NOMTYP TYPE STRING,
NMSHTYPE TYPE STRING,
TSYST TYPE STRING,
NMSHIPPER TYPE STRING,
NMCARRIER TYPE STRING,
CYCLE TYPE STRING,
NMVEHICLE TYPE STRING,
NMVESSEL TYPE STRING,
ROUTE TYPE STRING,
DOCIND_FCC TYPE STRING,
DOCNR_FCC TYPE STRING,
DOCITM_FCC TYPE STRING,
SITYP TYPE STRING,
IDATE TYPE STRING,
ITIME TYPE STRING,
IDATE_TO TYPE STRING,
ITIME_TO TYPE STRING,
LOCID TYPE STRING,
S_MATNR_I TYPE STRING,
MATNR_I TYPE STRING,
MENGE TYPE STRING,
UNIT_I TYPE STRING,
UNIT_I_T TYPE STRING,
DOCIND TYPE STRING,
DOCNR TYPE STRING,
DOCITM TYPE STRING,
DOCSCHEDLN TYPE STRING,
TANK TYPE STRING,
CONS TYPE STRING,
PARTNR TYPE STRING,
CONPAT TYPE STRING,
INSPE TYPE STRING,
IMPOEXPO TYPE STRING,
FLAG_IMEX TYPE STRING,
OWNER TYPE STRING,
CHARG_O TYPE STRING,
CHARG_D TYPE STRING,
RVP TYPE STRING,
VALUATIONTYPE_O TYPE STRING,
VALUATIONTYPE_D TYPE STRING,
SHNUM TYPE STRING,
SHITEM TYPE STRING,
ILOCK TYPE STRING,
ACTUALS TYPE STRING,
UNLIMITED TYPE STRING,
DOCTYP TYPE STRING,
MENGE_R TYPE STRING,
LDRATE TYPE STRING,
LDQUOM TYPE STRING,
LDTUOM TYPE STRING,
THIRD_NOMNR TYPE STRING,
CHARG_D_CREATE TYPE STRING,
CHARG_O_CREATE TYPE STRING,
DOCIND_FC TYPE STRING,
DOCNR_FC TYPE STRING,
DOCITM_FC TYPE STRING,
CO_CARR TYPE STRING,
CO_SHIP TYPE STRING,
CO_TSYST TYPE STRING,
GA_CONF_QTY TYPE STRING,
GA_CONF_UOM TYPE STRING,
GA_TECHSCH_QTY TYPE STRING,
GA_TECHSCH_UOM TYPE STRING,
GA_RANK TYPE STRING,END OF T_EKKO_STR. DATA: WA_ROIJ_MASSCHANGE_FIELDS_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_ROIJ_MASSCHANGE_FIELDS_STR-NOMNR sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-NOMTYP sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-NMSHTYPE sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-TSYST sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-NMSHIPPER sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-NMCARRIER sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-CYCLE sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-NMVEHICLE sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-NMVESSEL sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-ROUTE sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-DOCIND_FCC sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-DOCNR_FCC sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-DOCITM_FCC sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-SITYP sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-IDATE sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-ITIME sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-IDATE_TO sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-ITIME_TO sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-LOCID sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-S_MATNR_I sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-MATNR_I sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-MENGE sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-UNIT_I sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-UNIT_I_T sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-DOCIND sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-DOCNR sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-DOCITM sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-DOCSCHEDLN sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-TANK sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-CONS sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-PARTNR sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-CONPAT sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-INSPE sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-IMPOEXPO sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-FLAG_IMEX sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-OWNER sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-CHARG_O sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-CHARG_D sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-RVP sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-VALUATIONTYPE_O sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-VALUATIONTYPE_D sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-SHNUM sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-SHITEM sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-ILOCK sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-ACTUALS sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-UNLIMITED sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-DOCTYP sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-MENGE_R sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-LDRATE sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-LDQUOM sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-LDTUOM sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-THIRD_NOMNR sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-CHARG_D_CREATE sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-CHARG_O_CREATE sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-DOCIND_FC sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-DOCNR_FC sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-DOCITM_FC sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-CO_CARR sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-CO_SHIP sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-CO_TSYST sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-GA_CONF_QTY sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-GA_CONF_UOM sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-GA_TECHSCH_QTY sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-GA_TECHSCH_UOM sy-vline
WA_ROIJ_MASSCHANGE_FIELDS_STR-GA_RANK sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.