ABAP Select data from SAP table /ISDFPS/SHPVSTOSTRUC 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 /ISDFPS/SHPVSTOSTRUC 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 /ISDFPS/SHPVSTOSTRUC. 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 /ISDFPS/SHPVSTOSTRUC 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_/ISDFPS/SHPVSTOSTRUC TYPE STANDARD TABLE OF /ISDFPS/SHPVSTOSTRUC,
      WA_/ISDFPS/SHPVSTOSTRUC TYPE /ISDFPS/SHPVSTOSTRUC,
      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: </ISDFPS/SHPVSTOSTRUC> TYPE /ISDFPS/SHPVSTOSTRUC.

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

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM /ISDFPS/SHPVSTOSTRUC
  INTO TABLE IT_/ISDFPS/SHPVSTOSTRUC.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /ISDFPS/SHPVSTOSTRUC
*  INTO TABLE @DATA(IT_/ISDFPS/SHPVSTOSTRUC2).
*--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_/ISDFPS/SHPVSTOSTRUC INDEX 1 INTO DATA(WA_/ISDFPS/SHPVSTOSTRUC2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/ISDFPS/SHPVSTOSTRUC ASSIGNING </ISDFPS/SHPVSTOSTRUC>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
</ISDFPS/SHPVSTOSTRUC>-EBELN = 1.
</ISDFPS/SHPVSTOSTRUC>-EBELP = 1.
</ISDFPS/SHPVSTOSTRUC>-EBEL_LOEKZ = 1.
</ISDFPS/SHPVSTOSTRUC>-PREQ_NO = 1.
</ISDFPS/SHPVSTOSTRUC>-PREQ_ITEM = 1.
ENDLOOP.

LOOP AT IT_/ISDFPS/SHPVSTOSTRUC INTO WA_/ISDFPS/SHPVSTOSTRUC.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/ISDFPS/SHPVSTOSTRUC-PLANNING_GUID, sy-vline,
WA_/ISDFPS/SHPVSTOSTRUC-DOC_MANUAL, sy-vline,
WA_/ISDFPS/SHPVSTOSTRUC-VBELN_INB, sy-vline,
WA_/ISDFPS/SHPVSTOSTRUC-POSNR_INB, sy-vline,
WA_/ISDFPS/SHPVSTOSTRUC-MANDT, sy-vline,
WA_/ISDFPS/SHPVSTOSTRUC-VBELN, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/ISDFPS/SHPVSTOSTRUC 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_/ISDFPS/SHPVSTOSTRUC 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_/ISDFPS/SHPVSTOSTRUC INTO WA_/ISDFPS/SHPVSTOSTRUC. *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 EBELN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/ISDFPS/SHPVSTOSTRUC-EBELN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/ISDFPS/SHPVSTOSTRUC-EBELN.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

*Conversion exit EXCRT, internal->external for field STCUR CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT' EXPORTING input = WA_/ISDFPS/SHPVSTOSTRUC-STCUR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/ISDFPS/SHPVSTOSTRUC-STCUR.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit ALPHA, internal->external for field AUTBESTNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/ISDFPS/SHPVSTOSTRUC-AUTBESTNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/ISDFPS/SHPVSTOSTRUC-AUTBESTNR.
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_/ISDFPS/SHPVSTOSTRUC_STR,
EBELN TYPE STRING,
EBELP TYPE STRING,
EBEL_LOEKZ TYPE STRING,
PREQ_NO TYPE STRING,
PREQ_ITEM TYPE STRING,
PLANNING_GUID TYPE STRING,
DOC_MANUAL TYPE STRING,
VBELN_INB TYPE STRING,
POSNR_INB TYPE STRING,
MANDT TYPE STRING,
VBELN TYPE STRING,
ERNAM TYPE STRING,
ERZET TYPE STRING,
ERDAT TYPE STRING,
BZIRK TYPE STRING,
VSTEL TYPE STRING,
VKORG TYPE STRING,
LFART TYPE STRING,
AUTLF TYPE STRING,
KZAZU TYPE STRING,
WADAT TYPE STRING,
LDDAT TYPE STRING,
TDDAT TYPE STRING,
LFDAT TYPE STRING,
KODAT TYPE STRING,
ABLAD TYPE STRING,
INCO1 TYPE STRING,
INCO2 TYPE STRING,
EXPKZ TYPE STRING,
ROUTE TYPE STRING,
FAKSK TYPE STRING,
LIFSK TYPE STRING,
VBTYP TYPE STRING,
KNFAK TYPE STRING,
TPQUA TYPE STRING,
TPGRP TYPE STRING,
LPRIO TYPE STRING,
VSBED TYPE STRING,
KUNNR TYPE STRING,
KUNAG TYPE STRING,
KDGRP TYPE STRING,
STZKL TYPE STRING,
STZZU TYPE STRING,
BTGEW TYPE STRING,
NTGEW TYPE STRING,
GEWEI TYPE STRING,
VOLUM TYPE STRING,
VOLEH TYPE STRING,
ANZPK TYPE STRING,
BEROT TYPE STRING,
LFUHR TYPE STRING,
GRULG TYPE STRING,
LSTEL TYPE STRING,
TRAGR TYPE STRING,
FKARV TYPE STRING,
FKDAT TYPE STRING,
PERFK TYPE STRING,
ROUTA TYPE STRING,
STAFO TYPE STRING,
KALSM TYPE STRING,
KNUMV TYPE STRING,
WAERK TYPE STRING,
VKBUR TYPE STRING,
VBEAK TYPE STRING,
ZUKRL TYPE STRING,
VERUR TYPE STRING,
COMMN TYPE STRING,
STWAE TYPE STRING,
STCUR TYPE STRING,
EXNUM TYPE STRING,
AEDAT TYPE STRING,
LGNUM TYPE STRING,
WADAT_IST TYPE STRING,
AULWE TYPE STRING,
LGTOR TYPE STRING,
BESTK TYPE STRING,
WBSTK TYPE STRING,
FKSTK TYPE STRING,
GBSTK TYPE STRING,
KOSTK TYPE STRING,
KOQUK TYPE STRING,
LVSTK TYPE STRING,
UVALS TYPE STRING,
UVVLS TYPE STRING,
UVFAS TYPE STRING,
UVALL TYPE STRING,
UVVLK TYPE STRING,
UVFAK TYPE STRING,
PKSTK TYPE STRING,
TRSTA TYPE STRING,
CMGST TYPE STRING,
PDSTK TYPE STRING,
PODAT TYPE STRING,
POTIM TYPE STRING,
MSR_ACTIVE TYPE STRING,
POSNR_OUTB TYPE STRING,
VGBEL TYPE STRING,
VTLSTATUS TYPE STRING,
VTLSTATUS_ICON TYPE STRING,
LOGSYSAUTK TYPE STRING,
AUTBESTNR TYPE STRING,
RECV_FORCE_OBJID TYPE STRING,
RECV_FORCE_ID TYPE STRING,
RECV_FORCE_CNT TYPE STRING,
RELOC_ID TYPE STRING,
RELOC_SEQ_ID TYPE STRING,END OF T_EKKO_STR. DATA: WA_/ISDFPS/SHPVSTOSTRUC_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_/ISDFPS/SHPVSTOSTRUC_STR-EBELN sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-EBELP sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-EBEL_LOEKZ sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-PREQ_NO sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-PREQ_ITEM sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-PLANNING_GUID sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-DOC_MANUAL sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-VBELN_INB sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-POSNR_INB sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-MANDT sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-VBELN sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-ERNAM sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-ERZET sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-ERDAT sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-BZIRK sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-VSTEL sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-VKORG sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-LFART sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-AUTLF sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-KZAZU sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-WADAT sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-LDDAT sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-TDDAT sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-LFDAT sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-KODAT sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-ABLAD sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-INCO1 sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-INCO2 sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-EXPKZ sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-ROUTE sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-FAKSK sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-LIFSK sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-VBTYP sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-KNFAK sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-TPQUA sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-TPGRP sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-LPRIO sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-VSBED sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-KUNNR sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-KUNAG sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-KDGRP sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-STZKL sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-STZZU sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-BTGEW sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-NTGEW sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-GEWEI sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-VOLUM sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-VOLEH sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-ANZPK sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-BEROT sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-LFUHR sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-GRULG sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-LSTEL sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-TRAGR sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-FKARV sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-FKDAT sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-PERFK sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-ROUTA sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-STAFO sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-KALSM sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-KNUMV sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-WAERK sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-VKBUR sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-VBEAK sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-ZUKRL sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-VERUR sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-COMMN sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-STWAE sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-STCUR sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-EXNUM sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-AEDAT sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-LGNUM sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-WADAT_IST sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-AULWE sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-LGTOR sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-BESTK sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-WBSTK sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-FKSTK sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-GBSTK sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-KOSTK sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-KOQUK sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-LVSTK sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-UVALS sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-UVVLS sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-UVFAS sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-UVALL sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-UVVLK sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-UVFAK sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-PKSTK sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-TRSTA sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-CMGST sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-PDSTK sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-PODAT sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-POTIM sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-MSR_ACTIVE sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-POSNR_OUTB sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-VGBEL sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-VTLSTATUS sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-VTLSTATUS_ICON sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-LOGSYSAUTK sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-AUTBESTNR sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-RECV_FORCE_OBJID sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-RECV_FORCE_ID sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-RECV_FORCE_CNT sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-RELOC_ID sy-vline
WA_/ISDFPS/SHPVSTOSTRUC_STR-RELOC_SEQ_ID sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.