ABAP Select data from SAP table ROIJNOMIIO 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 ROIJNOMIIO 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 ROIJNOMIIO. 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 ROIJNOMIIO 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_ROIJNOMIIO TYPE STANDARD TABLE OF ROIJNOMIIO,
      WA_ROIJNOMIIO TYPE ROIJNOMIIO,
      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: <ROIJNOMIIO> TYPE ROIJNOMIIO.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM ROIJNOMIIO
*  INTO TABLE @DATA(IT_ROIJNOMIIO2).
*--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_ROIJNOMIIO INDEX 1 INTO DATA(WA_ROIJNOMIIO2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_ROIJNOMIIO ASSIGNING <ROIJNOMIIO>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<ROIJNOMIIO>-MANDT = 1.
<ROIJNOMIIO>-NOMTK = 1.
<ROIJNOMIIO>-NOMIT = 1.
<ROIJNOMIIO>-SITYP = 1.
<ROIJNOMIIO>-ISTAT = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_ROIJNOMIIO-ISUBSTAT, sy-vline,
WA_ROIJNOMIIO-IDATE, sy-vline,
WA_ROIJNOMIIO-SCHED_TST_FROM, sy-vline,
WA_ROIJNOMIIO-SCHED_TST_TO, sy-vline,
WA_ROIJNOMIIO-LOCID, sy-vline,
WA_ROIJNOMIIO-S_MATNR_I, sy-vline.
ENDLOOP. *Add any further fields from structure WA_ROIJNOMIIO 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_ROIJNOMIIO 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_ROIJNOMIIO INTO WA_ROIJNOMIIO. *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 NOMTK CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ROIJNOMIIO-NOMTK IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJNOMIIO-NOMTK.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN1, internal->external for field S_MATNR_I CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_ROIJNOMIIO-S_MATNR_I IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJNOMIIO-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_ROIJNOMIIO-MATNR_I IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJNOMIIO-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_ROIJNOMIIO-UNIT_I IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJNOMIIO-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_ROIJNOMIIO-UNIT_I_T IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJNOMIIO-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_ROIJNOMIIO-DOCNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJNOMIIO-DOCNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field CO_CARR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ROIJNOMIIO-CO_CARR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJNOMIIO-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_ROIJNOMIIO-CO_SHIP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJNOMIIO-CO_SHIP.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit CUNIT, internal->external for field GA_CONF_UOM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ROIJNOMIIO-GA_CONF_UOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJNOMIIO-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_ROIJNOMIIO-GA_TECHSCH_UOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJNOMIIO-GA_TECHSCH_UOM.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field UNIT_I_PAR CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ROIJNOMIIO-UNIT_I_PAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ROIJNOMIIO-UNIT_I_PAR.
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_ROIJNOMIIO_STR,
MANDT TYPE STRING,
NOMTK TYPE STRING,
NOMIT TYPE STRING,
SITYP TYPE STRING,
ISTAT TYPE STRING,
ISUBSTAT TYPE STRING,
IDATE TYPE STRING,
SCHED_TST_FROM TYPE STRING,
SCHED_TST_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,
QTYFCR TYPE STRING,
QTYFCR_UOM TYPE STRING,
WORKLIST_I 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,
PRORATEQTY TYPE STRING,
ASSIGNEDQTY TYPE STRING,
ACTDAT TYPE STRING,
ACTTIME TYPE STRING,
ACTUALS TYPE STRING,
ACTUALQTY TYPE STRING,
ACTUALUOM TYPE STRING,
ITBOTOL TYPE STRING,
ITBUTOL TYPE STRING,
ITBOTOLABS TYPE STRING,
ITBUTOLABS TYPE STRING,
ITTOLUNIT TYPE STRING,
UNLIMITED TYPE STRING,
BLOIND TYPE STRING,
DELIND TYPE STRING,
UPDATEXDOK TYPE STRING,
INCOMPLETE_FLAG TYPE STRING,
DOCTYP TYPE STRING,
LDRATE TYPE STRING,
LDQUOM TYPE STRING,
LDTUOM TYPE STRING,
THIRD_NOMNR TYPE STRING,
UPMAT TYPE STRING,
REFITEM TYPE STRING,
STLTY TYPE STRING,
STLKN TYPE STRING,
CHARG_D_CREATE TYPE STRING,
CHARG_O_CREATE TYPE STRING,
CO_CARR TYPE STRING,
CO_SHIP TYPE STRING,
CO_TSYST TYPE STRING,
COMMCTL TYPE STRING,
SOLDTO TYPE STRING,
PRORATE_ROUTINE TYPE STRING,
CHARG_L TYPE STRING,
CHARG_L_CREATE TYPE STRING,
TCNUM TYPE STRING,
TCITM TYPE STRING,
GA_NMSHIPPER TYPE STRING,
GA_CONF_QTY TYPE STRING,
GA_CONF_UOM TYPE STRING,
GA_TECHSCH_QTY TYPE STRING,
GA_TECHSCH_UOM TYPE STRING,
GA_CONF_QTY_CAL TYPE STRING,
GA_TSCH_QTY_CAL TYPE STRING,
GA_ALLOCATED_QTY TYPE STRING,
GA_ALLOCATED_UOM TYPE STRING,
GA_RANK TYPE STRING,
CYCLE_ITEM TYPE STRING,
LESSHNUM TYPE STRING,
LESTPNUM TYPE STRING,
ATL_DELV_NUMBER TYPE STRING,
ATL_DELV_ITM TYPE STRING,
ATL_CRDT_QTY TYPE STRING,
ATL_CRDT_UOM TYPE STRING,
ATL_CRDT_VAL TYPE STRING,
ATL_CRDT_CURR TYPE STRING,
PRE_EXIST_IND TYPE STRING,
PLANIND TYPE STRING,
LOCPT TYPE STRING,
LOCSL TYPE STRING,
QUICKCONF TYPE STRING,
ERDAT TYPE STRING,
ERZEIT TYPE STRING,
ERNAM TYPE STRING,
AEDAT TYPE STRING,
AEZEIT TYPE STRING,
AENAM TYPE STRING,
LOCNAM TYPE STRING,
VBELN TYPE STRING,
POSNR TYPE STRING,
NOMIT_CONS TYPE STRING,
ACTUALQTY_PAR TYPE STRING,
ACTUALUOM_PAR TYPE STRING,
LOV_IND TYPE STRING,
FERRYIND TYPE STRING,
RAILCARQTY TYPE STRING,
OITAXFROM TYPE STRING,
OIHANTYP TYPE STRING,
OITAXGRP TYPE STRING,
OITAXTO TYPE STRING,
OIOILCON TYPE STRING,
OIEDBAL TYPE STRING,
OIPRICIE TYPE STRING,
OIINEX TYPE STRING,
OIEDBALM TYPE STRING,
LOG_PROC TYPE STRING,
TAX_PROC TYPE STRING,
OICERTF1 TYPE STRING,
OIDATFM1 TYPE STRING,
OIDATTO1 TYPE STRING,
OIH_LICTP TYPE STRING,
OIH_LICIN TYPE STRING,
OIH_LCFOL TYPE STRING,
OIH_FOLQTY TYPE STRING,
OICERTF1_GI TYPE STRING,
OIDATFM1_GI TYPE STRING,
OIDATTO1_GI TYPE STRING,
OIH_LICTP_GI TYPE STRING,
OIH_LICIN_GI TYPE STRING,
OIH_LCFOL_GI TYPE STRING,
OIH_FOLQTY_GI TYPE STRING,
OIPIPEVAL TYPE STRING,
OIC_LIFNR TYPE STRING,
OIC_DCITYC TYPE STRING,
OIC_DCOUNC TYPE STRING,
OIC_DREGIO TYPE STRING,
OIC_DLAND1 TYPE STRING,
OIC_OCITYC TYPE STRING,
OIC_OCOUNC TYPE STRING,
OIC_OREGIO TYPE STRING,
OIC_OLAND1 TYPE STRING,
OIC_PORGIN TYPE STRING,
OIC_PDESTN TYPE STRING,
OIC_PTRIP TYPE STRING,
OIC_PBATCH TYPE STRING,
OIC_MOT TYPE STRING,
OIC_AORGIN TYPE STRING,
OIC_ADESTN TYPE STRING,
OIC_TRUCKN TYPE STRING,
OIA_BASELO TYPE STRING,
OIEDOK TYPE STRING,
OIEDOK_GI TYPE STRING,
OIEDBAL_GI TYPE STRING,
OIEDBALM_GI TYPE STRING,
OIHANTYP_GI TYPE STRING,
OIINEX_GI TYPE STRING,
OITAXGRP_GI TYPE STRING,
OITAXFROM_GI TYPE STRING,
OITAXTO_GI TYPE STRING,
BWTAR_INTRANSIT TYPE STRING,
HT_GL TYPE STRING,
HT_LOAD TYPE STRING,
HT_DIS TYPE STRING,
LICIN_NUM TYPE STRING,
LICEXT_NUM TYPE STRING,
OIH_DISTLIC TYPE STRING,
SHIP_FROM TYPE STRING,
DUTY_TO TYPE STRING,
_DATAAGING TYPE STRING,
DUMMY_NOMITM_INCL_EEW_PS TYPE STRING,
/DMBE/SMARTID TYPE STRING,
/DMBE/OPTIONALITYKEY TYPE STRING,
UPDKZ TYPE STRING,
UPDWL TYPE STRING,
UPDRD TYPE STRING,
PEGID TYPE STRING,
MATNR_I_TXT TYPE STRING,
S_MATNR_I_TXT TYPE STRING,
CONPAT_TXT TYPE STRING,
LOCPT_TXT TYPE STRING,
CONS_TXT TYPE STRING,
IMEXPO_TXT TYPE STRING,
INSPE_TXT TYPE STRING,
TANK_TXT TYPE STRING,
EVTTXT TYPE STRING,
IC_DELIND_I TYPE STRING,
IC_BLOIND_I TYPE STRING,
IC_WORKLIST_I TYPE STRING,
IC_HOLD_I TYPE STRING,
IC_INCOMPLETE TYPE STRING,
MENGE_R TYPE STRING,
QTYFCR_R TYPE STRING,
QTYCTR TYPE STRING,
QTYCTR_R TYPE STRING,
QTYCTRQS TYPE STRING,
QTYCTRQS_R TYPE STRING,
QTYCOF TYPE STRING,
QTYCOF_R TYPE STRING,
QTYREFDOC TYPE STRING,
STATUSSTRING_I TYPE STRING,
ITIME TYPE STRING,
IDATE_TO TYPE STRING,
ITIME_TO TYPE STRING,
DOCIND_FC TYPE STRING,
DOCNR_FC TYPE STRING,
DOCITM_FC TYPE STRING,
TEXT_IND TYPE STRING,
INCO1 TYPE STRING,
INCO2 TYPE STRING,
DUMMY_ITEM TYPE STRING,
RING_TR TYPE STRING,
UPDATE_REFDOC_IND TYPE STRING,
ITIMEZONE TYPE STRING,
LOCID_PARENT TYPE STRING,
BRANCH_NR TYPE STRING,
BRANCH_SEQ TYPE STRING,
IC_ATL_STATUS TYPE STRING,
GTM_LOG_OPTION TYPE STRING,
MENGE_PAR TYPE STRING,
UNIT_I_PAR TYPE STRING,
NO_DISPLAY_1 TYPE STRING,
NO_DISPLAY_2 TYPE STRING,
SELECTED_BY_QRY TYPE STRING,
ADDED_BY_FILTER TYPE STRING,
CYCLE TYPE STRING,END OF T_EKKO_STR. DATA: WA_ROIJNOMIIO_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_ROIJNOMIIO_STR-MANDT sy-vline
WA_ROIJNOMIIO_STR-NOMTK sy-vline
WA_ROIJNOMIIO_STR-NOMIT sy-vline
WA_ROIJNOMIIO_STR-SITYP sy-vline
WA_ROIJNOMIIO_STR-ISTAT sy-vline
WA_ROIJNOMIIO_STR-ISUBSTAT sy-vline
WA_ROIJNOMIIO_STR-IDATE sy-vline
WA_ROIJNOMIIO_STR-SCHED_TST_FROM sy-vline
WA_ROIJNOMIIO_STR-SCHED_TST_TO sy-vline
WA_ROIJNOMIIO_STR-LOCID sy-vline
WA_ROIJNOMIIO_STR-S_MATNR_I sy-vline
WA_ROIJNOMIIO_STR-MATNR_I sy-vline
WA_ROIJNOMIIO_STR-MENGE sy-vline
WA_ROIJNOMIIO_STR-UNIT_I sy-vline
WA_ROIJNOMIIO_STR-UNIT_I_T sy-vline
WA_ROIJNOMIIO_STR-DOCIND sy-vline
WA_ROIJNOMIIO_STR-DOCNR sy-vline
WA_ROIJNOMIIO_STR-DOCITM sy-vline
WA_ROIJNOMIIO_STR-DOCSCHEDLN sy-vline
WA_ROIJNOMIIO_STR-QTYFCR sy-vline
WA_ROIJNOMIIO_STR-QTYFCR_UOM sy-vline
WA_ROIJNOMIIO_STR-WORKLIST_I sy-vline
WA_ROIJNOMIIO_STR-TANK sy-vline
WA_ROIJNOMIIO_STR-CONS sy-vline
WA_ROIJNOMIIO_STR-PARTNR sy-vline
WA_ROIJNOMIIO_STR-CONPAT sy-vline
WA_ROIJNOMIIO_STR-INSPE sy-vline
WA_ROIJNOMIIO_STR-IMPOEXPO sy-vline
WA_ROIJNOMIIO_STR-FLAG_IMEX sy-vline
WA_ROIJNOMIIO_STR-OWNER sy-vline
WA_ROIJNOMIIO_STR-CHARG_O sy-vline
WA_ROIJNOMIIO_STR-CHARG_D sy-vline
WA_ROIJNOMIIO_STR-RVP sy-vline
WA_ROIJNOMIIO_STR-VALUATIONTYPE_O sy-vline
WA_ROIJNOMIIO_STR-VALUATIONTYPE_D sy-vline
WA_ROIJNOMIIO_STR-SHNUM sy-vline
WA_ROIJNOMIIO_STR-SHITEM sy-vline
WA_ROIJNOMIIO_STR-ILOCK sy-vline
WA_ROIJNOMIIO_STR-PRORATEQTY sy-vline
WA_ROIJNOMIIO_STR-ASSIGNEDQTY sy-vline
WA_ROIJNOMIIO_STR-ACTDAT sy-vline
WA_ROIJNOMIIO_STR-ACTTIME sy-vline
WA_ROIJNOMIIO_STR-ACTUALS sy-vline
WA_ROIJNOMIIO_STR-ACTUALQTY sy-vline
WA_ROIJNOMIIO_STR-ACTUALUOM sy-vline
WA_ROIJNOMIIO_STR-ITBOTOL sy-vline
WA_ROIJNOMIIO_STR-ITBUTOL sy-vline
WA_ROIJNOMIIO_STR-ITBOTOLABS sy-vline
WA_ROIJNOMIIO_STR-ITBUTOLABS sy-vline
WA_ROIJNOMIIO_STR-ITTOLUNIT sy-vline
WA_ROIJNOMIIO_STR-UNLIMITED sy-vline
WA_ROIJNOMIIO_STR-BLOIND sy-vline
WA_ROIJNOMIIO_STR-DELIND sy-vline
WA_ROIJNOMIIO_STR-UPDATEXDOK sy-vline
WA_ROIJNOMIIO_STR-INCOMPLETE_FLAG sy-vline
WA_ROIJNOMIIO_STR-DOCTYP sy-vline
WA_ROIJNOMIIO_STR-LDRATE sy-vline
WA_ROIJNOMIIO_STR-LDQUOM sy-vline
WA_ROIJNOMIIO_STR-LDTUOM sy-vline
WA_ROIJNOMIIO_STR-THIRD_NOMNR sy-vline
WA_ROIJNOMIIO_STR-UPMAT sy-vline
WA_ROIJNOMIIO_STR-REFITEM sy-vline
WA_ROIJNOMIIO_STR-STLTY sy-vline
WA_ROIJNOMIIO_STR-STLKN sy-vline
WA_ROIJNOMIIO_STR-CHARG_D_CREATE sy-vline
WA_ROIJNOMIIO_STR-CHARG_O_CREATE sy-vline
WA_ROIJNOMIIO_STR-CO_CARR sy-vline
WA_ROIJNOMIIO_STR-CO_SHIP sy-vline
WA_ROIJNOMIIO_STR-CO_TSYST sy-vline
WA_ROIJNOMIIO_STR-COMMCTL sy-vline
WA_ROIJNOMIIO_STR-SOLDTO sy-vline
WA_ROIJNOMIIO_STR-PRORATE_ROUTINE sy-vline
WA_ROIJNOMIIO_STR-CHARG_L sy-vline
WA_ROIJNOMIIO_STR-CHARG_L_CREATE sy-vline
WA_ROIJNOMIIO_STR-TCNUM sy-vline
WA_ROIJNOMIIO_STR-TCITM sy-vline
WA_ROIJNOMIIO_STR-GA_NMSHIPPER sy-vline
WA_ROIJNOMIIO_STR-GA_CONF_QTY sy-vline
WA_ROIJNOMIIO_STR-GA_CONF_UOM sy-vline
WA_ROIJNOMIIO_STR-GA_TECHSCH_QTY sy-vline
WA_ROIJNOMIIO_STR-GA_TECHSCH_UOM sy-vline
WA_ROIJNOMIIO_STR-GA_CONF_QTY_CAL sy-vline
WA_ROIJNOMIIO_STR-GA_TSCH_QTY_CAL sy-vline
WA_ROIJNOMIIO_STR-GA_ALLOCATED_QTY sy-vline
WA_ROIJNOMIIO_STR-GA_ALLOCATED_UOM sy-vline
WA_ROIJNOMIIO_STR-GA_RANK sy-vline
WA_ROIJNOMIIO_STR-CYCLE_ITEM sy-vline
WA_ROIJNOMIIO_STR-LESSHNUM sy-vline
WA_ROIJNOMIIO_STR-LESTPNUM sy-vline
WA_ROIJNOMIIO_STR-ATL_DELV_NUMBER sy-vline
WA_ROIJNOMIIO_STR-ATL_DELV_ITM sy-vline
WA_ROIJNOMIIO_STR-ATL_CRDT_QTY sy-vline
WA_ROIJNOMIIO_STR-ATL_CRDT_UOM sy-vline
WA_ROIJNOMIIO_STR-ATL_CRDT_VAL sy-vline
WA_ROIJNOMIIO_STR-ATL_CRDT_CURR sy-vline
WA_ROIJNOMIIO_STR-PRE_EXIST_IND sy-vline
WA_ROIJNOMIIO_STR-PLANIND sy-vline
WA_ROIJNOMIIO_STR-LOCPT sy-vline
WA_ROIJNOMIIO_STR-LOCSL sy-vline
WA_ROIJNOMIIO_STR-QUICKCONF sy-vline
WA_ROIJNOMIIO_STR-ERDAT sy-vline
WA_ROIJNOMIIO_STR-ERZEIT sy-vline
WA_ROIJNOMIIO_STR-ERNAM sy-vline
WA_ROIJNOMIIO_STR-AEDAT sy-vline
WA_ROIJNOMIIO_STR-AEZEIT sy-vline
WA_ROIJNOMIIO_STR-AENAM sy-vline
WA_ROIJNOMIIO_STR-LOCNAM sy-vline
WA_ROIJNOMIIO_STR-VBELN sy-vline
WA_ROIJNOMIIO_STR-POSNR sy-vline
WA_ROIJNOMIIO_STR-NOMIT_CONS sy-vline
WA_ROIJNOMIIO_STR-ACTUALQTY_PAR sy-vline
WA_ROIJNOMIIO_STR-ACTUALUOM_PAR sy-vline
WA_ROIJNOMIIO_STR-LOV_IND sy-vline
WA_ROIJNOMIIO_STR-FERRYIND sy-vline
WA_ROIJNOMIIO_STR-RAILCARQTY sy-vline
WA_ROIJNOMIIO_STR-OITAXFROM sy-vline
WA_ROIJNOMIIO_STR-OIHANTYP sy-vline
WA_ROIJNOMIIO_STR-OITAXGRP sy-vline
WA_ROIJNOMIIO_STR-OITAXTO sy-vline
WA_ROIJNOMIIO_STR-OIOILCON sy-vline
WA_ROIJNOMIIO_STR-OIEDBAL sy-vline
WA_ROIJNOMIIO_STR-OIPRICIE sy-vline
WA_ROIJNOMIIO_STR-OIINEX sy-vline
WA_ROIJNOMIIO_STR-OIEDBALM sy-vline
WA_ROIJNOMIIO_STR-LOG_PROC sy-vline
WA_ROIJNOMIIO_STR-TAX_PROC sy-vline
WA_ROIJNOMIIO_STR-OICERTF1 sy-vline
WA_ROIJNOMIIO_STR-OIDATFM1 sy-vline
WA_ROIJNOMIIO_STR-OIDATTO1 sy-vline
WA_ROIJNOMIIO_STR-OIH_LICTP sy-vline
WA_ROIJNOMIIO_STR-OIH_LICIN sy-vline
WA_ROIJNOMIIO_STR-OIH_LCFOL sy-vline
WA_ROIJNOMIIO_STR-OIH_FOLQTY sy-vline
WA_ROIJNOMIIO_STR-OICERTF1_GI sy-vline
WA_ROIJNOMIIO_STR-OIDATFM1_GI sy-vline
WA_ROIJNOMIIO_STR-OIDATTO1_GI sy-vline
WA_ROIJNOMIIO_STR-OIH_LICTP_GI sy-vline
WA_ROIJNOMIIO_STR-OIH_LICIN_GI sy-vline
WA_ROIJNOMIIO_STR-OIH_LCFOL_GI sy-vline
WA_ROIJNOMIIO_STR-OIH_FOLQTY_GI sy-vline
WA_ROIJNOMIIO_STR-OIPIPEVAL sy-vline
WA_ROIJNOMIIO_STR-OIC_LIFNR sy-vline
WA_ROIJNOMIIO_STR-OIC_DCITYC sy-vline
WA_ROIJNOMIIO_STR-OIC_DCOUNC sy-vline
WA_ROIJNOMIIO_STR-OIC_DREGIO sy-vline
WA_ROIJNOMIIO_STR-OIC_DLAND1 sy-vline
WA_ROIJNOMIIO_STR-OIC_OCITYC sy-vline
WA_ROIJNOMIIO_STR-OIC_OCOUNC sy-vline
WA_ROIJNOMIIO_STR-OIC_OREGIO sy-vline
WA_ROIJNOMIIO_STR-OIC_OLAND1 sy-vline
WA_ROIJNOMIIO_STR-OIC_PORGIN sy-vline
WA_ROIJNOMIIO_STR-OIC_PDESTN sy-vline
WA_ROIJNOMIIO_STR-OIC_PTRIP sy-vline
WA_ROIJNOMIIO_STR-OIC_PBATCH sy-vline
WA_ROIJNOMIIO_STR-OIC_MOT sy-vline
WA_ROIJNOMIIO_STR-OIC_AORGIN sy-vline
WA_ROIJNOMIIO_STR-OIC_ADESTN sy-vline
WA_ROIJNOMIIO_STR-OIC_TRUCKN sy-vline
WA_ROIJNOMIIO_STR-OIA_BASELO sy-vline
WA_ROIJNOMIIO_STR-OIEDOK sy-vline
WA_ROIJNOMIIO_STR-OIEDOK_GI sy-vline
WA_ROIJNOMIIO_STR-OIEDBAL_GI sy-vline
WA_ROIJNOMIIO_STR-OIEDBALM_GI sy-vline
WA_ROIJNOMIIO_STR-OIHANTYP_GI sy-vline
WA_ROIJNOMIIO_STR-OIINEX_GI sy-vline
WA_ROIJNOMIIO_STR-OITAXGRP_GI sy-vline
WA_ROIJNOMIIO_STR-OITAXFROM_GI sy-vline
WA_ROIJNOMIIO_STR-OITAXTO_GI sy-vline
WA_ROIJNOMIIO_STR-BWTAR_INTRANSIT sy-vline
WA_ROIJNOMIIO_STR-HT_GL sy-vline
WA_ROIJNOMIIO_STR-HT_LOAD sy-vline
WA_ROIJNOMIIO_STR-HT_DIS sy-vline
WA_ROIJNOMIIO_STR-LICIN_NUM sy-vline
WA_ROIJNOMIIO_STR-LICEXT_NUM sy-vline
WA_ROIJNOMIIO_STR-OIH_DISTLIC sy-vline
WA_ROIJNOMIIO_STR-SHIP_FROM sy-vline
WA_ROIJNOMIIO_STR-DUTY_TO sy-vline
WA_ROIJNOMIIO_STR-_DATAAGING sy-vline
WA_ROIJNOMIIO_STR-DUMMY_NOMITM_INCL_EEW_PS sy-vline
WA_ROIJNOMIIO_STR-/DMBE/SMARTID sy-vline
WA_ROIJNOMIIO_STR-/DMBE/OPTIONALITYKEY sy-vline
WA_ROIJNOMIIO_STR-UPDKZ sy-vline
WA_ROIJNOMIIO_STR-UPDWL sy-vline
WA_ROIJNOMIIO_STR-UPDRD sy-vline
WA_ROIJNOMIIO_STR-PEGID sy-vline
WA_ROIJNOMIIO_STR-MATNR_I_TXT sy-vline
WA_ROIJNOMIIO_STR-S_MATNR_I_TXT sy-vline
WA_ROIJNOMIIO_STR-CONPAT_TXT sy-vline
WA_ROIJNOMIIO_STR-LOCPT_TXT sy-vline
WA_ROIJNOMIIO_STR-CONS_TXT sy-vline
WA_ROIJNOMIIO_STR-IMEXPO_TXT sy-vline
WA_ROIJNOMIIO_STR-INSPE_TXT sy-vline
WA_ROIJNOMIIO_STR-TANK_TXT sy-vline
WA_ROIJNOMIIO_STR-EVTTXT sy-vline
WA_ROIJNOMIIO_STR-IC_DELIND_I sy-vline
WA_ROIJNOMIIO_STR-IC_BLOIND_I sy-vline
WA_ROIJNOMIIO_STR-IC_WORKLIST_I sy-vline
WA_ROIJNOMIIO_STR-IC_HOLD_I sy-vline
WA_ROIJNOMIIO_STR-IC_INCOMPLETE sy-vline
WA_ROIJNOMIIO_STR-MENGE_R sy-vline
WA_ROIJNOMIIO_STR-QTYFCR_R sy-vline
WA_ROIJNOMIIO_STR-QTYCTR sy-vline
WA_ROIJNOMIIO_STR-QTYCTR_R sy-vline
WA_ROIJNOMIIO_STR-QTYCTRQS sy-vline
WA_ROIJNOMIIO_STR-QTYCTRQS_R sy-vline
WA_ROIJNOMIIO_STR-QTYCOF sy-vline
WA_ROIJNOMIIO_STR-QTYCOF_R sy-vline
WA_ROIJNOMIIO_STR-QTYREFDOC sy-vline
WA_ROIJNOMIIO_STR-STATUSSTRING_I sy-vline
WA_ROIJNOMIIO_STR-ITIME sy-vline
WA_ROIJNOMIIO_STR-IDATE_TO sy-vline
WA_ROIJNOMIIO_STR-ITIME_TO sy-vline
WA_ROIJNOMIIO_STR-DOCIND_FC sy-vline
WA_ROIJNOMIIO_STR-DOCNR_FC sy-vline
WA_ROIJNOMIIO_STR-DOCITM_FC sy-vline
WA_ROIJNOMIIO_STR-TEXT_IND sy-vline
WA_ROIJNOMIIO_STR-INCO1 sy-vline
WA_ROIJNOMIIO_STR-INCO2 sy-vline
WA_ROIJNOMIIO_STR-DUMMY_ITEM sy-vline
WA_ROIJNOMIIO_STR-RING_TR sy-vline
WA_ROIJNOMIIO_STR-UPDATE_REFDOC_IND sy-vline
WA_ROIJNOMIIO_STR-ITIMEZONE sy-vline
WA_ROIJNOMIIO_STR-LOCID_PARENT sy-vline
WA_ROIJNOMIIO_STR-BRANCH_NR sy-vline
WA_ROIJNOMIIO_STR-BRANCH_SEQ sy-vline
WA_ROIJNOMIIO_STR-IC_ATL_STATUS sy-vline
WA_ROIJNOMIIO_STR-GTM_LOG_OPTION sy-vline
WA_ROIJNOMIIO_STR-MENGE_PAR sy-vline
WA_ROIJNOMIIO_STR-UNIT_I_PAR sy-vline
WA_ROIJNOMIIO_STR-NO_DISPLAY_1 sy-vline
WA_ROIJNOMIIO_STR-NO_DISPLAY_2 sy-vline
WA_ROIJNOMIIO_STR-SELECTED_BY_QRY sy-vline
WA_ROIJNOMIIO_STR-ADDED_BY_FILTER sy-vline
WA_ROIJNOMIIO_STR-CYCLE sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.