Solved: a string with some variables in it

Former Member · ‎2010 Oct 12

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 · ‎2010 Oct 12

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

Regds,

Senthil

Former Member · ‎2010 Oct 12

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

Regds,

Senthil

Former Member · ‎2010 Oct 12

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

like

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

Regards

Marco

Former Member · ‎2010 Oct 12

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

Rob

Former Member · ‎2010 Oct 12

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 · ‎2010 Oct 13

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 ' '.

a string with some variables in it