ABAP Select data from SAP table ROXEE60123 into internal table

Get Example source ABAP code based on a different SAP table
  Get ABAP code

Below is a number of ABAP code snippets to demonstrate how to select data from SAP ROXEE60123 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 ROXEE60123. 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 ROXEE60123 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_ROXEE60123 TYPE STANDARD TABLE OF ROXEE60123,
      WA_ROXEE60123 TYPE ROXEE60123,
      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: <ROXEE60123> TYPE ROXEE60123.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM ROXEE60123
*  INTO TABLE @DATA(IT_ROXEE601232).
*--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_ROXEE60123 INDEX 1 INTO DATA(WA_ROXEE601232).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_ROXEE60123 ASSIGNING <ROXEE60123>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
<ROXEE60123>-MANDT = 1.
<ROXEE60123>-TPLNR = 1.
<ROXEE60123>-GHO_NETOBJ_TYPE = 1.
<ROXEE60123>-GHO_EXTENAL_ID = 1.
<ROXEE60123>-LGORT_D = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_ROXEE60123-SYSTEM_ID, sy-vline,
  WA_ROXEE60123-GHO_WELL_NAME, sy-vline,
  WA_ROXEE60123-GHO_WELLNAME_ALT, sy-vline,
  WA_ROXEE60123-GHO_CONN_DATE, sy-vline,
  WA_ROXEE60123-GHO_COMPL_DATE, sy-vline,
  WA_ROXEE60123-WELL_TYPE, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_ROXEE60123 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_ROXEE60123 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_ROXEE60123 INTO WA_ROXEE60123.


*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 TPLNR, internal->external for field TPLNR
CALL FUNCTION 'CONVERSION_EXIT_TPLNR_OUTPUT'
  EXPORTING
    input =                      WA_ROXEE60123-TPLNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ROXEE60123-TPLNR.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit TPLNR, internal->external for field GHO_WC_REF_ID
