Application server Download.

[kesavadas_thekkillath]

I have written a code to download the itab data into a excel fiel to application server.

The download is happening correctly...but

the problem is the the data is not getting seperated columnwise

its displaying in the single column.

How to provide the tab seperator.

I used the #,pipe symbol for seperation...but its not coming correctly...how to resolve this

CONSTANTS:co_remotepath(40) VALUE '/tmp/meterid.xls'.

DATA:wk_string(200).

DATA:wk_menge(10).

DATA:wk_seperator TYPE c VALUE '|'.

OPEN DATASET p_pfile FOR OUTPUT IN TEXT MODE

ENCODING DEFAULT.

CONCATENATE text-007

wk_seperator

text-008

wk_seperator

text-009

INTO wk_string.

TRANSFER wk_string TO p_pfile.

CLEAR wk_string.

LOOP AT p_it_final.

wk_menge = p_it_final-menge.

CONDENSE wk_menge.

CONCATENATE p_it_final-matnr_i

wk_seperator

p_it_final-maktx

wk_seperator

wk_menge

INTO wk_string .

TRANSFER wk_string TO p_pfile.

ENDLOOP.

CLOSE DATASET p_pfile.

ENDIF.

[kesavadas_thekkillath]

I have written a code to download the itab data into a excel fiel to application server.

The download is happening correctly...but

the problem is the the data is not getting seperated columnwise

its displaying in the single column.

How to provide the tab seperator.

I used the #,pipe symbol for seperation...but its not coming correctly...how to resolve this

CONSTANTS:co_remotepath(40) VALUE '/tmp/meterid.xls'.

DATA:wk_string(200).

DATA:wk_menge(10).

DATA:wk_seperator TYPE c VALUE '|'.

OPEN DATASET p_pfile FOR OUTPUT IN TEXT MODE

ENCODING DEFAULT.

CONCATENATE text-007

wk_seperator

text-008

wk_seperator

text-009

INTO wk_string.

TRANSFER wk_string TO p_pfile.

CLEAR wk_string.

LOOP AT p_it_final.

wk_menge = p_it_final-menge.

CONDENSE wk_menge.

CONCATENATE p_it_final-matnr_i

wk_seperator

p_it_final-maktx

wk_seperator

wk_menge

INTO wk_string .

TRANSFER wk_string TO p_pfile.

ENDLOOP.

CLOSE DATASET p_pfile.

ENDIF.

[Former Member]

CONSTANTS:co_remotepath(40) VALUE '/tmp/meterid.xls'.

DATA:wk_string(200).
DATA:wk_menge(10).
DATA:wk_seperator TYPE c VALUE '|'.

OPEN DATASET p_pfile FOR OUTPUT IN TEXT MODE 
ENCODING DEFAULT.

CONCATENATE text-007
*wk_seperator
text-008
*wk_seperator
text-009
INTO wk_string
separated by cl_abap_char_utilities=>horizontal_tab. " add this line

TRANSFER wk_string TO p_pfile.

CLEAR wk_string.

LOOP AT p_it_final.

wk_menge = p_it_final-menge.

CONDENSE wk_menge.

CONCATENATE p_it_final-matnr_i
*wk_seperator
p_it_final-maktx
*wk_seperator
wk_menge
INTO wk_string separated by cl_abap_char_utilities=>horizontal_tab. " add this line 

TRANSFER wk_string TO p_pfile.

ENDLOOP.

CLOSE DATASET p_pfile.
ENDIF.

[vishal_sharda2]

Hi Keshu,

Greetings!

Which FM are you using for download?

You can check if there is any parameter in FM for field separator.

Please let me know which FM are you using.

Regards,

Vishal.

[Former Member]

Hi,

To get a tab seperator declare a constant

l_tab type c value cl_abap_char_utilities=>horizontal_tab.

Use concatenate A B into C seperated by l_tab.

Then you will get the tab seperator