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

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

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

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


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
</ACCGO/CAK_S_COMMODITY_ITEM>-TKONN = 1.
</ACCGO/CAK_S_COMMODITY_ITEM>-TPOSN = 1.
</ACCGO/CAK_S_COMMODITY_ITEM>-MATNR = 1.
</ACCGO/CAK_S_COMMODITY_ITEM>-MATNR_DESC = 1.
</ACCGO/CAK_S_COMMODITY_ITEM>-WERKS_NAME = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/ACCGO/CAK_S_COMMODITY_ITEM-WERKS_DESC, sy-vline,
  WA_/ACCGO/CAK_S_COMMODITY_ITEM-MENGE, sy-vline,
  WA_/ACCGO/CAK_S_COMMODITY_ITEM-MEINS, sy-vline,
  WA_/ACCGO/CAK_S_COMMODITY_ITEM-NUMBER_OF_VEHICLES, sy-vline,
  WA_/ACCGO/CAK_S_COMMODITY_ITEM-MODE_ID, sy-vline,
  WA_/ACCGO/CAK_S_COMMODITY_ITEM-MODE_DESC, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/ACCGO/CAK_S_COMMODITY_ITEM 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_/ACCGO/CAK_S_COMMODITY_ITEM 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_/ACCGO/CAK_S_COMMODITY_ITEM INTO WA_/ACCGO/CAK_S_COMMODITY_ITEM.


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

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

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

