ABAP Select data from SAP table CEWMINBDELIVQ 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 CEWMINBDELIVQ 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 CEWMINBDELIVQ. 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 CEWMINBDELIVQ 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_CEWMINBDELIVQ TYPE STANDARD TABLE OF CEWMINBDELIVQ,
      WA_CEWMINBDELIVQ TYPE CEWMINBDELIVQ,
      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: <CEWMINBDELIVQ> TYPE CEWMINBDELIVQ.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CEWMINBDELIVQ
*  INTO TABLE @DATA(IT_CEWMINBDELIVQ2).
*--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_CEWMINBDELIVQ INDEX 1 INTO DATA(WA_CEWMINBDELIVQ2).


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

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

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CEWMINBDELIVQ-TIMEZONEID, sy-vline,
  WA_CEWMINBDELIVQ-RECEIVINGOFFICE, sy-vline,
  WA_CEWMINBDELIVQ-MEANSOFTRANSPORTTYPE, sy-vline,
  WA_CEWMINBDELIVQ-MEANSOFTRANSPORTTYPENAME, sy-vline,
  WA_CEWMINBDELIVQ-MEANSOFTRANSPORT, sy-vline,
  WA_CEWMINBDELIVQ-DELIVERYITEMCATEGORY, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_CEWMINBDELIVQ 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_CEWMINBDELIVQ 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_CEWMINBDELIVQ INTO WA_CEWMINBDELIVQ.


