topic Need help on SQL query in Application Development and Automation Discussions

Need help on SQL query

karthik_narayan2 — Fri, 17 Sep 2010 03:02:40 GMT

Hi ,

I am trying to pull the data from 2 tables TBCTO and TBTCP using Inner join condition, but i am not able to get the result.

can anyone please help me out. below is the query.

SELECT tbtco_{jobname tbtco}strttime tbtco_{prdmins tbtco}prdhours

tbtco_{prddays tbtco}prdweeks tbtco_{prdmonths tbtco}periodic

tbtco~eventid

tbtcp_{progname tbtcp}variant

INTO CORRESPONDING FIELDS OF TABLE git_jblst

FROM tbtco

INNER JOIN tbtcp

ON tbtco_{jobname = tbtcp}jobname

AND tbtco_{jobcount = tbtcp}jobcount

WHERE tbtco~jobname LIKE s_jbname.

Thanks,

Re: Need help on SQL query

Former Member — Fri, 17 Sep 2010 03:13:05 GMT

Hi,

Try to change your where clause to:


WHERE tbtco~jobname IN s_jbname. "instead of LIKE as yours

regards,

Re: Need help on SQL query

Former Member — Fri, 17 Sep 2010 03:34:44 GMT

Please check parameter s_jbname, IN ABAP OPEN SQL,Wildcard characters can be used to create the pattern in dobj, where "%" represents any character string, even an empty one, and "_" represents any character. Captilatization is taken into account. Blank characters at the end of dobj are ignored. This is also valid in particular for data objects of the type string with closing blank characters that are otherwise taken into account in ABAP.

You can refer to the following code:

PARAMETERS srch_str TYPE c LENGTH 20.

DATA text_tab TYPE TABLE OF doktl.

CONCATENATE '%' srch_str '%' INTO srch_str.

SELECT *

FROM doktl

INTO TABLE text_tab

WHERE doktext LIKE srch_str.

Edited by: Jack Wu on Sep 17, 2010 11:36 AM

Re: Need help on SQL query

karthik_narayan2 — Fri, 17 Sep 2010 03:47:21 GMT

Thanks, it works.