topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Wed, 18 Jun 2008 05:20:29 GMT

i have created one RFC. in that one import parameter is clientname. after giving the clientname i want to check the database table wheather that word contains in the database table of that field. how to write select satatement with contains.

please help me

Re: select statement

Former Member — Wed, 18 Jun 2008 05:21:57 GMT

Hi,

Write:

select f1 from tab1

where f1 like '%WORD%.

Re: select statement

Former Member — Wed, 18 Jun 2008 05:25:10 GMT

hi,

select single * from table name where sy-mandt = xxxxx.

if sy-subrc = 0.

message i000(0) with 'User exists'.

else.

message i000(0) with 'User doesnot exists'.

endif.

Hope this is clear.

Thanks and regards

Re: select statement

former_member195383 — Wed, 18 Jun 2008 05:25:58 GMT

suppose ztab is the database table....and wf_name is the parameter that u r passing.

select single namefield

into wf_namecheck from ztab

where namefield cs wf_name.

if sy-subrc = 0.

it is success..

Reward if useful...

Re: select statement

Former Member — Wed, 18 Jun 2008 05:26:53 GMT

Hi vishal

its not working.

Re: select statement

Former Member — Wed, 18 Jun 2008 06:10:08 GMT

Try this:

concatenate '%' import_parameter_name '%' into v_clientname.

select single f1 from table1 where f1 like v_clientname.

if sy-subrc = 0.

found

else.

not found

endif.