topic Re: Select Join problem in Application Development and Automation Discussions

Select Join problem

Former Member — Thu, 24 Apr 2008 07:34:44 GMT

Hi Experts,

I need your help on this. I really don't know what's wrong with my select statment. Please let me know what went wrong. I'm not sure if select join statement allows parameters for select-options. Below is my select statement. Thanks.

SELECT tbtco_{jobname tbtcp}listident

INTO CORRESPONDING FIELDS OF TABLE itab

FROM tbtco JOIN TBTCP ON ( tbtco_{jobcount = tbtcp}jobcount )

WHERE tbtco~status = 'F'

AND tbtco~jobname IN P_SEARCH

AND tbtco~enddate IN p_date

AND tbtcp~listident IN p_spool.

IF sy-subrc = 0.

APPEND itab.

CLEAR itab.

ENDIF.

Anna

Re: Select Join problem

PS_1978 — Thu, 24 Apr 2008 07:38:21 GMT

Hi,

if those are the parameters, use EQ instead of IN. There is no need of APPEND ITAB statement as you are using INTO CORRESPONDING FIELDS OF TABLE ITAB.

Best Regards,

Kumar. S

Edited by: Sivapuram Phani Kumar on Apr 24, 2008 1:08 PM

Re: Select Join problem

Former Member — Thu, 24 Apr 2008 07:43:03 GMT

hi try


SELECT tbtco~jobname tbtcp~listident
INTO CORRESPONDING FIELDS OF TABLE itab
FROM ( tbtco INNER JOIN TBTCP ON tbtco~jobcount = tbtcp~jobcount AND tbtcp~listident IN p_spool )
WHERE tbtco~status = 'F'
AND tbtco~jobname IN P_SEARCH
AND tbtco~enddate IN p_date.

bye

reward if useful

Re: Select Join problem

Former Member — Thu, 24 Apr 2008 08:21:46 GMT

Thanks for your reply, but I'm using select-options for this. That's why I had to put "IN."

Re: Select Join problem

Former Member — Thu, 24 Apr 2008 08:26:36 GMT

Just to give you an idea: Here's what I did.

SELECT-OPTIONS: p_search FOR TBTCO-jobname,

p_date FOR TBTCO-enddate,

p_spool FOR TBTCP-listident.

DATA: BEGIN OF itab OCCURS 0,

sp_name TYPE tbtco-jobname,

br_code(1),

dumon(7),

sp_numb TYPE TSP01-rqident,

ofc(12),

END OF itab.

SELECT tbtco_{jobname tbtcp}listident

INTO CORRESPONDING FIELDS OF TABLE itab

FROM tbtco JOIN TBTCP ON ( tbtco_{jobcount = tbtcp}jobcount )

WHERE tbtco~status = 'F'

AND tbtco~jobname IN P_SEARCH

AND tbtco~enddate IN p_date

AND tbtcp~listident IN p_spool.

IF sy-subrc = 0.

APPEND itab.

CLEAR itab.

ENDIF.

Re: Select Join problem

Former Member — Thu, 24 Apr 2008 08:28:14 GMT

Hi Matthias,

Thanks so much for your reply but sad to say that your suggestion prompted an error that "You cannot use "IN" in "ON" conditions.

Re: Select Join problem

Former Member — Thu, 24 Apr 2008 10:05:53 GMT

Hi,

Are you getting any error?

Regards,

Pria.

Re: Select Join problem

PS_1978 — Thu, 24 Apr 2008 10:08:50 GMT

Hi,

tables: tbtco, tbtcp.

Define these two tables just above the select-options... it will work...

Regards,

Kumar.

Re: Select Join problem

Former Member — Thu, 24 Apr 2008 20:07:52 GMT

Hi,

You can use select-options in u r where condition with IN operator so it should perfectly work and the error u r getting is not because of join statement so try declaring tables that u r using in u r select-options to avoid fields are not found and try ,it should work then.

reward if it is useful.

Thanks,

Ramesh.

Re: Select Join problem

Former Member — Fri, 25 Apr 2008 07:25:14 GMT

Hi Pria,

Actually there's no error. The sy-subrc actually returns 0, but it doesn't save the data in the internal table. Anyway to solve this problem, I did the long way. I copied one table into an itab and just did looping. I just had this idea that maybe SELECT-JOIN statements don't accept parameters selection-options.