*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_CEWMINBDELIVQ-INBOUNDDELIVERY
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CEWMINBDELIVQ-INBOUNDDELIVERY.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field DISPLAYWEIGHTUNIT
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_CEWMINBDELIVQ-DISPLAYWEIGHTUNIT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CEWMINBDELIVQ-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_CEWMINBDELIVQ_STR, 
MANDT TYPE STRING,
WAREHOUSE TYPE STRING,
INBOUNDDELIVERY TYPE STRING,
INBOUNDDELIVERYITEM TYPE STRING,
WAREHOUSENAME TYPE STRING,
TIMEZONEID TYPE STRING,
RECEIVINGOFFICE TYPE STRING,
MEANSOFTRANSPORTTYPE TYPE STRING,
MEANSOFTRANSPORTTYPENAME TYPE STRING,
MEANSOFTRANSPORT TYPE STRING,
DELIVERYITEMCATEGORY TYPE STRING,
DELIVERYITEMCATEGORYNAME TYPE STRING,
DELIVERYDOCUMENTCATEGORY TYPE STRING,
INBOUNDDELIVERYDOCUMENTTYPE TYPE STRING,
INBDELIVERYDOCUMENTTYPENAME TYPE STRING,
INBOUNDDELIVERYITEMTYPE TYPE STRING,
INBOUNDDELIVERYITEMTYPENAME TYPE STRING,
WAREHOUSEPROCESSTYPE TYPE STRING,
WAREHOUSEPROCESSTYPENAME TYPE STRING,
WAREHOUSEDOOR TYPE STRING,
STAGINGAREAGROUP TYPE STRING,
STAGINGAREA TYPE STRING,
STAGINGBAY TYPE STRING,
GOODSMOVEMENTBIN TYPE STRING,
PRODUCT TYPE STRING,
PRODUCTNAME TYPE STRING,
BATCH TYPE STRING,
ENTITLEDTODISPOSEPARTY TYPE STRING,
NAMEOFENTITLEDTODISPOSEPARTY TYPE STRING,
SHIPFROMPARTY TYPE STRING,
SHIPFROMPARTYNAME TYPE STRING,
ISBUSINESSPURPOSECOMPLETED TYPE STRING,
CARRIER TYPE STRING,
CARRIERNAME 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,
COMPLETIONSTATUS TYPE STRING,
COMPLETIONSTATUSNAME TYPE STRING,
UNLOADINGSTATUS TYPE STRING,
UNLOADINGSTATUSNAME TYPE STRING,
PUTAWAYSTATUS TYPE STRING,
PUTAWAYSTATUSNAME TYPE STRING,
GOODSRECEIPTSTATUS TYPE STRING,
GOODSRECEIPTSTATUSNAME TYPE STRING,
QUALITYMGMTCOUNTPLNGSTATUS TYPE STRING,
QUALITYMGMTCOUNTPLNGSTATUSNAME TYPE STRING,
QUALITYMGMTINSPPLNGSTATUS TYPE STRING,
QUALITYMGMTINSPPLNGSTSNAME TYPE STRING,
QUALITYMGMTINSPECTIONSTATUS TYPE STRING,
QUALITYMGMTINSPECTIONSTSNAME TYPE STRING,
GOODSMOVEMENTBLOCKSTATUS TYPE STRING,
GOODSMOVEMENTBLOCKSTATUSNAME TYPE STRING,
CHECKTOLERANCESTATUS TYPE STRING,
CHECKTOLERANCESTATUSNAME TYPE STRING,
PLANNINGPUTAWAYSTATUS TYPE STRING,
PLANNINGPUTAWAYSTATUSNAME TYPE STRING,
TRANSPORTATIONUNITASSGMTSTATUS TYPE STRING,
TRANSPUNITASSGMTSTATUSNAME TYPE STRING,
VALUEADDEDSERVICEORDERSTATUS TYPE STRING,
VALUEADDEDDELIVSTSNAME TYPE STRING,
VALUATIONQTYASSIGNMENTSTATUS TYPE STRING,
VALUATIONQTYASSGMTSTATUSNAME TYPE STRING,
WAREHOUSEACTIVITYSTATUS TYPE STRING,
WAREHOUSEACTIVITYSTATUSNAME TYPE STRING,
TRANSITSTATUS TYPE STRING,
TRANSITSTATUSNAME TYPE STRING,
TRANSITPROCEDURESTATUS TYPE STRING,
TRANSITPROCEDURESTATUSNAME TYPE STRING,
TRANSPORTATIONPLANNINGSTATUS TYPE STRING,
TRANSPPLNGSTATUSNAME TYPE STRING,
OVERALLBLOCKSTATUS TYPE STRING,
OVERALLBLOCKSTATUSNAME TYPE STRING,
ITEMINCONSISTENCYBLKSTATUS TYPE STRING,
ITEMINCONSISTENCYBLKSTATUSNAME TYPE STRING,
TRANSPPLANBLOCKSTATUS TYPE STRING,
TRANSPPLANBLOCKSTATUSNAME TYPE STRING,
INBDELIVITEMCRTNUTCDATETIME TYPE STRING,
PLANNEDGRSTARTUTCDATETIME TYPE STRING,
PLANNEDGRENDUTCDATETIME TYPE STRING,
UNLOADINGENDUTCDATETIME TYPE STRING,
ACTUALPUTAWAYENDUTCDATETIME TYPE STRING,
ACTUALGRSTARTUTCDATETIME TYPE STRING,
ACTUALGRENDUTCDATETIME TYPE STRING,
INBDELIVCOMPLTNENDUTCDATETIME TYPE STRING,
PLNDARRIVALINYARDUTCDATETIME TYPE STRING,
ACTUALARRIVALINYARDUTCDATETIME TYPE STRING,
PLNDDELIVERYWHSETMZNDATETIME TYPE STRING,
ACTUALDELIVERYWHSETMZNDATETIME TYPE STRING,
PLNDARRVLINYARDWHSETMZNDTETME TYPE STRING,
ACTLARRVLINYARDWHSETMZNDTETME TYPE STRING,
PUTAWAYENDWHSETMZNDATETIME TYPE STRING,
ACTUALGRENDWHSETMZNDATETIME TYPE STRING,
UNLOADINGENDWHSETMZNDATETIME TYPE STRING,
INBDELIVITMCMPLTWHSETMZNDTETME TYPE STRING,
INBDELIVCRTNWHSETMZNDATETIME TYPE STRING,
PLNDGRENDWHSETMZNDATETIME TYPE STRING,
GOODSRECEIPTDURATIONINMINUTES TYPE STRING,
WAITINYARDDURATIONINMINUTES TYPE STRING,
ARRIVALINYARDOVRDDURNINMINUTES TYPE STRING,
NOWHSEACTIVITYTIMEINMINUTES TYPE STRING,
PLNDGOODSRECEIPTWHSETMZNYEAR TYPE STRING,
PLNDGOODSRECEIPTWHSETMZNMONTH TYPE STRING,
PLNDGOODSRECEIPTWHSETMZNDATE TYPE STRING,
PLNDGOODSRECEIPTWHSETMZNHOUR TYPE STRING,
PLNDGOODSRECEIPTWHSETMZNTIME TYPE STRING,
UNLOADINGENDWHSETMZNYEAR TYPE STRING,
UNLOADINGENDWHSETMZNMONTH TYPE STRING,
UNLOADINGENDWHSETMZNDATE TYPE STRING,
UNLOADINGENDWHSETMZNHOUR TYPE STRING,
UNLOADINGENDWHSETMZNTIME 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,
PLANNEDDELIVERYWHSETMZNYEAR TYPE STRING,
PLANNEDDELIVERYWHSETMZNMONTH TYPE STRING,
PLANNEDDELIVERYWHSETMZNDATE TYPE STRING,
PLANNEDDELIVERYWHSETMZNHOUR TYPE STRING,
PLANNEDDELIVERYWHSETMZNTIME TYPE STRING,
ACTUALDELIVERYWHSETMZNYEAR TYPE STRING,
ACTUALDELIVERYWHSETMZNMONTH TYPE STRING,
ACTUALDELIVERYWHSETMZNDATE TYPE STRING,
ACTUALDELIVERYWHSETMZNHOUR TYPE STRING,
ACTUALDELIVERYWHSETMZNTIME TYPE STRING,
PLNDARRVLINYARDWHSETMZNYEAR TYPE STRING,
PLNDARRVLINYARDWHSETMZNMONTH TYPE STRING,
PLNDARRVLINYARDWHSETMZNDATE TYPE STRING,
PLNDARRVLINYARDWHSETMZNHOUR TYPE STRING,
PLNDARRVLINYARDWHSETMZNTIME TYPE STRING,
ACTLARRVLINYARDWHSETMZNYEAR TYPE STRING,
ACTLARRVLINYARDWHSETMZNMONTH TYPE STRING,
ACTLARRVLINYARDWHSETMZNDATE TYPE STRING,
ACTLARRVLINYARDWHSETMZNHOUR TYPE STRING,
ACTLARRVLINYARDWHSETMZNTIME TYPE STRING,
PLNDDELIVTO30MINSWHSEDTETME TYPE STRING,
PLNDDELIVTO60MINSWHSEDTETME TYPE STRING,
PLNDARRVLTO30MINSWHSEDTETME TYPE STRING,
PLNDARRVLTO60MINSWHSEDTETME TYPE STRING,
ACTLDELIVTO30MINSWHSEDTETME TYPE STRING,
ACTLDELIVTO60MINSWHSEDTETME TYPE STRING,
ACTLARRVLTO30MINSWHSEDTETME TYPE STRING,
ACTLARRVLTO60MINSWHSEDTETME TYPE STRING,
COMPLTNENDTO30MINSWHSEDTETME TYPE STRING,
COMPLTNENDTO60MINSWHSEDTETME TYPE STRING,
GRENDRNDDTO30MINSWHSEDTETME TYPE STRING,
GRENDRNDDTO60MINSWHSEDTETME TYPE STRING,
PTWYENDRNDDTO30MINSWHSEDTETME TYPE STRING,
PTWYENDRNDDTO60MINSWHSEDTETME TYPE STRING,
UNLDGENDRNDDTO30MINSWHSEDTETME TYPE STRING,
UNLDGENDRNDDTO60MINSWHSEDTETME TYPE STRING,
NUMBEROFINBOUNDDELIVERIES TYPE STRING,
NUMBEROFINBDELIVITEMS TYPE STRING,END OF T_EKKO_STR.
DATA: WA_CEWMINBDELIVQ_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_CEWMINBDELIVQ_STR-MANDT sy-vline 
WA_CEWMINBDELIVQ_STR-WAREHOUSE sy-vline 
WA_CEWMINBDELIVQ_STR-INBOUNDDELIVERY sy-vline 
WA_CEWMINBDELIVQ_STR-INBOUNDDELIVERYITEM sy-vline 
WA_CEWMINBDELIVQ_STR-WAREHOUSENAME sy-vline 
WA_CEWMINBDELIVQ_STR-TIMEZONEID sy-vline 
WA_CEWMINBDELIVQ_STR-RECEIVINGOFFICE sy-vline 
WA_CEWMINBDELIVQ_STR-MEANSOFTRANSPORTTYPE sy-vline 
WA_CEWMINBDELIVQ_STR-MEANSOFTRANSPORTTYPENAME sy-vline 
WA_CEWMINBDELIVQ_STR-MEANSOFTRANSPORT sy-vline 
WA_CEWMINBDELIVQ_STR-DELIVERYITEMCATEGORY sy-vline 
WA_CEWMINBDELIVQ_STR-DELIVERYITEMCATEGORYNAME sy-vline 
WA_CEWMINBDELIVQ_STR-DELIVERYDOCUMENTCATEGORY sy-vline 
WA_CEWMINBDELIVQ_STR-INBOUNDDELIVERYDOCUMENTTYPE sy-vline 
WA_CEWMINBDELIVQ_STR-INBDELIVERYDOCUMENTTYPENAME sy-vline 
WA_CEWMINBDELIVQ_STR-INBOUNDDELIVERYITEMTYPE sy-vline 
WA_CEWMINBDELIVQ_STR-INBOUNDDELIVERYITEMTYPENAME sy-vline 
WA_CEWMINBDELIVQ_STR-WAREHOUSEPROCESSTYPE sy-vline 
WA_CEWMINBDELIVQ_STR-WAREHOUSEPROCESSTYPENAME sy-vline 
WA_CEWMINBDELIVQ_STR-WAREHOUSEDOOR sy-vline 
WA_CEWMINBDELIVQ_STR-STAGINGAREAGROUP sy-vline 
WA_CEWMINBDELIVQ_STR-STAGINGAREA sy-vline 
WA_CEWMINBDELIVQ_STR-STAGINGBAY sy-vline 
WA_CEWMINBDELIVQ_STR-GOODSMOVEMENTBIN sy-vline 
WA_CEWMINBDELIVQ_STR-PRODUCT sy-vline 
WA_CEWMINBDELIVQ_STR-PRODUCTNAME sy-vline 
WA_CEWMINBDELIVQ_STR-BATCH sy-vline 
WA_CEWMINBDELIVQ_STR-ENTITLEDTODISPOSEPARTY sy-vline 
WA_CEWMINBDELIVQ_STR-NAMEOFENTITLEDTODISPOSEPARTY sy-vline 
WA_CEWMINBDELIVQ_STR-SHIPFROMPARTY sy-vline 
WA_CEWMINBDELIVQ_STR-SHIPFROMPARTYNAME sy-vline 
WA_CEWMINBDELIVQ_STR-ISBUSINESSPURPOSECOMPLETED sy-vline 
WA_CEWMINBDELIVQ_STR-CARRIER sy-vline 
WA_CEWMINBDELIVQ_STR-CARRIERNAME sy-vline 
WA_CEWMINBDELIVQ_STR-STOCKOWNER sy-vline 
WA_CEWMINBDELIVQ_STR-STOCKOWNERNAME sy-vline 
WA_CEWMINBDELIVQ_STR-STOCKTYPE sy-vline 
WA_CEWMINBDELIVQ_STR-STOCKTYPENAME sy-vline 
WA_CEWMINBDELIVQ_STR-PRODUCTQUANTITY sy-vline 
WA_CEWMINBDELIVQ_STR-QUANTITYUNIT sy-vline 
WA_CEWMINBDELIVQ_STR-ITEMVOLUME sy-vline 
WA_CEWMINBDELIVQ_STR-DISPLAYVOLUMEUNIT sy-vline 
WA_CEWMINBDELIVQ_STR-ITEMNETWEIGHT sy-vline 
WA_CEWMINBDELIVQ_STR-ITEMGROSSWEIGHT sy-vline 
WA_CEWMINBDELIVQ_STR-DISPLAYWEIGHTUNIT sy-vline 
WA_CEWMINBDELIVQ_STR-COMPLETIONSTATUS sy-vline 
WA_CEWMINBDELIVQ_STR-COMPLETIONSTATUSNAME sy-vline 
WA_CEWMINBDELIVQ_STR-UNLOADINGSTATUS sy-vline 
WA_CEWMINBDELIVQ_STR-UNLOADINGSTATUSNAME sy-vline 
WA_CEWMINBDELIVQ_STR-PUTAWAYSTATUS sy-vline 
WA_CEWMINBDELIVQ_STR-PUTAWAYSTATUSNAME sy-vline 
WA_CEWMINBDELIVQ_STR-GOODSRECEIPTSTATUS sy-vline 
WA_CEWMINBDELIVQ_STR-GOODSRECEIPTSTATUSNAME sy-vline 
WA_CEWMINBDELIVQ_STR-QUALITYMGMTCOUNTPLNGSTATUS sy-vline 
WA_CEWMINBDELIVQ_STR-QUALITYMGMTCOUNTPLNGSTATUSNAME sy-vline 
WA_CEWMINBDELIVQ_STR-QUALITYMGMTINSPPLNGSTATUS sy-vline 
WA_CEWMINBDELIVQ_STR-QUALITYMGMTINSPPLNGSTSNAME sy-vline 
WA_CEWMINBDELIVQ_STR-QUALITYMGMTINSPECTIONSTATUS sy-vline 
WA_CEWMINBDELIVQ_STR-QUALITYMGMTINSPECTIONSTSNAME sy-vline 
WA_CEWMINBDELIVQ_STR-GOODSMOVEMENTBLOCKSTATUS sy-vline 
WA_CEWMINBDELIVQ_STR-GOODSMOVEMENTBLOCKSTATUSNAME sy-vline 
WA_CEWMINBDELIVQ_STR-CHECKTOLERANCESTATUS sy-vline 
WA_CEWMINBDELIVQ_STR-CHECKTOLERANCESTATUSNAME sy-vline 
WA_CEWMINBDELIVQ_STR-PLANNINGPUTAWAYSTATUS sy-vline 
WA_CEWMINBDELIVQ_STR-PLANNINGPUTAWAYSTATUSNAME sy-vline 
WA_CEWMINBDELIVQ_STR-TRANSPORTATIONUNITASSGMTSTATUS sy-vline 
WA_CEWMINBDELIVQ_STR-TRANSPUNITASSGMTSTATUSNAME sy-vline 
WA_CEWMINBDELIVQ_STR-VALUEADDEDSERVICEORDERSTATUS sy-vline 
WA_CEWMINBDELIVQ_STR-VALUEADDEDDELIVSTSNAME sy-vline 
WA_CEWMINBDELIVQ_STR-VALUATIONQTYASSIGNMENTSTATUS sy-vline 
WA_CEWMINBDELIVQ_STR-VALUATIONQTYASSGMTSTATUSNAME sy-vline 
WA_CEWMINBDELIVQ_STR-WAREHOUSEACTIVITYSTATUS sy-vline 
WA_CEWMINBDELIVQ_STR-WAREHOUSEACTIVITYSTATUSNAME sy-vline 
WA_CEWMINBDELIVQ_STR-TRANSITSTATUS sy-vline 
WA_CEWMINBDELIVQ_STR-TRANSITSTATUSNAME sy-vline 
WA_CEWMINBDELIVQ_STR-TRANSITPROCEDURESTATUS sy-vline 
WA_CEWMINBDELIVQ_STR-TRANSITPROCEDURESTATUSNAME sy-vline 
WA_CEWMINBDELIVQ_STR-TRANSPORTATIONPLANNINGSTATUS sy-vline 
WA_CEWMINBDELIVQ_STR-TRANSPPLNGSTATUSNAME sy-vline 
WA_CEWMINBDELIVQ_STR-OVERALLBLOCKSTATUS sy-vline 
WA_CEWMINBDELIVQ_STR-OVERALLBLOCKSTATUSNAME sy-vline 
WA_CEWMINBDELIVQ_STR-ITEMINCONSISTENCYBLKSTATUS sy-vline 
WA_CEWMINBDELIVQ_STR-ITEMINCONSISTENCYBLKSTATUSNAME sy-vline 
WA_CEWMINBDELIVQ_STR-TRANSPPLANBLOCKSTATUS sy-vline 
WA_CEWMINBDELIVQ_STR-TRANSPPLANBLOCKSTATUSNAME sy-vline 
WA_CEWMINBDELIVQ_STR-INBDELIVITEMCRTNUTCDATETIME sy-vline 
WA_CEWMINBDELIVQ_STR-PLANNEDGRSTARTUTCDATETIME sy-vline 
WA_CEWMINBDELIVQ_STR-PLANNEDGRENDUTCDATETIME sy-vline 
WA_CEWMINBDELIVQ_STR-UNLOADINGENDUTCDATETIME sy-vline 
WA_CEWMINBDELIVQ_STR-ACTUALPUTAWAYENDUTCDATETIME sy-vline 
WA_CEWMINBDELIVQ_STR-ACTUALGRSTARTUTCDATETIME sy-vline 
WA_CEWMINBDELIVQ_STR-ACTUALGRENDUTCDATETIME sy-vline 
WA_CEWMINBDELIVQ_STR-INBDELIVCOMPLTNENDUTCDATETIME sy-vline 
WA_CEWMINBDELIVQ_STR-PLNDARRIVALINYARDUTCDATETIME sy-vline 
WA_CEWMINBDELIVQ_STR-ACTUALARRIVALINYARDUTCDATETIME sy-vline 
WA_CEWMINBDELIVQ_STR-PLNDDELIVERYWHSETMZNDATETIME sy-vline 
WA_CEWMINBDELIVQ_STR-ACTUALDELIVERYWHSETMZNDATETIME sy-vline 
WA_CEWMINBDELIVQ_STR-PLNDARRVLINYARDWHSETMZNDTETME sy-vline 
WA_CEWMINBDELIVQ_STR-ACTLARRVLINYARDWHSETMZNDTETME sy-vline 
WA_CEWMINBDELIVQ_STR-PUTAWAYENDWHSETMZNDATETIME sy-vline 
WA_CEWMINBDELIVQ_STR-ACTUALGRENDWHSETMZNDATETIME sy-vline 
WA_CEWMINBDELIVQ_STR-UNLOADINGENDWHSETMZNDATETIME sy-vline 
WA_CEWMINBDELIVQ_STR-INBDELIVITMCMPLTWHSETMZNDTETME sy-vline 
WA_CEWMINBDELIVQ_STR-INBDELIVCRTNWHSETMZNDATETIME sy-vline 
WA_CEWMINBDELIVQ_STR-PLNDGRENDWHSETMZNDATETIME sy-vline 
WA_CEWMINBDELIVQ_STR-GOODSRECEIPTDURATIONINMINUTES sy-vline 
WA_CEWMINBDELIVQ_STR-WAITINYARDDURATIONINMINUTES sy-vline 
WA_CEWMINBDELIVQ_STR-ARRIVALINYARDOVRDDURNINMINUTES sy-vline 
WA_CEWMINBDELIVQ_STR-NOWHSEACTIVITYTIMEINMINUTES sy-vline 
WA_CEWMINBDELIVQ_STR-PLNDGOODSRECEIPTWHSETMZNYEAR sy-vline 
WA_CEWMINBDELIVQ_STR-PLNDGOODSRECEIPTWHSETMZNMONTH sy-vline 
WA_CEWMINBDELIVQ_STR-PLNDGOODSRECEIPTWHSETMZNDATE sy-vline 
WA_CEWMINBDELIVQ_STR-PLNDGOODSRECEIPTWHSETMZNHOUR sy-vline 
WA_CEWMINBDELIVQ_STR-PLNDGOODSRECEIPTWHSETMZNTIME sy-vline 
WA_CEWMINBDELIVQ_STR-UNLOADINGENDWHSETMZNYEAR sy-vline 
WA_CEWMINBDELIVQ_STR-UNLOADINGENDWHSETMZNMONTH sy-vline 
WA_CEWMINBDELIVQ_STR-UNLOADINGENDWHSETMZNDATE sy-vline 
WA_CEWMINBDELIVQ_STR-UNLOADINGENDWHSETMZNHOUR sy-vline 
WA_CEWMINBDELIVQ_STR-UNLOADINGENDWHSETMZNTIME sy-vline 
WA_CEWMINBDELIVQ_STR-PUTAWAYENDWHSETMZNYEAR sy-vline 
WA_CEWMINBDELIVQ_STR-PUTAWAYENDWHSETMZNMONTH sy-vline 
WA_CEWMINBDELIVQ_STR-PUTAWAYENDWHSETMZNDATE sy-vline 
WA_CEWMINBDELIVQ_STR-PUTAWAYENDWHSETMZNHOUR sy-vline 
WA_CEWMINBDELIVQ_STR-PUTAWAYENDWHSETMZNTIME sy-vline 
WA_CEWMINBDELIVQ_STR-GOODSRECEIPTENDWHSETMZNYEAR sy-vline 
WA_CEWMINBDELIVQ_STR-GOODSRECEIPTENDWHSETMZNMONTH sy-vline 
WA_CEWMINBDELIVQ_STR-GOODSRECEIPTENDWHSETMZNDATE sy-vline 
WA_CEWMINBDELIVQ_STR-GOODSRECEIPTENDWHSETMZNHOUR sy-vline 
WA_CEWMINBDELIVQ_STR-GOODSRECEIPTENDWHSETMZNTIME sy-vline 
WA_CEWMINBDELIVQ_STR-INBDELIVCOMPLTNENDWHSETMZNYEAR sy-vline 
WA_CEWMINBDELIVQ_STR-INBDELIVCOMPLTNENDWHSETMZNMNTH sy-vline 
WA_CEWMINBDELIVQ_STR-INBDELIVCOMPLTNENDWHSETMZNDATE sy-vline 
WA_CEWMINBDELIVQ_STR-INBDELIVCOMPLTNENDWHSETMZNHOUR sy-vline 
WA_CEWMINBDELIVQ_STR-INBDELIVCOMPLTNENDWHSETMZNTIME sy-vline 
WA_CEWMINBDELIVQ_STR-PLANNEDDELIVERYWHSETMZNYEAR sy-vline 
WA_CEWMINBDELIVQ_STR-PLANNEDDELIVERYWHSETMZNMONTH sy-vline 
WA_CEWMINBDELIVQ_STR-PLANNEDDELIVERYWHSETMZNDATE sy-vline 
WA_CEWMINBDELIVQ_STR-PLANNEDDELIVERYWHSETMZNHOUR sy-vline 
WA_CEWMINBDELIVQ_STR-PLANNEDDELIVERYWHSETMZNTIME sy-vline 
WA_CEWMINBDELIVQ_STR-ACTUALDELIVERYWHSETMZNYEAR sy-vline 
WA_CEWMINBDELIVQ_STR-ACTUALDELIVERYWHSETMZNMONTH sy-vline 
WA_CEWMINBDELIVQ_STR-ACTUALDELIVERYWHSETMZNDATE sy-vline 
WA_CEWMINBDELIVQ_STR-ACTUALDELIVERYWHSETMZNHOUR sy-vline 
WA_CEWMINBDELIVQ_STR-ACTUALDELIVERYWHSETMZNTIME sy-vline 
WA_CEWMINBDELIVQ_STR-PLNDARRVLINYARDWHSETMZNYEAR sy-vline 
WA_CEWMINBDELIVQ_STR-PLNDARRVLINYARDWHSETMZNMONTH sy-vline 
WA_CEWMINBDELIVQ_STR-PLNDARRVLINYARDWHSETMZNDATE sy-vline 
WA_CEWMINBDELIVQ_STR-PLNDARRVLINYARDWHSETMZNHOUR sy-vline 
WA_CEWMINBDELIVQ_STR-PLNDARRVLINYARDWHSETMZNTIME sy-vline 
WA_CEWMINBDELIVQ_STR-ACTLARRVLINYARDWHSETMZNYEAR sy-vline 
WA_CEWMINBDELIVQ_STR-ACTLARRVLINYARDWHSETMZNMONTH sy-vline 
WA_CEWMINBDELIVQ_STR-ACTLARRVLINYARDWHSETMZNDATE sy-vline 
WA_CEWMINBDELIVQ_STR-ACTLARRVLINYARDWHSETMZNHOUR sy-vline 
WA_CEWMINBDELIVQ_STR-ACTLARRVLINYARDWHSETMZNTIME sy-vline 
WA_CEWMINBDELIVQ_STR-PLNDDELIVTO30MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVQ_STR-PLNDDELIVTO60MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVQ_STR-PLNDARRVLTO30MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVQ_STR-PLNDARRVLTO60MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVQ_STR-ACTLDELIVTO30MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVQ_STR-ACTLDELIVTO60MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVQ_STR-ACTLARRVLTO30MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVQ_STR-ACTLARRVLTO60MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVQ_STR-COMPLTNENDTO30MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVQ_STR-COMPLTNENDTO60MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVQ_STR-GRENDRNDDTO30MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVQ_STR-GRENDRNDDTO60MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVQ_STR-PTWYENDRNDDTO30MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVQ_STR-PTWYENDRNDDTO60MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVQ_STR-UNLDGENDRNDDTO30MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVQ_STR-UNLDGENDRNDDTO60MINSWHSEDTETME sy-vline 
WA_CEWMINBDELIVQ_STR-NUMBEROFINBOUNDDELIVERIES sy-vline 
WA_CEWMINBDELIVQ_STR-NUMBEROFINBDELIVITEMS sy-vline      INTO ld_text SEPARATED BY SPACE.

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