ABAP Select data from SAP table IACCIT_ACDOCA 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 IACCIT_ACDOCA 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 IACCIT_ACDOCA. 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 IACCIT_ACDOCA 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_IACCIT_ACDOCA TYPE STANDARD TABLE OF IACCIT_ACDOCA,
      WA_IACCIT_ACDOCA TYPE IACCIT_ACDOCA,
      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: <IACCIT_ACDOCA> TYPE IACCIT_ACDOCA.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM IACCIT_ACDOCA
*  INTO TABLE @DATA(IT_IACCIT_ACDOCA2).
*--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_IACCIT_ACDOCA INDEX 1 INTO DATA(WA_IACCIT_ACDOCA2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_IACCIT_ACDOCA ASSIGNING <IACCIT_ACDOCA>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<IACCIT_ACDOCA>-SUBTA = 1.
<IACCIT_ACDOCA>-SUBTA_REV = 1.
<IACCIT_ACDOCA>-SLALITTYPE = 1.
<IACCIT_ACDOCA>-MOVCAT = 1.
<IACCIT_ACDOCA>-AWITEM = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_IACCIT_ACDOCA-AWITGRP, sy-vline,
WA_IACCIT_ACDOCA-PREC_AWTYP, sy-vline,
WA_IACCIT_ACDOCA-PREC_AWORG, sy-vline,
WA_IACCIT_ACDOCA-PREC_AWREF, sy-vline,
WA_IACCIT_ACDOCA-PREC_AWITEM, sy-vline,
WA_IACCIT_ACDOCA-PREC_BUKRS, sy-vline.
ENDLOOP. *Add any further fields from structure WA_IACCIT_ACDOCA 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_IACCIT_ACDOCA 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_IACCIT_ACDOCA INTO WA_IACCIT_ACDOCA. *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 PREC_AWREF CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IACCIT_ACDOCA-PREC_AWREF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IACCIT_ACDOCA-PREC_AWREF.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit AC132, internal->external for field ANBTR_PN CALL FUNCTION 'CONVERSION_EXIT_AC132_OUTPUT' EXPORTING input = WA_IACCIT_ACDOCA-ANBTR_PN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IACCIT_ACDOCA-ANBTR_PN.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit GJAHR, internal->external for field BDGT_CNSMPN_YEAR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_IACCIT_ACDOCA-BDGT_CNSMPN_YEAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IACCIT_ACDOCA-BDGT_CNSMPN_YEAR.
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_IACCIT_ACDOCA_STR,
SUBTA TYPE STRING,
SUBTA_REV TYPE STRING,
SLALITTYPE TYPE STRING,
MOVCAT TYPE STRING,
AWITEM TYPE STRING,
AWITGRP TYPE STRING,
PREC_AWTYP TYPE STRING,
PREC_AWORG TYPE STRING,
PREC_AWREF TYPE STRING,
PREC_AWITEM TYPE STRING,
PREC_BUKRS TYPE STRING,
PREC_GJAHR TYPE STRING,
PREC_BELNR TYPE STRING,
PREC_DOCLN TYPE STRING,
PREC_SUBTA TYPE STRING,
CLOSING_RUN_ID TYPE STRING,
SRC_AWTYP TYPE STRING,
SRC_AWSYS TYPE STRING,
SRC_AWORG TYPE STRING,
SRC_AWREF TYPE STRING,
SRC_AWITEM TYPE STRING,
SRC_AWSUBIT TYPE STRING,
DEPR_PERIOD TYPE STRING,
OBJNR_OF TYPE STRING,
VTSTAMP TYPE STRING,
VLBKUM TYPE STRING,
PBUKRS_COFI TYPE STRING,
PHOART_COFI TYPE STRING,
PAOBJNR_ATTR TYPE STRING,
RSRCE TYPE STRING,
UKOSTL TYPE STRING,
ULSTAR TYPE STRING,
UPRCTR TYPE STRING,
UMATNR TYPE STRING,
VARC_UACCT TYPE STRING,
VGBEL TYPE STRING,
VGPOS TYPE STRING,
VGTYP TYPE STRING,
ANLKL TYPE STRING,
KTOGR TYPE STRING,
PANL1 TYPE STRING,
PANL2 TYPE STRING,
ARBID TYPE STRING,
BTTYPE TYPE STRING,
CBTTYPE TYPE STRING,
CLOSINGSTEP TYPE STRING,
XCOMMITMENT TYPE STRING,
TRAVEL_REQ TYPE STRING,
TRAVEL_REQ_ITEM TYPE STRING,
COCO_NUM TYPE STRING,
XUNIQUECVTYPS TYPE STRING,
PROJ_LEDGER TYPE STRING,
XLEDGERDIFFVALUES TYPE STRING,
XLEDGERSPECQUANT TYPE STRING,
XADDLATE_ITEM TYPE STRING,
TRAVA_PN TYPE STRING,
LDGRPSPEC_PN TYPE STRING,
AFABESPEC_PN TYPE STRING,
ANLN2_PN TYPE STRING,
BWASL_PN TYPE STRING,
BZDAT_PN TYPE STRING,
XVABG_PN TYPE STRING,
ANBTR_PN TYPE STRING,
PROZS_PN TYPE STRING,
UBZDT_PN TYPE STRING,
XMANPROPVAL_PN TYPE STRING,
TRANSACTION_UUID TYPE STRING,
BDGT_ACCOUNT TYPE STRING,
BDGT_ACCOUNT_COCODE TYPE STRING,
BDGT_CNSMPN_DATE TYPE STRING,
BDGT_CNSMPN_PERIOD TYPE STRING,
BDGT_CNSMPN_YEAR TYPE STRING,
BDGT_RELEVANT TYPE STRING,
BDGT_CNSMPN_TYPE TYPE STRING,
BDGT_CNSMPN_AMOUNT_TYPE TYPE STRING,
RSPONSORED_PROG TYPE STRING,
RSPONSORED_CLASS TYPE STRING,
RBDGT_VLDTY_NBR TYPE STRING,
ORGL_CHANGE TYPE STRING,
ACDOC_EEW_DUMMY TYPE STRING,END OF T_EKKO_STR. DATA: WA_IACCIT_ACDOCA_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_IACCIT_ACDOCA_STR-SUBTA sy-vline
WA_IACCIT_ACDOCA_STR-SUBTA_REV sy-vline
WA_IACCIT_ACDOCA_STR-SLALITTYPE sy-vline
WA_IACCIT_ACDOCA_STR-MOVCAT sy-vline
WA_IACCIT_ACDOCA_STR-AWITEM sy-vline
WA_IACCIT_ACDOCA_STR-AWITGRP sy-vline
WA_IACCIT_ACDOCA_STR-PREC_AWTYP sy-vline
WA_IACCIT_ACDOCA_STR-PREC_AWORG sy-vline
WA_IACCIT_ACDOCA_STR-PREC_AWREF sy-vline
WA_IACCIT_ACDOCA_STR-PREC_AWITEM sy-vline
WA_IACCIT_ACDOCA_STR-PREC_BUKRS sy-vline
WA_IACCIT_ACDOCA_STR-PREC_GJAHR sy-vline
WA_IACCIT_ACDOCA_STR-PREC_BELNR sy-vline
WA_IACCIT_ACDOCA_STR-PREC_DOCLN sy-vline
WA_IACCIT_ACDOCA_STR-PREC_SUBTA sy-vline
WA_IACCIT_ACDOCA_STR-CLOSING_RUN_ID sy-vline
WA_IACCIT_ACDOCA_STR-SRC_AWTYP sy-vline
WA_IACCIT_ACDOCA_STR-SRC_AWSYS sy-vline
WA_IACCIT_ACDOCA_STR-SRC_AWORG sy-vline
WA_IACCIT_ACDOCA_STR-SRC_AWREF sy-vline
WA_IACCIT_ACDOCA_STR-SRC_AWITEM sy-vline
WA_IACCIT_ACDOCA_STR-SRC_AWSUBIT sy-vline
WA_IACCIT_ACDOCA_STR-DEPR_PERIOD sy-vline
WA_IACCIT_ACDOCA_STR-OBJNR_OF sy-vline
WA_IACCIT_ACDOCA_STR-VTSTAMP sy-vline
WA_IACCIT_ACDOCA_STR-VLBKUM sy-vline
WA_IACCIT_ACDOCA_STR-PBUKRS_COFI sy-vline
WA_IACCIT_ACDOCA_STR-PHOART_COFI sy-vline
WA_IACCIT_ACDOCA_STR-PAOBJNR_ATTR sy-vline
WA_IACCIT_ACDOCA_STR-RSRCE sy-vline
WA_IACCIT_ACDOCA_STR-UKOSTL sy-vline
WA_IACCIT_ACDOCA_STR-ULSTAR sy-vline
WA_IACCIT_ACDOCA_STR-UPRCTR sy-vline
WA_IACCIT_ACDOCA_STR-UMATNR sy-vline
WA_IACCIT_ACDOCA_STR-VARC_UACCT sy-vline
WA_IACCIT_ACDOCA_STR-VGBEL sy-vline
WA_IACCIT_ACDOCA_STR-VGPOS sy-vline
WA_IACCIT_ACDOCA_STR-VGTYP sy-vline
WA_IACCIT_ACDOCA_STR-ANLKL sy-vline
WA_IACCIT_ACDOCA_STR-KTOGR sy-vline
WA_IACCIT_ACDOCA_STR-PANL1 sy-vline
WA_IACCIT_ACDOCA_STR-PANL2 sy-vline
WA_IACCIT_ACDOCA_STR-ARBID sy-vline
WA_IACCIT_ACDOCA_STR-BTTYPE sy-vline
WA_IACCIT_ACDOCA_STR-CBTTYPE sy-vline
WA_IACCIT_ACDOCA_STR-CLOSINGSTEP sy-vline
WA_IACCIT_ACDOCA_STR-XCOMMITMENT sy-vline
WA_IACCIT_ACDOCA_STR-TRAVEL_REQ sy-vline
WA_IACCIT_ACDOCA_STR-TRAVEL_REQ_ITEM sy-vline
WA_IACCIT_ACDOCA_STR-COCO_NUM sy-vline
WA_IACCIT_ACDOCA_STR-XUNIQUECVTYPS sy-vline
WA_IACCIT_ACDOCA_STR-PROJ_LEDGER sy-vline
WA_IACCIT_ACDOCA_STR-XLEDGERDIFFVALUES sy-vline
WA_IACCIT_ACDOCA_STR-XLEDGERSPECQUANT sy-vline
WA_IACCIT_ACDOCA_STR-XADDLATE_ITEM sy-vline
WA_IACCIT_ACDOCA_STR-TRAVA_PN sy-vline
WA_IACCIT_ACDOCA_STR-LDGRPSPEC_PN sy-vline
WA_IACCIT_ACDOCA_STR-AFABESPEC_PN sy-vline
WA_IACCIT_ACDOCA_STR-ANLN2_PN sy-vline
WA_IACCIT_ACDOCA_STR-BWASL_PN sy-vline
WA_IACCIT_ACDOCA_STR-BZDAT_PN sy-vline
WA_IACCIT_ACDOCA_STR-XVABG_PN sy-vline
WA_IACCIT_ACDOCA_STR-ANBTR_PN sy-vline
WA_IACCIT_ACDOCA_STR-PROZS_PN sy-vline
WA_IACCIT_ACDOCA_STR-UBZDT_PN sy-vline
WA_IACCIT_ACDOCA_STR-XMANPROPVAL_PN sy-vline
WA_IACCIT_ACDOCA_STR-TRANSACTION_UUID sy-vline
WA_IACCIT_ACDOCA_STR-BDGT_ACCOUNT sy-vline
WA_IACCIT_ACDOCA_STR-BDGT_ACCOUNT_COCODE sy-vline
WA_IACCIT_ACDOCA_STR-BDGT_CNSMPN_DATE sy-vline
WA_IACCIT_ACDOCA_STR-BDGT_CNSMPN_PERIOD sy-vline
WA_IACCIT_ACDOCA_STR-BDGT_CNSMPN_YEAR sy-vline
WA_IACCIT_ACDOCA_STR-BDGT_RELEVANT sy-vline
WA_IACCIT_ACDOCA_STR-BDGT_CNSMPN_TYPE sy-vline
WA_IACCIT_ACDOCA_STR-BDGT_CNSMPN_AMOUNT_TYPE sy-vline
WA_IACCIT_ACDOCA_STR-RSPONSORED_PROG sy-vline
WA_IACCIT_ACDOCA_STR-RSPONSORED_CLASS sy-vline
WA_IACCIT_ACDOCA_STR-RBDGT_VLDTY_NBR sy-vline
WA_IACCIT_ACDOCA_STR-ORGL_CHANGE sy-vline
WA_IACCIT_ACDOCA_STR-ACDOC_EEW_DUMMY sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.