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

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

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

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


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
</ACCGO/UIS_S_EVNT_CNG_API>-EVENT_ID = 1.
</ACCGO/UIS_S_EVNT_CNG_API>-UISID = 1.
</ACCGO/UIS_S_EVNT_CNG_API>-EVENT_KEY = 1.
</ACCGO/UIS_S_EVNT_CNG_API>-EVENT_TYPE = 1.
</ACCGO/UIS_S_EVNT_CNG_API>-PURCHASE_ORG = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/ACCGO/UIS_S_EVNT_CNG_API-SPECIFIC_MATNR, sy-vline,
  WA_/ACCGO/UIS_S_EVNT_CNG_API-MATERIAL, sy-vline,
  WA_/ACCGO/UIS_S_EVNT_CNG_API-TRACE_ID, sy-vline,
  WA_/ACCGO/UIS_S_EVNT_CNG_API-TICKET, sy-vline,
  WA_/ACCGO/UIS_S_EVNT_CNG_API-TICKET_RC, sy-vline,
  WA_/ACCGO/UIS_S_EVNT_CNG_API-EXT_IDENTIFIER, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/ACCGO/UIS_S_EVNT_CNG_API 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/UIS_S_EVNT_CNG_API 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/UIS_S_EVNT_CNG_API INTO WA_/ACCGO/UIS_S_EVNT_CNG_API.


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field /ACCGO/VENDOR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_/ACCGO/UIS_S_EVNT_CNG_API-/ACCGO/VENDOR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/ACCGO/UIS_S_EVNT_CNG_API-/ACCGO/VENDOR.
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/UIS_S_EVNT_CNG_API_STR, 
EVENT_ID TYPE STRING,
UISID TYPE STRING,
EVENT_KEY TYPE STRING,
EVENT_TYPE TYPE STRING,
PURCHASE_ORG TYPE STRING,
SPECIFIC_MATNR TYPE STRING,
MATERIAL TYPE STRING,
TRACE_ID TYPE STRING,
TICKET TYPE STRING,
TICKET_RC TYPE STRING,
EXT_IDENTIFIER TYPE STRING,
FINAL_DELIVERY TYPE STRING,
EVNT_LOC_TYP TYPE STRING,
EVNT_LOC TYPE STRING,
REC_LOC_TYP TYPE STRING,
REC_LOC TYPE STRING,
APPL_INSTR TYPE STRING,
ON_ACC_OF TYPE STRING,
TC_ID TYPE STRING,
TC_ITEM TYPE STRING,
B2B_TC_ID TYPE STRING,
B2B_TC_ITEM TYPE STRING,
PO_ID TYPE STRING,
PO_ITEM TYPE STRING,
STO_ID TYPE STRING,
STO_ITEM TYPE STRING,
SO_ID TYPE STRING,
SO_ITEM TYPE STRING,
DEL_ID TYPE STRING,
DEL_ITEM TYPE STRING,
STORAGE_AGREEMENT_ID TYPE STRING,
STORAGE_AGREEMENT_ITEM TYPE STRING,
ACCNT_ADDR_FLAG TYPE STRING,
BOL TYPE STRING,
BOL_DATE TYPE STRING,
NOM_KEY TYPE STRING,
NOM_ID TYPE STRING,
NOM_ITEM TYPE STRING,
MOT TYPE STRING,
TRNSP_GRP TYPE STRING,
MEANS_OF_TRNSP TYPE STRING,
DRIVER_ID TYPE STRING,
LICENSE TYPE STRING,
VEHICLE_ID TYPE STRING,
LEAD_CAR_NO TYPE STRING,
NO_OF_CARS TYPE STRING,
BARGE_ID TYPE STRING,
VESSEL_ID TYPE STRING,
BOOKING_NO TYPE STRING,
DESCR TYPE STRING,
EVNT_ACTUAL_DATE TYPE STRING,
EVNT_ACTUAL_TIME TYPE STRING,
POSTING_DATE TYPE STRING,
COMMENTS TYPE STRING,
EV_ACTION TYPE STRING,
BIN TYPE STRING,
STRG_LOC TYPE STRING,
RELEASED_BY TYPE STRING,
RELEASED_DATE TYPE STRING,
RELEASED_TIME TYPE STRING,
REL_WGT_QREP_GUID TYPE STRING,
REL_WGT_QREP_VERSION TYPE STRING,
CHANGED_BY TYPE STRING,
STATUS TYPE STRING,
PART_WT_IND TYPE STRING,
LOAD_RT TYPE STRING,
DIS_RT TYPE STRING,
CROP_SEASON_ID TYPE STRING,
DEL_PERIOD TYPE STRING,
DEL_PERIOD_END TYPE STRING,
SOURCE_LOC TYPE STRING,
LOAD_RT_QTY TYPE STRING,
LOAD_RT_TIM TYPE STRING,
DEL_PD_UOM TYPE STRING,
DIS_RT_QTY TYPE STRING,
DIS_RT_TIM TYPE STRING,
LOAD_LOCATION TYPE STRING,
DISCHARGE_LOC TYPE STRING,
VKTRA TYPE STRING,
MEANS_TRNSPT TYPE STRING,
INCO_TERMS TYPE STRING,
DELETION_FLAG TYPE STRING,
ALTERNATE_VENDOR TYPE STRING,
NFNUM TYPE STRING,
NFQTY TYPE STRING,
NFTOT TYPE STRING,
DELIVERY_NFVALID TYPE STRING,
NFVALID TYPE STRING,
STKZN TYPE STRING,
SUPPLIER_NATURAL_PERSON TYPE STRING,
LFSNR TYPE STRING,
TROP_EARLY_INVOICE TYPE STRING,
TROP TYPE STRING,
SPLIT TYPE STRING,
NFFRE TYPE STRING,
MWSKZ TYPE STRING,
J_1BEXBASE TYPE STRING,
NFCURR TYPE STRING,
NFUOM TYPE STRING,
LAQTY TYPE STRING,
LAQ_UOM TYPE STRING,
FINAL TYPE STRING,
BELNR TYPE STRING,
GJAHR TYPE STRING,
DNQTY TYPE STRING,
DNUOM TYPE STRING,
COMMINGLED TYPE STRING,
FUTURE TYPE STRING,
EBELN TYPE STRING,
EBELP TYPE STRING,
REF_TC TYPE STRING,
REF_IT TYPE STRING,
/ACCGO/GMO_RELEVANCY TYPE STRING,
/ACCGO/ROYALTIES_ID TYPE STRING,
/ACCGO/VENDOR TYPE STRING,
/ACCGO/TECHNOLOGY TYPE STRING,
/ACCGO/PERCENTAGE TYPE STRING,
FEE_DATA TYPE STRING,
NOMTYP TYPE STRING,
TSYST TYPE STRING,
INCOTERM_UPS TYPE STRING,
AUTO_INCOTERM TYPE STRING,
SCALE_TKT_NO TYPE STRING,
CA_DATE TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/ACCGO/UIS_S_EVNT_CNG_API_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/UIS_S_EVNT_CNG_API_STR-EVENT_ID sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-UISID sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-EVENT_KEY sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-EVENT_TYPE sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-PURCHASE_ORG sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-SPECIFIC_MATNR sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-MATERIAL sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-TRACE_ID sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-TICKET sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-TICKET_RC sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-EXT_IDENTIFIER sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-FINAL_DELIVERY sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-EVNT_LOC_TYP sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-EVNT_LOC sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-REC_LOC_TYP sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-REC_LOC sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-APPL_INSTR sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-ON_ACC_OF sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-TC_ID sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-TC_ITEM sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-B2B_TC_ID sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-B2B_TC_ITEM sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-PO_ID sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-PO_ITEM sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-STO_ID sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-STO_ITEM sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-SO_ID sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-SO_ITEM sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-DEL_ID sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-DEL_ITEM sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-STORAGE_AGREEMENT_ID sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-STORAGE_AGREEMENT_ITEM sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-ACCNT_ADDR_FLAG sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-BOL sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-BOL_DATE sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-NOM_KEY sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-NOM_ID sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-NOM_ITEM sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-MOT sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-TRNSP_GRP sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-MEANS_OF_TRNSP sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-DRIVER_ID sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-LICENSE sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-VEHICLE_ID sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-LEAD_CAR_NO sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-NO_OF_CARS sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-BARGE_ID sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-VESSEL_ID sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-BOOKING_NO sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-DESCR sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-EVNT_ACTUAL_DATE sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-EVNT_ACTUAL_TIME sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-POSTING_DATE sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-COMMENTS sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-EV_ACTION sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-BIN sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-STRG_LOC sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-RELEASED_BY sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-RELEASED_DATE sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-RELEASED_TIME sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-REL_WGT_QREP_GUID sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-REL_WGT_QREP_VERSION sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-CHANGED_BY sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-STATUS sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-PART_WT_IND sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-LOAD_RT sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-DIS_RT sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-CROP_SEASON_ID sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-DEL_PERIOD sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-DEL_PERIOD_END sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-SOURCE_LOC sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-LOAD_RT_QTY sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-LOAD_RT_TIM sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-DEL_PD_UOM sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-DIS_RT_QTY sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-DIS_RT_TIM sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-LOAD_LOCATION sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-DISCHARGE_LOC sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-VKTRA sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-MEANS_TRNSPT sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-INCO_TERMS sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-DELETION_FLAG sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-ALTERNATE_VENDOR sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-NFNUM sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-NFQTY sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-NFTOT sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-DELIVERY_NFVALID sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-NFVALID sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-STKZN sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-SUPPLIER_NATURAL_PERSON sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-LFSNR sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-TROP_EARLY_INVOICE sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-TROP sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-SPLIT sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-NFFRE sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-MWSKZ sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-J_1BEXBASE sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-NFCURR sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-NFUOM sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-LAQTY sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-LAQ_UOM sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-FINAL sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-BELNR sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-GJAHR sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-DNQTY sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-DNUOM sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-COMMINGLED sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-FUTURE sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-EBELN sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-EBELP sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-REF_TC sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-REF_IT sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-/ACCGO/GMO_RELEVANCY sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-/ACCGO/ROYALTIES_ID sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-/ACCGO/VENDOR sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-/ACCGO/TECHNOLOGY sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-/ACCGO/PERCENTAGE sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-FEE_DATA sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-NOMTYP sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-TSYST sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-INCOTERM_UPS sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-AUTO_INCOTERM sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-SCALE_TKT_NO sy-vline 
WA_/ACCGO/UIS_S_EVNT_CNG_API_STR-CA_DATE sy-vline      INTO ld_text SEPARATED BY SPACE.

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