CALL FUNCTION 'CONVERSION_EXIT_TPLNR_OUTPUT'
  EXPORTING
    input =                      WA_ROXEE60123-GHO_WC_REF_ID
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ROXEE60123-GHO_WC_REF_ID.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field GHO_MFOLD_DP_UOM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_ROXEE60123-GHO_MFOLD_DP_UOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ROXEE60123-GHO_MFOLD_DP_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_ROXEE60123_STR, 
MANDT TYPE STRING,
TPLNR TYPE STRING,
GHO_NETOBJ_TYPE TYPE STRING,
GHO_EXTENAL_ID TYPE STRING,
LGORT_D TYPE STRING,
SYSTEM_ID TYPE STRING,
GHO_WELL_NAME TYPE STRING,
GHO_WELLNAME_ALT TYPE STRING,
GHO_CONN_DATE TYPE STRING,
GHO_COMPL_DATE TYPE STRING,
WELL_TYPE TYPE STRING,
GHO_PLABAND_DATE TYPE STRING,
FLD_SYS_WELL_ID TYPE STRING,
WELL_TEST_TYPE TYPE STRING,
PLNTY TYPE STRING,
PLNNR TYPE STRING,
PLNAL TYPE STRING,
AUART TYPE STRING,
GHO_WC_REF_ID TYPE STRING,
GHO_WC_NAME TYPE STRING,
GHO_WC_NAME_ALT TYPE STRING,
GHO_WC_TYPE TYPE STRING,
GHO_WC_COMP_DATE TYPE STRING,
FLD_SYS_WC_ID TYPE STRING,
COMMINGLD_WC_IND TYPE STRING,
WC_WELLTEST_TYPE TYPE STRING,
WC_PLNTY TYPE STRING,
WC_PLNNR TYPE STRING,
WC_PLNAL TYPE STRING,
WC_AUART TYPE STRING,
GHO_SUB_ADDRNUM TYPE STRING,
GHO_RESERVOIR TYPE STRING,
GHO_CONCESSION TYPE STRING,
GHO_FIELD TYPE STRING,
GHO_SHORE_IND TYPE STRING,
GHO_MTR_DESCR TYPE STRING,
GHO_MTR_TYPE TYPE STRING,
GHO_MTR_OP_MODE TYPE STRING,
GHO_MTR_DESN_PRE TYPE STRING,
GHO_MTR_OP_PRE TYPE STRING,
GHO_MTR_DESN_TEM TYPE STRING,
GHO_MTR_OP_TEMP TYPE STRING,
GHO_MTR_LVR_FROM TYPE STRING,
GHO_MTR_LVR_TO TYPE STRING,
GHO_MTR_LQD_RAT TYPE STRING,
GHO_MTR_VOL_FRA TYPE STRING,
GHO_MTR_LQD_VOL TYPE STRING,
GHO_MTR_DP_UOM TYPE STRING,
GHO_MTR_DT_UOM TYPE STRING,
GHO_MTR_OP_UOM TYPE STRING,
GHO_MTR_OT_UOM TYPE STRING,
GHO_MTR_LVRF_UOM TYPE STRING,
GHO_MTR_LVRT_UOM TYPE STRING,
GHO_MTR_LQDRATUI TYPE STRING,
GHO_MTR_LQDVOLUI TYPE STRING,
GHO_PUMP_DESCR TYPE STRING,
GHO_PUMP_TYPE TYPE STRING,
GHO_PUMP_DRIVER TYPE STRING,
GHO_PUMP_FLUID TYPE STRING,
GHO_PUMP_APPL TYPE STRING,
GHO_PUMP_DESIGN TYPE STRING,
GHO_PUMP_PR TYPE STRING,
GHO_PUMP_SP TYPE STRING,
GHO_PUMP_DP TYPE STRING,
GHO_PUMP_SPEED TYPE STRING,
GHO_PUMP_PR_UOM TYPE STRING,
GHO_PUMP_SP_UOM TYPE STRING,
GHO_PUMP_DP_UOM TYPE STRING,
GHO_PUMP_SD_UOM TYPE STRING,
GHO_UOS TYPE STRING,
GHO_SEP_DP TYPE STRING,
GHO_SEP_DP_UOM TYPE STRING,
GHO_SEP_OP TYPE STRING,
GHO_SEP_OP_UOM TYPE STRING,
GHO_SEP_DT TYPE STRING,
GHO_SEP_DT_UOM TYPE STRING,
GHO_SEP_OT TYPE STRING,
GHO_SEP_OT_UOM TYPE STRING,
CHOKE_SIZE_VAL TYPE STRING,
CHOKE_SIZE_UOM TYPE STRING,
GHO_COMP_TYPE TYPE STRING,
GHO_SP_FIRST TYPE STRING,
GHO_SP_F_UOM TYPE STRING,
GHO_SP_SECOND TYPE STRING,
GHO_SP_S_UOM TYPE STRING,
GHO_DP_FIRST TYPE STRING,
GHO_DP_F_UOM TYPE STRING,
GHO_DP_SECOND TYPE STRING,
GHO_DP_S_UOM TYPE STRING,
GHO_COMP_DT TYPE STRING,
GHO_COMP_DT_UOM TYPE STRING,
GHO_COMP_POWER TYPE STRING,
GHO_POWER_UOM TYPE STRING,
GHO_TB_TYPE TYPE STRING,
GHO_TB_DPR TYPE STRING,
GHO_TB_DPR_UOM TYPE STRING,
GHO_TB_OPR TYPE STRING,
GHO_TB_OPR_UOM TYPE STRING,
GHO_TB_SPD TYPE STRING,
GHO_TB_SPD_UOM TYPE STRING,
GHO_TB_FL_TYPE TYPE STRING,
GHO_OFS TYPE STRING,
GHO_LFS TYPE STRING,
GHO_LFS_UOM TYPE STRING,
GHO_PN_TZ TYPE STRING,
GHO_PN_SBD TYPE STRING,
GHO_PN_NW_ALLOC TYPE STRING,
NETID TYPE STRING,
OPERATOR TYPE STRING,
SEQNR TYPE STRING,
TANK_TYPE TYPE STRING,
GHO_SUBSURF_IND TYPE STRING,
GHO_ELEVATION_RE TYPE STRING,
GHO_WELL_TVD TYPE STRING,
GHO_PERF_FROM TYPE STRING,
GHO_PERF_TO TYPE STRING,
GHO_HGR_DEPTH TYPE STRING,
GHO_SHOE_DEPTH TYPE STRING,
GHO_ELEV_UOM TYPE STRING,
GHO_PERF_UOM TYPE STRING,
GHO_PERT_UOM TYPE STRING,
GHO_HGR_DEP_UOM TYPE STRING,
GHO_SHOE_DEP_UOM TYPE STRING,
GHO_DEPTH_UOM TYPE STRING,
GHO_WELL_TVD_UOM TYPE STRING,
GHO_DEH_TYPE TYPE STRING,
GHO_DEH_DSN_TEMP TYPE STRING,
GHO_DEH_OP_TEMP TYPE STRING,
GHO_DEH_DT_UOM TYPE STRING,
GHO_DEH_OT_UOM TYPE STRING,
GHO_HT_CONFIG TYPE STRING,
GHO_HT_TMECH TYPE STRING,
GHO_HT_DESN_TEMP TYPE STRING,
GHO_HT_OP_TEMP TYPE STRING,
GHO_HT_DT_UOM TYPE STRING,
GHO_HT_OT_UOM TYPE STRING,
GHO_PIPE_DPRE TYPE STRING,
GHO_PIPE_DP_UOM TYPE STRING,
GHO_LPL TYPE STRING,
GHO_LEN_UOM TYPE STRING,
GHO_INDIAMETER TYPE STRING,
GHO_IND_UOM TYPE STRING,
GHO_OUTDIAMETER TYPE STRING,
GHO_OUTD_UOM TYPE STRING,
GHO_WALLTHICK TYPE STRING,
GHO_WT_UOM TYPE STRING,
GHO_PIPEMATNR TYPE STRING,
GHO_MFOLD_DPRE TYPE STRING,
GHO_MFOLD_DP_UOM TYPE STRING,END OF T_EKKO_STR.
DATA: WA_ROXEE60123_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_ROXEE60123_STR-MANDT sy-vline 
WA_ROXEE60123_STR-TPLNR sy-vline 
WA_ROXEE60123_STR-GHO_NETOBJ_TYPE sy-vline 
WA_ROXEE60123_STR-GHO_EXTENAL_ID sy-vline 
WA_ROXEE60123_STR-LGORT_D sy-vline 
WA_ROXEE60123_STR-SYSTEM_ID sy-vline 
WA_ROXEE60123_STR-GHO_WELL_NAME sy-vline 
WA_ROXEE60123_STR-GHO_WELLNAME_ALT sy-vline 
WA_ROXEE60123_STR-GHO_CONN_DATE sy-vline 
WA_ROXEE60123_STR-GHO_COMPL_DATE sy-vline 
WA_ROXEE60123_STR-WELL_TYPE sy-vline 
WA_ROXEE60123_STR-GHO_PLABAND_DATE sy-vline 
WA_ROXEE60123_STR-FLD_SYS_WELL_ID sy-vline 
WA_ROXEE60123_STR-WELL_TEST_TYPE sy-vline 
WA_ROXEE60123_STR-PLNTY sy-vline 
WA_ROXEE60123_STR-PLNNR sy-vline 
WA_ROXEE60123_STR-PLNAL sy-vline 
WA_ROXEE60123_STR-AUART sy-vline 
WA_ROXEE60123_STR-GHO_WC_REF_ID sy-vline 
WA_ROXEE60123_STR-GHO_WC_NAME sy-vline 
WA_ROXEE60123_STR-GHO_WC_NAME_ALT sy-vline 
WA_ROXEE60123_STR-GHO_WC_TYPE sy-vline 
WA_ROXEE60123_STR-GHO_WC_COMP_DATE sy-vline 
WA_ROXEE60123_STR-FLD_SYS_WC_ID sy-vline 
WA_ROXEE60123_STR-COMMINGLD_WC_IND sy-vline 
WA_ROXEE60123_STR-WC_WELLTEST_TYPE sy-vline 
WA_ROXEE60123_STR-WC_PLNTY sy-vline 
WA_ROXEE60123_STR-WC_PLNNR sy-vline 
WA_ROXEE60123_STR-WC_PLNAL sy-vline 
WA_ROXEE60123_STR-WC_AUART sy-vline 
WA_ROXEE60123_STR-GHO_SUB_ADDRNUM sy-vline 
WA_ROXEE60123_STR-GHO_RESERVOIR sy-vline 
WA_ROXEE60123_STR-GHO_CONCESSION sy-vline 
WA_ROXEE60123_STR-GHO_FIELD sy-vline 
WA_ROXEE60123_STR-GHO_SHORE_IND sy-vline 
WA_ROXEE60123_STR-GHO_MTR_DESCR sy-vline 
WA_ROXEE60123_STR-GHO_MTR_TYPE sy-vline 
WA_ROXEE60123_STR-GHO_MTR_OP_MODE sy-vline 
WA_ROXEE60123_STR-GHO_MTR_DESN_PRE sy-vline 
WA_ROXEE60123_STR-GHO_MTR_OP_PRE sy-vline 
WA_ROXEE60123_STR-GHO_MTR_DESN_TEM sy-vline 
WA_ROXEE60123_STR-GHO_MTR_OP_TEMP sy-vline 
WA_ROXEE60123_STR-GHO_MTR_LVR_FROM sy-vline 
WA_ROXEE60123_STR-GHO_MTR_LVR_TO sy-vline 
WA_ROXEE60123_STR-GHO_MTR_LQD_RAT sy-vline 
WA_ROXEE60123_STR-GHO_MTR_VOL_FRA sy-vline 
WA_ROXEE60123_STR-GHO_MTR_LQD_VOL sy-vline 
WA_ROXEE60123_STR-GHO_MTR_DP_UOM sy-vline 
WA_ROXEE60123_STR-GHO_MTR_DT_UOM sy-vline 
WA_ROXEE60123_STR-GHO_MTR_OP_UOM sy-vline 
WA_ROXEE60123_STR-GHO_MTR_OT_UOM sy-vline 
WA_ROXEE60123_STR-GHO_MTR_LVRF_UOM sy-vline 
WA_ROXEE60123_STR-GHO_MTR_LVRT_UOM sy-vline 
WA_ROXEE60123_STR-GHO_MTR_LQDRATUI sy-vline 
WA_ROXEE60123_STR-GHO_MTR_LQDVOLUI sy-vline 
WA_ROXEE60123_STR-GHO_PUMP_DESCR sy-vline 
WA_ROXEE60123_STR-GHO_PUMP_TYPE sy-vline 
WA_ROXEE60123_STR-GHO_PUMP_DRIVER sy-vline 
WA_ROXEE60123_STR-GHO_PUMP_FLUID sy-vline 
WA_ROXEE60123_STR-GHO_PUMP_APPL sy-vline 
WA_ROXEE60123_STR-GHO_PUMP_DESIGN sy-vline 
WA_ROXEE60123_STR-GHO_PUMP_PR sy-vline 
WA_ROXEE60123_STR-GHO_PUMP_SP sy-vline 
WA_ROXEE60123_STR-GHO_PUMP_DP sy-vline 
WA_ROXEE60123_STR-GHO_PUMP_SPEED sy-vline 
WA_ROXEE60123_STR-GHO_PUMP_PR_UOM sy-vline 
WA_ROXEE60123_STR-GHO_PUMP_SP_UOM sy-vline 
WA_ROXEE60123_STR-GHO_PUMP_DP_UOM sy-vline 
WA_ROXEE60123_STR-GHO_PUMP_SD_UOM sy-vline 
WA_ROXEE60123_STR-GHO_UOS sy-vline 
WA_ROXEE60123_STR-GHO_SEP_DP sy-vline 
WA_ROXEE60123_STR-GHO_SEP_DP_UOM sy-vline 
WA_ROXEE60123_STR-GHO_SEP_OP sy-vline 
WA_ROXEE60123_STR-GHO_SEP_OP_UOM sy-vline 
WA_ROXEE60123_STR-GHO_SEP_DT sy-vline 
WA_ROXEE60123_STR-GHO_SEP_DT_UOM sy-vline 
WA_ROXEE60123_STR-GHO_SEP_OT sy-vline 
WA_ROXEE60123_STR-GHO_SEP_OT_UOM sy-vline 
WA_ROXEE60123_STR-CHOKE_SIZE_VAL sy-vline 
WA_ROXEE60123_STR-CHOKE_SIZE_UOM sy-vline 
WA_ROXEE60123_STR-GHO_COMP_TYPE sy-vline 
WA_ROXEE60123_STR-GHO_SP_FIRST sy-vline 
WA_ROXEE60123_STR-GHO_SP_F_UOM sy-vline 
WA_ROXEE60123_STR-GHO_SP_SECOND sy-vline 
WA_ROXEE60123_STR-GHO_SP_S_UOM sy-vline 
WA_ROXEE60123_STR-GHO_DP_FIRST sy-vline 
WA_ROXEE60123_STR-GHO_DP_F_UOM sy-vline 
WA_ROXEE60123_STR-GHO_DP_SECOND sy-vline 
WA_ROXEE60123_STR-GHO_DP_S_UOM sy-vline 
WA_ROXEE60123_STR-GHO_COMP_DT sy-vline 
WA_ROXEE60123_STR-GHO_COMP_DT_UOM sy-vline 
WA_ROXEE60123_STR-GHO_COMP_POWER sy-vline 
WA_ROXEE60123_STR-GHO_POWER_UOM sy-vline 
WA_ROXEE60123_STR-GHO_TB_TYPE sy-vline 
WA_ROXEE60123_STR-GHO_TB_DPR sy-vline 
WA_ROXEE60123_STR-GHO_TB_DPR_UOM sy-vline 
WA_ROXEE60123_STR-GHO_TB_OPR sy-vline 
WA_ROXEE60123_STR-GHO_TB_OPR_UOM sy-vline 
WA_ROXEE60123_STR-GHO_TB_SPD sy-vline 
WA_ROXEE60123_STR-GHO_TB_SPD_UOM sy-vline 
WA_ROXEE60123_STR-GHO_TB_FL_TYPE sy-vline 
WA_ROXEE60123_STR-GHO_OFS sy-vline 
WA_ROXEE60123_STR-GHO_LFS sy-vline 
WA_ROXEE60123_STR-GHO_LFS_UOM sy-vline 
WA_ROXEE60123_STR-GHO_PN_TZ sy-vline 
WA_ROXEE60123_STR-GHO_PN_SBD sy-vline 
WA_ROXEE60123_STR-GHO_PN_NW_ALLOC sy-vline 
WA_ROXEE60123_STR-NETID sy-vline 
WA_ROXEE60123_STR-OPERATOR sy-vline 
WA_ROXEE60123_STR-SEQNR sy-vline 
WA_ROXEE60123_STR-TANK_TYPE sy-vline 
WA_ROXEE60123_STR-GHO_SUBSURF_IND sy-vline 
WA_ROXEE60123_STR-GHO_ELEVATION_RE sy-vline 
WA_ROXEE60123_STR-GHO_WELL_TVD sy-vline 
WA_ROXEE60123_STR-GHO_PERF_FROM sy-vline 
WA_ROXEE60123_STR-GHO_PERF_TO sy-vline 
WA_ROXEE60123_STR-GHO_HGR_DEPTH sy-vline 
WA_ROXEE60123_STR-GHO_SHOE_DEPTH sy-vline 
WA_ROXEE60123_STR-GHO_ELEV_UOM sy-vline 
WA_ROXEE60123_STR-GHO_PERF_UOM sy-vline 
WA_ROXEE60123_STR-GHO_PERT_UOM sy-vline 
WA_ROXEE60123_STR-GHO_HGR_DEP_UOM sy-vline 
WA_ROXEE60123_STR-GHO_SHOE_DEP_UOM sy-vline 
WA_ROXEE60123_STR-GHO_DEPTH_UOM sy-vline 
WA_ROXEE60123_STR-GHO_WELL_TVD_UOM sy-vline 
WA_ROXEE60123_STR-GHO_DEH_TYPE sy-vline 
WA_ROXEE60123_STR-GHO_DEH_DSN_TEMP sy-vline 
WA_ROXEE60123_STR-GHO_DEH_OP_TEMP sy-vline 
WA_ROXEE60123_STR-GHO_DEH_DT_UOM sy-vline 
WA_ROXEE60123_STR-GHO_DEH_OT_UOM sy-vline 
WA_ROXEE60123_STR-GHO_HT_CONFIG sy-vline 
WA_ROXEE60123_STR-GHO_HT_TMECH sy-vline 
WA_ROXEE60123_STR-GHO_HT_DESN_TEMP sy-vline 
WA_ROXEE60123_STR-GHO_HT_OP_TEMP sy-vline 
WA_ROXEE60123_STR-GHO_HT_DT_UOM sy-vline 
WA_ROXEE60123_STR-GHO_HT_OT_UOM sy-vline 
WA_ROXEE60123_STR-GHO_PIPE_DPRE sy-vline 
WA_ROXEE60123_STR-GHO_PIPE_DP_UOM sy-vline 
WA_ROXEE60123_STR-GHO_LPL sy-vline 
WA_ROXEE60123_STR-GHO_LEN_UOM sy-vline 
WA_ROXEE60123_STR-GHO_INDIAMETER sy-vline 
WA_ROXEE60123_STR-GHO_IND_UOM sy-vline 
WA_ROXEE60123_STR-GHO_OUTDIAMETER sy-vline 
WA_ROXEE60123_STR-GHO_OUTD_UOM sy-vline 
WA_ROXEE60123_STR-GHO_WALLTHICK sy-vline 
WA_ROXEE60123_STR-GHO_WT_UOM sy-vline 
WA_ROXEE60123_STR-GHO_PIPEMATNR sy-vline 
WA_ROXEE60123_STR-GHO_MFOLD_DPRE sy-vline 
WA_ROXEE60123_STR-GHO_MFOLD_DP_UOM sy-vline      INTO ld_text SEPARATED BY SPACE.

*Add any further fields from structure WA_EKKO_STR you want to CONCATENATE...
ENDLOOP.
ENDFORM.