ABAP Select data from SAP table RCOOM 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 RCOOM 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 RCOOM. 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 RCOOM 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_RCOOM TYPE STANDARD TABLE OF RCOOM,
      WA_RCOOM TYPE RCOOM,
      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: <RCOOM> TYPE RCOOM.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM RCOOM
*  INTO TABLE @DATA(IT_RCOOM2).
*--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_RCOOM INDEX 1 INTO DATA(WA_RCOOM2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_RCOOM ASSIGNING <RCOOM>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<RCOOM>-KOKRS = 1.
<RCOOM>-FISCPER = 1.
<RCOOM>-FISCYEAR = 1.
<RCOOM>-FISCVAR = 1.
<RCOOM>-OBJNR = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_RCOOM-KOSTL, sy-vline,
WA_RCOOM-LSTAR, sy-vline,
WA_RCOOM-AUFNR, sy-vline,
WA_RCOOM-PRZNR, sy-vline,
WA_RCOOM-KSTRG, sy-vline,
WA_RCOOM-POSID, sy-vline.
ENDLOOP. *Add any further fields from structure WA_RCOOM 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_RCOOM 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_RCOOM INTO WA_RCOOM. *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 PERI7, internal->external for field FISCPER CALL FUNCTION 'CONVERSION_EXIT_PERI7_OUTPUT' EXPORTING input = WA_RCOOM-FISCPER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-FISCPER.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit OBJEX, internal->external for field OBJNR CALL FUNCTION 'CONVERSION_EXIT_OBJEX_OUTPUT' EXPORTING input = WA_RCOOM-OBJNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-OBJNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit ABPSN, internal->external for field POSID CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_RCOOM-POSID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-POSID.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

*Conversion exit OBJEX, internal->external for field PAROB CALL FUNCTION 'CONVERSION_EXIT_OBJEX_OUTPUT' EXPORTING input = WA_RCOOM-PAROB IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-PAROB.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit AC152, internal->external for field SWG CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-SWG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-SWG.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SWF CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-SWF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-SWF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SWV CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-SWV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-SWV.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit AC152, internal->external for field SWKG CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-SWKG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-SWKG.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SWKF CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-SWKF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-SWKF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SWKV CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-SWKV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-SWKV.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field STKG CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT' EXPORTING input = WA_RCOOM-STKG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-STKG.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field STKF CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT' EXPORTING input = WA_RCOOM-STKF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-STKF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field STKV CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT' EXPORTING input = WA_RCOOM-STKV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-STKV.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SWLJET CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-SWLJET IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-SWLJET.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SWLGES CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-SWLGES IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-SWLGES.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SWLGPL CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-SWLGPL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-SWLGPL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SKSTG CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-SKSTG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-SKSTG.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SKSTF CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-SKSTF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-SKSTF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SKSTV CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-SKSTV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-SKSTV.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field AWKG CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-AWKG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-AWKG.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field AWKF CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-AWKF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-AWKF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field AWKV CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-AWKV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-AWKV.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit POSID, internal->external for field IP_POSID CALL FUNCTION 'CONVERSION_EXIT_POSID_OUTPUT' EXPORTING input = WA_RCOOM-IP_POSID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-IP_POSID.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit REQID, internal->external for field IA_POSID CALL FUNCTION 'CONVERSION_EXIT_REQID_OUTPUT' EXPORTING input = WA_RCOOM-IA_POSID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-IA_POSID.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit AC152, internal->external for field SWOG CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-SWOG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-SWOG.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SWOF CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-SWOF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-SWOF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SWOV CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-SWOV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-SWOV.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SWTG CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-SWTG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-SWTG.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SWTF CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-SWTF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-SWTF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SWTV CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_RCOOM-SWTV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-SWTV.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field STOG CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT' EXPORTING input = WA_RCOOM-STOG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-STOG.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field STOF CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT' EXPORTING input = WA_RCOOM-STOF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-STOF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field STOV CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT' EXPORTING input = WA_RCOOM-STOV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RCOOM-STOV.
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_RCOOM_STR,
KOKRS TYPE STRING,
FISCPER TYPE STRING,
FISCYEAR TYPE STRING,
FISCVAR TYPE STRING,
OBJNR TYPE STRING,
KOSTL TYPE STRING,
LSTAR TYPE STRING,
AUFNR TYPE STRING,
PRZNR TYPE STRING,
KSTRG TYPE STRING,
POSID TYPE STRING,
PKSTL_BUE TYPE STRING,
KSTAR TYPE STRING,
GJAHR TYPE STRING,
PERIO TYPE STRING,
WRTTP TYPE STRING,
VERSN TYPE STRING,
BELKZ TYPE STRING,
VTYPE TYPE STRING,
MEASTYPE TYPE STRING,
VTDETAIL TYPE STRING,
VTSTAT TYPE STRING,
VRGNG TYPE STRING,
PAROB TYPE STRING,
USPOB TYPE STRING,
TARKZ TYPE STRING,
STAGR TYPE STRING,
ELEMT TYPE STRING,
ABKAT TYPE STRING,
CBRKE TYPE STRING,
CBRKI TYPE STRING,
CBART TYPE STRING,
DRVTP TYPE STRING,
SWG TYPE STRING,
SWF TYPE STRING,
SWV TYPE STRING,
SME TYPE STRING,
SMA TYPE STRING,
SMEG TYPE STRING,
SMEF TYPE STRING,
SMEV TYPE STRING,
WAERS TYPE STRING,
CURTYPE TYPE STRING,
MEINH TYPE STRING,
SWKG TYPE STRING,
SWKF TYPE STRING,
SWKV TYPE STRING,
SLST TYPE STRING,
SDIS TYPE STRING,
SKAP TYPE STRING,
SAUS TYPE STRING,
STKG TYPE STRING,
STKF TYPE STRING,
STKV TYPE STRING,
SSME TYPE STRING,
SWLJET TYPE STRING,
SWLGES TYPE STRING,
SWLGPL TYPE STRING,
SKSTG TYPE STRING,
SKSTF TYPE STRING,
SKSTV TYPE STRING,
AWKG TYPE STRING,
AWKF TYPE STRING,
AWKV TYPE STRING,
LEINH TYPE STRING,
AUSEH TYPE STRING,
IP_POSID TYPE STRING,
IP_GNJHR TYPE STRING,
IP_PRNAM TYPE STRING,
IA_POSID TYPE STRING,
IA_GNJHR TYPE STRING,
IA_VERSN TYPE STRING,
SSMED TYPE STRING,
RSPOBART TYPE STRING,
RSPAROBVAL TYPE STRING,
VALUTYP TYPE STRING,
BEKNZ TYPE STRING,
SEKNZ TYPE STRING,
KWAER TYPE STRING,
OWAER TYPE STRING,
TWAER TYPE STRING,
SWOG TYPE STRING,
SWOF TYPE STRING,
SWOV TYPE STRING,
SWTG TYPE STRING,
SWTF TYPE STRING,
SWTV TYPE STRING,
SMAX TYPE STRING,
STOG TYPE STRING,
STOF TYPE STRING,
STOV TYPE STRING,
STOE TYPE STRING,END OF T_EKKO_STR. DATA: WA_RCOOM_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_RCOOM_STR-KOKRS sy-vline
WA_RCOOM_STR-FISCPER sy-vline
WA_RCOOM_STR-FISCYEAR sy-vline
WA_RCOOM_STR-FISCVAR sy-vline
WA_RCOOM_STR-OBJNR sy-vline
WA_RCOOM_STR-KOSTL sy-vline
WA_RCOOM_STR-LSTAR sy-vline
WA_RCOOM_STR-AUFNR sy-vline
WA_RCOOM_STR-PRZNR sy-vline
WA_RCOOM_STR-KSTRG sy-vline
WA_RCOOM_STR-POSID sy-vline
WA_RCOOM_STR-PKSTL_BUE sy-vline
WA_RCOOM_STR-KSTAR sy-vline
WA_RCOOM_STR-GJAHR sy-vline
WA_RCOOM_STR-PERIO sy-vline
WA_RCOOM_STR-WRTTP sy-vline
WA_RCOOM_STR-VERSN sy-vline
WA_RCOOM_STR-BELKZ sy-vline
WA_RCOOM_STR-VTYPE sy-vline
WA_RCOOM_STR-MEASTYPE sy-vline
WA_RCOOM_STR-VTDETAIL sy-vline
WA_RCOOM_STR-VTSTAT sy-vline
WA_RCOOM_STR-VRGNG sy-vline
WA_RCOOM_STR-PAROB sy-vline
WA_RCOOM_STR-USPOB sy-vline
WA_RCOOM_STR-TARKZ sy-vline
WA_RCOOM_STR-STAGR sy-vline
WA_RCOOM_STR-ELEMT sy-vline
WA_RCOOM_STR-ABKAT sy-vline
WA_RCOOM_STR-CBRKE sy-vline
WA_RCOOM_STR-CBRKI sy-vline
WA_RCOOM_STR-CBART sy-vline
WA_RCOOM_STR-DRVTP sy-vline
WA_RCOOM_STR-SWG sy-vline
WA_RCOOM_STR-SWF sy-vline
WA_RCOOM_STR-SWV sy-vline
WA_RCOOM_STR-SME sy-vline
WA_RCOOM_STR-SMA sy-vline
WA_RCOOM_STR-SMEG sy-vline
WA_RCOOM_STR-SMEF sy-vline
WA_RCOOM_STR-SMEV sy-vline
WA_RCOOM_STR-WAERS sy-vline
WA_RCOOM_STR-CURTYPE sy-vline
WA_RCOOM_STR-MEINH sy-vline
WA_RCOOM_STR-SWKG sy-vline
WA_RCOOM_STR-SWKF sy-vline
WA_RCOOM_STR-SWKV sy-vline
WA_RCOOM_STR-SLST sy-vline
WA_RCOOM_STR-SDIS sy-vline
WA_RCOOM_STR-SKAP sy-vline
WA_RCOOM_STR-SAUS sy-vline
WA_RCOOM_STR-STKG sy-vline
WA_RCOOM_STR-STKF sy-vline
WA_RCOOM_STR-STKV sy-vline
WA_RCOOM_STR-SSME sy-vline
WA_RCOOM_STR-SWLJET sy-vline
WA_RCOOM_STR-SWLGES sy-vline
WA_RCOOM_STR-SWLGPL sy-vline
WA_RCOOM_STR-SKSTG sy-vline
WA_RCOOM_STR-SKSTF sy-vline
WA_RCOOM_STR-SKSTV sy-vline
WA_RCOOM_STR-AWKG sy-vline
WA_RCOOM_STR-AWKF sy-vline
WA_RCOOM_STR-AWKV sy-vline
WA_RCOOM_STR-LEINH sy-vline
WA_RCOOM_STR-AUSEH sy-vline
WA_RCOOM_STR-IP_POSID sy-vline
WA_RCOOM_STR-IP_GNJHR sy-vline
WA_RCOOM_STR-IP_PRNAM sy-vline
WA_RCOOM_STR-IA_POSID sy-vline
WA_RCOOM_STR-IA_GNJHR sy-vline
WA_RCOOM_STR-IA_VERSN sy-vline
WA_RCOOM_STR-SSMED sy-vline
WA_RCOOM_STR-RSPOBART sy-vline
WA_RCOOM_STR-RSPAROBVAL sy-vline
WA_RCOOM_STR-VALUTYP sy-vline
WA_RCOOM_STR-BEKNZ sy-vline
WA_RCOOM_STR-SEKNZ sy-vline
WA_RCOOM_STR-KWAER sy-vline
WA_RCOOM_STR-OWAER sy-vline
WA_RCOOM_STR-TWAER sy-vline
WA_RCOOM_STR-SWOG sy-vline
WA_RCOOM_STR-SWOF sy-vline
WA_RCOOM_STR-SWOV sy-vline
WA_RCOOM_STR-SWTG sy-vline
WA_RCOOM_STR-SWTF sy-vline
WA_RCOOM_STR-SWTV sy-vline
WA_RCOOM_STR-SMAX sy-vline
WA_RCOOM_STR-STOG sy-vline
WA_RCOOM_STR-STOF sy-vline
WA_RCOOM_STR-STOV sy-vline
WA_RCOOM_STR-STOE sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.