topic Re: column heading in Application Development and Automation Discussions

column heading

Former Member — Wed, 26 Dec 2007 10:53:57 GMT

Hi,

I am downloading one file to application server,

I can find all the fields in the file which I downloaded,

My problem is I want to maintain the column heading for the

fields in the file downloaded.

How can I do this.

Re: column heading

former_member386202 — Wed, 26 Dec 2007 10:56:44 GMT

Hi,

Use TCODE CG3Y to download the file to application server.

Regards,

Prashant

Re: column heading

Former Member — Wed, 26 Dec 2007 14:56:18 GMT

Hi,

r u using one internal table for download into application server,in that internal table specify column heading.

for example.

it_app_server-heading1 = 'Sales Order No'.

it_app_server = itab-vbeln.

Regards,

Billa

Re: column heading

former_member156446 — Wed, 26 Dec 2007 15:12:01 GMT

first u need to append the internal table with header description and then data..

or u can use append lines of itab1 to itab2...

append itab sy-index 1.

Re: column heading

Former Member — Thu, 27 Dec 2007 04:02:20 GMT

Hi Jack,

I have an internal table itab

types: begin of t_st,

lifnr type lfa1-lifnr,

name1 type lfa1-name1,

end of t_st.

data: itab type standard table of t_st,

wa_itab type t_st.

you sais append lines of

can use append lines of itab1 to itab2...

append itab sy-index 1.

can you write and show how is this possible.

Re: column heading

former_member402443 — Thu, 27 Dec 2007 04:53:32 GMT

Hi Shilpa,

You want to add the Column Heading also along with data to the file your are downloading to application server.

Check this code.It might help you.

TYPES : BEGIN OF tab,

vbeln like vbak-vbeln,

ernam like vbak-ernam,

vbtyp like vbak-vbtyp,

END OF tab.

DATA : itab TYPE STANDARD TABLE OF tab,

wa_itab type tab.

*Here I am first moving the Column heading to the internal table.

MOVE 'Sale Doc' to wa_itab-vbeln.

MOVE 'Person' to wa_itab-ernam.

MOVE 'T' to wa_itab-vbtyp.

APPEND wa_itab to itab.

*After that I am passing data to the internal table so that the data will be started from the second row and the first row containing the

header info.

MOVE '1000' TO wa_itab-vbeln.

MOVE 'sdfd' TO wa_itab-ernam.

MOVE 'h' TO wa_itab-vbtyp.

APPEND wa_itab to itab.

MOVE '1001' TO wa_itab-vbeln.

MOVE 'jsdj' TO wa_itab-ernam.

MOVE 'j' TO wa_itab-vbtyp.

APPEND wa_itab to itab.

MOVE '1002' TO wa_itab-vbeln.

MOVE 'qeqw' TO wa_itab-ernam.

MOVE 'K' TO wa_itab-vbtyp.

APPEND wa_itab to itab.

LOOP at itab into wa_itab.

write 😕 wa_itab-vbeln,

wa_itab-ernam,

wa_itab-vbtyp.

ENDLOOP.

Reward Points, if useful.

Regards,

Manoj Kumar

Re: column heading

former_member156446 — Thu, 27 Dec 2007 05:13:43 GMT

if it_output is ur final internal table..

it_output-lifnr = 'LIFNR' or ' VENDOR#'

it_output-name1 = 'NAME1' or 'NAME'.

after doing this u can append ur data into the internal table..

else if you already had a internal table say it_had.

> append lines of it_had to it_output. will work.. u need to do it >manually u have not other way to do

Re: column heading

Former Member — Thu, 27 Dec 2007 05:23:54 GMT

Hi Shilpa

If u done want to disturb the contents of the existing Internal table, then first create the file in App server and insert the Column headings (the first row is filled). Keep the file open and now transfer the contents of your ITAB to the App server file in Append mode. Now close the file. (CLOSE DATASET).

Thanks

Sharath.

Re: column heading

Former Member — Thu, 27 Dec 2007 06:53:56 GMT

I have an internal table of 20 fields,

I have stored that internal table in file in the application server.

When I open that file which is in application server I am to see only 10 fields.

how can I over come this problem.