topic Concatenate in Application Development and Automation Discussions

Concatenate

Former Member — Tue, 22 Jan 2008 10:15:11 GMT

Hello

I need to select the data from AGR_USERS table(which is assignment of roles to users table).

Each user can have multiple roles.

My requirement is that I need to concatenate all the roles for a user in a string in an internal table.

How do I go about this?

Regards

Samir

Re: Concatenate

Former Member — Tue, 22 Jan 2008 10:20:17 GMT

hi,,

first get all the data into the internal table

then

declare variable

data:

w_roles type string.

loop at itab into wa.

concatenate wa-roles w_roles into w_roles separated by space .

endloop.

write: / w_roles.

plzz reward if it is usefull plzz dont forget to reward...

Re: Concatenate

Former Member — Tue, 22 Jan 2008 10:31:48 GMT

Hi,

You can get the usernames from USR02 table.Now for each entry in USR02 put a select-endselect statement fetching values from AGR_USERS table concatenating to the internal table's role entry corresponding to username.

Hope this helps.

Reward if useful.

Thanks.

Anjaly

Re: Concatenate

Former Member — Tue, 22 Jan 2008 10:36:13 GMT

Hi Davinder,

try Fm CONVERT_TABLE_TO_STRING

Regards,

-Muktar