topic Re: Adding titlles while loading on App. Server...urgent!!! in Application Development and Automation Discussions

Adding titlles while loading on App. Server...urgent!!!

Former Member — Tue, 04 Apr 2006 16:54:52 GMT

hello everyone,

This is what i'm doing:

*********************************************************

Open dataset....

Loop at internal table.

*Collect all data

*Concatenating all fields into string separated by comma

transfer string to string1

Endloop.

close dataset.

********************************************************

I need to add headings/titles corresponding to the fields that i'm concatenating into the string so that when i open the file on the App. Server I see the titles corresponding to the data.

How can I do that?

Thanks in advance.

Regards,

Fred.

Re: Adding titlles while loading on App. Server...urgent!!!

LucianoBentiveg — Tue, 04 Apr 2006 17:04:01 GMT

Open dataset....

Loop at internal table.

at first.

Concatenating all headings into string separated by
comma

transfer string to string1

endat.

*Collect all data

*Concatenating all fields into string separated by comma

transfer string to string1

Endloop.

close dataset.

Re: Adding titlles while loading on App. Server...urgent!!!

RichHeilman — Tue, 04 Apr 2006 17:06:37 GMT

Just write to the dataset before the loop.

report zrich_0001.


parameters: d2 type localfile default '/usr/sap/TST/SYS/Data1.txt'.


data: begin of itab occurs 0,
      rec(200) type c,
      end of itab.
data: wa(200) type c.


start-of-selection.

* Open
  open dataset d2 for output in text mode.

<b>* Write headings
  wa = 'Field1,Field2,Field3,Field4,Field5'.
  transfer wa to d2.</b>

* Write detail from itab
  loop at itab.
    transfer itab to d2.
  endloop.

* Close it
  close dataset d2.

Regards,

Rich Heilman