ABAP Select data from SAP table VDPFLOW_SF 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 VDPFLOW_SF 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 VDPFLOW_SF. 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 VDPFLOW_SF 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_VDPFLOW_SF TYPE STANDARD TABLE OF VDPFLOW_SF,
      WA_VDPFLOW_SF TYPE VDPFLOW_SF,
      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: <VDPFLOW_SF> TYPE VDPFLOW_SF.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM VDPFLOW_SF
*  INTO TABLE @DATA(IT_VDPFLOW_SF2).
*--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_VDPFLOW_SF INDEX 1 INTO DATA(WA_VDPFLOW_SF2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_VDPFLOW_SF ASSIGNING <VDPFLOW_SF>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<VDPFLOW_SF>-MANDT = 1.
<VDPFLOW_SF>-DLINR = 1.
<VDPFLOW_SF>-OBJNR = 1.
<VDPFLOW_SF>-POPER = 1.
<VDPFLOW_SF>-TWAER = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_VDPFLOW_SF-MEINH, sy-vline,
WA_VDPFLOW_SF-MANUAL, sy-vline,
WA_VDPFLOW_SF-KSTAR, sy-vline,
WA_VDPFLOW_SF-KOSTL, sy-vline,
WA_VDPFLOW_SF-LSTAR, sy-vline,
WA_VDPFLOW_SF-MATNR, sy-vline.
ENDLOOP. *Add any further fields from structure WA_VDPFLOW_SF 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_VDPFLOW_SF 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_VDPFLOW_SF INTO WA_VDPFLOW_SF. *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 PERI7, internal->external for field POPER CALL FUNCTION 'CONVERSION_EXIT_PERI7_OUTPUT' EXPORTING input = WA_VDPFLOW_SF-POPER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_VDPFLOW_SF-POPER.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit FMCIS, internal->external for field FIPOS CALL FUNCTION 'CONVERSION_EXIT_FMCIS_OUTPUT' EXPORTING input = WA_VDPFLOW_SF-FIPOS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_VDPFLOW_SF-FIPOS.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

*Conversion exit PRSWP, internal->external for field PRS_WORK_PERIOD CALL FUNCTION 'CONVERSION_EXIT_PRSWP_OUTPUT' EXPORTING input = WA_VDPFLOW_SF-PRS_WORK_PERIOD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_VDPFLOW_SF-PRS_WORK_PERIOD.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

*Conversion exit ABPSP, internal->external for field WBS_BILLING_ELEMENTS CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_VDPFLOW_SF-WBS_BILLING_ELEMENTS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_VDPFLOW_SF-WBS_BILLING_ELEMENTS.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit ABPSP, internal->external for field WBS_ELEMENT CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_VDPFLOW_SF-WBS_ELEMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_VDPFLOW_SF-WBS_ELEMENT.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit ALPHA, internal->external for field ASSETSUBNO CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_VDPFLOW_SF-ASSETSUBNO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_VDPFLOW_SF-ASSETSUBNO.
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_VDPFLOW_SF_STR,
MANDT TYPE STRING,
DLINR TYPE STRING,
OBJNR TYPE STRING,
POPER TYPE STRING,
TWAER TYPE STRING,
MEINH TYPE STRING,
MANUAL TYPE STRING,
KSTAR TYPE STRING,
KOSTL TYPE STRING,
LSTAR TYPE STRING,
MATNR TYPE STRING,
STAGR TYPE STRING,
FIPOS TYPE STRING,
WRTTP TYPE STRING,
VERSN TYPE STRING,
WERKS TYPE STRING,
PRODU TYPE STRING,
FAKTF TYPE STRING,
BEMOT TYPE STRING,
BELNR TYPE STRING,
BUZEI TYPE STRING,
DOCLN TYPE STRING,
ARBPL TYPE STRING,
AWERK TYPE STRING,
PRZNR TYPE STRING,
ASNUM TYPE STRING,
PERNR TYPE STRING,
RSRCE TYPE STRING,
PRS_WORK_PERIOD TYPE STRING,
GSBER TYPE STRING,
PARGB TYPE STRING,
PRCTR TYPE STRING,
PPRCTR TYPE STRING,
WTY_IND TYPE STRING,
ORDERED_PROD TYPE STRING,
CATEGORY_ID TYPE STRING,
AWSYS TYPE STRING,
SERV_AGENT_ID TYPE STRING,
REF_OBJECT_ID TYPE STRING,
REF_OBJECT_ITEM TYPE STRING,
CPD_DLIID TYPE STRING,
ORIG_OBJNR TYPE STRING,
FPLNR TYPE STRING,
FPLTR TYPE STRING,
BPCAT TYPE STRING,
BILLINGPLANITEMUSAGE TYPE STRING,
WBS_BILLING_ELEMENTS TYPE STRING,
WORK_ITEM_ID TYPE STRING,
SERV_ORG TYPE STRING,
OVERTIMECAT TYPE STRING,
FAREA TYPE STRING,
RGRANT_NBR TYPE STRING,
WBS_ELEMENT TYPE STRING,
ORDERID TYPE STRING,
FUNDS_CTR TYPE STRING,
FUND TYPE STRING,
SPONSORED_PROG TYPE STRING,
SPONSORED_CLASS TYPE STRING,
GL_SIRID TYPE STRING,
REFDOCNR TYPE STRING,
REFDOCLN TYPE STRING,
SGTXT TYPE STRING,
GM_VALUETYPE TYPE STRING,
ASSETMAINO TYPE STRING,
ASSETSUBNO TYPE STRING,
BUDGET_PD TYPE STRING,
DLISRC TYPE STRING,
PROFNR TYPE STRING,
TIMESTMP TYPE STRING,
SOITEXT TYPE STRING,
SF_DLIUS TYPE STRING,
SF_IN_WTGBTR TYPE STRING,
SF_IN_WOGBTR TYPE STRING,
SF_IN_WKGBTR TYPE STRING,
SF_IN_MEGBTR TYPE STRING,
SF_NO_WTGBTR TYPE STRING,
SF_NO_WOGBTR TYPE STRING,
SF_NO_WKGBTR TYPE STRING,
SF_NO_MEGBTR TYPE STRING,
SF_RV_WTGBTR1 TYPE STRING,
SF_RV_WTGBTR2 TYPE STRING,
SF_RV_WTGBTR3 TYPE STRING,
SF_RV_WTGBTR4 TYPE STRING,
SF_RV_WAERS TYPE STRING,END OF T_EKKO_STR. DATA: WA_VDPFLOW_SF_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_VDPFLOW_SF_STR-MANDT sy-vline
WA_VDPFLOW_SF_STR-DLINR sy-vline
WA_VDPFLOW_SF_STR-OBJNR sy-vline
WA_VDPFLOW_SF_STR-POPER sy-vline
WA_VDPFLOW_SF_STR-TWAER sy-vline
WA_VDPFLOW_SF_STR-MEINH sy-vline
WA_VDPFLOW_SF_STR-MANUAL sy-vline
WA_VDPFLOW_SF_STR-KSTAR sy-vline
WA_VDPFLOW_SF_STR-KOSTL sy-vline
WA_VDPFLOW_SF_STR-LSTAR sy-vline
WA_VDPFLOW_SF_STR-MATNR sy-vline
WA_VDPFLOW_SF_STR-STAGR sy-vline
WA_VDPFLOW_SF_STR-FIPOS sy-vline
WA_VDPFLOW_SF_STR-WRTTP sy-vline
WA_VDPFLOW_SF_STR-VERSN sy-vline
WA_VDPFLOW_SF_STR-WERKS sy-vline
WA_VDPFLOW_SF_STR-PRODU sy-vline
WA_VDPFLOW_SF_STR-FAKTF sy-vline
WA_VDPFLOW_SF_STR-BEMOT sy-vline
WA_VDPFLOW_SF_STR-BELNR sy-vline
WA_VDPFLOW_SF_STR-BUZEI sy-vline
WA_VDPFLOW_SF_STR-DOCLN sy-vline
WA_VDPFLOW_SF_STR-ARBPL sy-vline
WA_VDPFLOW_SF_STR-AWERK sy-vline
WA_VDPFLOW_SF_STR-PRZNR sy-vline
WA_VDPFLOW_SF_STR-ASNUM sy-vline
WA_VDPFLOW_SF_STR-PERNR sy-vline
WA_VDPFLOW_SF_STR-RSRCE sy-vline
WA_VDPFLOW_SF_STR-PRS_WORK_PERIOD sy-vline
WA_VDPFLOW_SF_STR-GSBER sy-vline
WA_VDPFLOW_SF_STR-PARGB sy-vline
WA_VDPFLOW_SF_STR-PRCTR sy-vline
WA_VDPFLOW_SF_STR-PPRCTR sy-vline
WA_VDPFLOW_SF_STR-WTY_IND sy-vline
WA_VDPFLOW_SF_STR-ORDERED_PROD sy-vline
WA_VDPFLOW_SF_STR-CATEGORY_ID sy-vline
WA_VDPFLOW_SF_STR-AWSYS sy-vline
WA_VDPFLOW_SF_STR-SERV_AGENT_ID sy-vline
WA_VDPFLOW_SF_STR-REF_OBJECT_ID sy-vline
WA_VDPFLOW_SF_STR-REF_OBJECT_ITEM sy-vline
WA_VDPFLOW_SF_STR-CPD_DLIID sy-vline
WA_VDPFLOW_SF_STR-ORIG_OBJNR sy-vline
WA_VDPFLOW_SF_STR-FPLNR sy-vline
WA_VDPFLOW_SF_STR-FPLTR sy-vline
WA_VDPFLOW_SF_STR-BPCAT sy-vline
WA_VDPFLOW_SF_STR-BILLINGPLANITEMUSAGE sy-vline
WA_VDPFLOW_SF_STR-WBS_BILLING_ELEMENTS sy-vline
WA_VDPFLOW_SF_STR-WORK_ITEM_ID sy-vline
WA_VDPFLOW_SF_STR-SERV_ORG sy-vline
WA_VDPFLOW_SF_STR-OVERTIMECAT sy-vline
WA_VDPFLOW_SF_STR-FAREA sy-vline
WA_VDPFLOW_SF_STR-RGRANT_NBR sy-vline
WA_VDPFLOW_SF_STR-WBS_ELEMENT sy-vline
WA_VDPFLOW_SF_STR-ORDERID sy-vline
WA_VDPFLOW_SF_STR-FUNDS_CTR sy-vline
WA_VDPFLOW_SF_STR-FUND sy-vline
WA_VDPFLOW_SF_STR-SPONSORED_PROG sy-vline
WA_VDPFLOW_SF_STR-SPONSORED_CLASS sy-vline
WA_VDPFLOW_SF_STR-GL_SIRID sy-vline
WA_VDPFLOW_SF_STR-REFDOCNR sy-vline
WA_VDPFLOW_SF_STR-REFDOCLN sy-vline
WA_VDPFLOW_SF_STR-SGTXT sy-vline
WA_VDPFLOW_SF_STR-GM_VALUETYPE sy-vline
WA_VDPFLOW_SF_STR-ASSETMAINO sy-vline
WA_VDPFLOW_SF_STR-ASSETSUBNO sy-vline
WA_VDPFLOW_SF_STR-BUDGET_PD sy-vline
WA_VDPFLOW_SF_STR-DLISRC sy-vline
WA_VDPFLOW_SF_STR-PROFNR sy-vline
WA_VDPFLOW_SF_STR-TIMESTMP sy-vline
WA_VDPFLOW_SF_STR-SOITEXT sy-vline
WA_VDPFLOW_SF_STR-SF_DLIUS sy-vline
WA_VDPFLOW_SF_STR-SF_IN_WTGBTR sy-vline
WA_VDPFLOW_SF_STR-SF_IN_WOGBTR sy-vline
WA_VDPFLOW_SF_STR-SF_IN_WKGBTR sy-vline
WA_VDPFLOW_SF_STR-SF_IN_MEGBTR sy-vline
WA_VDPFLOW_SF_STR-SF_NO_WTGBTR sy-vline
WA_VDPFLOW_SF_STR-SF_NO_WOGBTR sy-vline
WA_VDPFLOW_SF_STR-SF_NO_WKGBTR sy-vline
WA_VDPFLOW_SF_STR-SF_NO_MEGBTR sy-vline
WA_VDPFLOW_SF_STR-SF_RV_WTGBTR1 sy-vline
WA_VDPFLOW_SF_STR-SF_RV_WTGBTR2 sy-vline
WA_VDPFLOW_SF_STR-SF_RV_WTGBTR3 sy-vline
WA_VDPFLOW_SF_STR-SF_RV_WTGBTR4 sy-vline
WA_VDPFLOW_SF_STR-SF_RV_WAERS sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.