ABAP Select data from SAP table MEREP_OUTTAB_ACCOUNTING 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 MEREP_OUTTAB_ACCOUNTING 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 MEREP_OUTTAB_ACCOUNTING. 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 MEREP_OUTTAB_ACCOUNTING 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_MEREP_OUTTAB_ACCOUNTING TYPE STANDARD TABLE OF MEREP_OUTTAB_ACCOUNTING,
      WA_MEREP_OUTTAB_ACCOUNTING TYPE MEREP_OUTTAB_ACCOUNTING,
      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: <MEREP_OUTTAB_ACCOUNTING> TYPE MEREP_OUTTAB_ACCOUNTING.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM MEREP_OUTTAB_ACCOUNTING
*  INTO TABLE @DATA(IT_MEREP_OUTTAB_ACCOUNTING2).
*--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_MEREP_OUTTAB_ACCOUNTING INDEX 1 INTO DATA(WA_MEREP_OUTTAB_ACCOUNTING2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_MEREP_OUTTAB_ACCOUNTING ASSIGNING <MEREP_OUTTAB_ACCOUNTING>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<MEREP_OUTTAB_ACCOUNTING>-EBELN = 1.
<MEREP_OUTTAB_ACCOUNTING>-EBELP = 1.
<MEREP_OUTTAB_ACCOUNTING>-BSART = 1.
<MEREP_OUTTAB_ACCOUNTING>-BSTYP = 1.
<MEREP_OUTTAB_ACCOUNTING>-SUPERFIELD = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_MEREP_OUTTAB_ACCOUNTING-EKORG, sy-vline,
WA_MEREP_OUTTAB_ACCOUNTING-EKGRP, sy-vline,
WA_MEREP_OUTTAB_ACCOUNTING-BEDAT, sy-vline,
WA_MEREP_OUTTAB_ACCOUNTING-EMATN, sy-vline,
WA_MEREP_OUTTAB_ACCOUNTING-TXZ01, sy-vline,
WA_MEREP_OUTTAB_ACCOUNTING-MATKL, sy-vline.
ENDLOOP. *Add any further fields from structure WA_MEREP_OUTTAB_ACCOUNTING 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_MEREP_OUTTAB_ACCOUNTING 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_MEREP_OUTTAB_ACCOUNTING INTO WA_MEREP_OUTTAB_ACCOUNTING. *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 EBELN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_MEREP_OUTTAB_ACCOUNTING-EBELN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MEREP_OUTTAB_ACCOUNTING-EBELN.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit NUMCV, internal->external for field VORNR CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_MEREP_OUTTAB_ACCOUNTING-VORNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MEREP_OUTTAB_ACCOUNTING-VORNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit FMCIS, internal->external for field FIPOS CALL FUNCTION 'CONVERSION_EXIT_FMCIS_OUTPUT' EXPORTING input = WA_MEREP_OUTTAB_ACCOUNTING-FIPOS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MEREP_OUTTAB_ACCOUNTING-FIPOS.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field TCNO CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_MEREP_OUTTAB_ACCOUNTING-TCNO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MEREP_OUTTAB_ACCOUNTING-TCNO.
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_MEREP_OUTTAB_ACCOUNTING_STR,
EBELN TYPE STRING,
EBELP TYPE STRING,
BSART TYPE STRING,
BSTYP TYPE STRING,
SUPERFIELD TYPE STRING,
EKORG TYPE STRING,
EKGRP TYPE STRING,
BEDAT TYPE STRING,
EMATN TYPE STRING,
TXZ01 TYPE STRING,
MATKL TYPE STRING,
ICON_PO_HIST TYPE STRING,
ICON_COMP_CONS TYPE STRING,
LOEKZ TYPE STRING,
PSTYP TYPE STRING,
EPSTP TYPE STRING,
KNTTP TYPE STRING,
BEDNR TYPE STRING,
WERKS TYPE STRING,
LGORT TYPE STRING,
MENGE TYPE STRING,
MEINS TYPE STRING,
LAGMG TYPE STRING,
LMEIN TYPE STRING,
NETPR TYPE STRING,
WAERS TYPE STRING,
PEINH TYPE STRING,
KONNR TYPE STRING,
KTPNR TYPE STRING,
KTWRT TYPE STRING,
OFZWT TYPE STRING,
KTWTO TYPE STRING,
KTWTR TYPE STRING,
KTMNG TYPE STRING,
OFZMG TYPE STRING,
KTMGR TYPE STRING,
KDATB TYPE STRING,
KDATE TYPE STRING,
MGLIEF TYPE STRING,
WTLIEF TYPE STRING,
MGINV TYPE STRING,
WTINV TYPE STRING,
AGDAT TYPE STRING,
STATU TYPE STRING,
SUBMI TYPE STRING,
AZPOS TYPE STRING,
BSAKZ TYPE STRING,
INFNR TYPE STRING,
PACKNO TYPE STRING,
FRGGR TYPE STRING,
FRGSX TYPE STRING,
FRGZU TYPE STRING,
FRGKE TYPE STRING,
RESLO TYPE STRING,
VENDOR_NAME TYPE STRING,
BPRME TYPE STRING,
MWSKZ TYPE STRING,
TXJCD TYPE STRING,
NETWR TYPE STRING,
MEMORY TYPE STRING,
MEMORYTYPE TYPE STRING,
LAMNG TYPE STRING,
SGT_SCAT TYPE STRING,
SGT_RCAT TYPE STRING,
EXLIN TYPE STRING,
EXSNR TYPE STRING,
EHTYP TYPE STRING,
PRIO_URG TYPE STRING,
PRIO_REQ TYPE STRING,
LONGNUM TYPE STRING,
FSH_SEASON_YEAR TYPE STRING,
FSH_SEASON TYPE STRING,
FSH_COLLECTION TYPE STRING,
FSH_THEME TYPE STRING,
RFM_PSST_RULE TYPE STRING,
RFM_PSST_GROUP TYPE STRING,
WRF_CHARSTC1 TYPE STRING,
WRF_CHARSTC1_TXT TYPE STRING,
WRF_CHARSTC2 TYPE STRING,
WRF_CHARSTC2_TXT TYPE STRING,
WRF_CHARSTC3 TYPE STRING,
WRF_CHARSTC3_TXT TYPE STRING,
ZEKKN TYPE STRING,
KNTMG TYPE STRING,
KOSTL TYPE STRING,
PS_PSP_PNR TYPE STRING,
AUFNR TYPE STRING,
ANLN1 TYPE STRING,
ANLN2 TYPE STRING,
VBELN TYPE STRING,
VBELP TYPE STRING,
VETEN TYPE STRING,
NPLNR TYPE STRING,
VORNR TYPE STRING,
LOEKZ_K TYPE STRING,
AEDAT TYPE STRING,
VPROZ TYPE STRING,
SAKTO TYPE STRING,
GSBER TYPE STRING,
WEMPF TYPE STRING,
ABLAD TYPE STRING,
KOKRS TYPE STRING,
PAOBJNR TYPE STRING,
PRCTR TYPE STRING,
AUFPL TYPE STRING,
IMKEY TYPE STRING,
APLZL TYPE STRING,
VPTNR TYPE STRING,
FIPOS TYPE STRING,
RECID TYPE STRING,
FISTL TYPE STRING,
GEBER TYPE STRING,
GRANT_NBR TYPE STRING,
FKBER TYPE STRING,
DABRZ TYPE STRING,
AUFPL_ORD TYPE STRING,
APLZL_ORD TYPE STRING,
NAVNW TYPE STRING,
LSTAR TYPE STRING,
PRZNR TYPE STRING,
KBLNR TYPE STRING,
KBLPOS TYPE STRING,
SWENR TYPE STRING,
SGENR TYPE STRING,
SGRNR TYPE STRING,
SMENR TYPE STRING,
SMIVE TYPE STRING,
SNKSL TYPE STRING,
SEMPSL TYPE STRING,
SVWNR TYPE STRING,
RECNNR TYPE STRING,
SBERI TYPE STRING,
TCNO TYPE STRING,
PSP_PNR TYPE STRING,
SRV_UPDKZ TYPE STRING,
BUDGET_PD TYPE STRING,
AA_FINAL_IND TYPE STRING,
AA_FINAL_REASON TYPE STRING,
AA_FINAL_REASON_TEXT TYPE STRING,END OF T_EKKO_STR. DATA: WA_MEREP_OUTTAB_ACCOUNTING_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_MEREP_OUTTAB_ACCOUNTING_STR-EBELN sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-EBELP sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-BSART sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-BSTYP sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-SUPERFIELD sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-EKORG sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-EKGRP sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-BEDAT sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-EMATN sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-TXZ01 sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-MATKL sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-ICON_PO_HIST sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-ICON_COMP_CONS sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-LOEKZ sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-PSTYP sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-EPSTP sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-KNTTP sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-BEDNR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-WERKS sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-LGORT sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-MENGE sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-MEINS sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-LAGMG sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-LMEIN sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-NETPR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-WAERS sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-PEINH sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-KONNR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-KTPNR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-KTWRT sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-OFZWT sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-KTWTO sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-KTWTR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-KTMNG sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-OFZMG sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-KTMGR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-KDATB sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-KDATE sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-MGLIEF sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-WTLIEF sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-MGINV sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-WTINV sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-AGDAT sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-STATU sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-SUBMI sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-AZPOS sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-BSAKZ sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-INFNR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-PACKNO sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-FRGGR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-FRGSX sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-FRGZU sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-FRGKE sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-RESLO sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-VENDOR_NAME sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-BPRME sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-MWSKZ sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-TXJCD sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-NETWR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-MEMORY sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-MEMORYTYPE sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-LAMNG sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-SGT_SCAT sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-SGT_RCAT sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-EXLIN sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-EXSNR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-EHTYP sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-PRIO_URG sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-PRIO_REQ sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-LONGNUM sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-FSH_SEASON_YEAR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-FSH_SEASON sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-FSH_COLLECTION sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-FSH_THEME sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-RFM_PSST_RULE sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-RFM_PSST_GROUP sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-WRF_CHARSTC1 sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-WRF_CHARSTC1_TXT sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-WRF_CHARSTC2 sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-WRF_CHARSTC2_TXT sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-WRF_CHARSTC3 sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-WRF_CHARSTC3_TXT sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-ZEKKN sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-KNTMG sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-KOSTL sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-PS_PSP_PNR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-AUFNR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-ANLN1 sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-ANLN2 sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-VBELN sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-VBELP sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-VETEN sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-NPLNR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-VORNR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-LOEKZ_K sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-AEDAT sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-VPROZ sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-SAKTO sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-GSBER sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-WEMPF sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-ABLAD sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-KOKRS sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-PAOBJNR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-PRCTR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-AUFPL sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-IMKEY sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-APLZL sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-VPTNR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-FIPOS sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-RECID sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-FISTL sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-GEBER sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-GRANT_NBR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-FKBER sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-DABRZ sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-AUFPL_ORD sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-APLZL_ORD sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-NAVNW sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-LSTAR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-PRZNR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-KBLNR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-KBLPOS sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-SWENR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-SGENR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-SGRNR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-SMENR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-SMIVE sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-SNKSL sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-SEMPSL sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-SVWNR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-RECNNR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-SBERI sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-TCNO sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-PSP_PNR sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-SRV_UPDKZ sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-BUDGET_PD sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-AA_FINAL_IND sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-AA_FINAL_REASON sy-vline
WA_MEREP_OUTTAB_ACCOUNTING_STR-AA_FINAL_REASON_TEXT sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.