ABAP Select data from SAP table CEWMINBDELIVLQ 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 CEWMINBDELIVLQ 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 CEWMINBDELIVLQ. 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 CEWMINBDELIVLQ 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_CEWMINBDELIVLQ TYPE STANDARD TABLE OF CEWMINBDELIVLQ,
      WA_CEWMINBDELIVLQ TYPE CEWMINBDELIVLQ,
      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: <CEWMINBDELIVLQ> TYPE CEWMINBDELIVLQ.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CEWMINBDELIVLQ
*  INTO TABLE @DATA(IT_CEWMINBDELIVLQ2).
*--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_CEWMINBDELIVLQ INDEX 1 INTO DATA(WA_CEWMINBDELIVLQ2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_CEWMINBDELIVLQ ASSIGNING <CEWMINBDELIVLQ>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
<CEWMINBDELIVLQ>-MANDT = 1.
<CEWMINBDELIVLQ>-WAREHOUSE = 1.
<CEWMINBDELIVLQ>-INBOUNDDELIVERY = 1.
<CEWMINBDELIVLQ>-INBOUNDDELIVERYITEM = 1.
<CEWMINBDELIVLQ>-WAREHOUSENAME = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CEWMINBDELIVLQ-TIMEZONEID, sy-vline,
  WA_CEWMINBDELIVLQ-DELIVERYDOCUMENTCATEGORY, sy-vline,
  WA_CEWMINBDELIVLQ-DELIVERYITEMCATEGORY, sy-vline,
  WA_CEWMINBDELIVLQ-DELIVERYITEMCATEGORYNAME, sy-vline,
  WA_CEWMINBDELIVLQ-INBOUNDDELIVERYDOCUMENTTYPE, sy-vline,
  WA_CEWMINBDELIVLQ-INBDELIVERYDOCUMENTTYPENAME, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_CEWMINBDELIVLQ 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_CEWMINBDELIVLQ 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_CEWMINBDELIVLQ INTO WA_CEWMINBDELIVLQ.


*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 INBOUNDDELIVERY
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_CEWMINBDELIVLQ-INBOUNDDELIVERY
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CEWMINBDELIVLQ-INBOUNDDELIVERY.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit BPMAP, internal->external for field STOCKOWNER
CALL FUNCTION 'CONVERSION_EXIT_BPMAP_OUTPUT'
  EXPORTING
    input =                      WA_CEWMINBDELIVLQ-STOCKOWNER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CEWMINBDELIVLQ-STOCKOWNER.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit CUNIT, internal->external for field DISPLAYWEIGHTUNIT
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_CEWMINBDELIVLQ-DISPLAYWEIGHTUNIT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CEWMINBDELIVLQ-DISPLAYWEIGHTUNIT.
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_CEWMINBDELIVLQ_STR, 
MANDT TYPE STRING,
WAREHOUSE TYPE STRING,
INBOUNDDELIVERY TYPE STRING,
INBOUNDDELIVERYITEM TYPE STRING,
WAREHOUSENAME TYPE STRING,
TIMEZONEID TYPE STRING,
DELIVERYDOCUMENTCATEGORY TYPE STRING,
DELIVERYITEMCATEGORY TYPE STRING,
DELIVERYITEMCATEGORYNAME TYPE STRING,
INBOUNDDELIVERYDOCUMENTTYPE TYPE STRING,
INBDELIVERYDOCUMENTTYPENAME TYPE STRING,
INBOUNDDELIVERYITEMTYPE TYPE STRING,
INBOUNDDELIVERYITEMTYPENAME TYPE STRING,
WAREHOUSEPROCESSTYPE TYPE STRING,
WAREHOUSEPROCESSTYPENAME TYPE STRING,
PRODUCT TYPE STRING,
PRODUCTNAME TYPE STRING,
BATCH TYPE STRING,
ENTITLEDTODISPOSEPARTY TYPE STRING,
NAMEOFENTITLEDTODISPOSEPARTY TYPE STRING,
SHIPFROMPARTY TYPE STRING,
SHIPFROMPARTYNAME TYPE STRING,
STOCKOWNER TYPE STRING,
STOCKOWNERNAME TYPE STRING,
STOCKTYPE TYPE STRING,
STOCKTYPENAME TYPE STRING,
PRODUCTQUANTITY TYPE STRING,
QUANTITYUNIT TYPE STRING,
ITEMVOLUME TYPE STRING,
DISPLAYVOLUMEUNIT TYPE STRING,
ITEMNETWEIGHT TYPE STRING,
ITEMGROSSWEIGHT TYPE STRING,
DISPLAYWEIGHTUNIT TYPE STRING,
OVERALLBLOCKSTATUS TYPE STRING,
OVERALLBLOCKSTATUSNAME TYPE STRING,
ITEMINCONSISTENCYBLKSTATUS TYPE STRING,
ITEMINCONSISTENCYBLKSTATUSNAME TYPE STRING,
COMPLETIONSTATUS TYPE STRING,
COMPLETIONSTATUSNAME TYPE STRING,
PLANNINGPUTAWAYSTATUS TYPE STRING,
PLANNINGPUTAWAYSTATUSNAME TYPE STRING,
GOODSRECEIPTSTATUS TYPE STRING,
GOODSRECEIPTSTATUSNAME TYPE STRING,
PUTAWAYSTATUS TYPE STRING,
PUTAWAYSTATUSNAME TYPE STRING,
QUALITYMGMTCOUNTPLNGSTATUS TYPE STRING,
QUALITYMGMTCOUNTPLNGSTATUSNAME TYPE STRING,
QUALITYMGMTINSPPLNGSTATUS TYPE STRING,
QUALITYMGMTINSPPLNGSTSNAME TYPE STRING,
CHECKTOLERANCESTATUS TYPE STRING,
CHECKTOLERANCESTATUSNAME TYPE STRING,
VALUATIONQTYASSIGNMENTSTATUS TYPE STRING,
VALUATIONQTYASSGMTSTATUSNAME TYPE STRING,
WAREHOUSEACTIVITYSTATUS TYPE STRING,
WAREHOUSEACTIVITYSTATUSNAME TYPE STRING,
INBDELIVITEMCRTNUTCDATETIME TYPE STRING,
ACTUALGRSTARTUTCDATETIME TYPE STRING,
PLANNEDGRSTARTUTCDATETIME TYPE STRING,
PLANNEDGRENDUTCDATETIME TYPE STRING,
ACTUALPUTAWAYENDUTCDATETIME TYPE STRING,
ACTUALGRENDUTCDATETIME TYPE STRING,
NOWHSEACTIVITYTIMEINMINUTES TYPE STRING,
GOODSRECEIPTDURATIONINMINUTES TYPE STRING,
PLNDDELIVERYWHSETMZNDATETIME TYPE STRING,
PLNDGRENDWHSETMZNDATETIME TYPE STRING,
PUTAWAYENDWHSETMZNDATETIME TYPE STRING,
ACTUALGRENDWHSETMZNDATETIME TYPE STRING,
INBDELIVITMCMPLTWHSETMZNDTETME TYPE STRING,
PLANNEDDELIVERYWHSETMZNYEAR TYPE STRING,
PLANNEDDELIVERYWHSETMZNMONTH TYPE STRING,
PLANNEDDELIVERYWHSETMZNDATE TYPE STRING,
PLANNEDDELIVERYWHSETMZNHOUR TYPE STRING,
PLANNEDDELIVERYWHSETMZNTIME TYPE STRING,
PLNDGOODSRECEIPTWHSETMZNYEAR TYPE STRING,
PLNDGOODSRECEIPTWHSETMZNMONTH TYPE STRING,
PLNDGOODSRECEIPTWHSETMZNDATE TYPE STRING,
PLNDGOODSRECEIPTWHSETMZNHOUR TYPE STRING,
PLNDGOODSRECEIPTWHSETMZNTIME TYPE STRING,
PUTAWAYENDWHSETMZNYEAR TYPE STRING,
PUTAWAYENDWHSETMZNMONTH TYPE STRING,
PUTAWAYENDWHSETMZNDATE TYPE STRING,
PUTAWAYENDWHSETMZNHOUR TYPE STRING,
PUTAWAYENDWHSETMZNTIME TYPE STRING,
GOODSRECEIPTENDWHSETMZNYEAR TYPE STRING,
GOODSRECEIPTENDWHSETMZNMONTH TYPE STRING,
GOODSRECEIPTENDWHSETMZNDATE TYPE STRING,
GOODSRECEIPTENDWHSETMZNHOUR TYPE STRING,
GOODSRECEIPTENDWHSETMZNTIME TYPE STRING,
INBDELIVCOMPLTNENDWHSETMZNYEAR TYPE STRING,
INBDELIVCOMPLTNENDWHSETMZNMNTH TYPE STRING,
INBDELIVCOMPLTNENDWHSETMZNDATE TYPE STRING,
INBDELIVCOMPLTNENDWHSETMZNHOUR TYPE STRING,
INBDELIVCOMPLTNENDWHSETMZNTIME TYPE STRING,
PLNDDELIVTO30MINSWHSEDTETME TYPE STRING,
PLNDDELIVTO60MINSWHSEDTETME TYPE STRING,
COMPLTNENDTO30MINSWHSEDTETME TYPE STRING,
COMPLTNENDTO60MINSWHSEDTETME TYPE STRING,
GRENDRNDDTO30MINSWHSEDTETME TYPE STRING,
GRENDRNDDTO60MINSWHSEDTETME TYPE STRING,
PTWYENDRNDDTO30MINSWHSEDTETME TYPE STRING,
PTWYENDRNDDTO60MINSWHSEDTETME TYPE STRING,
NUMBEROFINBOUNDDELIVERIES TYPE STRING,
NUMBEROFINBDELIVITEMS TYPE STRING,
EWMPLNDGRWHSETMZNHOUR TYPE STRING,
EWMQUANTITYHASADJUSTMENT TYPE STRING,
EWMPLNDGRDATEISINPAST TYPE STRING,
EWMACTUALGRDATEISONTIME TYPE STRING,
EWMPLNDGOODSRECEIPTDATEISTODAY TYPE STRING,
EWMACTUALPUTAWAYDATEISTODAY TYPE STRING,
EWMPLNDORACTGRISTODAY TYPE STRING,
EWMPLNDDELIVERYTIMEISINPAST TYPE STRING,
EWMACTGRISBEFOREPLNDDELIVTIME TYPE STRING,
EWMPLNDDELIVERYDATEISTODAY TYPE STRING,
EWMPLNDDELIVERYWHSETMZNHOUR TYPE STRING,END OF T_EKKO_STR.
DATA: WA_CEWMINBDELIVLQ_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_CEWMINBDELIVLQ_STR-MANDT sy-vline 
WA_CEWMINBDELIVLQ_STR-WAREHOUSE sy-vline 
WA_CEWMINBDELIVLQ_STR-INBOUNDDELIVERY sy-vline 
WA_CEWMINBDELIVLQ_STR-INBOUNDDELIVERYITEM sy-vline 
WA_CEWMINBDELIVLQ_STR-WAREHOUSENAME sy-vline 
WA_CEWMINBDELIVLQ_STR-TIMEZONEID sy-vline 
WA_CEWMINBDELIVLQ_STR-DELIVERYDOCUMENTCATEGORY sy-vline 
WA_CEWMINBDELIVLQ_STR-DELIVERYITEMCATEGORY sy-vline 
WA_CEWMINBDELIVLQ_STR-DELIVERYITEMCATEGORYNAME sy-vline 
WA_CEWMINBDELIVLQ_STR-INBOUNDDELIVERYDOCUMENTTYPE sy-vline 
WA_CEWMINBDELIVLQ_STR-INBDELIVERYDOCUMENTTYPENAME sy-vline 
WA_CEWMINBDELIVLQ_STR-INBOUNDDELIVERYITEMTYPE sy-vline 
WA_CEWMINBDELIVLQ_STR-INBOUNDDELIVERYITEMTYPENAME sy-vline 
WA_CEWMINBDELIVLQ_STR-WAREHOUSEPROCESSTYPE sy-vline 
WA_CEWMINBDELIVLQ_STR-WAREHOUSEPROCESSTYPENAME sy-vline 
WA_CEWMINBDELIVLQ_STR-PRODUCT sy-vline 
WA_CEWMINBDELIVLQ_STR-PRODUCTNAME sy-vline 
WA_CEWMINBDELIVLQ_STR-BATCH sy-vline 
WA_CEWMINBDELIVLQ_STR-ENTITLEDTODISPOSEPARTY sy-vline 
WA_CEWMINBDELIVLQ_STR-NAMEOFENTITLEDTODISPOSEPARTY sy-vline 
WA_CEWMINBDELIVLQ_STR-SHIPFROMPARTY sy-vline 
WA_CEWMINBDELIVLQ_STR-SHIPFROMPARTYNAME sy-vline 
WA_CEWMINBDELIVLQ_STR-STOCKOWNER sy-vline 
WA_CEWMINBDELIVLQ_STR-STOCKOWNERNAME sy-vline 
WA_CEWMINBDELIVLQ_STR-STOCKTYPE sy-vline 
WA_CEWMINBDELIVLQ_STR-STOCKTYPENAME sy-vline 
WA_CEWMINBDELIVLQ_STR-PRODUCTQUANTITY sy-vline 
WA_CEWMINBDELIVLQ_STR-QUANTITYUNIT sy-vline 
WA_CEWMINBDELIVLQ_STR-ITEMVOLUME sy-vline 
WA_CEWMINBDELIVLQ_STR-DISPLAYVOLUMEUNIT sy-vline 
WA_CEWMINBDELIVLQ_STR-ITEMNETWEIGHT sy-vline 
WA_CEWMINBDELIVLQ_STR-ITEMGROSSWEIGHT sy-vline 
WA_CEWMINBDELIVLQ_STR-DISPLAYWEIGHTUNIT sy-vline 
WA_CEWMINBDELIVLQ_STR-OVERALLBLOCKSTATUS sy-vline 
WA_CEWMINBDELIVLQ_STR-OVERALLBLOCKSTATUSNAME sy-vline 
WA_CEWMINBDELIVLQ_STR-ITEMINCONSISTENCYBLKSTATUS sy-vline 
WA_CEWMINBDELIVLQ_STR-ITEMINCONSISTENCYBLKSTATUSNAME sy-vline 
WA_CEWMINBDELIVLQ_STR-COMPLETIONSTATUS sy-vline 
WA_CEWMINBDELIVLQ_STR-COMPLETIONSTATUSNAME sy-vline 
WA_CEWMINBDELIVLQ_STR-PLANNINGPUTAWAYSTATUS sy-vline 
WA_CEWMINBDELIVLQ_STR-PLANNINGPUTAWAYSTATUSNAME sy-vline 
WA_CEWMINBDELIVLQ_STR-GOODSRECEIPTSTATUS sy-vline 
WA_CEWMINBDELIVLQ_STR-GOODSRECEIPTSTATUSNAME sy-vline 
WA_CEWMINBDELIVLQ_STR-PUTAWAYSTATUS sy-vline 
WA_CEWMINBDELIVLQ_STR-PUTAWAYSTATUSNAME sy-vline 
WA_CEWMINBDELIVLQ_STR-QUALITYMGMTCOUNTPLNGSTATUS sy-vline 
WA_CEWMINBDELIVLQ_STR-QUALITYMGMTCOUNTPLNGSTATUSNAME sy-vline 
WA_CEWMINBDELIVLQ_STR-QUALITYMGMTINSPPLNGSTATUS sy-vline 
WA_CEWMINBDELIVLQ_STR-QUALITYMGMTINSPPLNGSTSNAME sy-vline 
WA_CEWMINBDELIVLQ_STR-CHECKTOLERANCESTATUS sy-vline 
WA_CEWMINBDELIVLQ_STR-CHECKTOLERANCESTATUSNAME sy-vline 
WA_CEWMINBDELIVLQ_STR-VALUATIONQTYASSIGNMENTSTATUS sy-vline 
WA_CEWMINBDELIVLQ_STR-VALUATIONQTYASSGMTSTATUSNAME sy-vline 
WA_CEWMINBDELIVLQ_STR-WAREHOUSEACTIVITYSTATUS sy-vline 
WA_CEWMINBDELIVLQ_STR-WAREHOUSEACTIVITYSTATUSNAME sy-vline 
WA_CEWMINBDELIVLQ_STR-INBDELIVITEMCRTNUTCDATETIME sy-vline 
WA_CEWMINBDELIVLQ_STR-ACTUALGRSTARTUTCDATETIME sy-vline 
WA_CEWMINBDELIVLQ_STR-PLANNEDGRSTARTUTCDATETIME sy-vline 
WA_CEWMINBDELIVLQ_STR-PLANNEDGRENDUTCDATETIME sy-vline 
WA_CEWMINBDELIVLQ_STR-ACTUALPUTAWAYENDUTCDATETIME sy-vline 
WA_CEWMINBDELIVLQ_STR-ACTUALGRENDUTCDATETIME sy-vline 
WA_CEWMINBDELIVLQ_STR-NOWHSEACTIVITYTIMEINMINUTES sy-vline 
WA_CEWMINBDELIVLQ_STR-GOODSRECEIPTDURATIONINMINUTES sy-vline 
WA_CEWMINBDELIVLQ_STR-PLNDDELIVERYWHSETMZNDATETIME sy-vline 
WA_CEWMINBDELIVLQ_STR-PLNDGRENDWHSETMZNDATETIME sy-vline 
WA_CEWMINBDELIVLQ_STR-PUTAWAYENDWHSETMZNDATETIME sy-vline 
WA_CEWMINBDELIVLQ_STR-ACTUALGRENDWHSETMZNDATETIME sy-vline 
WA_CEWMINBDELIVLQ_STR-INBDELIVITMCMPLTWHSETMZNDTETME sy-vline 
WA_CEWMINBDELIVLQ_STR-PLANNEDDELIVERYWHSETMZNYEAR sy-vline 
WA_CEWMINBDELIVLQ_STR-PLANNEDDELIVERYWHSETMZNMONTH sy-vline 
WA_CEWMINBDELIVLQ_STR-PLANNEDDELIVERYWHSETMZNDATE sy-vline 
WA_CEWMINBDELIVLQ_STR-PLANNEDDELIVERYWHSETMZNHOUR sy-vline 
WA_CEWMINBDELIVLQ_STR-PLANNEDDELIVERYWHSETMZNTIME sy-vline 
WA_CEWMINBDELIVLQ_STR-PLNDGOODSRECEIPTWHSETMZNYEAR sy-vline 
WA_CEWMINBDELIVLQ_STR-PLNDGOODSRECEIPTWHSETMZNMONTH sy-vline 
WA_CEWMINBDELIVLQ_STR-PLNDGOODSRECEIPTWHSETMZNDATE sy-vline 
WA_CEWMINBDELIVLQ_STR-PLNDGOODSRECEIPTWHSETMZNHOUR sy-vline 
WA_CEWMINBDELIVLQ_STR-PLNDGOODSRECEIPTWHSETMZNTIME sy-vline 
WA_CEWMINBDELIVLQ_STR-PUTAWAYENDWHSETMZNYEAR sy-vline 
WA_CEWMINBDELIVLQ_STR-PUTAWAYENDWHSETMZNMONTH sy-vline 
WA_CEWMINBDELIVLQ_STR-PUTAWAYENDWHSETMZNDATE sy-vline 
WA_CEWMINBDELIVLQ_STR-PUTAWAYENDWHSETMZNHOUR sy-vline 
WA_CEWMINBDELIVLQ_STR-PUTAWAYENDWHSETMZNTIME sy-vline 
WA_CEWMINBDELIVLQ_STR-GOODSRECEIPTENDWHSETMZNYEAR sy-vline 
WA_CEWMINBDELIVLQ_STR-GOODSRECEIPTENDWHSETMZNMONTH sy-vline 
WA_CEWMINBDELIVLQ_STR-GOODSRECEIPTENDWHSETMZNDATE sy-vline 
WA_CEWMINBDELIVLQ_STR-GOODSRECEIPTENDWHSETMZNHOUR sy-vline 
WA_CEWMINBDELIVLQ_STR-GOODSRECEIPTENDWHSETMZNTIME sy-vline 
WA_CEWMINBDELIVLQ_STR-INBDELIVCOMPLTNENDWHSETMZNYEAR sy-vline 
WA_CEWMINBDELIVLQ_STR-INBDELIVCOMPLTNENDWHSETMZNMNTH sy-vline 
WA_CEWMINBDELIVLQ_STR-INBDELIVCOMPLTNENDWHSETMZNDATE sy-vline 
WA_CEWMINBDELIVLQ_STR-INBDELIVCOMPLTNENDWHSETMZNHOUR sy-vline 
WA_CEWMINBDELIVLQ_STR-INBDELIVCOMPLTNENDWHSETMZNTIME sy-vline 
WA_CEWMINBDELIVLQ_STR-PLNDDELIVTO30MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVLQ_STR-PLNDDELIVTO60MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVLQ_STR-COMPLTNENDTO30MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVLQ_STR-COMPLTNENDTO60MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVLQ_STR-GRENDRNDDTO30MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVLQ_STR-GRENDRNDDTO60MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVLQ_STR-PTWYENDRNDDTO30MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVLQ_STR-PTWYENDRNDDTO60MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVLQ_STR-NUMBEROFINBOUNDDELIVERIES sy-vline 
WA_CEWMINBDELIVLQ_STR-NUMBEROFINBDELIVITEMS sy-vline 
WA_CEWMINBDELIVLQ_STR-EWMPLNDGRWHSETMZNHOUR sy-vline 
WA_CEWMINBDELIVLQ_STR-EWMQUANTITYHASADJUSTMENT sy-vline 
WA_CEWMINBDELIVLQ_STR-EWMPLNDGRDATEISINPAST sy-vline 
WA_CEWMINBDELIVLQ_STR-EWMACTUALGRDATEISONTIME sy-vline 
WA_CEWMINBDELIVLQ_STR-EWMPLNDGOODSRECEIPTDATEISTODAY sy-vline 
WA_CEWMINBDELIVLQ_STR-EWMACTUALPUTAWAYDATEISTODAY sy-vline 
WA_CEWMINBDELIVLQ_STR-EWMPLNDORACTGRISTODAY sy-vline 
WA_CEWMINBDELIVLQ_STR-EWMPLNDDELIVERYTIMEISINPAST sy-vline 
WA_CEWMINBDELIVLQ_STR-EWMACTGRISBEFOREPLNDDELIVTIME sy-vline 
WA_CEWMINBDELIVLQ_STR-EWMPLNDDELIVERYDATEISTODAY sy-vline 
WA_CEWMINBDELIVLQ_STR-EWMPLNDDELIVERYWHSETMZNHOUR sy-vline      INTO ld_text SEPARATED BY SPACE.

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