ABAP Select data from SAP table V_JSBW_INVOICE 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 V_JSBW_INVOICE 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 V_JSBW_INVOICE. 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 V_JSBW_INVOICE 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_V_JSBW_INVOICE TYPE STANDARD TABLE OF V_JSBW_INVOICE,
      WA_V_JSBW_INVOICE TYPE V_JSBW_INVOICE,
      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: <V_JSBW_INVOICE> TYPE V_JSBW_INVOICE.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM V_JSBW_INVOICE
*  INTO TABLE @DATA(IT_V_JSBW_INVOICE2).
*--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_V_JSBW_INVOICE INDEX 1 INTO DATA(WA_V_JSBW_INVOICE2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_V_JSBW_INVOICE ASSIGNING <V_JSBW_INVOICE>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<V_JSBW_INVOICE>-MANDT = 1.
<V_JSBW_INVOICE>-VBELN = 1.
<V_JSBW_INVOICE>-FKART = 1.
<V_JSBW_INVOICE>-VBTYP = 1.
<V_JSBW_INVOICE>-WAERK = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_V_JSBW_INVOICE-VKORG, sy-vline,
WA_V_JSBW_INVOICE-VTWEG, sy-vline,
WA_V_JSBW_INVOICE-KALSM, sy-vline,
WA_V_JSBW_INVOICE-KNUMV, sy-vline,
WA_V_JSBW_INVOICE-FKDAT, sy-vline,
WA_V_JSBW_INVOICE-KONDA, sy-vline.
ENDLOOP. *Add any further fields from structure WA_V_JSBW_INVOICE 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_V_JSBW_INVOICE 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_V_JSBW_INVOICE INTO WA_V_JSBW_INVOICE. *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 VBELN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_V_JSBW_INVOICE-VBELN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_JSBW_INVOICE-VBELN.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit MCAMP, internal->external for field CAMPAIGN CALL FUNCTION 'CONVERSION_EXIT_MCAMP_OUTPUT' EXPORTING input = WA_V_JSBW_INVOICE-CAMPAIGN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_JSBW_INVOICE-CAMPAIGN.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field ISPADRNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_V_JSBW_INVOICE-ISPADRNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_JSBW_INVOICE-ISPADRNR.
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_V_JSBW_INVOICE_STR,
MANDT TYPE STRING,
VBELN TYPE STRING,
FKART TYPE STRING,
VBTYP TYPE STRING,
WAERK TYPE STRING,
VKORG TYPE STRING,
VTWEG TYPE STRING,
KALSM TYPE STRING,
KNUMV TYPE STRING,
FKDAT TYPE STRING,
KONDA TYPE STRING,
KDGRP TYPE STRING,
PLTYP TYPE STRING,
ZLSCH TYPE STRING,
KTGRD TYPE STRING,
REGIO TYPE STRING,
COUNC TYPE STRING,
CITYC TYPE STRING,
BUKRS TYPE STRING,
KUNRG TYPE STRING,
KUNAG TYPE STRING,
ISPSHKZGK TYPE STRING,
ISPSTOGRD TYPE STRING,
ISPXINK TYPE STRING,
ISPXWBZABO TYPE STRING,
ISPINKVSG TYPE STRING,
ISPINKGP TYPE STRING,
ISPXVDICHT TYPE STRING,
XRENEWAL TYPE STRING,
POSNR TYPE STRING,
FKIMG TYPE STRING,
VRKME TYPE STRING,
MEINS TYPE STRING,
GSBER TYPE STRING,
FBUDA TYPE STRING,
NETWR TYPE STRING,
MATKL TYPE STRING,
SPART TYPE STRING,
WERKS TYPE STRING,
ALAND TYPE STRING,
WKREG TYPE STRING,
WKCOU TYPE STRING,
WKCTY TYPE STRING,
SKFBP TYPE STRING,
SPARA TYPE STRING,
SHKZG TYPE STRING,
ERNAM TYPE STRING,
ERDAT TYPE STRING,
ERZET TYPE STRING,
STAFO TYPE STRING,
WAVWR TYPE STRING,
ISPAUART TYPE STRING,
ISPAUAGRP TYPE STRING,
ISPKOSTL_L TYPE STRING,
ISPDRERZ TYPE STRING,
ISPPVA TYPE STRING,
ISPBEZ TYPE STRING,
ISPLIFART TYPE STRING,
ISPPOSEX TYPE STRING,
ISPVBELN TYPE STRING,
ISPPOSNR TYPE STRING,
ISPETENR TYPE STRING,
ISPETEEX TYPE STRING,
ISPETART TYPE STRING,
ISPETMENGE TYPE STRING,
ISPETMEINS TYPE STRING,
ISPETVOR TYPE STRING,
ISPANZET TYPE STRING,
ISPERSDAT TYPE STRING,
ISPWRBAKT TYPE STRING,
ISPFAKVON TYPE STRING,
ISPFAKBIS TYPE STRING,
ISPKONDA TYPE STRING,
ISPKDGRP TYPE STRING,
ISPPOART TYPE STRING,
ISPBRTWR_P TYPE STRING,
ISPVERSDAT TYPE STRING,
ISPLANDE TYPE STRING,
ISPVAUSGB TYPE STRING,
ISPVKBURZU TYPE STRING,
ISPXFKRUEK TYPE STRING,
ISPIVWKN TYPE STRING,
ISPXIVW TYPE STRING,
XNEGOPTION TYPE STRING,
IVWDATUM TYPE STRING,
CAMPAIGN TYPE STRING,
FKPERVON TYPE STRING,
FKPERBIS TYPE STRING,
ISPZSKLS TYPE STRING,
ISPWRBART TYPE STRING,
POSNR_UR TYPE STRING,
CYCLENR TYPE STRING,
FAKNRRUECK TYPE STRING,
XAUTO_REN TYPE STRING,
X_MONTAG TYPE STRING,
X_DIENSTAG TYPE STRING,
X_MITTWOCH TYPE STRING,
X_DONNETAG TYPE STRING,
X_FREITAG TYPE STRING,
X_SAMSTAG TYPE STRING,
X_SONNTAG TYPE STRING,
VBELN_FROM TYPE STRING,
POSNR_UR_FROM TYPE STRING,
CYCLENR_FROM TYPE STRING,
PARVW TYPE STRING,
KUNNR TYPE STRING,
ADRNR TYPE STRING,
LAND1 TYPE STRING,
ISPADRNR TYPE STRING,
ISPADRVAR TYPE STRING,END OF T_EKKO_STR. DATA: WA_V_JSBW_INVOICE_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_V_JSBW_INVOICE_STR-MANDT sy-vline
WA_V_JSBW_INVOICE_STR-VBELN sy-vline
WA_V_JSBW_INVOICE_STR-FKART sy-vline
WA_V_JSBW_INVOICE_STR-VBTYP sy-vline
WA_V_JSBW_INVOICE_STR-WAERK sy-vline
WA_V_JSBW_INVOICE_STR-VKORG sy-vline
WA_V_JSBW_INVOICE_STR-VTWEG sy-vline
WA_V_JSBW_INVOICE_STR-KALSM sy-vline
WA_V_JSBW_INVOICE_STR-KNUMV sy-vline
WA_V_JSBW_INVOICE_STR-FKDAT sy-vline
WA_V_JSBW_INVOICE_STR-KONDA sy-vline
WA_V_JSBW_INVOICE_STR-KDGRP sy-vline
WA_V_JSBW_INVOICE_STR-PLTYP sy-vline
WA_V_JSBW_INVOICE_STR-ZLSCH sy-vline
WA_V_JSBW_INVOICE_STR-KTGRD sy-vline
WA_V_JSBW_INVOICE_STR-REGIO sy-vline
WA_V_JSBW_INVOICE_STR-COUNC sy-vline
WA_V_JSBW_INVOICE_STR-CITYC sy-vline
WA_V_JSBW_INVOICE_STR-BUKRS sy-vline
WA_V_JSBW_INVOICE_STR-KUNRG sy-vline
WA_V_JSBW_INVOICE_STR-KUNAG sy-vline
WA_V_JSBW_INVOICE_STR-ISPSHKZGK sy-vline
WA_V_JSBW_INVOICE_STR-ISPSTOGRD sy-vline
WA_V_JSBW_INVOICE_STR-ISPXINK sy-vline
WA_V_JSBW_INVOICE_STR-ISPXWBZABO sy-vline
WA_V_JSBW_INVOICE_STR-ISPINKVSG sy-vline
WA_V_JSBW_INVOICE_STR-ISPINKGP sy-vline
WA_V_JSBW_INVOICE_STR-ISPXVDICHT sy-vline
WA_V_JSBW_INVOICE_STR-XRENEWAL sy-vline
WA_V_JSBW_INVOICE_STR-POSNR sy-vline
WA_V_JSBW_INVOICE_STR-FKIMG sy-vline
WA_V_JSBW_INVOICE_STR-VRKME sy-vline
WA_V_JSBW_INVOICE_STR-MEINS sy-vline
WA_V_JSBW_INVOICE_STR-GSBER sy-vline
WA_V_JSBW_INVOICE_STR-FBUDA sy-vline
WA_V_JSBW_INVOICE_STR-NETWR sy-vline
WA_V_JSBW_INVOICE_STR-MATKL sy-vline
WA_V_JSBW_INVOICE_STR-SPART sy-vline
WA_V_JSBW_INVOICE_STR-WERKS sy-vline
WA_V_JSBW_INVOICE_STR-ALAND sy-vline
WA_V_JSBW_INVOICE_STR-WKREG sy-vline
WA_V_JSBW_INVOICE_STR-WKCOU sy-vline
WA_V_JSBW_INVOICE_STR-WKCTY sy-vline
WA_V_JSBW_INVOICE_STR-SKFBP sy-vline
WA_V_JSBW_INVOICE_STR-SPARA sy-vline
WA_V_JSBW_INVOICE_STR-SHKZG sy-vline
WA_V_JSBW_INVOICE_STR-ERNAM sy-vline
WA_V_JSBW_INVOICE_STR-ERDAT sy-vline
WA_V_JSBW_INVOICE_STR-ERZET sy-vline
WA_V_JSBW_INVOICE_STR-STAFO sy-vline
WA_V_JSBW_INVOICE_STR-WAVWR sy-vline
WA_V_JSBW_INVOICE_STR-ISPAUART sy-vline
WA_V_JSBW_INVOICE_STR-ISPAUAGRP sy-vline
WA_V_JSBW_INVOICE_STR-ISPKOSTL_L sy-vline
WA_V_JSBW_INVOICE_STR-ISPDRERZ sy-vline
WA_V_JSBW_INVOICE_STR-ISPPVA sy-vline
WA_V_JSBW_INVOICE_STR-ISPBEZ sy-vline
WA_V_JSBW_INVOICE_STR-ISPLIFART sy-vline
WA_V_JSBW_INVOICE_STR-ISPPOSEX sy-vline
WA_V_JSBW_INVOICE_STR-ISPVBELN sy-vline
WA_V_JSBW_INVOICE_STR-ISPPOSNR sy-vline
WA_V_JSBW_INVOICE_STR-ISPETENR sy-vline
WA_V_JSBW_INVOICE_STR-ISPETEEX sy-vline
WA_V_JSBW_INVOICE_STR-ISPETART sy-vline
WA_V_JSBW_INVOICE_STR-ISPETMENGE sy-vline
WA_V_JSBW_INVOICE_STR-ISPETMEINS sy-vline
WA_V_JSBW_INVOICE_STR-ISPETVOR sy-vline
WA_V_JSBW_INVOICE_STR-ISPANZET sy-vline
WA_V_JSBW_INVOICE_STR-ISPERSDAT sy-vline
WA_V_JSBW_INVOICE_STR-ISPWRBAKT sy-vline
WA_V_JSBW_INVOICE_STR-ISPFAKVON sy-vline
WA_V_JSBW_INVOICE_STR-ISPFAKBIS sy-vline
WA_V_JSBW_INVOICE_STR-ISPKONDA sy-vline
WA_V_JSBW_INVOICE_STR-ISPKDGRP sy-vline
WA_V_JSBW_INVOICE_STR-ISPPOART sy-vline
WA_V_JSBW_INVOICE_STR-ISPBRTWR_P sy-vline
WA_V_JSBW_INVOICE_STR-ISPVERSDAT sy-vline
WA_V_JSBW_INVOICE_STR-ISPLANDE sy-vline
WA_V_JSBW_INVOICE_STR-ISPVAUSGB sy-vline
WA_V_JSBW_INVOICE_STR-ISPVKBURZU sy-vline
WA_V_JSBW_INVOICE_STR-ISPXFKRUEK sy-vline
WA_V_JSBW_INVOICE_STR-ISPIVWKN sy-vline
WA_V_JSBW_INVOICE_STR-ISPXIVW sy-vline
WA_V_JSBW_INVOICE_STR-XNEGOPTION sy-vline
WA_V_JSBW_INVOICE_STR-IVWDATUM sy-vline
WA_V_JSBW_INVOICE_STR-CAMPAIGN sy-vline
WA_V_JSBW_INVOICE_STR-FKPERVON sy-vline
WA_V_JSBW_INVOICE_STR-FKPERBIS sy-vline
WA_V_JSBW_INVOICE_STR-ISPZSKLS sy-vline
WA_V_JSBW_INVOICE_STR-ISPWRBART sy-vline
WA_V_JSBW_INVOICE_STR-POSNR_UR sy-vline
WA_V_JSBW_INVOICE_STR-CYCLENR sy-vline
WA_V_JSBW_INVOICE_STR-FAKNRRUECK sy-vline
WA_V_JSBW_INVOICE_STR-XAUTO_REN sy-vline
WA_V_JSBW_INVOICE_STR-X_MONTAG sy-vline
WA_V_JSBW_INVOICE_STR-X_DIENSTAG sy-vline
WA_V_JSBW_INVOICE_STR-X_MITTWOCH sy-vline
WA_V_JSBW_INVOICE_STR-X_DONNETAG sy-vline
WA_V_JSBW_INVOICE_STR-X_FREITAG sy-vline
WA_V_JSBW_INVOICE_STR-X_SAMSTAG sy-vline
WA_V_JSBW_INVOICE_STR-X_SONNTAG sy-vline
WA_V_JSBW_INVOICE_STR-VBELN_FROM sy-vline
WA_V_JSBW_INVOICE_STR-POSNR_UR_FROM sy-vline
WA_V_JSBW_INVOICE_STR-CYCLENR_FROM sy-vline
WA_V_JSBW_INVOICE_STR-PARVW sy-vline
WA_V_JSBW_INVOICE_STR-KUNNR sy-vline
WA_V_JSBW_INVOICE_STR-ADRNR sy-vline
WA_V_JSBW_INVOICE_STR-LAND1 sy-vline
WA_V_JSBW_INVOICE_STR-ISPADRNR sy-vline
WA_V_JSBW_INVOICE_STR-ISPADRVAR sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.