topic Re: Please Help in Application Development and Automation Discussions

Please Help

Former Member — Fri, 07 Sep 2007 06:19:10 GMT

I have a code like this:

My purpose is to have a header in my excel summary report.

But there's an error like this:

"Field "gv_HEADING-TEXT" is unknown. It is neither in one of the

specified tables nor defined by a "DATA" statement. "DATA" statement."

sample code in my program:

data: gv_heading(10) type c.

gv_HEADING-TEXT = 'Company Code'.

append IT_HEADING.

gv_HEADING-TEXT = 'RFQ Number'.

append IT_HEADING.

gv_HEADING-TEXT = 'RFQ Line Item'.

append IT_HEADING.

call function 'GUI_DOWNLOAD'

exporting

FILENAME = L_FNAME

FILETYPE = 'DAT'

tables

DATA_TAB = IT_FINAL

FIELDNAMES = gv_HEADING

Please help me in solving this problem.

more points!!

Re: Please Help

Former Member — Fri, 07 Sep 2007 06:21:19 GMT

data : begin of GV_HEADING occurs 0,
         TEXT(15),
       end of GV_HEADING.

Regards

Pratyusha

Re: Please Help

gopi_narendra — Fri, 07 Sep 2007 06:25:32 GMT

Hi Salma,


" i missed the declaration in my previous post.
* Excel fieldname heading
data : begin of IT_HEADING occurs 0,
         TEXT(15),
       end of IT_HEADING.

    IT_HEADING-TEXT = 'Company Code'.
    append IT_HEADING.
    IT_HEADING-TEXT = 'RFQ Number'.
    append IT_HEADING.
    IT_HEADING-TEXT = 'RFQ Line Item'.
    append IT_HEADING.

    call function 'GUI_DOWNLOAD'
      exporting
        FILENAME                = L_FNAME
        FILETYPE                = 'DAT'
      tables
        DATA_TAB                = IT_FINAL
        FIELDNAMES              = IT_HEADING

Regards

Gopi

Re: Please Help

Former Member — Fri, 07 Sep 2007 06:26:55 GMT

Hi,

gv_HEADING is of type C.

and it dont have and components TEXT..

I think your It_heading is having the component TEXT..

Now define.

data gv_heading type <It_heading type> .. I.e you might have it_heading of some type declare thesame for gv_heading..

types: begin of ty_heading ,

text(200) type c,

end of ty_heading.

data gv_heading type ty_heading.

rewards if useful,

regards,

nazeer

Re: Please Help

Former Member — Fri, 07 Sep 2007 06:32:29 GMT

hi,

declare gv_heading as a workarea and use it as

types: begin of gv_heading1

text(15) type c,

endof gv_heading1.

data: gv_heading type gv_heading1.

gv_HEADING-TEXT = 'Company Code'.

append IT_HEADING.

gv_HEADING-TEXT = 'RFQ Number'.

append IT_HEADING.

gv_HEADING-TEXT = 'RFQ Line Item'.

append IT_HEADING.

call function 'GUI_DOWNLOAD'

exporting

FILENAME = L_FNAME

FILETYPE = 'DAT'

tables

DATA_TAB = IT_FINAL

FIELDNAMES = gv_HEADING

if helpful reward some points.

with regards,

Suresh Aluri.

Re: Please Help

Former Member — Fri, 07 Sep 2007 06:40:40 GMT

Thanks to all masters!!!

Especially to master gopi!!! It works!!

'till next questions...ehehe