12-26-2007 10:53 AM
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.
12-26-2007 10:56 AM
Hi,
Use TCODE CG3Y to download the file to application server.
Regards,
Prashant
12-26-2007 2:56 PM
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
12-26-2007 3:12 PM
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.
12-27-2007 4:02 AM
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.
12-27-2007 4:53 AM
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
12-27-2007 5:13 AM
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
12-27-2007 5:23 AM
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.
12-27-2007 6:53 AM
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.