ABAP Select data from SAP table QEWLD 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 QEWLD 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 QEWLD. 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 QEWLD 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_QEWLD TYPE STANDARD TABLE OF QEWLD,
      WA_QEWLD TYPE QEWLD,
      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: <QEWLD> TYPE QEWLD.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM QEWLD
*  INTO TABLE @DATA(IT_QEWLD2).
*--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_QEWLD INDEX 1 INTO DATA(WA_QEWLD2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_QEWLD ASSIGNING <QEWLD>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<QEWLD>-MANDANT = 1.
<QEWLD>-PRUEFLOS = 1.
<QEWLD>-VORGLFNR = 1.
<QEWLD>-ZAEHLER = 1.
<QEWLD>-AUFPL = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_QEWLD-VORNR, sy-vline,
WA_QEWLD-ERSTELLER, sy-vline,
WA_QEWLD-ERSTELLDAT, sy-vline,
WA_QEWLD-ERSTELZEIT, sy-vline,
WA_QEWLD-AENDERER, sy-vline,
WA_QEWLD-AENDERDAT, sy-vline.
ENDLOOP. *Add any further fields from structure WA_QEWLD 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_QEWLD 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_QEWLD INTO WA_QEWLD. *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 PRUEFLOS CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_QEWLD-PRUEFLOS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_QEWLD-PRUEFLOS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit NUMCV, internal->external for field VORNR CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_QEWLD-VORNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_QEWLD-VORNR.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit NUMCV, internal->external for field UVORN CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_QEWLD-UVORN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_QEWLD-UVORN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ISOLA, internal->external for field TXTSP CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT' EXPORTING input = WA_QEWLD-TXTSP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_QEWLD-TXTSP.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit NUMCV, internal->external for field REVLVLOT CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_QEWLD-REVLVLOT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_QEWLD-REVLVLOT.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit ISOLA, internal->external for field SPRACHELOT CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT' EXPORTING input = WA_QEWLD-SPRACHELOT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_QEWLD-SPRACHELOT.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field LS_VBELNLOT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_QEWLD-LS_VBELNLOT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_QEWLD-LS_VBELNLOT.
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_QEWLD_STR,
MANDANT TYPE STRING,
PRUEFLOS TYPE STRING,
VORGLFNR TYPE STRING,
ZAEHLER TYPE STRING,
AUFPL TYPE STRING,
VORNR TYPE STRING,
ERSTELLER TYPE STRING,
ERSTELLDAT TYPE STRING,
ERSTELZEIT TYPE STRING,
AENDERER TYPE STRING,
AENDERDAT TYPE STRING,
AENDERZEIT TYPE STRING,
RUECKMELDER TYPE STRING,
RUECKMEDAT TYPE STRING,
RUECKMEZEIT TYPE STRING,
HHANW TYPE STRING,
PRUEFER TYPE STRING,
STATUS TYPE STRING,
MBEWERTG TYPE STRING,
FEHLERKZ TYPE STRING,
LOGNUMBER TYPE STRING,
DUMMY10 TYPE STRING,
DUMMY20 TYPE STRING,
DUMMY40 TYPE STRING,
UPSL TYPE STRING,
APLFL TYPE STRING,
UVORN TYPE STRING,
STEUS TYPE STRING,
LTXA1 TYPE STRING,
TXTSP TYPE STRING,
PRPLATZ TYPE STRING,
PRPLATZWRK TYPE STRING,
PRPLATZTXT TYPE STRING,
SUBSYS TYPE STRING,
IDENT TYPE STRING,
SSAVD TYPE STRING,
WERKS TYPE STRING,
ARBID TYPE STRING,
STATUSD TYPE STRING,
STATUSD_TEXT TYPE STRING,
HHANW_TEXT TYPE STRING,
XSLEX TYPE STRING,
STTXTLOT TYPE STRING,
USTXTLOT TYPE STRING,
WERKLOT TYPE STRING,
ARTLOT TYPE STRING,
HERKUNFTLOT TYPE STRING,
OBJNRLOT TYPE STRING,
OBTYPLOT TYPE STRING,
KTEXTMATLOT TYPE STRING,
STSMALOT TYPE STRING,
STAT02LOT TYPE STRING,
STAT07LOT TYPE STRING,
STAT09LOT TYPE STRING,
STAT19LOT TYPE STRING,
KZSKIPLOTLOT TYPE STRING,
HPZLOT TYPE STRING,
ENSTEHDATLOT TYPE STRING,
ENTSTEZEITLOT TYPE STRING,
ERSTELLERLOT TYPE STRING,
ERSTELDATLOT TYPE STRING,
ERSTELZEITLOT TYPE STRING,
AENDERERLOT TYPE STRING,
AENDERDATLOT TYPE STRING,
AENDERZEITLOT TYPE STRING,
PASTRTERMLOT TYPE STRING,
PASTRZEITLOT TYPE STRING,
PAENDTERMLOT TYPE STRING,
PAENDZEITLOT TYPE STRING,
STAT13LOT TYPE STRING,
AUFNRLOT TYPE STRING,
VERIDLOT TYPE STRING,
KUNNRLOT TYPE STRING,
LIFNRLOT TYPE STRING,
HERSTELLERLOT TYPE STRING,
EMATNRLOT TYPE STRING,
MATNRLOT TYPE STRING,
REVLVLOT TYPE STRING,
XCHPFLOT TYPE STRING,
CHARGLOT TYPE STRING,
LICHNLOT TYPE STRING,
LAGORTCHRGLOT TYPE STRING,
EBELNLOT TYPE STRING,
EBELPLOT TYPE STRING,
MJAHRLOT TYPE STRING,
MBLNRLOT TYPE STRING,
ZEILELOT TYPE STRING,
WERKVORGLOT TYPE STRING,
LAGORTVORGLOT TYPE STRING,
LGNUMLOT TYPE STRING,
LGTYPLOT TYPE STRING,
LGPLALOT TYPE STRING,
SPRACHELOT TYPE STRING,
KTEXTLOSLOT TYPE STRING,
ZUSMKZAEHLLOT TYPE STRING,
OFFENNLZMKLOT TYPE STRING,
OFFEN_LZMKLOT TYPE STRING,
LOSMENGELOT TYPE STRING,
MENGENEINHLOT TYPE STRING,
ANZGEBLOT TYPE STRING,
GEBEHLOT TYPE STRING,
GESSTICHPRLOT TYPE STRING,
EINHPROBELOT TYPE STRING,
PS_PSP_PNRLOT TYPE STRING,
KDAUFLOT TYPE STRING,
KDPOSLOT TYPE STRING,
SOBKZLOT TYPE STRING,
LS_KDAUFLOT TYPE STRING,
LS_KDPOSLOT TYPE STRING,
LS_VBELNLOT TYPE STRING,
LS_POSNRLOT TYPE STRING,
LS_KDMATLOT TYPE STRING,END OF T_EKKO_STR. DATA: WA_QEWLD_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_QEWLD_STR-MANDANT sy-vline
WA_QEWLD_STR-PRUEFLOS sy-vline
WA_QEWLD_STR-VORGLFNR sy-vline
WA_QEWLD_STR-ZAEHLER sy-vline
WA_QEWLD_STR-AUFPL sy-vline
WA_QEWLD_STR-VORNR sy-vline
WA_QEWLD_STR-ERSTELLER sy-vline
WA_QEWLD_STR-ERSTELLDAT sy-vline
WA_QEWLD_STR-ERSTELZEIT sy-vline
WA_QEWLD_STR-AENDERER sy-vline
WA_QEWLD_STR-AENDERDAT sy-vline
WA_QEWLD_STR-AENDERZEIT sy-vline
WA_QEWLD_STR-RUECKMELDER sy-vline
WA_QEWLD_STR-RUECKMEDAT sy-vline
WA_QEWLD_STR-RUECKMEZEIT sy-vline
WA_QEWLD_STR-HHANW sy-vline
WA_QEWLD_STR-PRUEFER sy-vline
WA_QEWLD_STR-STATUS sy-vline
WA_QEWLD_STR-MBEWERTG sy-vline
WA_QEWLD_STR-FEHLERKZ sy-vline
WA_QEWLD_STR-LOGNUMBER sy-vline
WA_QEWLD_STR-DUMMY10 sy-vline
WA_QEWLD_STR-DUMMY20 sy-vline
WA_QEWLD_STR-DUMMY40 sy-vline
WA_QEWLD_STR-UPSL sy-vline
WA_QEWLD_STR-APLFL sy-vline
WA_QEWLD_STR-UVORN sy-vline
WA_QEWLD_STR-STEUS sy-vline
WA_QEWLD_STR-LTXA1 sy-vline
WA_QEWLD_STR-TXTSP sy-vline
WA_QEWLD_STR-PRPLATZ sy-vline
WA_QEWLD_STR-PRPLATZWRK sy-vline
WA_QEWLD_STR-PRPLATZTXT sy-vline
WA_QEWLD_STR-SUBSYS sy-vline
WA_QEWLD_STR-IDENT sy-vline
WA_QEWLD_STR-SSAVD sy-vline
WA_QEWLD_STR-WERKS sy-vline
WA_QEWLD_STR-ARBID sy-vline
WA_QEWLD_STR-STATUSD sy-vline
WA_QEWLD_STR-STATUSD_TEXT sy-vline
WA_QEWLD_STR-HHANW_TEXT sy-vline
WA_QEWLD_STR-XSLEX sy-vline
WA_QEWLD_STR-STTXTLOT sy-vline
WA_QEWLD_STR-USTXTLOT sy-vline
WA_QEWLD_STR-WERKLOT sy-vline
WA_QEWLD_STR-ARTLOT sy-vline
WA_QEWLD_STR-HERKUNFTLOT sy-vline
WA_QEWLD_STR-OBJNRLOT sy-vline
WA_QEWLD_STR-OBTYPLOT sy-vline
WA_QEWLD_STR-KTEXTMATLOT sy-vline
WA_QEWLD_STR-STSMALOT sy-vline
WA_QEWLD_STR-STAT02LOT sy-vline
WA_QEWLD_STR-STAT07LOT sy-vline
WA_QEWLD_STR-STAT09LOT sy-vline
WA_QEWLD_STR-STAT19LOT sy-vline
WA_QEWLD_STR-KZSKIPLOTLOT sy-vline
WA_QEWLD_STR-HPZLOT sy-vline
WA_QEWLD_STR-ENSTEHDATLOT sy-vline
WA_QEWLD_STR-ENTSTEZEITLOT sy-vline
WA_QEWLD_STR-ERSTELLERLOT sy-vline
WA_QEWLD_STR-ERSTELDATLOT sy-vline
WA_QEWLD_STR-ERSTELZEITLOT sy-vline
WA_QEWLD_STR-AENDERERLOT sy-vline
WA_QEWLD_STR-AENDERDATLOT sy-vline
WA_QEWLD_STR-AENDERZEITLOT sy-vline
WA_QEWLD_STR-PASTRTERMLOT sy-vline
WA_QEWLD_STR-PASTRZEITLOT sy-vline
WA_QEWLD_STR-PAENDTERMLOT sy-vline
WA_QEWLD_STR-PAENDZEITLOT sy-vline
WA_QEWLD_STR-STAT13LOT sy-vline
WA_QEWLD_STR-AUFNRLOT sy-vline
WA_QEWLD_STR-VERIDLOT sy-vline
WA_QEWLD_STR-KUNNRLOT sy-vline
WA_QEWLD_STR-LIFNRLOT sy-vline
WA_QEWLD_STR-HERSTELLERLOT sy-vline
WA_QEWLD_STR-EMATNRLOT sy-vline
WA_QEWLD_STR-MATNRLOT sy-vline
WA_QEWLD_STR-REVLVLOT sy-vline
WA_QEWLD_STR-XCHPFLOT sy-vline
WA_QEWLD_STR-CHARGLOT sy-vline
WA_QEWLD_STR-LICHNLOT sy-vline
WA_QEWLD_STR-LAGORTCHRGLOT sy-vline
WA_QEWLD_STR-EBELNLOT sy-vline
WA_QEWLD_STR-EBELPLOT sy-vline
WA_QEWLD_STR-MJAHRLOT sy-vline
WA_QEWLD_STR-MBLNRLOT sy-vline
WA_QEWLD_STR-ZEILELOT sy-vline
WA_QEWLD_STR-WERKVORGLOT sy-vline
WA_QEWLD_STR-LAGORTVORGLOT sy-vline
WA_QEWLD_STR-LGNUMLOT sy-vline
WA_QEWLD_STR-LGTYPLOT sy-vline
WA_QEWLD_STR-LGPLALOT sy-vline
WA_QEWLD_STR-SPRACHELOT sy-vline
WA_QEWLD_STR-KTEXTLOSLOT sy-vline
WA_QEWLD_STR-ZUSMKZAEHLLOT sy-vline
WA_QEWLD_STR-OFFENNLZMKLOT sy-vline
WA_QEWLD_STR-OFFEN_LZMKLOT sy-vline
WA_QEWLD_STR-LOSMENGELOT sy-vline
WA_QEWLD_STR-MENGENEINHLOT sy-vline
WA_QEWLD_STR-ANZGEBLOT sy-vline
WA_QEWLD_STR-GEBEHLOT sy-vline
WA_QEWLD_STR-GESSTICHPRLOT sy-vline
WA_QEWLD_STR-EINHPROBELOT sy-vline
WA_QEWLD_STR-PS_PSP_PNRLOT sy-vline
WA_QEWLD_STR-KDAUFLOT sy-vline
WA_QEWLD_STR-KDPOSLOT sy-vline
WA_QEWLD_STR-SOBKZLOT sy-vline
WA_QEWLD_STR-LS_KDAUFLOT sy-vline
WA_QEWLD_STR-LS_KDPOSLOT sy-vline
WA_QEWLD_STR-LS_VBELNLOT sy-vline
WA_QEWLD_STR-LS_POSNRLOT sy-vline
WA_QEWLD_STR-LS_KDMATLOT sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.