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

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

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

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


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/SCWM/S_ESI_DB_LABEL ASSIGNING </SCWM/S_ESI_DB_LABEL>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
</SCWM/S_ESI_DB_LABEL>-HEADER_S = 1.
</SCWM/S_ESI_DB_LABEL>-CLIENT = 1.
</SCWM/S_ESI_DB_LABEL>-GUID_ESI = 1.
</SCWM/S_ESI_DB_LABEL>-DOCTYPE = 1.
</SCWM/S_ESI_DB_LABEL>-DOCID = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/SCWM/S_ESI_DB_LABEL-SOURCE, sy-vline,
  WA_/SCWM/S_ESI_DB_LABEL-TERMINAL, sy-vline,
  WA_/SCWM/S_ESI_DB_LABEL-CREATED_BY, sy-vline,
  WA_/SCWM/S_ESI_DB_LABEL-CREATED_AT, sy-vline,
  WA_/SCWM/S_ESI_DB_LABEL-CHANGED_BY, sy-vline,
  WA_/SCWM/S_ESI_DB_LABEL-CHANGED_AT, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/SCWM/S_ESI_DB_LABEL 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_/SCWM/S_ESI_DB_LABEL 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_/SCWM/S_ESI_DB_LABEL INTO WA_/SCWM/S_ESI_DB_LABEL.


