ABAP Select data from SAP table SHP_ES_OUTBDELIVREQBYELEM_QRY 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 SHP_ES_OUTBDELIVREQBYELEM_QRY 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 SHP_ES_OUTBDELIVREQBYELEM_QRY. 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 SHP_ES_OUTBDELIVREQBYELEM_QRY 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_SHP_ES_OUTBDELIVREQBYELEM_QRY TYPE STANDARD TABLE OF SHP_ES_OUTBDELIVREQBYELEM_QRY,
      WA_SHP_ES_OUTBDELIVREQBYELEM_QRY TYPE SHP_ES_OUTBDELIVREQBYELEM_QRY,
      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: <SHP_ES_OUTBDELIVREQBYELEM_QRY> TYPE SHP_ES_OUTBDELIVREQBYELEM_QRY.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM SHP_ES_OUTBDELIVREQBYELEM_QRY
*  INTO TABLE @DATA(IT_SHP_ES_OUTBDELIVREQBYELEM_QRY2).
*--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_SHP_ES_OUTBDELIVREQBYELEM_QRY INDEX 1 INTO DATA(WA_SHP_ES_OUTBDELIVREQBYELEM_QRY2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_SHP_ES_OUTBDELIVREQBYELEM_QRY ASSIGNING <SHP_ES_OUTBDELIVREQBYELEM_QRY>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<SHP_ES_OUTBDELIVREQBYELEM_QRY>-SCENARIO = 1.
<SHP_ES_OUTBDELIVREQBYELEM_QRY>-LIST_PROFILE = 1.
<SHP_ES_OUTBDELIVREQBYELEM_QRY>-SELECT_OPTIONS = 1.
<SHP_ES_OUTBDELIVREQBYELEM_QRY>-SEL_CRIT_IGNORE_ITEM = 1.
<SHP_ES_OUTBDELIVREQBYELEM_QRY>-MATNR = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_SHP_ES_OUTBDELIVREQBYELEM_QRY-DEL, sy-vline,
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY-BYPASSING_BUFFER, sy-vline,
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY-FILTER_BY_ENQUE, sy-vline,
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY-PREDECESSOR_ENQ, sy-vline,
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY-DATA, sy-vline,
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY-ALL, sy-vline.
ENDLOOP. *Add any further fields from structure WA_SHP_ES_OUTBDELIVREQBYELEM_QRY 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_SHP_ES_OUTBDELIVREQBYELEM_QRY 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_SHP_ES_OUTBDELIVREQBYELEM_QRY INTO WA_SHP_ES_OUTBDELIVREQBYELEM_QRY. *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 PARVW, internal->external for field PARVW CALL FUNCTION 'CONVERSION_EXIT_PARVW_OUTPUT' EXPORTING input = WA_SHP_ES_OUTBDELIVREQBYELEM_QRY-PARVW IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SHP_ES_OUTBDELIVREQBYELEM_QRY-PARVW.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit ALPHA, internal->external for field LAST_VBELN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_SHP_ES_OUTBDELIVREQBYELEM_QRY-LAST_VBELN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SHP_ES_OUTBDELIVREQBYELEM_QRY-LAST_VBELN.
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_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR,
SCENARIO TYPE STRING,
LIST_PROFILE TYPE STRING,
SELECT_OPTIONS TYPE STRING,
SEL_CRIT_IGNORE_ITEM TYPE STRING,
MATNR TYPE STRING,
DEL TYPE STRING,
BYPASSING_BUFFER TYPE STRING,
FILTER_BY_ENQUE TYPE STRING,
PREDECESSOR_ENQ TYPE STRING,
DATA TYPE STRING,
ALL TYPE STRING,
HEAD_STATUS TYPE STRING,
HEAD_PARTNER TYPE STRING,
ITEM TYPE STRING,
ITEM_STATUS TYPE STRING,
DOC_FLOW TYPE STRING,
INCOMPLETE TYPE STRING,
REF_DATA TYPE STRING,
ADD_DATA_ORD TYPE STRING,
HEAD_STATUS_EX TYPE STRING,
HEAD_PARTNER_EX TYPE STRING,
ITEM_EX TYPE STRING,
ITEM_STATUS_EX TYPE STRING,
DOC_FLOW_EX TYPE STRING,
INCOMPLETE_EX TYPE STRING,
REF_DATA_EX TYPE STRING,
ADD_DATA_ORD_EX TYPE STRING,
DELIVERY_KEYS TYPE STRING,
ABLAD TYPE STRING,
ABTNR TYPE STRING,
AUFNR TYPE STRING,
AULWE TYPE STRING,
BLDAT TYPE STRING,
CHARG TYPE STRING,
CMFRE TYPE STRING,
CMGST TYPE STRING,
CMNGV TYPE STRING,
CTLPC TYPE STRING,
EAN11 TYPE STRING,
ERDAT TYPE STRING,
ERNAM TYPE STRING,
FKSTK TYPE STRING,
GBSTK TYPE STRING,
GRUPP TYPE STRING,
KDMAT TYPE STRING,
KKBER TYPE STRING,
KNKLI TYPE STRING,
KODAT TYPE STRING,
KOQUK TYPE STRING,
KOSTK TYPE STRING,
KUNNR TYPE STRING,
KUNN2 TYPE STRING,
KUNWE TYPE STRING,
LDDAT TYPE STRING,
LFART TYPE STRING,
LFDAT TYPE STRING,
LGNUM TYPE STRING,
LGORT TYPE STRING,
LGTOR TYPE STRING,
LIFEX TYPE STRING,
LIFSK TYPE STRING,
LPRIO TYPE STRING,
LSTEL TYPE STRING,
LVSTK TYPE STRING,
MATKL TYPE STRING,
MATNR TYPE STRING,
PARNR TYPE STRING,
PARVW TYPE STRING,
PERNR TYPE STRING,
PKSTK TYPE STRING,
PRVBE TYPE STRING,
ROUTE TYPE STRING,
SAMMG TYPE STRING,
SBGRP TYPE STRING,
SPART TYPE STRING,
SPDNR TYPE STRING,
TDDAT TYPE STRING,
TKNUM TYPE STRING,
TRAID TYPE STRING,
TRSTA TYPE STRING,
VBELN TYPE STRING,
VKBUR TYPE STRING,
VKGRP TYPE STRING,
VKORG TYPE STRING,
VSBED TYPE STRING,
VSTEL TYPE STRING,
VTWEG TYPE STRING,
WADAT TYPE STRING,
WADAT_IST TYPE STRING,
WAKTI TYPE STRING,
WAUHR TYPE STRING,
WERKS TYPE STRING,
WBSTK TYPE STRING,
XBLNR TYPE STRING,
BESTK TYPE STRING,
VGBEL TYPE STRING,
VGPOS TYPE STRING,
VGSYS TYPE STRING,
VBTYP TYPE STRING,
VLSTK TYPE STRING,
SPE_ATP_TMSTMP TYPE STRING,
SPE_REL_TMSTMP TYPE STRING,
SPE_PSTYV TYPE STRING,
ABLAD TYPE STRING,
ABTNR TYPE STRING,
AUART TYPE STRING,
AULWE TYPE STRING,
AUTLF TYPE STRING,
EBELN TYPE STRING,
G_RTE TYPE STRING,
KDMAT TYPE STRING,
KUNNR TYPE STRING,
KUNN2 TYPE STRING,
KUNWE TYPE STRING,
LEDAT TYPE STRING,
LGORT TYPE STRING,
LIFSP TYPE STRING,
LPRIO TYPE STRING,
MATKL TYPE STRING,
MATNR TYPE STRING,
PARNR TYPE STRING,
PERNR TYPE STRING,
RESWK TYPE STRING,
ROUTE TYPE STRING,
SPART TYPE STRING,
SPDNR TYPE STRING,
VBELN TYPE STRING,
VKBUR TYPE STRING,
VKGRP TYPE STRING,
VKORG TYPE STRING,
VSBED TYPE STRING,
VSTEL TYPE STRING,
VTWEG TYPE STRING,
WADAT TYPE STRING,
WAKTI TYPE STRING,
WAUHR TYPE STRING,
WBSTK TYPE STRING,
WERKS TYPE STRING,
RELOC_ID TYPE STRING,
RELOC_SEQ_ID TYPE STRING,
TM_CTRL_KEY TYPE STRING,
EPA_PNAME TYPE STRING,
ABRVW TYPE STRING,
BORGR_GRP TYPE STRING,
JIT TYPE STRING,
PRODN TYPE STRING,
VETYP TYPE STRING,
VEHID TYPE STRING,
SSPEZ TYPE STRING,
GRPIN TYPE STRING,
GRIND TYPE STRING,
PKSTK TYPE STRING,
RFM_PSST_GROUP TYPE STRING,
PARAMETERS TYPE STRING,
VSTEL TYPE STRING,
PARVW TYPE STRING,
AUFNR TYPE STRING,
DGFIX TYPE STRING,
COMPL TYPE STRING,
OTHER_PARTNERS TYPE STRING,
NO_ADDRESSES TYPE STRING,
NO_TEXTS TYPE STRING,
COUNT_HITS_ONLY TYPE STRING,
LANGU TYPE STRING,
HITS TYPE STRING,
COUNT TYPE STRING,
MORE TYPE STRING,
LAST_VBELN TYPE STRING,END OF T_EKKO_STR. DATA: WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_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_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-SCENARIO sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-LIST_PROFILE sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-SELECT_OPTIONS sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-SEL_CRIT_IGNORE_ITEM sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-MATNR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-DEL sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-BYPASSING_BUFFER sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-FILTER_BY_ENQUE sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-PREDECESSOR_ENQ sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-DATA sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-ALL sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-HEAD_STATUS sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-HEAD_PARTNER sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-ITEM sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-ITEM_STATUS sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-DOC_FLOW sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-INCOMPLETE sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-REF_DATA sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-ADD_DATA_ORD sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-HEAD_STATUS_EX sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-HEAD_PARTNER_EX sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-ITEM_EX sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-ITEM_STATUS_EX sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-DOC_FLOW_EX sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-INCOMPLETE_EX sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-REF_DATA_EX sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-ADD_DATA_ORD_EX sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-DELIVERY_KEYS sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-ABLAD sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-ABTNR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-AUFNR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-AULWE sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-BLDAT sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-CHARG sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-CMFRE sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-CMGST sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-CMNGV sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-CTLPC sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-EAN11 sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-ERDAT sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-ERNAM sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-FKSTK sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-GBSTK sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-GRUPP sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-KDMAT sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-KKBER sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-KNKLI sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-KODAT sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-KOQUK sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-KOSTK sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-KUNNR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-KUNN2 sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-KUNWE sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-LDDAT sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-LFART sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-LFDAT sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-LGNUM sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-LGORT sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-LGTOR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-LIFEX sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-LIFSK sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-LPRIO sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-LSTEL sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-LVSTK sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-MATKL sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-MATNR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-PARNR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-PARVW sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-PERNR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-PKSTK sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-PRVBE sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-ROUTE sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-SAMMG sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-SBGRP sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-SPART sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-SPDNR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-TDDAT sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-TKNUM sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-TRAID sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-TRSTA sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VBELN sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VKBUR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VKGRP sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VKORG sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VSBED sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VSTEL sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VTWEG sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-WADAT sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-WADAT_IST sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-WAKTI sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-WAUHR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-WERKS sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-WBSTK sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-XBLNR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-BESTK sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VGBEL sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VGPOS sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VGSYS sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VBTYP sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VLSTK sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-SPE_ATP_TMSTMP sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-SPE_REL_TMSTMP sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-SPE_PSTYV sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-ABLAD sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-ABTNR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-AUART sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-AULWE sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-AUTLF sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-EBELN sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-G_RTE sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-KDMAT sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-KUNNR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-KUNN2 sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-KUNWE sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-LEDAT sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-LGORT sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-LIFSP sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-LPRIO sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-MATKL sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-MATNR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-PARNR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-PERNR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-RESWK sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-ROUTE sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-SPART sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-SPDNR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VBELN sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VKBUR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VKGRP sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VKORG sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VSBED sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VSTEL sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VTWEG sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-WADAT sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-WAKTI sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-WAUHR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-WBSTK sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-WERKS sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-RELOC_ID sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-RELOC_SEQ_ID sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-TM_CTRL_KEY sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-EPA_PNAME sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-ABRVW sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-BORGR_GRP sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-JIT sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-PRODN sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VETYP sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VEHID sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-SSPEZ sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-GRPIN sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-GRIND sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-PKSTK sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-RFM_PSST_GROUP sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-PARAMETERS sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-VSTEL sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-PARVW sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-AUFNR sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-DGFIX sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-COMPL sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-OTHER_PARTNERS sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-NO_ADDRESSES sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-NO_TEXTS sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-COUNT_HITS_ONLY sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-LANGU sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-HITS sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-COUNT sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-MORE sy-vline
WA_SHP_ES_OUTBDELIVREQBYELEM_QRY_STR-LAST_VBELN sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.