*Conversion exit GOVW1, internal->external for field GOV_WEIGHT
CALL FUNCTION 'CONVERSION_EXIT_GOVW1_OUTPUT'
  EXPORTING
    input =                      WA_/ACCGO/CAK_S_COMMODITY_ITEM-GOV_WEIGHT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/ACCGO/CAK_S_COMMODITY_ITEM-GOV_WEIGHT.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit ALPHA, internal->external for field TKONN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_/ACCGO/CAK_S_COMMODITY_ITEM-TKONN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/ACCGO/CAK_S_COMMODITY_ITEM-TKONN.
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_/ACCGO/CAK_S_COMMODITY_ITEM_STR, 
TKONN TYPE STRING,
TPOSN TYPE STRING,
MATNR TYPE STRING,
MATNR_DESC TYPE STRING,
WERKS_NAME TYPE STRING,
WERKS_DESC TYPE STRING,
MENGE TYPE STRING,
MEINS TYPE STRING,
NUMBER_OF_VEHICLES TYPE STRING,
MODE_ID TYPE STRING,
MODE_DESC TYPE STRING,
DATE_FROM TYPE STRING,
DATE_TO TYPE STRING,
VAL_POINT TYPE STRING,
VAL_POINT_DESC TYPE STRING,
PRICE_TYPE TYPE STRING,
PRICE_TYPE_DESC TYPE STRING,
PYMNT_TERMS TYPE STRING,
PYMNT_TERMS_DESC TYPE STRING,
PYMNT_DATE TYPE STRING,
SCHEDULE_GUID TYPE STRING,
SCHEDULE_ID TYPE STRING,
SCHEDULE_NAME TYPE STRING,
VERSION TYPE STRING,
VALIDITY_VERSION TYPE STRING,
TIMING TYPE STRING,
GOVERNING_TERM TYPE STRING,
GOV_TERM_DESC TYPE STRING,
GOV_WEIGHT TYPE STRING,
GOV_WEIGHT_DESC TYPE STRING,
GOV_ANALYSIS TYPE STRING,
GOV_ANALYSIS_DESC TYPE STRING,
AT_UNLOAD_LOC TYPE STRING,
OV_FLAG TYPE STRING,
PRICING_APPROACH TYPE STRING,
PR_APPROACH_DESC TYPE STRING,
CANC_QTY TYPE STRING,
CANC_QTY_UOM TYPE STRING,
UNDERFILL_QTY TYPE STRING,
PRICECHANGED TYPE STRING,
CANCPERFORMED TYPE STRING,
TOLRID TYPE STRING,
TOL_DESC TYPE STRING,
TOLR_TYP_ID TYPE STRING,
OPTION_T TYPE STRING,
DELIVERY_QTY TYPE STRING,
DELIVERY_QTY_UOM TYPE STRING,
SINGLE_OVERFILL TYPE STRING,
ITEMISCOMPLETED TYPE STRING,
QTOL_GUID TYPE STRING,
COMMODITYSUBACCOUNT TYPE STRING,
COMMODITYSUBACCOUNTNAME TYPE STRING,
COMMODITYSUBACCOUNT_MIRROR TYPE STRING,
COMMODITYSUBACCOUNTNAME_MIRROR TYPE STRING,
MNTNCONTRTOLERANCEITEMDETAIL TYPE STRING,
MNTNCONTROPTIONDETAIL TYPE STRING,
MNTNCONTROPTIONITEMDETAIL TYPE STRING,
MNTNDISCPREMQLTYSCHEDCHARSDET TYPE STRING,
MNTNCONTRACTITEMTOCREDIT TYPE STRING,
MNTNCONTRACTPRICELOT TYPE STRING,
MNTNCONTRPARTNERITEMDETAIL TYPE STRING,
MNTNCONTRACTITEMFREECHAR TYPE STRING,
MNTNCONTRRELATEDTRADESDET TYPE STRING,
TOL_TYP_DESC TYPE STRING,
BS_OPTN_DESC TYPE STRING,
IS_COMM_QTY_CHANGED TYPE STRING,
IS_EXP_QTY_CHANGED TYPE STRING,
IS_NO_VEHICLE_CHANGED TYPE STRING,
LOCATION_HIERARCHY TYPE STRING,
MNTNTRADINGCONTRACTITEMFEEDET TYPE STRING,
MNTNCONTRACTMANDFC TYPE STRING,
TKONN TYPE STRING,
TPOSN TYPE STRING,
MATNR_FC TYPE STRING,
PLANT_NAME_FC TYPE STRING,
ORDER_QTY_FC TYPE STRING,
ORDER_UNIT_FC TYPE STRING,
NO_OF_VEHICLE_FC TYPE STRING,
MODE_ID_FC TYPE STRING,
DATE_FROM_FC TYPE STRING,
DATE_TO_FC TYPE STRING,
VAL_POINT_FC TYPE STRING,
PRICE_TYPE_FC TYPE STRING,
PYMNT_TERMS_FC TYPE STRING,
PYMNT_DATE_FC TYPE STRING,
SCHEDULE_NAME_FC TYPE STRING,
VERSION_FC TYPE STRING,
VALIDITY_VERSION_FC TYPE STRING,
TIMING_FC TYPE STRING,
OV_FLAG_FC TYPE STRING,
GOVERNING_TERM_FC TYPE STRING,
GOV_WEIGHT_FC TYPE STRING,
GOV_ANALYSIS_FC TYPE STRING,
TOLRID_FC TYPE STRING,
TOLR_TYP_ID_FC TYPE STRING,
DELIVERY_QTY TYPE STRING,
SINGLE_OVERFILL_WC TYPE STRING,
SUBACCOUNT_WC TYPE STRING,
LOCATION_HIERARCHY_WC TYPE STRING,
AT_UNLOAD_FC TYPE STRING,
BUYER_SELLER_FC TYPE STRING,
MIRROR_SUBACCOUNT_FC TYPE STRING,
MNTNCONTRACTITEMCANCELLATION TYPE STRING,
CREDIT_SALE_IND TYPE STRING,
IS_CR_SALE_IND_EDITABLE TYPE STRING,
MNTNCONTRACTITEMTEXT TYPE STRING,
CONTRACT_TYPE TYPE STRING,
PURCHASE_ORG TYPE STRING,
SIDE TYPE STRING,
COUNTER_PARTY TYPE STRING,
MNTNCONTRACTITEMDUMMY TYPE STRING,
CONTRACTLOCHIERARCHY TYPE STRING,
CONTRACTLOCTIONIDSET TYPE STRING,
CONTRACTSTORAGEDATASET TYPE STRING,
MNTNCONTRACTPRICINGCONDITION TYPE STRING,
MNTNCONTRPREPAYREQ TYPE STRING,
THRESHOLD_PERCENTAGE TYPE STRING,
THRESHOLD_GUID TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/ACCGO/CAK_S_COMMODITY_ITEM_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_/ACCGO/CAK_S_COMMODITY_ITEM_STR-TKONN sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-TPOSN sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MATNR sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MATNR_DESC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-WERKS_NAME sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-WERKS_DESC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MENGE sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MEINS sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-NUMBER_OF_VEHICLES sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MODE_ID sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MODE_DESC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-DATE_FROM sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-DATE_TO sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-VAL_POINT sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-VAL_POINT_DESC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-PRICE_TYPE sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-PRICE_TYPE_DESC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-PYMNT_TERMS sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-PYMNT_TERMS_DESC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-PYMNT_DATE sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-SCHEDULE_GUID sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-SCHEDULE_ID sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-SCHEDULE_NAME sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-VERSION sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-VALIDITY_VERSION sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-TIMING sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-GOVERNING_TERM sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-GOV_TERM_DESC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-GOV_WEIGHT sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-GOV_WEIGHT_DESC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-GOV_ANALYSIS sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-GOV_ANALYSIS_DESC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-AT_UNLOAD_LOC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-OV_FLAG sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-PRICING_APPROACH sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-PR_APPROACH_DESC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-CANC_QTY sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-CANC_QTY_UOM sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-UNDERFILL_QTY sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-PRICECHANGED sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-CANCPERFORMED sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-TOLRID sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-TOL_DESC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-TOLR_TYP_ID sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-OPTION_T sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-DELIVERY_QTY sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-DELIVERY_QTY_UOM sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-SINGLE_OVERFILL sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-ITEMISCOMPLETED sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-QTOL_GUID sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-COMMODITYSUBACCOUNT sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-COMMODITYSUBACCOUNTNAME sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-COMMODITYSUBACCOUNT_MIRROR sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-COMMODITYSUBACCOUNTNAME_MIRROR sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MNTNCONTRTOLERANCEITEMDETAIL sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MNTNCONTROPTIONDETAIL sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MNTNCONTROPTIONITEMDETAIL sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MNTNDISCPREMQLTYSCHEDCHARSDET sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MNTNCONTRACTITEMTOCREDIT sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MNTNCONTRACTPRICELOT sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MNTNCONTRPARTNERITEMDETAIL sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MNTNCONTRACTITEMFREECHAR sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MNTNCONTRRELATEDTRADESDET sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-TOL_TYP_DESC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-BS_OPTN_DESC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-IS_COMM_QTY_CHANGED sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-IS_EXP_QTY_CHANGED sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-IS_NO_VEHICLE_CHANGED sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-LOCATION_HIERARCHY sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MNTNTRADINGCONTRACTITEMFEEDET sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MNTNCONTRACTMANDFC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-TKONN sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-TPOSN sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MATNR_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-PLANT_NAME_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-ORDER_QTY_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-ORDER_UNIT_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-NO_OF_VEHICLE_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MODE_ID_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-DATE_FROM_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-DATE_TO_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-VAL_POINT_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-PRICE_TYPE_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-PYMNT_TERMS_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-PYMNT_DATE_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-SCHEDULE_NAME_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-VERSION_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-VALIDITY_VERSION_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-TIMING_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-OV_FLAG_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-GOVERNING_TERM_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-GOV_WEIGHT_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-GOV_ANALYSIS_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-TOLRID_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-TOLR_TYP_ID_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-DELIVERY_QTY sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-SINGLE_OVERFILL_WC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-SUBACCOUNT_WC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-LOCATION_HIERARCHY_WC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-AT_UNLOAD_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-BUYER_SELLER_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MIRROR_SUBACCOUNT_FC sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MNTNCONTRACTITEMCANCELLATION sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-CREDIT_SALE_IND sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-IS_CR_SALE_IND_EDITABLE sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MNTNCONTRACTITEMTEXT sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-CONTRACT_TYPE sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-PURCHASE_ORG sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-SIDE sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-COUNTER_PARTY sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MNTNCONTRACTITEMDUMMY sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-CONTRACTLOCHIERARCHY sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-CONTRACTLOCTIONIDSET sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-CONTRACTSTORAGEDATASET sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MNTNCONTRACTPRICINGCONDITION sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-MNTNCONTRPREPAYREQ sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-THRESHOLD_PERCENTAGE sy-vline 
WA_/ACCGO/CAK_S_COMMODITY_ITEM_STR-THRESHOLD_GUID sy-vline      INTO ld_text SEPARATED BY SPACE.

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