*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 CUNIT, internal->external for field UNIT_WEIGHT
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_/SCWM/S_ESI_DB_LABEL-UNIT_WEIGHT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_ESI_DB_LABEL-UNIT_WEIGHT.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit CUNIT, internal->external for field UNIT_LWH
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_/SCWM/S_ESI_DB_LABEL-UNIT_LWH
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_ESI_DB_LABEL-UNIT_LWH.
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_/SCWM/S_ESI_DB_LABEL_STR, 
HEADER_S TYPE STRING,
CLIENT TYPE STRING,
GUID_ESI TYPE STRING,
DOCTYPE TYPE STRING,
DOCID TYPE STRING,
SOURCE TYPE STRING,
TERMINAL TYPE STRING,
CREATED_BY TYPE STRING,
CREATED_AT TYPE STRING,
CHANGED_BY TYPE STRING,
CHANGED_AT TYPE STRING,
CARRIER TYPE STRING,
SHIPACCT TYPE STRING,
TRACKN TYPE STRING,
SHIPID TYPE STRING,
PARCEL_N TYPE STRING,
PARCEL_OF_M TYPE STRING,
ROUTECODE TYPE STRING,
TOURCODE TYPE STRING,
HUB_DEP TYPE STRING,
HUB_DEST TYPE STRING,
HUB_ADD TYPE STRING,
ROUTESOURCE TYPE STRING,
DEST_CODE TYPE STRING,
SERVICECODE TYPE STRING,
PRODUCTCODE TYPE STRING,
COUNTER TYPE STRING,
BILLOPT TYPE STRING,
FREIGHT_TERM TYPE STRING,
PALOCOL TYPE STRING,
BULKIND TYPE STRING,
LETTER TYPE STRING,
LONGCODE TYPE STRING,
ADD_A TYPE STRING,
ADD_B TYPE STRING,
ADD_C TYPE STRING,
ADD05 TYPE STRING,
ADD10 TYPE STRING,
ADD20 TYPE STRING,
FIXED_DATE TYPE STRING,
EARLIESTDELTIME TYPE STRING,
SATDELV TYPE STRING,
POD_REQU TYPE STRING,
HOLDFPICKUP TYPE STRING,
CONFIDENTIAL TYPE STRING,
WEIGHT_ITEM TYPE STRING,
WEIGHT_SHIP TYPE STRING,
UNIT_WEIGHT TYPE STRING,
VOLUME_ITEM TYPE STRING,
VOLUME_SHIP TYPE STRING,
UNIT_VOLUME TYPE STRING,
LENGTH TYPE STRING,
WIDTH TYPE STRING,
HEIGHT TYPE STRING,
UNIT_LWH TYPE STRING,
DIMWEIGHT TYPE STRING,
FIRST_LABEL TYPE STRING,
PICKUP_DATE TYPE STRING,
PRINTED TYPE STRING,
MANIFEST TYPE STRING,
CANCELLED_MAN TYPE STRING,
HANDOVER_TRK TYPE STRING,
HANDOVER_PRINT TYPE STRING,
ESI_HDR_DUMMY TYPE STRING,
COD_DAT_EXIST TYPE STRING,
FOTRADE_EXIST TYPE STRING,
ADDTEXT_EXIST TYPE STRING,
HAZ_MAT_EXIST TYPE STRING,
RETURNS_EXIST TYPE STRING,
TRACKDT_EXIST TYPE STRING,
REF_T TYPE STRING,
PARTN_T TYPE STRING,
COD_S TYPE STRING,
CLIENT TYPE STRING,
GUID_ESI TYPE STRING,
CODAMOUNT TYPE STRING,
CODCURR TYPE STRING,
PAYMETHOD TYPE STRING,
CODPURPOSE TYPE STRING,
CODCONTROLL TYPE STRING,
ADDINSURANCE TYPE STRING,
INSAMOUNT TYPE STRING,
INSCURR TYPE STRING,
ESI_COD_DUMMY TYPE STRING,
DESCR_T TYPE STRING,
FOTRD_S TYPE STRING,
CLIENT TYPE STRING,
GUID_ESI TYPE STRING,
COUNTRYCD_A TYPE STRING,
WAYBILLNR TYPE STRING,
TRADEZONE TYPE STRING,
CONTA TYPE STRING,
CUSTOFFICE TYPE STRING,
CUSTOFFICEDEST TYPE STRING,
EXTYPE TYPE STRING,
EXPR5 TYPE STRING,
STATVALUE TYPE STRING,
STATVALCURR TYPE STRING,
COUNTRYOFORIGIN TYPE STRING,
REGIONOFORIGIN TYPE STRING,
STAWN TYPE STRING,
PREFERE TYPE STRING,
STXT1 TYPE STRING,
STXT2 TYPE STRING,
FTADD01 TYPE STRING,
FTADD02 TYPE STRING,
ESI_FOT_DUMMY TYPE STRING,
HAZMAT_S TYPE STRING,
CLIENT TYPE STRING,
GUID_ESI TYPE STRING,
REGULATIONSET TYPE STRING,
REPORTABLEQUANT TYPE STRING,
HAZARDCLASS TYPE STRING,
SUBRISKCLASS TYPE STRING,
HAZMATIDENTNR TYPE STRING,
ADRITEMNUMBER TYPE STRING,
PACKGROUPNR TYPE STRING,
ADRPACKGRPLETTER TYPE STRING,
QUANTITY TYPE STRING,
QUANUOM TYPE STRING,
PACKINSTR TYPE STRING,
HAZTRANSMODE TYPE STRING,
EMERGEPHONENR TYPE STRING,
HAZSHIPNAME TYPE STRING,
HAZTECNAME TYPE STRING,
HAZADDDESCR TYPE STRING,
HAZPACKTYPE TYPE STRING,
LABELSREQU TYPE STRING,
ESI_HAZ_DUMMY TYPE STRING,
RETURNS_S TYPE STRING,
CLIENT TYPE STRING,
GUID_ESI TYPE STRING,
RETURNSRVC TYPE STRING,
RETURNTRACKN TYPE STRING,
RETURNREFNR TYPE STRING,
RETURNREFTYPE TYPE STRING,
RETURNREFSRC TYPE STRING,
RETURNROUTECD TYPE STRING,
RETURNDEPOT_A TYPE STRING,
RETURNDEPOT_B TYPE STRING,
EXCHANGESRVC TYPE STRING,
EXCHANGETRACKN TYPE STRING,
EXCHANGESHIPID TYPE STRING,
ESI_RET_DUMMY TYPE STRING,
INDEX_T TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/SCWM/S_ESI_DB_LABEL_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_/SCWM/S_ESI_DB_LABEL_STR-HEADER_S sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-CLIENT sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-GUID_ESI sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-DOCTYPE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-DOCID sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-SOURCE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-TERMINAL sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-CREATED_BY sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-CREATED_AT sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-CHANGED_BY sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-CHANGED_AT sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-CARRIER sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-SHIPACCT sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-TRACKN sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-SHIPID sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-PARCEL_N sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-PARCEL_OF_M sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-ROUTECODE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-TOURCODE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-HUB_DEP sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-HUB_DEST sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-HUB_ADD sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-ROUTESOURCE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-DEST_CODE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-SERVICECODE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-PRODUCTCODE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-COUNTER sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-BILLOPT sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-FREIGHT_TERM sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-PALOCOL sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-BULKIND sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-LETTER sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-LONGCODE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-ADD_A sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-ADD_B sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-ADD_C sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-ADD05 sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-ADD10 sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-ADD20 sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-FIXED_DATE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-EARLIESTDELTIME sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-SATDELV sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-POD_REQU sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-HOLDFPICKUP sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-CONFIDENTIAL sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-WEIGHT_ITEM sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-WEIGHT_SHIP sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-UNIT_WEIGHT sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-VOLUME_ITEM sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-VOLUME_SHIP sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-UNIT_VOLUME sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-LENGTH sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-WIDTH sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-HEIGHT sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-UNIT_LWH sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-DIMWEIGHT sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-FIRST_LABEL sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-PICKUP_DATE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-PRINTED sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-MANIFEST sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-CANCELLED_MAN sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-HANDOVER_TRK sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-HANDOVER_PRINT sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-ESI_HDR_DUMMY sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-COD_DAT_EXIST sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-FOTRADE_EXIST sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-ADDTEXT_EXIST sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-HAZ_MAT_EXIST sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-RETURNS_EXIST sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-TRACKDT_EXIST sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-REF_T sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-PARTN_T sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-COD_S sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-CLIENT sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-GUID_ESI sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-CODAMOUNT sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-CODCURR sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-PAYMETHOD sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-CODPURPOSE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-CODCONTROLL sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-ADDINSURANCE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-INSAMOUNT sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-INSCURR sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-ESI_COD_DUMMY sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-DESCR_T sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-FOTRD_S sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-CLIENT sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-GUID_ESI sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-COUNTRYCD_A sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-WAYBILLNR sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-TRADEZONE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-CONTA sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-CUSTOFFICE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-CUSTOFFICEDEST sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-EXTYPE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-EXPR5 sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-STATVALUE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-STATVALCURR sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-COUNTRYOFORIGIN sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-REGIONOFORIGIN sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-STAWN sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-PREFERE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-STXT1 sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-STXT2 sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-FTADD01 sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-FTADD02 sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-ESI_FOT_DUMMY sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-HAZMAT_S sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-CLIENT sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-GUID_ESI sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-REGULATIONSET sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-REPORTABLEQUANT sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-HAZARDCLASS sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-SUBRISKCLASS sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-HAZMATIDENTNR sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-ADRITEMNUMBER sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-PACKGROUPNR sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-ADRPACKGRPLETTER sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-QUANTITY sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-QUANUOM sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-PACKINSTR sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-HAZTRANSMODE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-EMERGEPHONENR sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-HAZSHIPNAME sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-HAZTECNAME sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-HAZADDDESCR sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-HAZPACKTYPE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-LABELSREQU sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-ESI_HAZ_DUMMY sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-RETURNS_S sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-CLIENT sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-GUID_ESI sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-RETURNSRVC sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-RETURNTRACKN sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-RETURNREFNR sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-RETURNREFTYPE sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-RETURNREFSRC sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-RETURNROUTECD sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-RETURNDEPOT_A sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-RETURNDEPOT_B sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-EXCHANGESRVC sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-EXCHANGETRACKN sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-EXCHANGESHIPID sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-ESI_RET_DUMMY sy-vline 
WA_/SCWM/S_ESI_DB_LABEL_STR-INDEX_T sy-vline      INTO ld_text SEPARATED BY SPACE.

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