topic Re: a string with some variables in it in Application Development and Automation Discussions

a string with some variables in it

Former Member — Tue, 12 Oct 2010 19:05:55 GMT

Hi Friends,

I am trying to construct a string with some variables in it.

I am not getting the values of the variables

instead only the string. How must the below string look

if pa_lief and pa_bukr are variables where contain values.

ls_options-TEXT =  'LIFNR =  pa_lief AND BUKRS =  pa_bukr '.
APPEND ls_options TO lt_options.

Kindly regards

Marco

Former Member — Tue, 12 Oct 2010 19:23:30 GMT

CONCATENATE 'LIFNR =' pa_lief 'AND BUKRS =' pa_bukr into ls_options-TEXT separated by ' '.

Regds,

Senthil

Former Member — Tue, 12 Oct 2010 19:35:20 GMT

Kumar thx since this is a criteria of select statement I need both the values and the quotes.

ls_options-TEXT = 'WHERE LIFNR = ''0000241332'' AND BUKRS = ''0120'''.

Regards

Marco

Former Member — Tue, 12 Oct 2010 20:16:34 GMT

This seems very basic. You just include the quotes when doing the concatenation, being careful of spaces.

Rob

Former Member — Tue, 12 Oct 2010 20:18:00 GMT

Why do you need double quotes ".. double quotes doesnot mean anything but comment.

Concatenate should suffice your where condition.

CONCATENATE 'WHERE' 'LIFNR =' pa_lief 'AND BUKRS =' pa_bukr into ls_options-TEXT separated by ' '.

WRITE : 'WHERE', 'LIFNR =', pa_lief, 'AND BUKRS =', pa_bukr to ls_options-TEXT.

former_member186741 — Wed, 13 Oct 2010 02:16:37 GMT

why do you want the variable values rather than the names? The sql select can cope with the variable names.

I think Senthil's original solution is fine,

CONCATENATE 'LIFNR =' pa_lief 'AND BUKRS =' pa_bukr into ls_options-TEXT separated by ' '.