topic Re: concatenation in Application Development and Automation Discussions

concatenation

Former Member — Thu, 22 Nov 2007 12:01:22 GMT

hi all,

i have internal table itab with single field dptype.the table has 3 records--

ITAB

DPTYPE A

DPTYPE B

DPTYPE C.

i have a field TEXT.

my requirement is i want all records of itab into single field TEXT,as follows

TEXT = A,B,C

what should i use-- concatenate ?

plz help me.

Thanks,

Shivaa.

Re: concatenation

Former Member — Thu, 22 Nov 2007 12:04:47 GMT

hi,

send ur query little bit clear,or send the coding

thanks

Re: concatenation

Former Member — Thu, 22 Nov 2007 12:05:25 GMT

<b>data: var(50) type c,

cnt type i,

lv_lines type i.

describe table itab lines lv_lines.

loop at itab into wa.

cnt = cnt + 1.

if sy-index = 1.

move wa-f2 to var.

else.

concatenate wa-f2 var into wa-f2 seperated by ','.

delete itab from wa.

Modify itab from wa.

clear wa.

endif.

if cnt = lv_lines.

exit.

endif.

endloop.</b>

Reward Points if this helps,

Satish

Message was edited by:

Satish Panakala

Re: concatenation

Former Member — Thu, 22 Nov 2007 12:06:50 GMT

Hi,

fld1 = 'aa'.

fld1 = 'bb'.

fld1 = 'cc'.

concatenate fld1 fld2 fld3 into text.

Regards,

Vani.

Re: concatenation

Former Member — Thu, 22 Nov 2007 12:06:58 GMT

clear text.

loop at itab.

concatenate itab-fld2 ',' text into text.

endloop.

this way you'l get all the values of field2 into text...

Re: concatenation

Former Member — Thu, 22 Nov 2007 12:16:46 GMT

Hi,

data: text type string,

text1 type string.

data from itab.

loop at itab into wa.

text1 = wa-a.

concatenate text1 text into text.

endloop.

write: text.

Reward points if useful.

Regards,

Vimal

Re: concatenation

Former Member — Thu, 22 Nov 2007 12:17:24 GMT

thanx a lot satish its working

Re: concatenation

Former Member — Thu, 22 Nov 2007 12:18:56 GMT

satish, the first reply from u was sufficent for me.

any way thanx fir the edited message