topic Help in join in Application Development and Automation Discussions

Help in join

Former Member — Tue, 18 Mar 2008 08:32:54 GMT

hi,

i do this join and i get in the retrieval data with subty 02 ,03,20

despite that i put the line (IN) in code see below

what i doing wrong?

Regards

SELECT pa0040~pernr pa0040~lobnr t591s~stext
   FROM ( pa0040
   INNER JOIN t591s
     ON pa0040~subty = t591s~subty
     AND t591s~infty = '0040'
     AND t591s~sprsl = 'E' )
     INTO CORRESPONDING FIELDS OF TABLE it_p40
    WHERE pernr = pernr
     AND pa0040~subty IN ('01', '12', '13','14','15','16','17','19')  <--HERE
     AND pa0040~begda LE to
     AND pa0040~endda GE to.

Re: Help in join

Former Member — Tue, 18 Mar 2008 08:36:14 GMT

Check the where condition

WHERE pa0040~pernr = pernr

Re: Help in join

Former Member — Tue, 18 Mar 2008 08:37:47 GMT

Hi Ricardo ,

Try this .

SELECT pa0040_{pernr pa0040}lobnr t591s~stext

FROM ( pa0040

INNER JOIN t591s

ON pa0040_{subty = t591s}subty

AND t591s~infty = '0040'

AND t591s~sprsl = 'E' )

INTO CORRESPONDING FIELDS OF TABLE it_p40

WHERE pa0040~subty IN ('01', '12', '13','14','15','16','17','19')

and pa0040~pernr = pernr

AND pa0040~begda LE to

AND pa0040~endda GE to.

Regards,

Chitra

Re: Help in join

Former Member — Tue, 18 Mar 2008 08:48:13 GMT

Dear


SELECT pa0040~pernr pa0040~lobnr t591s~stext
 INTO CORRESPONDING FIELDS OF TABLE it_p40   
 FROM  pa0040
   INNER JOIN t591s
     ON pa0040~subty = t591s~subty
     AND t591s~infty = '0040'
     AND t591s~sprsl = 'E'     
    WHERE pernr = pernr
     AND pa0040~subty IN ('01' , '12' , '13' , '14' , '15' , '16' , '17' , '19') 
     AND pa0040~begda LE to ?????
     AND pa0040~endda GE to ?????.

Try this code (copy and past and put relevant Date fields to where i placed ?????.

Rewards if Useful.