ABAP Select data from SAP table FUDT_VDOCBKPF 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 FUDT_VDOCBKPF 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 FUDT_VDOCBKPF. 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 FUDT_VDOCBKPF 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_FUDT_VDOCBKPF TYPE STANDARD TABLE OF FUDT_VDOCBKPF,
      WA_FUDT_VDOCBKPF TYPE FUDT_VDOCBKPF,
      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: <FUDT_VDOCBKPF> TYPE FUDT_VDOCBKPF.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FUDT_VDOCBKPF
*  INTO TABLE @DATA(IT_FUDT_VDOCBKPF2).
*--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_FUDT_VDOCBKPF INDEX 1 INTO DATA(WA_FUDT_VDOCBKPF2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_FUDT_VDOCBKPF ASSIGNING <FUDT_VDOCBKPF>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<FUDT_VDOCBKPF>-MANDT = 1.
<FUDT_VDOCBKPF>-BUKRS = 1.
<FUDT_VDOCBKPF>-BELNR = 1.
<FUDT_VDOCBKPF>-GJAHR = 1.
<FUDT_VDOCBKPF>-BLART = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FUDT_VDOCBKPF-BLDAT, sy-vline,
WA_FUDT_VDOCBKPF-BUDAT, sy-vline,
WA_FUDT_VDOCBKPF-MONAT, sy-vline,
WA_FUDT_VDOCBKPF-CPUDT, sy-vline,
WA_FUDT_VDOCBKPF-CPUTM, sy-vline,
WA_FUDT_VDOCBKPF-AEDAT, sy-vline.
ENDLOOP. *Add any further fields from structure WA_FUDT_VDOCBKPF 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_FUDT_VDOCBKPF 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_FUDT_VDOCBKPF INTO WA_FUDT_VDOCBKPF. *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 BELNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FUDT_VDOCBKPF-BELNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FUDT_VDOCBKPF-BELNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit EXCRT, internal->external for field KURSF CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT' EXPORTING input = WA_FUDT_VDOCBKPF-KURSF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FUDT_VDOCBKPF-KURSF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EXCRT, internal->external for field KZKRS CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT' EXPORTING input = WA_FUDT_VDOCBKPF-KZKRS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FUDT_VDOCBKPF-KZKRS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EXCRT, internal->external for field KURS2 CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT' EXPORTING input = WA_FUDT_VDOCBKPF-KURS2 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FUDT_VDOCBKPF-KURS2.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EXCRT, internal->external for field KURS3 CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT' EXPORTING input = WA_FUDT_VDOCBKPF-KURS3 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FUDT_VDOCBKPF-KURS3.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit EXCRT, internal->external for field TXKRS CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT' EXPORTING input = WA_FUDT_VDOCBKPF-TXKRS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FUDT_VDOCBKPF-TXKRS.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit PRPMN, internal->external for field PROPMANO CALL FUNCTION 'CONVERSION_EXIT_PRPMN_OUTPUT' EXPORTING input = WA_FUDT_VDOCBKPF-PROPMANO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FUDT_VDOCBKPF-PROPMANO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ODNIT, internal->external for field XBLNR_ALT CALL FUNCTION 'CONVERSION_EXIT_ODNIT_OUTPUT' EXPORTING input = WA_FUDT_VDOCBKPF-XBLNR_ALT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FUDT_VDOCBKPF-XBLNR_ALT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EXCRX, internal->external for field KURSX CALL FUNCTION 'CONVERSION_EXIT_EXCRX_OUTPUT' EXPORTING input = WA_FUDT_VDOCBKPF-KURSX IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FUDT_VDOCBKPF-KURSX.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EXCRX, internal->external for field KUR2X CALL FUNCTION 'CONVERSION_EXIT_EXCRX_OUTPUT' EXPORTING input = WA_FUDT_VDOCBKPF-KUR2X IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FUDT_VDOCBKPF-KUR2X.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EXCRX, internal->external for field KUR3X CALL FUNCTION 'CONVERSION_EXIT_EXCRX_OUTPUT' EXPORTING input = WA_FUDT_VDOCBKPF-KUR3X IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FUDT_VDOCBKPF-KUR3X.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field BATCH CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FUDT_VDOCBKPF-BATCH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FUDT_VDOCBKPF-BATCH.
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_FUDT_VDOCBKPF_STR,
MANDT TYPE STRING,
BUKRS TYPE STRING,
BELNR TYPE STRING,
GJAHR TYPE STRING,
BLART TYPE STRING,
BLDAT TYPE STRING,
BUDAT TYPE STRING,
MONAT TYPE STRING,
CPUDT TYPE STRING,
CPUTM TYPE STRING,
AEDAT TYPE STRING,
UPDDT TYPE STRING,
WWERT TYPE STRING,
USNAM TYPE STRING,
TCODE TYPE STRING,
BVORG TYPE STRING,
XBLNR TYPE STRING,
DBBLG TYPE STRING,
STBLG TYPE STRING,
STJAH TYPE STRING,
BKTXT TYPE STRING,
WAERS TYPE STRING,
KURSF TYPE STRING,
KZWRS TYPE STRING,
KZKRS TYPE STRING,
BSTAT TYPE STRING,
XNETB TYPE STRING,
FRATH TYPE STRING,
XRUEB TYPE STRING,
GLVOR TYPE STRING,
GRPID TYPE STRING,
DOKID TYPE STRING,
ARCID TYPE STRING,
IBLAR TYPE STRING,
AWTYP TYPE STRING,
AWKEY TYPE STRING,
FIKRS TYPE STRING,
HWAER TYPE STRING,
HWAE2 TYPE STRING,
HWAE3 TYPE STRING,
KURS2 TYPE STRING,
KURS3 TYPE STRING,
BASW2 TYPE STRING,
BASW3 TYPE STRING,
UMRD2 TYPE STRING,
UMRD3 TYPE STRING,
XSTOV TYPE STRING,
STODT TYPE STRING,
XMWST TYPE STRING,
CURT2 TYPE STRING,
CURT3 TYPE STRING,
KUTY2 TYPE STRING,
KUTY3 TYPE STRING,
XSNET TYPE STRING,
AUSBK TYPE STRING,
XUSVR TYPE STRING,
DUEFL TYPE STRING,
AWSYS TYPE STRING,
TXKRS TYPE STRING,
LOTKZ TYPE STRING,
XWVOF TYPE STRING,
STGRD TYPE STRING,
PPNAM TYPE STRING,
BRNCH TYPE STRING,
NUMPG TYPE STRING,
ADISC TYPE STRING,
XREF1_HD TYPE STRING,
XREF2_HD TYPE STRING,
XREVERSAL TYPE STRING,
REINDAT TYPE STRING,
RLDNR TYPE STRING,
LDGRP TYPE STRING,
PROPMANO TYPE STRING,
XBLNR_ALT TYPE STRING,
VATDATE TYPE STRING,
DOCCAT TYPE STRING,
XSPLIT TYPE STRING,
CASH_ALLOC TYPE STRING,
FOLLOW_ON TYPE STRING,
XREORG TYPE STRING,
SUBSET TYPE STRING,
KURST TYPE STRING,
KURSX TYPE STRING,
KUR2X TYPE STRING,
KUR3X TYPE STRING,
XMCA TYPE STRING,
PSOTY TYPE STRING,
PSOAK TYPE STRING,
PSOKS TYPE STRING,
PSOSG TYPE STRING,
PSOFN TYPE STRING,
INTFORM TYPE STRING,
INTDATE TYPE STRING,
PSOBT TYPE STRING,
PSOZL TYPE STRING,
PSODT TYPE STRING,
PSOTM TYPE STRING,
FM_UMART TYPE STRING,
CCINS TYPE STRING,
CCNUM TYPE STRING,
SSBLK TYPE STRING,
BATCH TYPE STRING,
SNAME TYPE STRING,
SAMPLED TYPE STRING,
EXCLUDE_FLAG TYPE STRING,
BLIND TYPE STRING,
OFFSET_STATUS TYPE STRING,
OFFSET_REFER_DAT TYPE STRING,
PENRC TYPE STRING,
KNUMV TYPE STRING,END OF T_EKKO_STR. DATA: WA_FUDT_VDOCBKPF_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_FUDT_VDOCBKPF_STR-MANDT sy-vline
WA_FUDT_VDOCBKPF_STR-BUKRS sy-vline
WA_FUDT_VDOCBKPF_STR-BELNR sy-vline
WA_FUDT_VDOCBKPF_STR-GJAHR sy-vline
WA_FUDT_VDOCBKPF_STR-BLART sy-vline
WA_FUDT_VDOCBKPF_STR-BLDAT sy-vline
WA_FUDT_VDOCBKPF_STR-BUDAT sy-vline
WA_FUDT_VDOCBKPF_STR-MONAT sy-vline
WA_FUDT_VDOCBKPF_STR-CPUDT sy-vline
WA_FUDT_VDOCBKPF_STR-CPUTM sy-vline
WA_FUDT_VDOCBKPF_STR-AEDAT sy-vline
WA_FUDT_VDOCBKPF_STR-UPDDT sy-vline
WA_FUDT_VDOCBKPF_STR-WWERT sy-vline
WA_FUDT_VDOCBKPF_STR-USNAM sy-vline
WA_FUDT_VDOCBKPF_STR-TCODE sy-vline
WA_FUDT_VDOCBKPF_STR-BVORG sy-vline
WA_FUDT_VDOCBKPF_STR-XBLNR sy-vline
WA_FUDT_VDOCBKPF_STR-DBBLG sy-vline
WA_FUDT_VDOCBKPF_STR-STBLG sy-vline
WA_FUDT_VDOCBKPF_STR-STJAH sy-vline
WA_FUDT_VDOCBKPF_STR-BKTXT sy-vline
WA_FUDT_VDOCBKPF_STR-WAERS sy-vline
WA_FUDT_VDOCBKPF_STR-KURSF sy-vline
WA_FUDT_VDOCBKPF_STR-KZWRS sy-vline
WA_FUDT_VDOCBKPF_STR-KZKRS sy-vline
WA_FUDT_VDOCBKPF_STR-BSTAT sy-vline
WA_FUDT_VDOCBKPF_STR-XNETB sy-vline
WA_FUDT_VDOCBKPF_STR-FRATH sy-vline
WA_FUDT_VDOCBKPF_STR-XRUEB sy-vline
WA_FUDT_VDOCBKPF_STR-GLVOR sy-vline
WA_FUDT_VDOCBKPF_STR-GRPID sy-vline
WA_FUDT_VDOCBKPF_STR-DOKID sy-vline
WA_FUDT_VDOCBKPF_STR-ARCID sy-vline
WA_FUDT_VDOCBKPF_STR-IBLAR sy-vline
WA_FUDT_VDOCBKPF_STR-AWTYP sy-vline
WA_FUDT_VDOCBKPF_STR-AWKEY sy-vline
WA_FUDT_VDOCBKPF_STR-FIKRS sy-vline
WA_FUDT_VDOCBKPF_STR-HWAER sy-vline
WA_FUDT_VDOCBKPF_STR-HWAE2 sy-vline
WA_FUDT_VDOCBKPF_STR-HWAE3 sy-vline
WA_FUDT_VDOCBKPF_STR-KURS2 sy-vline
WA_FUDT_VDOCBKPF_STR-KURS3 sy-vline
WA_FUDT_VDOCBKPF_STR-BASW2 sy-vline
WA_FUDT_VDOCBKPF_STR-BASW3 sy-vline
WA_FUDT_VDOCBKPF_STR-UMRD2 sy-vline
WA_FUDT_VDOCBKPF_STR-UMRD3 sy-vline
WA_FUDT_VDOCBKPF_STR-XSTOV sy-vline
WA_FUDT_VDOCBKPF_STR-STODT sy-vline
WA_FUDT_VDOCBKPF_STR-XMWST sy-vline
WA_FUDT_VDOCBKPF_STR-CURT2 sy-vline
WA_FUDT_VDOCBKPF_STR-CURT3 sy-vline
WA_FUDT_VDOCBKPF_STR-KUTY2 sy-vline
WA_FUDT_VDOCBKPF_STR-KUTY3 sy-vline
WA_FUDT_VDOCBKPF_STR-XSNET sy-vline
WA_FUDT_VDOCBKPF_STR-AUSBK sy-vline
WA_FUDT_VDOCBKPF_STR-XUSVR sy-vline
WA_FUDT_VDOCBKPF_STR-DUEFL sy-vline
WA_FUDT_VDOCBKPF_STR-AWSYS sy-vline
WA_FUDT_VDOCBKPF_STR-TXKRS sy-vline
WA_FUDT_VDOCBKPF_STR-LOTKZ sy-vline
WA_FUDT_VDOCBKPF_STR-XWVOF sy-vline
WA_FUDT_VDOCBKPF_STR-STGRD sy-vline
WA_FUDT_VDOCBKPF_STR-PPNAM sy-vline
WA_FUDT_VDOCBKPF_STR-BRNCH sy-vline
WA_FUDT_VDOCBKPF_STR-NUMPG sy-vline
WA_FUDT_VDOCBKPF_STR-ADISC sy-vline
WA_FUDT_VDOCBKPF_STR-XREF1_HD sy-vline
WA_FUDT_VDOCBKPF_STR-XREF2_HD sy-vline
WA_FUDT_VDOCBKPF_STR-XREVERSAL sy-vline
WA_FUDT_VDOCBKPF_STR-REINDAT sy-vline
WA_FUDT_VDOCBKPF_STR-RLDNR sy-vline
WA_FUDT_VDOCBKPF_STR-LDGRP sy-vline
WA_FUDT_VDOCBKPF_STR-PROPMANO sy-vline
WA_FUDT_VDOCBKPF_STR-XBLNR_ALT sy-vline
WA_FUDT_VDOCBKPF_STR-VATDATE sy-vline
WA_FUDT_VDOCBKPF_STR-DOCCAT sy-vline
WA_FUDT_VDOCBKPF_STR-XSPLIT sy-vline
WA_FUDT_VDOCBKPF_STR-CASH_ALLOC sy-vline
WA_FUDT_VDOCBKPF_STR-FOLLOW_ON sy-vline
WA_FUDT_VDOCBKPF_STR-XREORG sy-vline
WA_FUDT_VDOCBKPF_STR-SUBSET sy-vline
WA_FUDT_VDOCBKPF_STR-KURST sy-vline
WA_FUDT_VDOCBKPF_STR-KURSX sy-vline
WA_FUDT_VDOCBKPF_STR-KUR2X sy-vline
WA_FUDT_VDOCBKPF_STR-KUR3X sy-vline
WA_FUDT_VDOCBKPF_STR-XMCA sy-vline
WA_FUDT_VDOCBKPF_STR-PSOTY sy-vline
WA_FUDT_VDOCBKPF_STR-PSOAK sy-vline
WA_FUDT_VDOCBKPF_STR-PSOKS sy-vline
WA_FUDT_VDOCBKPF_STR-PSOSG sy-vline
WA_FUDT_VDOCBKPF_STR-PSOFN sy-vline
WA_FUDT_VDOCBKPF_STR-INTFORM sy-vline
WA_FUDT_VDOCBKPF_STR-INTDATE sy-vline
WA_FUDT_VDOCBKPF_STR-PSOBT sy-vline
WA_FUDT_VDOCBKPF_STR-PSOZL sy-vline
WA_FUDT_VDOCBKPF_STR-PSODT sy-vline
WA_FUDT_VDOCBKPF_STR-PSOTM sy-vline
WA_FUDT_VDOCBKPF_STR-FM_UMART sy-vline
WA_FUDT_VDOCBKPF_STR-CCINS sy-vline
WA_FUDT_VDOCBKPF_STR-CCNUM sy-vline
WA_FUDT_VDOCBKPF_STR-SSBLK sy-vline
WA_FUDT_VDOCBKPF_STR-BATCH sy-vline
WA_FUDT_VDOCBKPF_STR-SNAME sy-vline
WA_FUDT_VDOCBKPF_STR-SAMPLED sy-vline
WA_FUDT_VDOCBKPF_STR-EXCLUDE_FLAG sy-vline
WA_FUDT_VDOCBKPF_STR-BLIND sy-vline
WA_FUDT_VDOCBKPF_STR-OFFSET_STATUS sy-vline
WA_FUDT_VDOCBKPF_STR-OFFSET_REFER_DAT sy-vline
WA_FUDT_VDOCBKPF_STR-PENRC sy-vline
WA_FUDT_VDOCBKPF_STR-KNUMV sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.