ABAP Select data from SAP table WZRE_S_ITEM_FIELDS 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_S_ITEM_FIELDS 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_S_ITEM_FIELDS. 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_S_ITEM_FIELDS 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_S_ITEM_FIELDS TYPE STANDARD TABLE OF WZRE_S_ITEM_FIELDS,
      WA_WZRE_S_ITEM_FIELDS TYPE WZRE_S_ITEM_FIELDS,
      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_S_ITEM_FIELDS> TYPE WZRE_S_ITEM_FIELDS.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM WZRE_S_ITEM_FIELDS
*  INTO TABLE @DATA(IT_WZRE_S_ITEM_FIELDS2).
*--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_S_ITEM_FIELDS INDEX 1 INTO DATA(WA_WZRE_S_ITEM_FIELDS2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_WZRE_S_ITEM_FIELDS ASSIGNING <WZRE_S_ITEM_FIELDS>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<WZRE_S_ITEM_FIELDS>-AGENCY_ID_CODE = 1.
<WZRE_S_ITEM_FIELDS>-AKTNR = 1.
<WZRE_S_ITEM_FIELDS>-ANZPU = 1.
<WZRE_S_ITEM_FIELDS>-ARKTX = 1.
<WZRE_S_ITEM_FIELDS>-AUFNR = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_WZRE_S_ITEM_FIELDS-AUFNRD, sy-vline,
WA_WZRE_S_ITEM_FIELDS-BEMOT, sy-vline,
WA_WZRE_S_ITEM_FIELDS-BONUS, sy-vline,
WA_WZRE_S_ITEM_FIELDS-BRGEW, sy-vline,
WA_WZRE_S_ITEM_FIELDS-BWTAR, sy-vline,
WA_WZRE_S_ITEM_FIELDS-BWTTY, sy-vline.
ENDLOOP. *Add any further fields from structure WA_WZRE_S_ITEM_FIELDS 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_S_ITEM_FIELDS 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_S_ITEM_FIELDS INTO WA_WZRE_S_ITEM_FIELDS. *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 AKTNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WZRE_S_ITEM_FIELDS-AKTNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WZRE_S_ITEM_FIELDS-AKTNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ABPSP, internal->external for field PS_PSP_PNR CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_WZRE_S_ITEM_FIELDS-PS_PSP_PNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WZRE_S_ITEM_FIELDS-PS_PSP_PNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ABPSP, internal->external for field PS_PSP_PNRD CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_WZRE_S_ITEM_FIELDS-PS_PSP_PNRD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WZRE_S_ITEM_FIELDS-PS_PSP_PNRD.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit ALPHA, internal->external for field REF_SAKTO CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WZRE_S_ITEM_FIELDS-REF_SAKTO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WZRE_S_ITEM_FIELDS-REF_SAKTO.
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_S_ITEM_FIELDS_STR,
AGENCY_ID_CODE TYPE STRING,
AKTNR TYPE STRING,
ANZPU TYPE STRING,
ARKTX TYPE STRING,
AUFNR TYPE STRING,
AUFNRD TYPE STRING,
BEMOT TYPE STRING,
BONUS TYPE STRING,
BRGEW TYPE STRING,
BWTAR TYPE STRING,
BWTTY TYPE STRING,
CHARG TYPE STRING,
CONTRACT TYPE STRING,
CONTRACT_ITEM TYPE STRING,
CONTRACT_TYPE TYPE STRING,
CWM_MEINS TYPE STRING,
CWM_MENGE TYPE STRING,
DISTRIB_STATUS TYPE STRING,
EBON2 TYPE STRING,
EBON3 TYPE STRING,
EBONF TYPE STRING,
EKKOL TYPE STRING,
FBUDA TYPE STRING,
FPRME TYPE STRING,
FPUMN TYPE STRING,
FPUMZ TYPE STRING,
FTYPV_V TYPE STRING,
GEWEI TYPE STRING,
GJAHRV TYPE STRING,
GSBER TYPE STRING,
GSBERD TYPE STRING,
GUID_REF TYPE STRING,
IDNLF TYPE STRING,
IDNLF_TYPE TYPE STRING,
INCO1_P TYPE STRING,
INCO2_P TYPE STRING,
INCOV_P TYPE STRING,
INCO2_L_P TYPE STRING,
INCO3_L_P TYPE STRING,
INVC_ITEM_ID TYPE STRING,
ITEMCAT TYPE STRING,
KOLIF TYPE STRING,
KOSTL TYPE STRING,
KOSTLD TYPE STRING,
KOWRR TYPE STRING,
LFGRU TYPE STRING,
LFTYPV TYPE STRING,
LTSNR TYPE STRING,
MATBF TYPE STRING,
MATKL TYPE STRING,
MATNR TYPE STRING,
MWSKZ TYPE STRING,
MWSK2 TYPE STRING,
NETPR_EXP TYPE STRING,
NO_INCOTERM_DETERMINATION TYPE STRING,
NTGEW TYPE STRING,
PBRTWR TYPE STRING,
PEINH TYPE STRING,
PMWSBP TYPE STRING,
PNETPR TYPE STRING,
PNETWR TYPE STRING,
POSNR_MAIN TYPE STRING,
POSNR_V TYPE STRING,
POSNRV TYPE STRING,
POSTING_RULE_D_I TYPE STRING,
POSTING_RULE_K_I TYPE STRING,
PRCTR TYPE STRING,
PRCTRD TYPE STRING,
PRSDT TYPE STRING,
PS_PSP_PNR TYPE STRING,
PS_PSP_PNRD TYPE STRING,
PUNEI TYPE STRING,
REF_ITEM_ID TYPE STRING,
REF_ITEM_NUMBER TYPE STRING,
REF_NUMBER TYPE STRING,
REF_TYPE TYPE STRING,
REFERENCE_ID TYPE STRING,
SCHEME_A_ID TYPE STRING,
SCHEME_ID TYPE STRING,
SETTL_STATUS_I_C TYPE STRING,
SETTL_STATUS_I_V TYPE STRING,
SKTOF TYPE STRING,
SPART_I TYPE STRING,
TXJCD TYPE STRING,
UMREN TYPE STRING,
UMREZ TYPE STRING,
VKORG_I TYPE STRING,
VTWEG_I TYPE STRING,
VOLEH TYPE STRING,
VOLUM TYPE STRING,
WAART TYPE STRING,
WBELN_V TYPE STRING,
WBELNV TYPE STRING,
WEIGHT_VOLUME TYPE STRING,
WERKS TYPE STRING,
MENGE TYPE STRING,
WFKME TYPE STRING,
REF_NUMBER_2 TYPE STRING,
REF_ITEM_NUM_2 TYPE STRING,
REF_TYPE_2 TYPE STRING,
REF_SAKTO TYPE STRING,
REF_PAOBJNR TYPE STRING,END OF T_EKKO_STR. DATA: WA_WZRE_S_ITEM_FIELDS_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_S_ITEM_FIELDS_STR-AGENCY_ID_CODE sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-AKTNR sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-ANZPU sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-ARKTX sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-AUFNR sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-AUFNRD sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-BEMOT sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-BONUS sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-BRGEW sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-BWTAR sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-BWTTY sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-CHARG sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-CONTRACT sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-CONTRACT_ITEM sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-CONTRACT_TYPE sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-CWM_MEINS sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-CWM_MENGE sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-DISTRIB_STATUS sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-EBON2 sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-EBON3 sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-EBONF sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-EKKOL sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-FBUDA sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-FPRME sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-FPUMN sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-FPUMZ sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-FTYPV_V sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-GEWEI sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-GJAHRV sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-GSBER sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-GSBERD sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-GUID_REF sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-IDNLF sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-IDNLF_TYPE sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-INCO1_P sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-INCO2_P sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-INCOV_P sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-INCO2_L_P sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-INCO3_L_P sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-INVC_ITEM_ID sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-ITEMCAT sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-KOLIF sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-KOSTL sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-KOSTLD sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-KOWRR sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-LFGRU sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-LFTYPV sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-LTSNR sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-MATBF sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-MATKL sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-MATNR sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-MWSKZ sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-MWSK2 sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-NETPR_EXP sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-NO_INCOTERM_DETERMINATION sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-NTGEW sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-PBRTWR sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-PEINH sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-PMWSBP sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-PNETPR sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-PNETWR sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-POSNR_MAIN sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-POSNR_V sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-POSNRV sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-POSTING_RULE_D_I sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-POSTING_RULE_K_I sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-PRCTR sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-PRCTRD sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-PRSDT sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-PS_PSP_PNR sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-PS_PSP_PNRD sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-PUNEI sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-REF_ITEM_ID sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-REF_ITEM_NUMBER sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-REF_NUMBER sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-REF_TYPE sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-REFERENCE_ID sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-SCHEME_A_ID sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-SCHEME_ID sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-SETTL_STATUS_I_C sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-SETTL_STATUS_I_V sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-SKTOF sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-SPART_I sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-TXJCD sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-UMREN sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-UMREZ sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-VKORG_I sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-VTWEG_I sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-VOLEH sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-VOLUM sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-WAART sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-WBELN_V sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-WBELNV sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-WEIGHT_VOLUME sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-WERKS sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-MENGE sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-WFKME sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-REF_NUMBER_2 sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-REF_ITEM_NUM_2 sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-REF_TYPE_2 sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-REF_SAKTO sy-vline
WA_WZRE_S_ITEM_FIELDS_STR-REF_PAOBJNR sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.