ABAP Select data from SAP table /ACCGO/OE_TICKET_ITEM_APPEND into internal table

Get Example source ABAP code based on a different SAP table
  

Below is a number of ABAP code snippets to demonstrate how to select data from SAP /ACCGO/OE_TICKET_ITEM_APPEND 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/OE_TICKET_ITEM_APPEND. 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/OE_TICKET_ITEM_APPEND 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/OE_TICKET_ITEM_APPEND TYPE STANDARD TABLE OF /ACCGO/OE_TICKET_ITEM_APPEND,
      WA_/ACCGO/OE_TICKET_ITEM_APPEND TYPE /ACCGO/OE_TICKET_ITEM_APPEND,
      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/OE_TICKET_ITEM_APPEND> TYPE /ACCGO/OE_TICKET_ITEM_APPEND.

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

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

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


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/ACCGO/OE_TICKET_ITEM_APPEND ASSIGNING </ACCGO/OE_TICKET_ITEM_APPEND>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
</ACCGO/OE_TICKET_ITEM_APPEND>-TICKET_KEY = 1.
</ACCGO/OE_TICKET_ITEM_APPEND>-TICKET_ITEM = 1.
</ACCGO/OE_TICKET_ITEM_APPEND>-TICKET_VERSION = 1.
</ACCGO/OE_TICKET_ITEM_APPEND>-TICKET_PURPOSE = 1.
</ACCGO/OE_TICKET_ITEM_APPEND>-CHARG = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/ACCGO/OE_TICKET_ITEM_APPEND-WERKS, sy-vline,
WA_/ACCGO/OE_TICKET_ITEM_APPEND-LGORT, sy-vline,
WA_/ACCGO/OE_TICKET_ITEM_APPEND-OIB_BLTIME, sy-vline,
WA_/ACCGO/OE_TICKET_ITEM_APPEND-BUDAT, sy-vline,
WA_/ACCGO/OE_TICKET_ITEM_APPEND-DOCNR, sy-vline,
WA_/ACCGO/OE_TICKET_ITEM_APPEND-DOCIND, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/ACCGO/OE_TICKET_ITEM_APPEND 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/OE_TICKET_ITEM_APPEND 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/OE_TICKET_ITEM_APPEND INTO WA_/ACCGO/OE_TICKET_ITEM_APPEND. *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 TICKET_KEY CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/ACCGO/OE_TICKET_ITEM_APPEND-TICKET_KEY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/ACCGO/OE_TICKET_ITEM_APPEND-TICKET_KEY.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field /ACCGO/OBLG_APPLDOC CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/ACCGO/OE_TICKET_ITEM_APPEND-/ACCGO/OBLG_APPLDOC IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/ACCGO/OE_TICKET_ITEM_APPEND-/ACCGO/OBLG_APPLDOC.
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/OE_TICKET_ITEM_APPEND_STR,
TICKET_KEY TYPE STRING,
TICKET_ITEM TYPE STRING,
TICKET_VERSION TYPE STRING,
TICKET_PURPOSE TYPE STRING,
CHARG TYPE STRING,
WERKS TYPE STRING,
LGORT TYPE STRING,
OIB_BLTIME TYPE STRING,
BUDAT TYPE STRING,
DOCNR TYPE STRING,
DOCIND TYPE STRING,
VBTYP TYPE STRING,
DOCITM TYPE STRING,
MENGE TYPE STRING,
UNIT_I TYPE STRING,
DELIV_DATE TYPE STRING,
MENGE_PAR TYPE STRING,
UNIT_I_PAR TYPE STRING,
ERDAT TYPE STRING,
ERZEIT TYPE STRING,
ERNAM TYPE STRING,
AEDAT TYPE STRING,
AEZEIT TYPE STRING,
AENAM TYPE STRING,
BLOIND TYPE STRING,
DELIND TYPE STRING,
/ACCGO/NOMTK TYPE STRING,
/ACCGO/NOMIT TYPE STRING,
/ACCGO/IDATE TYPE STRING,
/ACCGO/S_MATNR TYPE STRING,
/ACCGO/MATNR_I TYPE STRING,
/ACCGO/MATNR TYPE STRING,
/ACCGO/CHARG_O TYPE STRING,
/ACCGO/WERKS_O TYPE STRING,
/ACCGO/LGORT_O TYPE STRING,
/ACCGO/CHARG_D TYPE STRING,
/ACCGO/WERKS_D TYPE STRING,
/ACCGO/LGORT_D TYPE STRING,
/ACCGO/LOCID TYPE STRING,
/ACCGO/APPLIC TYPE STRING,
/ACCGO/FUNC_GRP TYPE STRING,
/ACCGO/APP_R_RUN TYPE STRING,
/ACCGO/APP_DOCT TYPE STRING,
/ACCGO/UIS_ID TYPE STRING,
/ACCGO/APPL_INST TYPE STRING,
/ACCGO/VERSION TYPE STRING,
/ACCGO/EVNT_TY TYPE STRING,
/ACCGO/APPLDOC TYPE STRING,
/ACCGO/APPL_ITEM TYPE STRING,
/ACCGO/SITYP TYPE STRING,
/ACCGO/DOCIND TYPE STRING,
/ACCGO/DOCNR TYPE STRING,
/ACCGO/DOCITM TYPE STRING,
/ACCGO/TM_REL TYPE STRING,
/ACCGO/INCO1 TYPE STRING,
/ACCGO/TITLE_TRANSFER TYPE STRING,
/ACCGO/VENDOR TYPE STRING,
/ACCGO/TRAN_MEAN TYPE STRING,
/ACCGO/DIS_LOC TYPE STRING,
/ACCGO/LOAD_LOC TYPE STRING,
/ACCGO/MOT TYPE STRING,
/ACCGO/COM_ITEM TYPE STRING,
/ACCGO/SCP_REL TYPE STRING,
/ACCGO/INCO2 TYPE STRING,
/ACCGO/NOMNR TYPE STRING,
/ACCGO/AGRID TYPE STRING,
/ACCGO/CORR_APP_INDEX TYPE STRING,
/ACCGO/CORR_FUNC_GRP TYPE STRING,
/ACCGO/REV_APP_INDEX TYPE STRING,
/ACCGO/REV_FUNC_GRP TYPE STRING,
/ACCGO/ACTION TYPE STRING,
/ACCGO/PHYS_APPLDOC TYPE STRING,
/ACCGO/PHYS_APPL_ITEM TYPE STRING,
/ACCGO/PHYSICAL_PLANT TYPE STRING,
/ACCGO/PHYSICAL_SLOC TYPE STRING,
/ACCGO/PHYSICAL_BATCH TYPE STRING,
/ACCGO/OBLG_APPLDOC TYPE STRING,
/ACCGO/OBLG_APPL_ITEM TYPE STRING,
/ACCGO/OBLIGATIONS_PLANT TYPE STRING,
/ACCGO/OBLIGATIONS_SLOC TYPE STRING,
/ACCGO/OBLIGATIONS_BATCH TYPE STRING,
/ACCGO/MATCH_ID TYPE STRING,
/ACCGO/LINK_ID TYPE STRING,END OF T_EKKO_STR. DATA: WA_/ACCGO/OE_TICKET_ITEM_APPEND_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/OE_TICKET_ITEM_APPEND_STR-TICKET_KEY sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-TICKET_ITEM sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-TICKET_VERSION sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-TICKET_PURPOSE sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-CHARG sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-WERKS sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-LGORT sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-OIB_BLTIME sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-BUDAT sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-DOCNR sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-DOCIND sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-VBTYP sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-DOCITM sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-MENGE sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-UNIT_I sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-DELIV_DATE sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-MENGE_PAR sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-UNIT_I_PAR sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-ERDAT sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-ERZEIT sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-ERNAM sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-AEDAT sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-AEZEIT sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-AENAM sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-BLOIND sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-DELIND sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/NOMTK sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/NOMIT sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/IDATE sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/S_MATNR sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/MATNR_I sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/MATNR sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/CHARG_O sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/WERKS_O sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/LGORT_O sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/CHARG_D sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/WERKS_D sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/LGORT_D sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/LOCID sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/APPLIC sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/FUNC_GRP sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/APP_R_RUN sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/APP_DOCT sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/UIS_ID sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/APPL_INST sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/VERSION sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/EVNT_TY sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/APPLDOC sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/APPL_ITEM sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/SITYP sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/DOCIND sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/DOCNR sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/DOCITM sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/TM_REL sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/INCO1 sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/TITLE_TRANSFER sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/VENDOR sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/TRAN_MEAN sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/DIS_LOC sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/LOAD_LOC sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/MOT sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/COM_ITEM sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/SCP_REL sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/INCO2 sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/NOMNR sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/AGRID sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/CORR_APP_INDEX sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/CORR_FUNC_GRP sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/REV_APP_INDEX sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/REV_FUNC_GRP sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/ACTION sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/PHYS_APPLDOC sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/PHYS_APPL_ITEM sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/PHYSICAL_PLANT sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/PHYSICAL_SLOC sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/PHYSICAL_BATCH sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/OBLG_APPLDOC sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/OBLG_APPL_ITEM sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/OBLIGATIONS_PLANT sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/OBLIGATIONS_SLOC sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/OBLIGATIONS_BATCH sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/MATCH_ID sy-vline
WA_/ACCGO/OE_TICKET_ITEM_APPEND_STR-/ACCGO/LINK_ID sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.