ABAP Select data from SAP table WZRE_WBRK_WBRP 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 WZRE_WBRK_WBRP 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 WZRE_WBRK_WBRP. 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 WZRE_WBRK_WBRP 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_WZRE_WBRK_WBRP TYPE STANDARD TABLE OF WZRE_WBRK_WBRP,
      WA_WZRE_WBRK_WBRP TYPE WZRE_WBRK_WBRP,
      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: <WZRE_WBRK_WBRP> TYPE WZRE_WBRK_WBRP.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM WZRE_WBRK_WBRP
*  INTO TABLE @DATA(IT_WZRE_WBRK_WBRP2).
*--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_WZRE_WBRK_WBRP INDEX 1 INTO DATA(WA_WZRE_WBRK_WBRP2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_WZRE_WBRK_WBRP ASSIGNING <WZRE_WBRK_WBRP>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<WZRE_WBRK_WBRP>-MANDT = 1.
<WZRE_WBRK_WBRP>-WBELN = 1.
<WZRE_WBRK_WBRP>-HLFART = 1.
<WZRE_WBRK_WBRP>-HLFTYP = 1.
<WZRE_WBRK_WBRP>-HWRART = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_WZRE_WBRK_WBRP-HWBTYP, sy-vline,
WA_WZRE_WBRK_WBRP-HWRTYP, sy-vline,
WA_WZRE_WBRK_WBRP-HABART, sy-vline,
WA_WZRE_WBRK_WBRP-HKALSM, sy-vline,
WA_WZRE_WBRK_WBRP-HKALSMD, sy-vline,
WA_WZRE_WBRK_WBRP-HWFDAT, sy-vline.
ENDLOOP. *Add any further fields from structure WA_WZRE_WBRK_WBRP 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_WZRE_WBRK_WBRP 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_WZRE_WBRK_WBRP INTO WA_WZRE_WBRK_WBRP. *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 WBELN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WZRE_WBRK_WBRP-WBELN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WZRE_WBRK_WBRP-WBELN.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field IAUFNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WZRE_WBRK_WBRP-IAUFNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WZRE_WBRK_WBRP-IAUFNR.
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_WZRE_WBRK_WBRP_STR,
MANDT TYPE STRING,
WBELN TYPE STRING,
HLFART TYPE STRING,
HLFTYP TYPE STRING,
HWRART TYPE STRING,
HWBTYP TYPE STRING,
HWRTYP TYPE STRING,
HABART TYPE STRING,
HKALSM TYPE STRING,
HKALSMD TYPE STRING,
HWFDAT TYPE STRING,
HRFBSK TYPE STRING,
HLIFRE TYPE STRING,
HLNRZB TYPE STRING,
HKUNRE TYPE STRING,
HKUNRG TYPE STRING,
HEKORG TYPE STRING,
HVKORG TYPE STRING,
HVTWEG TYPE STRING,
HSPART TYPE STRING,
HBUKRS TYPE STRING,
HERZET TYPE STRING,
HERDAT TYPE STRING,
HERNAM TYPE STRING,
HAEDAT TYPE STRING,
HBLDAT TYPE STRING,
HXBLNR TYPE STRING,
HZUONR TYPE STRING,
HWAERL TYPE STRING,
HWSTWAE TYPE STRING,
HWKURS TYPE STRING,
HSTCUR TYPE STRING,
HKUFIX TYPE STRING,
HWKURS_DAT TYPE STRING,
HBRTWR TYPE STRING,
HZTERM TYPE STRING,
HZBD1T TYPE STRING,
HZBD1P TYPE STRING,
HZBD2T TYPE STRING,
HZBD2P TYPE STRING,
HZBD3T TYPE STRING,
HZLSCH TYPE STRING,
HNETWR TYPE STRING,
HNETWRD TYPE STRING,
HBRTWRD TYPE STRING,
HZTERMD TYPE STRING,
HZBD1TD TYPE STRING,
HZBD1PD TYPE STRING,
HZBD2TD TYPE STRING,
HZBD2PD TYPE STRING,
HZBD3TD TYPE STRING,
HZLSCHD TYPE STRING,
HGSKTOD TYPE STRING,
HGSKTO TYPE STRING,
HFKSTO TYPE STRING,
HKAPPL TYPE STRING,
HKNUMV TYPE STRING,
HKNUMVD TYPE STRING,
HSTAFO TYPE STRING,
HLFAKS TYPE STRING,
HKNUMA TYPE STRING,
HLFART_RL TYPE STRING,
HWFDAT_RL TYPE STRING,
HWBELN_RL TYPE STRING,
HEKGRP TYPE STRING,
HVALTG TYPE STRING,
HVALDT TYPE STRING,
HMWSBK TYPE STRING,
HMWSBKD TYPE STRING,
HNAVNK TYPE STRING,
HLOGSYS TYPE STRING,
HDIEKZ TYPE STRING,
HLANDL TYPE STRING,
HLZBKZ TYPE STRING,
HKKBER TYPE STRING,
HLFGRU TYPE STRING,
HVALTGD TYPE STRING,
HVALDTD TYPE STRING,
HKIDNO TYPE STRING,
WDTYP TYPE STRING,
HWKURS_P1 TYPE STRING,
HWKURS_P2 TYPE STRING,
HWPYCUR_P1 TYPE STRING,
HWPYCUR_P2 TYPE STRING,
HESTATUS TYPE STRING,
HKURST TYPE STRING,
HVKBUR TYPE STRING,
HVKGRP TYPE STRING,
HSETTLE_DOC TYPE STRING,
HFKSTO_PART TYPE STRING,
HPOST_PARTY TYPE STRING,
HCPDK_ADDR TYPE STRING,
HFKSTO_PARTY TYPE STRING,
HCONTRACT TYPE STRING,
HCONTRACT_TYPE TYPE STRING,
HCOLLECTION_TYPE TYPE STRING,
HSETTLE_CATEGORY TYPE STRING,
HCMWAE TYPE STRING,
HCTLPC TYPE STRING,
HCM_AMOUNT TYPE STRING,
HIDOBJ_TYPE_V TYPE STRING,
HIDOBJ_VENDOR TYPE STRING,
HIDOBJ_TYPE_C TYPE STRING,
HIDOBJ_CUSTOMER TYPE STRING,
HPOSTING_RULE_K TYPE STRING,
HPOSTING_RULE_D TYPE STRING,
HPOSTING_RULE_A TYPE STRING,
HVKONT TYPE STRING,
HWT_ACTIVE TYPE STRING,
HBUKRS_DEB TYPE STRING,
HINCO1 TYPE STRING,
HINCO2 TYPE STRING,
IMANDT TYPE STRING,
IWBELN TYPE STRING,
IPOSNR TYPE STRING,
IMATNR TYPE STRING,
IMATKL TYPE STRING,
IWERKS TYPE STRING,
IMWSKZ TYPE STRING,
IMWSK2 TYPE STRING,
IPRSDT TYPE STRING,
IMENGE TYPE STRING,
INETPR TYPE STRING,
IPEINH TYPE STRING,
IWFKME TYPE STRING,
IUMREZ TYPE STRING,
IUMREN TYPE STRING,
IFPRME TYPE STRING,
IFPUMZ TYPE STRING,
IFPUMN TYPE STRING,
IMEINS TYPE STRING,
INTGEW TYPE STRING,
IBRGEW TYPE STRING,
IGEWEI TYPE STRING,
IVOLUM TYPE STRING,
IVOLEH TYPE STRING,
ISTAFO TYPE STRING,
IMTART TYPE STRING,
INETWR TYPE STRING,
IBRTWR TYPE STRING,
IKZWI1 TYPE STRING,
IKZWI2 TYPE STRING,
IKZWI3 TYPE STRING,
IKZWI4 TYPE STRING,
IKZWI5 TYPE STRING,
IKZWI6 TYPE STRING,
IBONBA TYPE STRING,
IEFFWR TYPE STRING,
IERNAM TYPE STRING,
IERDAT TYPE STRING,
IERZET TYPE STRING,
IKOWRR TYPE STRING,
ISKTOF TYPE STRING,
ISKFBP TYPE STRING,
INETWRD TYPE STRING,
IBRTWRD TYPE STRING,
IKZWI1D TYPE STRING,
IKZWI2D TYPE STRING,
IKZWI3D TYPE STRING,
IKZWI4D TYPE STRING,
IKZWI5D TYPE STRING,
IKZWI6D TYPE STRING,
IBONBAD TYPE STRING,
ISKFBPD TYPE STRING,
IEFFWRD TYPE STRING,
IMWSBPD TYPE STRING,
IWBELNV TYPE STRING,
IPOSNRV TYPE STRING,
ILFTYPV TYPE STRING,
IGJAHRV TYPE STRING,
IAKTNR TYPE STRING,
ILFGRU TYPE STRING,
IARKTX TYPE STRING,
IINFNR TYPE STRING,
IIDNLF TYPE STRING,
IMWSBP TYPE STRING,
ITXJCD TYPE STRING,
IEBONF TYPE STRING,
IBONUS TYPE STRING,
IEBON2 TYPE STRING,
IEBON3 TYPE STRING,
ILTSNR TYPE STRING,
IEKKOL TYPE STRING,
IPUNEI TYPE STRING,
IANZPU TYPE STRING,
IKOLIF TYPE STRING,
INAVNW TYPE STRING,
IBWTAR TYPE STRING,
IBWTTY TYPE STRING,
IGSBER TYPE STRING,
IPAOBJNR TYPE STRING,
IKOSTL TYPE STRING,
IPRCTR TYPE STRING,
IKOKRS TYPE STRING,
ICHARG TYPE STRING,
IWUVPRS TYPE STRING,
IWBELN_V TYPE STRING,
IPOSNR_V TYPE STRING,
IFTYPV_V TYPE STRING,
IITEMCAT TYPE STRING,
IMATBF TYPE STRING,
IMWERT_IM TYPE STRING,
IMWERT_PR TYPE STRING,
IMWERT_UM TYPE STRING,
ICONTRACT TYPE STRING,
ICONTRACT_TYPE TYPE STRING,
ICUOBJ TYPE STRING,
IITEM_CANCELED TYPE STRING,
IIDNLF_TYPE TYPE STRING,
IITEM_STATUS TYPE STRING,
IGUID_REF TYPE STRING,
IBEMOT TYPE STRING,
IAUFNR TYPE STRING,
IINCO1_P TYPE STRING,
IINCO2_P TYPE STRING,END OF T_EKKO_STR. DATA: WA_WZRE_WBRK_WBRP_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_WZRE_WBRK_WBRP_STR-MANDT sy-vline
WA_WZRE_WBRK_WBRP_STR-WBELN sy-vline
WA_WZRE_WBRK_WBRP_STR-HLFART sy-vline
WA_WZRE_WBRK_WBRP_STR-HLFTYP sy-vline
WA_WZRE_WBRK_WBRP_STR-HWRART sy-vline
WA_WZRE_WBRK_WBRP_STR-HWBTYP sy-vline
WA_WZRE_WBRK_WBRP_STR-HWRTYP sy-vline
WA_WZRE_WBRK_WBRP_STR-HABART sy-vline
WA_WZRE_WBRK_WBRP_STR-HKALSM sy-vline
WA_WZRE_WBRK_WBRP_STR-HKALSMD sy-vline
WA_WZRE_WBRK_WBRP_STR-HWFDAT sy-vline
WA_WZRE_WBRK_WBRP_STR-HRFBSK sy-vline
WA_WZRE_WBRK_WBRP_STR-HLIFRE sy-vline
WA_WZRE_WBRK_WBRP_STR-HLNRZB sy-vline
WA_WZRE_WBRK_WBRP_STR-HKUNRE sy-vline
WA_WZRE_WBRK_WBRP_STR-HKUNRG sy-vline
WA_WZRE_WBRK_WBRP_STR-HEKORG sy-vline
WA_WZRE_WBRK_WBRP_STR-HVKORG sy-vline
WA_WZRE_WBRK_WBRP_STR-HVTWEG sy-vline
WA_WZRE_WBRK_WBRP_STR-HSPART sy-vline
WA_WZRE_WBRK_WBRP_STR-HBUKRS sy-vline
WA_WZRE_WBRK_WBRP_STR-HERZET sy-vline
WA_WZRE_WBRK_WBRP_STR-HERDAT sy-vline
WA_WZRE_WBRK_WBRP_STR-HERNAM sy-vline
WA_WZRE_WBRK_WBRP_STR-HAEDAT sy-vline
WA_WZRE_WBRK_WBRP_STR-HBLDAT sy-vline
WA_WZRE_WBRK_WBRP_STR-HXBLNR sy-vline
WA_WZRE_WBRK_WBRP_STR-HZUONR sy-vline
WA_WZRE_WBRK_WBRP_STR-HWAERL sy-vline
WA_WZRE_WBRK_WBRP_STR-HWSTWAE sy-vline
WA_WZRE_WBRK_WBRP_STR-HWKURS sy-vline
WA_WZRE_WBRK_WBRP_STR-HSTCUR sy-vline
WA_WZRE_WBRK_WBRP_STR-HKUFIX sy-vline
WA_WZRE_WBRK_WBRP_STR-HWKURS_DAT sy-vline
WA_WZRE_WBRK_WBRP_STR-HBRTWR sy-vline
WA_WZRE_WBRK_WBRP_STR-HZTERM sy-vline
WA_WZRE_WBRK_WBRP_STR-HZBD1T sy-vline
WA_WZRE_WBRK_WBRP_STR-HZBD1P sy-vline
WA_WZRE_WBRK_WBRP_STR-HZBD2T sy-vline
WA_WZRE_WBRK_WBRP_STR-HZBD2P sy-vline
WA_WZRE_WBRK_WBRP_STR-HZBD3T sy-vline
WA_WZRE_WBRK_WBRP_STR-HZLSCH sy-vline
WA_WZRE_WBRK_WBRP_STR-HNETWR sy-vline
WA_WZRE_WBRK_WBRP_STR-HNETWRD sy-vline
WA_WZRE_WBRK_WBRP_STR-HBRTWRD sy-vline
WA_WZRE_WBRK_WBRP_STR-HZTERMD sy-vline
WA_WZRE_WBRK_WBRP_STR-HZBD1TD sy-vline
WA_WZRE_WBRK_WBRP_STR-HZBD1PD sy-vline
WA_WZRE_WBRK_WBRP_STR-HZBD2TD sy-vline
WA_WZRE_WBRK_WBRP_STR-HZBD2PD sy-vline
WA_WZRE_WBRK_WBRP_STR-HZBD3TD sy-vline
WA_WZRE_WBRK_WBRP_STR-HZLSCHD sy-vline
WA_WZRE_WBRK_WBRP_STR-HGSKTOD sy-vline
WA_WZRE_WBRK_WBRP_STR-HGSKTO sy-vline
WA_WZRE_WBRK_WBRP_STR-HFKSTO sy-vline
WA_WZRE_WBRK_WBRP_STR-HKAPPL sy-vline
WA_WZRE_WBRK_WBRP_STR-HKNUMV sy-vline
WA_WZRE_WBRK_WBRP_STR-HKNUMVD sy-vline
WA_WZRE_WBRK_WBRP_STR-HSTAFO sy-vline
WA_WZRE_WBRK_WBRP_STR-HLFAKS sy-vline
WA_WZRE_WBRK_WBRP_STR-HKNUMA sy-vline
WA_WZRE_WBRK_WBRP_STR-HLFART_RL sy-vline
WA_WZRE_WBRK_WBRP_STR-HWFDAT_RL sy-vline
WA_WZRE_WBRK_WBRP_STR-HWBELN_RL sy-vline
WA_WZRE_WBRK_WBRP_STR-HEKGRP sy-vline
WA_WZRE_WBRK_WBRP_STR-HVALTG sy-vline
WA_WZRE_WBRK_WBRP_STR-HVALDT sy-vline
WA_WZRE_WBRK_WBRP_STR-HMWSBK sy-vline
WA_WZRE_WBRK_WBRP_STR-HMWSBKD sy-vline
WA_WZRE_WBRK_WBRP_STR-HNAVNK sy-vline
WA_WZRE_WBRK_WBRP_STR-HLOGSYS sy-vline
WA_WZRE_WBRK_WBRP_STR-HDIEKZ sy-vline
WA_WZRE_WBRK_WBRP_STR-HLANDL sy-vline
WA_WZRE_WBRK_WBRP_STR-HLZBKZ sy-vline
WA_WZRE_WBRK_WBRP_STR-HKKBER sy-vline
WA_WZRE_WBRK_WBRP_STR-HLFGRU sy-vline
WA_WZRE_WBRK_WBRP_STR-HVALTGD sy-vline
WA_WZRE_WBRK_WBRP_STR-HVALDTD sy-vline
WA_WZRE_WBRK_WBRP_STR-HKIDNO sy-vline
WA_WZRE_WBRK_WBRP_STR-WDTYP sy-vline
WA_WZRE_WBRK_WBRP_STR-HWKURS_P1 sy-vline
WA_WZRE_WBRK_WBRP_STR-HWKURS_P2 sy-vline
WA_WZRE_WBRK_WBRP_STR-HWPYCUR_P1 sy-vline
WA_WZRE_WBRK_WBRP_STR-HWPYCUR_P2 sy-vline
WA_WZRE_WBRK_WBRP_STR-HESTATUS sy-vline
WA_WZRE_WBRK_WBRP_STR-HKURST sy-vline
WA_WZRE_WBRK_WBRP_STR-HVKBUR sy-vline
WA_WZRE_WBRK_WBRP_STR-HVKGRP sy-vline
WA_WZRE_WBRK_WBRP_STR-HSETTLE_DOC sy-vline
WA_WZRE_WBRK_WBRP_STR-HFKSTO_PART sy-vline
WA_WZRE_WBRK_WBRP_STR-HPOST_PARTY sy-vline
WA_WZRE_WBRK_WBRP_STR-HCPDK_ADDR sy-vline
WA_WZRE_WBRK_WBRP_STR-HFKSTO_PARTY sy-vline
WA_WZRE_WBRK_WBRP_STR-HCONTRACT sy-vline
WA_WZRE_WBRK_WBRP_STR-HCONTRACT_TYPE sy-vline
WA_WZRE_WBRK_WBRP_STR-HCOLLECTION_TYPE sy-vline
WA_WZRE_WBRK_WBRP_STR-HSETTLE_CATEGORY sy-vline
WA_WZRE_WBRK_WBRP_STR-HCMWAE sy-vline
WA_WZRE_WBRK_WBRP_STR-HCTLPC sy-vline
WA_WZRE_WBRK_WBRP_STR-HCM_AMOUNT sy-vline
WA_WZRE_WBRK_WBRP_STR-HIDOBJ_TYPE_V sy-vline
WA_WZRE_WBRK_WBRP_STR-HIDOBJ_VENDOR sy-vline
WA_WZRE_WBRK_WBRP_STR-HIDOBJ_TYPE_C sy-vline
WA_WZRE_WBRK_WBRP_STR-HIDOBJ_CUSTOMER sy-vline
WA_WZRE_WBRK_WBRP_STR-HPOSTING_RULE_K sy-vline
WA_WZRE_WBRK_WBRP_STR-HPOSTING_RULE_D sy-vline
WA_WZRE_WBRK_WBRP_STR-HPOSTING_RULE_A sy-vline
WA_WZRE_WBRK_WBRP_STR-HVKONT sy-vline
WA_WZRE_WBRK_WBRP_STR-HWT_ACTIVE sy-vline
WA_WZRE_WBRK_WBRP_STR-HBUKRS_DEB sy-vline
WA_WZRE_WBRK_WBRP_STR-HINCO1 sy-vline
WA_WZRE_WBRK_WBRP_STR-HINCO2 sy-vline
WA_WZRE_WBRK_WBRP_STR-IMANDT sy-vline
WA_WZRE_WBRK_WBRP_STR-IWBELN sy-vline
WA_WZRE_WBRK_WBRP_STR-IPOSNR sy-vline
WA_WZRE_WBRK_WBRP_STR-IMATNR sy-vline
WA_WZRE_WBRK_WBRP_STR-IMATKL sy-vline
WA_WZRE_WBRK_WBRP_STR-IWERKS sy-vline
WA_WZRE_WBRK_WBRP_STR-IMWSKZ sy-vline
WA_WZRE_WBRK_WBRP_STR-IMWSK2 sy-vline
WA_WZRE_WBRK_WBRP_STR-IPRSDT sy-vline
WA_WZRE_WBRK_WBRP_STR-IMENGE sy-vline
WA_WZRE_WBRK_WBRP_STR-INETPR sy-vline
WA_WZRE_WBRK_WBRP_STR-IPEINH sy-vline
WA_WZRE_WBRK_WBRP_STR-IWFKME sy-vline
WA_WZRE_WBRK_WBRP_STR-IUMREZ sy-vline
WA_WZRE_WBRK_WBRP_STR-IUMREN sy-vline
WA_WZRE_WBRK_WBRP_STR-IFPRME sy-vline
WA_WZRE_WBRK_WBRP_STR-IFPUMZ sy-vline
WA_WZRE_WBRK_WBRP_STR-IFPUMN sy-vline
WA_WZRE_WBRK_WBRP_STR-IMEINS sy-vline
WA_WZRE_WBRK_WBRP_STR-INTGEW sy-vline
WA_WZRE_WBRK_WBRP_STR-IBRGEW sy-vline
WA_WZRE_WBRK_WBRP_STR-IGEWEI sy-vline
WA_WZRE_WBRK_WBRP_STR-IVOLUM sy-vline
WA_WZRE_WBRK_WBRP_STR-IVOLEH sy-vline
WA_WZRE_WBRK_WBRP_STR-ISTAFO sy-vline
WA_WZRE_WBRK_WBRP_STR-IMTART sy-vline
WA_WZRE_WBRK_WBRP_STR-INETWR sy-vline
WA_WZRE_WBRK_WBRP_STR-IBRTWR sy-vline
WA_WZRE_WBRK_WBRP_STR-IKZWI1 sy-vline
WA_WZRE_WBRK_WBRP_STR-IKZWI2 sy-vline
WA_WZRE_WBRK_WBRP_STR-IKZWI3 sy-vline
WA_WZRE_WBRK_WBRP_STR-IKZWI4 sy-vline
WA_WZRE_WBRK_WBRP_STR-IKZWI5 sy-vline
WA_WZRE_WBRK_WBRP_STR-IKZWI6 sy-vline
WA_WZRE_WBRK_WBRP_STR-IBONBA sy-vline
WA_WZRE_WBRK_WBRP_STR-IEFFWR sy-vline
WA_WZRE_WBRK_WBRP_STR-IERNAM sy-vline
WA_WZRE_WBRK_WBRP_STR-IERDAT sy-vline
WA_WZRE_WBRK_WBRP_STR-IERZET sy-vline
WA_WZRE_WBRK_WBRP_STR-IKOWRR sy-vline
WA_WZRE_WBRK_WBRP_STR-ISKTOF sy-vline
WA_WZRE_WBRK_WBRP_STR-ISKFBP sy-vline
WA_WZRE_WBRK_WBRP_STR-INETWRD sy-vline
WA_WZRE_WBRK_WBRP_STR-IBRTWRD sy-vline
WA_WZRE_WBRK_WBRP_STR-IKZWI1D sy-vline
WA_WZRE_WBRK_WBRP_STR-IKZWI2D sy-vline
WA_WZRE_WBRK_WBRP_STR-IKZWI3D sy-vline
WA_WZRE_WBRK_WBRP_STR-IKZWI4D sy-vline
WA_WZRE_WBRK_WBRP_STR-IKZWI5D sy-vline
WA_WZRE_WBRK_WBRP_STR-IKZWI6D sy-vline
WA_WZRE_WBRK_WBRP_STR-IBONBAD sy-vline
WA_WZRE_WBRK_WBRP_STR-ISKFBPD sy-vline
WA_WZRE_WBRK_WBRP_STR-IEFFWRD sy-vline
WA_WZRE_WBRK_WBRP_STR-IMWSBPD sy-vline
WA_WZRE_WBRK_WBRP_STR-IWBELNV sy-vline
WA_WZRE_WBRK_WBRP_STR-IPOSNRV sy-vline
WA_WZRE_WBRK_WBRP_STR-ILFTYPV sy-vline
WA_WZRE_WBRK_WBRP_STR-IGJAHRV sy-vline
WA_WZRE_WBRK_WBRP_STR-IAKTNR sy-vline
WA_WZRE_WBRK_WBRP_STR-ILFGRU sy-vline
WA_WZRE_WBRK_WBRP_STR-IARKTX sy-vline
WA_WZRE_WBRK_WBRP_STR-IINFNR sy-vline
WA_WZRE_WBRK_WBRP_STR-IIDNLF sy-vline
WA_WZRE_WBRK_WBRP_STR-IMWSBP sy-vline
WA_WZRE_WBRK_WBRP_STR-ITXJCD sy-vline
WA_WZRE_WBRK_WBRP_STR-IEBONF sy-vline
WA_WZRE_WBRK_WBRP_STR-IBONUS sy-vline
WA_WZRE_WBRK_WBRP_STR-IEBON2 sy-vline
WA_WZRE_WBRK_WBRP_STR-IEBON3 sy-vline
WA_WZRE_WBRK_WBRP_STR-ILTSNR sy-vline
WA_WZRE_WBRK_WBRP_STR-IEKKOL sy-vline
WA_WZRE_WBRK_WBRP_STR-IPUNEI sy-vline
WA_WZRE_WBRK_WBRP_STR-IANZPU sy-vline
WA_WZRE_WBRK_WBRP_STR-IKOLIF sy-vline
WA_WZRE_WBRK_WBRP_STR-INAVNW sy-vline
WA_WZRE_WBRK_WBRP_STR-IBWTAR sy-vline
WA_WZRE_WBRK_WBRP_STR-IBWTTY sy-vline
WA_WZRE_WBRK_WBRP_STR-IGSBER sy-vline
WA_WZRE_WBRK_WBRP_STR-IPAOBJNR sy-vline
WA_WZRE_WBRK_WBRP_STR-IKOSTL sy-vline
WA_WZRE_WBRK_WBRP_STR-IPRCTR sy-vline
WA_WZRE_WBRK_WBRP_STR-IKOKRS sy-vline
WA_WZRE_WBRK_WBRP_STR-ICHARG sy-vline
WA_WZRE_WBRK_WBRP_STR-IWUVPRS sy-vline
WA_WZRE_WBRK_WBRP_STR-IWBELN_V sy-vline
WA_WZRE_WBRK_WBRP_STR-IPOSNR_V sy-vline
WA_WZRE_WBRK_WBRP_STR-IFTYPV_V sy-vline
WA_WZRE_WBRK_WBRP_STR-IITEMCAT sy-vline
WA_WZRE_WBRK_WBRP_STR-IMATBF sy-vline
WA_WZRE_WBRK_WBRP_STR-IMWERT_IM sy-vline
WA_WZRE_WBRK_WBRP_STR-IMWERT_PR sy-vline
WA_WZRE_WBRK_WBRP_STR-IMWERT_UM sy-vline
WA_WZRE_WBRK_WBRP_STR-ICONTRACT sy-vline
WA_WZRE_WBRK_WBRP_STR-ICONTRACT_TYPE sy-vline
WA_WZRE_WBRK_WBRP_STR-ICUOBJ sy-vline
WA_WZRE_WBRK_WBRP_STR-IITEM_CANCELED sy-vline
WA_WZRE_WBRK_WBRP_STR-IIDNLF_TYPE sy-vline
WA_WZRE_WBRK_WBRP_STR-IITEM_STATUS sy-vline
WA_WZRE_WBRK_WBRP_STR-IGUID_REF sy-vline
WA_WZRE_WBRK_WBRP_STR-IBEMOT sy-vline
WA_WZRE_WBRK_WBRP_STR-IAUFNR sy-vline
WA_WZRE_WBRK_WBRP_STR-IINCO1_P sy-vline
WA_WZRE_WBRK_WBRP_STR-IINCO2_P sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.