ABAP Select data from SAP table OIJ_EL_ETS_NOMI 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 OIJ_EL_ETS_NOMI 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 OIJ_EL_ETS_NOMI. 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 OIJ_EL_ETS_NOMI 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_OIJ_EL_ETS_NOMI TYPE STANDARD TABLE OF OIJ_EL_ETS_NOMI,
      WA_OIJ_EL_ETS_NOMI TYPE OIJ_EL_ETS_NOMI,
      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: <OIJ_EL_ETS_NOMI> TYPE OIJ_EL_ETS_NOMI.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM OIJ_EL_ETS_NOMI
*  INTO TABLE @DATA(IT_OIJ_EL_ETS_NOMI2).
*--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_OIJ_EL_ETS_NOMI INDEX 1 INTO DATA(WA_OIJ_EL_ETS_NOMI2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_OIJ_EL_ETS_NOMI ASSIGNING <OIJ_EL_ETS_NOMI>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<OIJ_EL_ETS_NOMI>-NOMINATIONNUMBER_SAP = 1.
<OIJ_EL_ETS_NOMI>-ITEMNUMBER = 1.
<OIJ_EL_ETS_NOMI>-ITEMTYPE = 1.
<OIJ_EL_ETS_NOMI>-ITEMSTATUS = 1.
<OIJ_EL_ETS_NOMI>-ITEMSUBSTATUS = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_OIJ_EL_ETS_NOMI-SCHEDULEDDATE, sy-vline,
WA_OIJ_EL_ETS_NOMI-LOCATIONID, sy-vline,
WA_OIJ_EL_ETS_NOMI-PLANNINGLOCATIONINDICATOR, sy-vline,
WA_OIJ_EL_ETS_NOMI-LOCATIONPLANT, sy-vline,
WA_OIJ_EL_ETS_NOMI-LOCATIONSTORAGELOCATION, sy-vline,
WA_OIJ_EL_ETS_NOMI-DEMANDMATERIAL, sy-vline.
ENDLOOP. *Add any further fields from structure WA_OIJ_EL_ETS_NOMI 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_OIJ_EL_ETS_NOMI 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_OIJ_EL_ETS_NOMI INTO WA_OIJ_EL_ETS_NOMI. *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 NOMINATIONNUMBER_SAP CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_OIJ_EL_ETS_NOMI-NOMINATIONNUMBER_SAP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIJ_EL_ETS_NOMI-NOMINATIONNUMBER_SAP.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN5, internal->external for field DEMANDMATERIAL CALL FUNCTION 'CONVERSION_EXIT_MATN5_OUTPUT' EXPORTING input = WA_OIJ_EL_ETS_NOMI-DEMANDMATERIAL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIJ_EL_ETS_NOMI-DEMANDMATERIAL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN5, internal->external for field SCHEDULEMATERIAL CALL FUNCTION 'CONVERSION_EXIT_MATN5_OUTPUT' EXPORTING input = WA_OIJ_EL_ETS_NOMI-SCHEDULEMATERIAL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIJ_EL_ETS_NOMI-SCHEDULEMATERIAL.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit MATN1, internal->external for field SCHEDULEMATERIAL_LONG CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_OIJ_EL_ETS_NOMI-SCHEDULEMATERIAL_LONG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIJ_EL_ETS_NOMI-SCHEDULEMATERIAL_LONG.
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_OIJ_EL_ETS_NOMI_STR,
NOMINATIONNUMBER_SAP TYPE STRING,
ITEMNUMBER TYPE STRING,
ITEMTYPE TYPE STRING,
ITEMSTATUS TYPE STRING,
ITEMSUBSTATUS TYPE STRING,
SCHEDULEDDATE TYPE STRING,
LOCATIONID TYPE STRING,
PLANNINGLOCATIONINDICATOR TYPE STRING,
LOCATIONPLANT TYPE STRING,
LOCATIONSTORAGELOCATION TYPE STRING,
DEMANDMATERIAL TYPE STRING,
SCHEDULEMATERIAL TYPE STRING,
NOMINATEDQUANTITY TYPE STRING,
QUANTITYUNIT_SAP TYPE STRING,
QUANTITYUNIT_ISO TYPE STRING,
DOCUMENTINDICATOR TYPE STRING,
DOCUMENTNUMBER TYPE STRING,
DOCUMENTTYPE TYPE STRING,
DOCUMENTITEM TYPE STRING,
DOCUMENTSCHEDULELINE TYPE STRING,
WORKLISTINDICATOR TYPE STRING,
TANKAGE TYPE STRING,
CONSIGNEE TYPE STRING,
LOCATIONPARTNER TYPE STRING,
CONTRACTPARTNER TYPE STRING,
INSPECTOR TYPE STRING,
IMPORTEREXPORTER TYPE STRING,
IMPORTEREXPORTERFLAG TYPE STRING,
BATCHORIGIN TYPE STRING,
VALUATIONTYPEORIGIN TYPE STRING,
BATCHDESTINATION TYPE STRING,
VALUATIONTYPEDESTINATION TYPE STRING,
BATCHDESTINATIONCREATE TYPE STRING,
BATCHATLOADING TYPE STRING,
BATCHATLOADINGCREATE TYPE STRING,
REEDVAPOURPRESSURE TYPE STRING,
SHIPMENTNUMBER TYPE STRING,
SHIPMENTITEM TYPE STRING,
ITEMPARTCOMPLETEFLAG TYPE STRING,
ITEMCOMPLETEFLAG TYPE STRING,
ACTUALQUANTITY TYPE STRING,
ACTUALQUANTITYUNIT_SAP TYPE STRING,
ACTUALQUANTITYUNIT_ISO TYPE STRING,
LASTITEMACTION TYPE STRING,
OVERTOLERANCEPERCT TYPE STRING,
UNDERTOLERANCEPERCT TYPE STRING,
OVERTOLERANCEABSOLUTE TYPE STRING,
UNDERTOLERANCEABSOLUTE TYPE STRING,
TOLERANCEUNIT_SAP TYPE STRING,
TOLERANCEUNIT_ISO TYPE STRING,
UNLIMITEDTOLERANCE TYPE STRING,
CREATION TYPE STRING,
CREATEDBY TYPE STRING,
MODIFICATION TYPE STRING,
CHANGEDBY TYPE STRING,
AUTOCONFIRM TYPE STRING,
BLOCKINGINDICATOR TYPE STRING,
DELETIONINDICATOR TYPE STRING,
INCOMPLETE_FLAG TYPE STRING,
NOMINATIONSCHEDULEDATEFROM TYPE STRING,
NOMINATIONSCHEDULEDATETO TYPE STRING,
TRADINGCONTRACT_NUM TYPE STRING,
TRADINGCONTRACT_ITEM TYPE STRING,
ACTUALQUANTITY_PAR TYPE STRING,
ACTUALQUANTITYUNIT_PAR_SAP TYPE STRING,
ACTUALQUANTITYUNIT_PAR_ISO TYPE STRING,
DEMANDMATERIAL_LONG TYPE STRING,
SCHEDULEMATERIAL_LONG TYPE STRING,
SCH_STARTDATE TYPE STRING,
SCH_STARTTIME TYPE STRING,
SCH_ENDDATE TYPE STRING,
SCH_ENDTTIME TYPE STRING,
UPDKZ TYPE STRING,END OF T_EKKO_STR. DATA: WA_OIJ_EL_ETS_NOMI_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_OIJ_EL_ETS_NOMI_STR-NOMINATIONNUMBER_SAP sy-vline
WA_OIJ_EL_ETS_NOMI_STR-ITEMNUMBER sy-vline
WA_OIJ_EL_ETS_NOMI_STR-ITEMTYPE sy-vline
WA_OIJ_EL_ETS_NOMI_STR-ITEMSTATUS sy-vline
WA_OIJ_EL_ETS_NOMI_STR-ITEMSUBSTATUS sy-vline
WA_OIJ_EL_ETS_NOMI_STR-SCHEDULEDDATE sy-vline
WA_OIJ_EL_ETS_NOMI_STR-LOCATIONID sy-vline
WA_OIJ_EL_ETS_NOMI_STR-PLANNINGLOCATIONINDICATOR sy-vline
WA_OIJ_EL_ETS_NOMI_STR-LOCATIONPLANT sy-vline
WA_OIJ_EL_ETS_NOMI_STR-LOCATIONSTORAGELOCATION sy-vline
WA_OIJ_EL_ETS_NOMI_STR-DEMANDMATERIAL sy-vline
WA_OIJ_EL_ETS_NOMI_STR-SCHEDULEMATERIAL sy-vline
WA_OIJ_EL_ETS_NOMI_STR-NOMINATEDQUANTITY sy-vline
WA_OIJ_EL_ETS_NOMI_STR-QUANTITYUNIT_SAP sy-vline
WA_OIJ_EL_ETS_NOMI_STR-QUANTITYUNIT_ISO sy-vline
WA_OIJ_EL_ETS_NOMI_STR-DOCUMENTINDICATOR sy-vline
WA_OIJ_EL_ETS_NOMI_STR-DOCUMENTNUMBER sy-vline
WA_OIJ_EL_ETS_NOMI_STR-DOCUMENTTYPE sy-vline
WA_OIJ_EL_ETS_NOMI_STR-DOCUMENTITEM sy-vline
WA_OIJ_EL_ETS_NOMI_STR-DOCUMENTSCHEDULELINE sy-vline
WA_OIJ_EL_ETS_NOMI_STR-WORKLISTINDICATOR sy-vline
WA_OIJ_EL_ETS_NOMI_STR-TANKAGE sy-vline
WA_OIJ_EL_ETS_NOMI_STR-CONSIGNEE sy-vline
WA_OIJ_EL_ETS_NOMI_STR-LOCATIONPARTNER sy-vline
WA_OIJ_EL_ETS_NOMI_STR-CONTRACTPARTNER sy-vline
WA_OIJ_EL_ETS_NOMI_STR-INSPECTOR sy-vline
WA_OIJ_EL_ETS_NOMI_STR-IMPORTEREXPORTER sy-vline
WA_OIJ_EL_ETS_NOMI_STR-IMPORTEREXPORTERFLAG sy-vline
WA_OIJ_EL_ETS_NOMI_STR-BATCHORIGIN sy-vline
WA_OIJ_EL_ETS_NOMI_STR-VALUATIONTYPEORIGIN sy-vline
WA_OIJ_EL_ETS_NOMI_STR-BATCHDESTINATION sy-vline
WA_OIJ_EL_ETS_NOMI_STR-VALUATIONTYPEDESTINATION sy-vline
WA_OIJ_EL_ETS_NOMI_STR-BATCHDESTINATIONCREATE sy-vline
WA_OIJ_EL_ETS_NOMI_STR-BATCHATLOADING sy-vline
WA_OIJ_EL_ETS_NOMI_STR-BATCHATLOADINGCREATE sy-vline
WA_OIJ_EL_ETS_NOMI_STR-REEDVAPOURPRESSURE sy-vline
WA_OIJ_EL_ETS_NOMI_STR-SHIPMENTNUMBER sy-vline
WA_OIJ_EL_ETS_NOMI_STR-SHIPMENTITEM sy-vline
WA_OIJ_EL_ETS_NOMI_STR-ITEMPARTCOMPLETEFLAG sy-vline
WA_OIJ_EL_ETS_NOMI_STR-ITEMCOMPLETEFLAG sy-vline
WA_OIJ_EL_ETS_NOMI_STR-ACTUALQUANTITY sy-vline
WA_OIJ_EL_ETS_NOMI_STR-ACTUALQUANTITYUNIT_SAP sy-vline
WA_OIJ_EL_ETS_NOMI_STR-ACTUALQUANTITYUNIT_ISO sy-vline
WA_OIJ_EL_ETS_NOMI_STR-LASTITEMACTION sy-vline
WA_OIJ_EL_ETS_NOMI_STR-OVERTOLERANCEPERCT sy-vline
WA_OIJ_EL_ETS_NOMI_STR-UNDERTOLERANCEPERCT sy-vline
WA_OIJ_EL_ETS_NOMI_STR-OVERTOLERANCEABSOLUTE sy-vline
WA_OIJ_EL_ETS_NOMI_STR-UNDERTOLERANCEABSOLUTE sy-vline
WA_OIJ_EL_ETS_NOMI_STR-TOLERANCEUNIT_SAP sy-vline
WA_OIJ_EL_ETS_NOMI_STR-TOLERANCEUNIT_ISO sy-vline
WA_OIJ_EL_ETS_NOMI_STR-UNLIMITEDTOLERANCE sy-vline
WA_OIJ_EL_ETS_NOMI_STR-CREATION sy-vline
WA_OIJ_EL_ETS_NOMI_STR-CREATEDBY sy-vline
WA_OIJ_EL_ETS_NOMI_STR-MODIFICATION sy-vline
WA_OIJ_EL_ETS_NOMI_STR-CHANGEDBY sy-vline
WA_OIJ_EL_ETS_NOMI_STR-AUTOCONFIRM sy-vline
WA_OIJ_EL_ETS_NOMI_STR-BLOCKINGINDICATOR sy-vline
WA_OIJ_EL_ETS_NOMI_STR-DELETIONINDICATOR sy-vline
WA_OIJ_EL_ETS_NOMI_STR-INCOMPLETE_FLAG sy-vline
WA_OIJ_EL_ETS_NOMI_STR-NOMINATIONSCHEDULEDATEFROM sy-vline
WA_OIJ_EL_ETS_NOMI_STR-NOMINATIONSCHEDULEDATETO sy-vline
WA_OIJ_EL_ETS_NOMI_STR-TRADINGCONTRACT_NUM sy-vline
WA_OIJ_EL_ETS_NOMI_STR-TRADINGCONTRACT_ITEM sy-vline
WA_OIJ_EL_ETS_NOMI_STR-ACTUALQUANTITY_PAR sy-vline
WA_OIJ_EL_ETS_NOMI_STR-ACTUALQUANTITYUNIT_PAR_SAP sy-vline
WA_OIJ_EL_ETS_NOMI_STR-ACTUALQUANTITYUNIT_PAR_ISO sy-vline
WA_OIJ_EL_ETS_NOMI_STR-DEMANDMATERIAL_LONG sy-vline
WA_OIJ_EL_ETS_NOMI_STR-SCHEDULEMATERIAL_LONG sy-vline
WA_OIJ_EL_ETS_NOMI_STR-SCH_STARTDATE sy-vline
WA_OIJ_EL_ETS_NOMI_STR-SCH_STARTTIME sy-vline
WA_OIJ_EL_ETS_NOMI_STR-SCH_ENDDATE sy-vline
WA_OIJ_EL_ETS_NOMI_STR-SCH_ENDTTIME sy-vline
WA_OIJ_EL_ETS_NOMI_STR-UPDKZ sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.