ABAP Select data from SAP table KKOS_DATA 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 KKOS_DATA 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 KKOS_DATA. 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 KKOS_DATA 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_KKOS_DATA TYPE STANDARD TABLE OF KKOS_DATA,
      WA_KKOS_DATA TYPE KKOS_DATA,
      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: <KKOS_DATA> TYPE KKOS_DATA.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM KKOS_DATA
*  INTO TABLE @DATA(IT_KKOS_DATA2).
*--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_KKOS_DATA INDEX 1 INTO DATA(WA_KKOS_DATA2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_KKOS_DATA ASSIGNING <KKOS_DATA>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<KKOS_DATA>-SAART = 1.
<KKOS_DATA>-ANRED = 1.
<KKOS_DATA>-NAME1 = 1.
<KKOS_DATA>-NAME2 = 1.
<KKOS_DATA>-PSTLZ = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_KKOS_DATA-ORT01, sy-vline,
WA_KKOS_DATA-LAND1, sy-vline,
WA_KKOS_DATA-STRAS, sy-vline,
WA_KKOS_DATA-PFACH, sy-vline,
WA_KKOS_DATA-PSTL2, sy-vline,
WA_KKOS_DATA-ORT02, sy-vline.
ENDLOOP. *Add any further fields from structure WA_KKOS_DATA 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_KKOS_DATA 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_KKOS_DATA INTO WA_KKOS_DATA. *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 KNRZA CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_KKOS_DATA-KNRZA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KKOS_DATA-KNRZA.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit ISOLA, internal->external for field SPRAS CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT' EXPORTING input = WA_KKOS_DATA-SPRAS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KKOS_DATA-SPRAS.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit AU152, internal->external for field KLIMG CALL FUNCTION 'CONVERSION_EXIT_AU152_OUTPUT' EXPORTING input = WA_KKOS_DATA-KLIMG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KKOS_DATA-KLIMG.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit AU152, internal->external for field KLIMK CALL FUNCTION 'CONVERSION_EXIT_AU152_OUTPUT' EXPORTING input = WA_KKOS_DATA-KLIMK IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KKOS_DATA-KLIMK.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit AU132, internal->external for field WEBTR CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT' EXPORTING input = WA_KKOS_DATA-WEBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KKOS_DATA-WEBTR.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit AC152, internal->external for field SLVFW CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KKOS_DATA-SLVFW IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KKOS_DATA-SLVFW.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SLJFW CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KKOS_DATA-SLJFW IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KKOS_DATA-SLJFW.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UMSAV CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KKOS_DATA-UMSAV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KKOS_DATA-UMSAV.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UMALS CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KKOS_DATA-UMALS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KKOS_DATA-UMALS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UMALH CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KKOS_DATA-UMALH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KKOS_DATA-UMALH.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SHBSD CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KKOS_DATA-SHBSD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KKOS_DATA-SHBSD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SBV01 CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KKOS_DATA-SBV01 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KKOS_DATA-SBV01.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SBV02 CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KKOS_DATA-SBV02 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KKOS_DATA-SBV02.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SBV03 CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KKOS_DATA-SBV03 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KKOS_DATA-SBV03.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SBV04 CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KKOS_DATA-SBV04 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KKOS_DATA-SBV04.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SBV05 CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KKOS_DATA-SBV05 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KKOS_DATA-SBV05.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SBV06 CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KKOS_DATA-SBV06 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KKOS_DATA-SBV06.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SBV07 CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KKOS_DATA-SBV07 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KKOS_DATA-SBV07.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SBV08 CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KKOS_DATA-SBV08 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KKOS_DATA-SBV08.
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_KKOS_DATA_STR,
SAART TYPE STRING,
ANRED TYPE STRING,
NAME1 TYPE STRING,
NAME2 TYPE STRING,
PSTLZ TYPE STRING,
ORT01 TYPE STRING,
LAND1 TYPE STRING,
STRAS TYPE STRING,
PFACH TYPE STRING,
PSTL2 TYPE STRING,
ORT02 TYPE STRING,
REGIO TYPE STRING,
COUNC TYPE STRING,
CITYC TYPE STRING,
XCPDK TYPE STRING,
XZEMP TYPE STRING,
BLNKZ TYPE STRING,
KTOKD TYPE STRING,
BANKN TYPE STRING,
BANKL TYPE STRING,
BANKS TYPE STRING,
BANKA TYPE STRING,
PSKTO TYPE STRING,
BKONT TYPE STRING,
BANKP TYPE STRING,
SWIFT TYPE STRING,
KNRZA TYPE STRING,
BRSCH TYPE STRING,
KONZS TYPE STRING,
KDNRE TYPE STRING,
KNRZB TYPE STRING,
TELF1 TYPE STRING,
TELX1 TYPE STRING,
TELFX TYPE STRING,
TELTX TYPE STRING,
DATLT TYPE STRING,
TELBX TYPE STRING,
SORTL TYPE STRING,
WAERS TYPE STRING,
SPRAS TYPE STRING,
LIFNR TYPE STRING,
KLIMG TYPE STRING,
BBBNR TYPE STRING,
BBSNR TYPE STRING,
BUBKZ TYPE STRING,
STCD1 TYPE STRING,
STCD2 TYPE STRING,
FISKN TYPE STRING,
STKZU TYPE STRING,
STKZA TYPE STRING,
ESRNR TYPE STRING,
AKONT TYPE STRING,
BEGRU TYPE STRING,
EIKTO TYPE STRING,
ERNAM TYPE STRING,
ZUAWA TYPE STRING,
ZWELS TYPE STRING,
ZAMIM TYPE STRING,
ZTERM TYPE STRING,
ZAHLS TYPE STRING,
MAHNS TYPE STRING,
KLIMK TYPE STRING,
VZSKZ TYPE STRING,
ZINDT TYPE STRING,
ZINRT TYPE STRING,
DATLZ TYPE STRING,
VBUND TYPE STRING,
BUSAB TYPE STRING,
KNRZE TYPE STRING,
FDGRV TYPE STRING,
PERRN TYPE STRING,
WKOND TYPE STRING,
WAKON TYPE STRING,
MSCHL TYPE STRING,
WEBTR TYPE STRING,
REMIT TYPE STRING,
QSZNR TYPE STRING,
QSZDT TYPE STRING,
VRSNR TYPE STRING,
REPRF TYPE STRING,
SLVFW TYPE STRING,
SLJFW TYPE STRING,
UMSAV TYPE STRING,
UMALS TYPE STRING,
UMALH TYPE STRING,
SHBSD TYPE STRING,
SKZ01 TYPE STRING,
SBV01 TYPE STRING,
SKZ02 TYPE STRING,
SBV02 TYPE STRING,
SKZ03 TYPE STRING,
SBV03 TYPE STRING,
SKZ04 TYPE STRING,
SBV04 TYPE STRING,
SKZ05 TYPE STRING,
SBV05 TYPE STRING,
SKZ06 TYPE STRING,
SBV06 TYPE STRING,
SKZ07 TYPE STRING,
SBV07 TYPE STRING,
SKZ08 TYPE STRING,
SBV08 TYPE STRING,END OF T_EKKO_STR. DATA: WA_KKOS_DATA_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_KKOS_DATA_STR-SAART sy-vline
WA_KKOS_DATA_STR-ANRED sy-vline
WA_KKOS_DATA_STR-NAME1 sy-vline
WA_KKOS_DATA_STR-NAME2 sy-vline
WA_KKOS_DATA_STR-PSTLZ sy-vline
WA_KKOS_DATA_STR-ORT01 sy-vline
WA_KKOS_DATA_STR-LAND1 sy-vline
WA_KKOS_DATA_STR-STRAS sy-vline
WA_KKOS_DATA_STR-PFACH sy-vline
WA_KKOS_DATA_STR-PSTL2 sy-vline
WA_KKOS_DATA_STR-ORT02 sy-vline
WA_KKOS_DATA_STR-REGIO sy-vline
WA_KKOS_DATA_STR-COUNC sy-vline
WA_KKOS_DATA_STR-CITYC sy-vline
WA_KKOS_DATA_STR-XCPDK sy-vline
WA_KKOS_DATA_STR-XZEMP sy-vline
WA_KKOS_DATA_STR-BLNKZ sy-vline
WA_KKOS_DATA_STR-KTOKD sy-vline
WA_KKOS_DATA_STR-BANKN sy-vline
WA_KKOS_DATA_STR-BANKL sy-vline
WA_KKOS_DATA_STR-BANKS sy-vline
WA_KKOS_DATA_STR-BANKA sy-vline
WA_KKOS_DATA_STR-PSKTO sy-vline
WA_KKOS_DATA_STR-BKONT sy-vline
WA_KKOS_DATA_STR-BANKP sy-vline
WA_KKOS_DATA_STR-SWIFT sy-vline
WA_KKOS_DATA_STR-KNRZA sy-vline
WA_KKOS_DATA_STR-BRSCH sy-vline
WA_KKOS_DATA_STR-KONZS sy-vline
WA_KKOS_DATA_STR-KDNRE sy-vline
WA_KKOS_DATA_STR-KNRZB sy-vline
WA_KKOS_DATA_STR-TELF1 sy-vline
WA_KKOS_DATA_STR-TELX1 sy-vline
WA_KKOS_DATA_STR-TELFX sy-vline
WA_KKOS_DATA_STR-TELTX sy-vline
WA_KKOS_DATA_STR-DATLT sy-vline
WA_KKOS_DATA_STR-TELBX sy-vline
WA_KKOS_DATA_STR-SORTL sy-vline
WA_KKOS_DATA_STR-WAERS sy-vline
WA_KKOS_DATA_STR-SPRAS sy-vline
WA_KKOS_DATA_STR-LIFNR sy-vline
WA_KKOS_DATA_STR-KLIMG sy-vline
WA_KKOS_DATA_STR-BBBNR sy-vline
WA_KKOS_DATA_STR-BBSNR sy-vline
WA_KKOS_DATA_STR-BUBKZ sy-vline
WA_KKOS_DATA_STR-STCD1 sy-vline
WA_KKOS_DATA_STR-STCD2 sy-vline
WA_KKOS_DATA_STR-FISKN sy-vline
WA_KKOS_DATA_STR-STKZU sy-vline
WA_KKOS_DATA_STR-STKZA sy-vline
WA_KKOS_DATA_STR-ESRNR sy-vline
WA_KKOS_DATA_STR-AKONT sy-vline
WA_KKOS_DATA_STR-BEGRU sy-vline
WA_KKOS_DATA_STR-EIKTO sy-vline
WA_KKOS_DATA_STR-ERNAM sy-vline
WA_KKOS_DATA_STR-ZUAWA sy-vline
WA_KKOS_DATA_STR-ZWELS sy-vline
WA_KKOS_DATA_STR-ZAMIM sy-vline
WA_KKOS_DATA_STR-ZTERM sy-vline
WA_KKOS_DATA_STR-ZAHLS sy-vline
WA_KKOS_DATA_STR-MAHNS sy-vline
WA_KKOS_DATA_STR-KLIMK sy-vline
WA_KKOS_DATA_STR-VZSKZ sy-vline
WA_KKOS_DATA_STR-ZINDT sy-vline
WA_KKOS_DATA_STR-ZINRT sy-vline
WA_KKOS_DATA_STR-DATLZ sy-vline
WA_KKOS_DATA_STR-VBUND sy-vline
WA_KKOS_DATA_STR-BUSAB sy-vline
WA_KKOS_DATA_STR-KNRZE sy-vline
WA_KKOS_DATA_STR-FDGRV sy-vline
WA_KKOS_DATA_STR-PERRN sy-vline
WA_KKOS_DATA_STR-WKOND sy-vline
WA_KKOS_DATA_STR-WAKON sy-vline
WA_KKOS_DATA_STR-MSCHL sy-vline
WA_KKOS_DATA_STR-WEBTR sy-vline
WA_KKOS_DATA_STR-REMIT sy-vline
WA_KKOS_DATA_STR-QSZNR sy-vline
WA_KKOS_DATA_STR-QSZDT sy-vline
WA_KKOS_DATA_STR-VRSNR sy-vline
WA_KKOS_DATA_STR-REPRF sy-vline
WA_KKOS_DATA_STR-SLVFW sy-vline
WA_KKOS_DATA_STR-SLJFW sy-vline
WA_KKOS_DATA_STR-UMSAV sy-vline
WA_KKOS_DATA_STR-UMALS sy-vline
WA_KKOS_DATA_STR-UMALH sy-vline
WA_KKOS_DATA_STR-SHBSD sy-vline
WA_KKOS_DATA_STR-SKZ01 sy-vline
WA_KKOS_DATA_STR-SBV01 sy-vline
WA_KKOS_DATA_STR-SKZ02 sy-vline
WA_KKOS_DATA_STR-SBV02 sy-vline
WA_KKOS_DATA_STR-SKZ03 sy-vline
WA_KKOS_DATA_STR-SBV03 sy-vline
WA_KKOS_DATA_STR-SKZ04 sy-vline
WA_KKOS_DATA_STR-SBV04 sy-vline
WA_KKOS_DATA_STR-SKZ05 sy-vline
WA_KKOS_DATA_STR-SBV05 sy-vline
WA_KKOS_DATA_STR-SKZ06 sy-vline
WA_KKOS_DATA_STR-SBV06 sy-vline
WA_KKOS_DATA_STR-SKZ07 sy-vline
WA_KKOS_DATA_STR-SBV07 sy-vline
WA_KKOS_DATA_STR-SKZ08 sy-vline
WA_KKOS_DATA_STR-SBV08 sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.