ABAP Select data from SAP table IPAREALGNMT 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 IPAREALGNMT 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 IPAREALGNMT. 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 IPAREALGNMT 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_IPAREALGNMT TYPE STANDARD TABLE OF IPAREALGNMT,
      WA_IPAREALGNMT TYPE IPAREALGNMT,
      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: <IPAREALGNMT> TYPE IPAREALGNMT.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM IPAREALGNMT
*  INTO TABLE @DATA(IT_IPAREALGNMT2).
*--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_IPAREALGNMT INDEX 1 INTO DATA(WA_IPAREALGNMT2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_IPAREALGNMT ASSIGNING <IPAREALGNMT>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<IPAREALGNMT>-MANDT = 1.
<IPAREALGNMT>-SOURCELEDGER = 1.
<IPAREALGNMT>-LEDGER = 1.
<IPAREALGNMT>-COMPANYCODE = 1.
<IPAREALGNMT>-FISCALYEAR = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_IPAREALGNMT-ACCOUNTINGDOCUMENT, sy-vline,
WA_IPAREALGNMT-LEDGERGLLINEITEM, sy-vline,
WA_IPAREALGNMT-REALIGNMENTRUN, sy-vline,
WA_IPAREALGNMT-PROFITCENTER, sy-vline,
WA_IPAREALGNMT-REALIGNMENTRUNENDDATE, sy-vline,
WA_IPAREALGNMT-REALIGNMENTRUNENDTIME, sy-vline.
ENDLOOP. *Add any further fields from structure WA_IPAREALGNMT 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_IPAREALGNMT 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_IPAREALGNMT INTO WA_IPAREALGNMT. *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 SOURCELEDGER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IPAREALGNMT-SOURCELEDGER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPAREALGNMT-SOURCELEDGER.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit GJAHR, internal->external for field FISCALYEAR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_IPAREALGNMT-FISCALYEAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPAREALGNMT-FISCALYEAR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ABPSN, internal->external for field REALGNMTPREVWBSELEMENT CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_IPAREALGNMT-REALGNMTPREVWBSELEMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPAREALGNMT-REALGNMTPREVWBSELEMENT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ABPSN, internal->external for field WBSELEMENT CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_IPAREALGNMT-WBSELEMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPAREALGNMT-WBSELEMENT.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit ALPHA, internal->external for field COSTCENTER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IPAREALGNMT-COSTCENTER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPAREALGNMT-COSTCENTER.
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_IPAREALGNMT_STR,
MANDT TYPE STRING,
SOURCELEDGER TYPE STRING,
LEDGER TYPE STRING,
COMPANYCODE TYPE STRING,
FISCALYEAR TYPE STRING,
ACCOUNTINGDOCUMENT TYPE STRING,
LEDGERGLLINEITEM TYPE STRING,
REALIGNMENTRUN TYPE STRING,
PROFITCENTER TYPE STRING,
REALIGNMENTRUNENDDATE TYPE STRING,
REALIGNMENTRUNENDTIME TYPE STRING,
FISCALPERIOD TYPE STRING,
POSTINGDATE TYPE STRING,
BUSINESSTRANSACTIONTYPE TYPE STRING,
AMOUNTINBALANCETRANSACCRCY TYPE STRING,
BALANCETRANSACTIONCURRENCY TYPE STRING,
AMOUNTINCOMPANYCODECURRENCY TYPE STRING,
COMPANYCODECURRENCY TYPE STRING,
AMOUNTINGLOBALCURRENCY TYPE STRING,
GLOBALCURRENCY TYPE STRING,
GLACCOUNT TYPE STRING,
FUNCTIONALAREA TYPE STRING,
SEGMENT TYPE STRING,
ACCOUNTINGDOCUMENTTYPE TYPE STRING,
SUPPLIER TYPE STRING,
CONTROLLINGAREA TYPE STRING,
REALGNMTPREVSOLDMATERIAL TYPE STRING,
SOLDMATERIAL TYPE STRING,
REALGNMTPREVBILLGDOCTYPE TYPE STRING,
BILLINGDOCUMENTTYPE TYPE STRING,
REALGNMTPREVCUSTOMERGROUP TYPE STRING,
CUSTOMERGROUP TYPE STRING,
REALGNMTPREVCUSTSUPLRCNTRY TYPE STRING,
CUSTOMERSUPPLIERCOUNTRY TYPE STRING,
REALGNMTPREVMATERIALGROUP TYPE STRING,
MATERIALGROUP TYPE STRING,
REALGNMTPREVSALESORGANIZATION TYPE STRING,
SALESORGANIZATION TYPE STRING,
REALGNMTPREVDISTRCHANNEL TYPE STRING,
DISTRIBUTIONCHANNEL TYPE STRING,
REALGNMTPREVPLANT TYPE STRING,
PLANT TYPE STRING,
REALGNMTPREVSALESORDER TYPE STRING,
SALESORDER TYPE STRING,
REALGNMTPREVSALESORDERITEM TYPE STRING,
SALESORDERITEM TYPE STRING,
REALGNMTPREVCUSTOMER TYPE STRING,
CUSTOMER TYPE STRING,
REALGNMTPREVORDERID TYPE STRING,
ORDERID TYPE STRING,
REALGNMTPREVSALESDISTRICT TYPE STRING,
SALESDISTRICT TYPE STRING,
REALGNMTPREVSHIPTOPARTY TYPE STRING,
SHIPTOPARTY TYPE STRING,
REALGNMTPREVBILLTOPARTY TYPE STRING,
BILLTOPARTY TYPE STRING,
REALGNMTPREVORGDIVISION TYPE STRING,
ORGANIZATIONDIVISION TYPE STRING,
WBSELEMENTINTERNALID TYPE STRING,
REALGNMTPREVWBSELEMENT TYPE STRING,
WBSELEMENT TYPE STRING,
REALGNMTPREVCOSTOBJECT TYPE STRING,
COSTOBJECT TYPE STRING,
REALGNMTPREVCOSTCENTER TYPE STRING,
COSTCENTER TYPE STRING,
NMBROFREALIGNEDJRNLENTRYITEMS TYPE STRING,END OF T_EKKO_STR. DATA: WA_IPAREALGNMT_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_IPAREALGNMT_STR-MANDT sy-vline
WA_IPAREALGNMT_STR-SOURCELEDGER sy-vline
WA_IPAREALGNMT_STR-LEDGER sy-vline
WA_IPAREALGNMT_STR-COMPANYCODE sy-vline
WA_IPAREALGNMT_STR-FISCALYEAR sy-vline
WA_IPAREALGNMT_STR-ACCOUNTINGDOCUMENT sy-vline
WA_IPAREALGNMT_STR-LEDGERGLLINEITEM sy-vline
WA_IPAREALGNMT_STR-REALIGNMENTRUN sy-vline
WA_IPAREALGNMT_STR-PROFITCENTER sy-vline
WA_IPAREALGNMT_STR-REALIGNMENTRUNENDDATE sy-vline
WA_IPAREALGNMT_STR-REALIGNMENTRUNENDTIME sy-vline
WA_IPAREALGNMT_STR-FISCALPERIOD sy-vline
WA_IPAREALGNMT_STR-POSTINGDATE sy-vline
WA_IPAREALGNMT_STR-BUSINESSTRANSACTIONTYPE sy-vline
WA_IPAREALGNMT_STR-AMOUNTINBALANCETRANSACCRCY sy-vline
WA_IPAREALGNMT_STR-BALANCETRANSACTIONCURRENCY sy-vline
WA_IPAREALGNMT_STR-AMOUNTINCOMPANYCODECURRENCY sy-vline
WA_IPAREALGNMT_STR-COMPANYCODECURRENCY sy-vline
WA_IPAREALGNMT_STR-AMOUNTINGLOBALCURRENCY sy-vline
WA_IPAREALGNMT_STR-GLOBALCURRENCY sy-vline
WA_IPAREALGNMT_STR-GLACCOUNT sy-vline
WA_IPAREALGNMT_STR-FUNCTIONALAREA sy-vline
WA_IPAREALGNMT_STR-SEGMENT sy-vline
WA_IPAREALGNMT_STR-ACCOUNTINGDOCUMENTTYPE sy-vline
WA_IPAREALGNMT_STR-SUPPLIER sy-vline
WA_IPAREALGNMT_STR-CONTROLLINGAREA sy-vline
WA_IPAREALGNMT_STR-REALGNMTPREVSOLDMATERIAL sy-vline
WA_IPAREALGNMT_STR-SOLDMATERIAL sy-vline
WA_IPAREALGNMT_STR-REALGNMTPREVBILLGDOCTYPE sy-vline
WA_IPAREALGNMT_STR-BILLINGDOCUMENTTYPE sy-vline
WA_IPAREALGNMT_STR-REALGNMTPREVCUSTOMERGROUP sy-vline
WA_IPAREALGNMT_STR-CUSTOMERGROUP sy-vline
WA_IPAREALGNMT_STR-REALGNMTPREVCUSTSUPLRCNTRY sy-vline
WA_IPAREALGNMT_STR-CUSTOMERSUPPLIERCOUNTRY sy-vline
WA_IPAREALGNMT_STR-REALGNMTPREVMATERIALGROUP sy-vline
WA_IPAREALGNMT_STR-MATERIALGROUP sy-vline
WA_IPAREALGNMT_STR-REALGNMTPREVSALESORGANIZATION sy-vline
WA_IPAREALGNMT_STR-SALESORGANIZATION sy-vline
WA_IPAREALGNMT_STR-REALGNMTPREVDISTRCHANNEL sy-vline
WA_IPAREALGNMT_STR-DISTRIBUTIONCHANNEL sy-vline
WA_IPAREALGNMT_STR-REALGNMTPREVPLANT sy-vline
WA_IPAREALGNMT_STR-PLANT sy-vline
WA_IPAREALGNMT_STR-REALGNMTPREVSALESORDER sy-vline
WA_IPAREALGNMT_STR-SALESORDER sy-vline
WA_IPAREALGNMT_STR-REALGNMTPREVSALESORDERITEM sy-vline
WA_IPAREALGNMT_STR-SALESORDERITEM sy-vline
WA_IPAREALGNMT_STR-REALGNMTPREVCUSTOMER sy-vline
WA_IPAREALGNMT_STR-CUSTOMER sy-vline
WA_IPAREALGNMT_STR-REALGNMTPREVORDERID sy-vline
WA_IPAREALGNMT_STR-ORDERID sy-vline
WA_IPAREALGNMT_STR-REALGNMTPREVSALESDISTRICT sy-vline
WA_IPAREALGNMT_STR-SALESDISTRICT sy-vline
WA_IPAREALGNMT_STR-REALGNMTPREVSHIPTOPARTY sy-vline
WA_IPAREALGNMT_STR-SHIPTOPARTY sy-vline
WA_IPAREALGNMT_STR-REALGNMTPREVBILLTOPARTY sy-vline
WA_IPAREALGNMT_STR-BILLTOPARTY sy-vline
WA_IPAREALGNMT_STR-REALGNMTPREVORGDIVISION sy-vline
WA_IPAREALGNMT_STR-ORGANIZATIONDIVISION sy-vline
WA_IPAREALGNMT_STR-WBSELEMENTINTERNALID sy-vline
WA_IPAREALGNMT_STR-REALGNMTPREVWBSELEMENT sy-vline
WA_IPAREALGNMT_STR-WBSELEMENT sy-vline
WA_IPAREALGNMT_STR-REALGNMTPREVCOSTOBJECT sy-vline
WA_IPAREALGNMT_STR-COSTOBJECT sy-vline
WA_IPAREALGNMT_STR-REALGNMTPREVCOSTCENTER sy-vline
WA_IPAREALGNMT_STR-COSTCENTER sy-vline
WA_IPAREALGNMT_STR-NMBROFREALIGNEDJRNLENTRYITEMS sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.