topic Re: help in join in Application Development and Automation Discussions

help in join

Former Member — Tue, 11 Mar 2008 09:17:04 GMT

hi,

i do this select and its working o.k. and i wont to add

another join on table p0001 fields ename what is the best what to do that?

i new in this topic

SELECT anla_{txt50 anla}anlkl anla~anln1

anlz_{raumn anla}liefe

FROM ( anlz

INNER JOIN anla

ON anlz_{anln1 = anla}anln1 )

INTO CORRESPONDING FIELDS OF TABLE it_an

WHERE anlz~pernr = pernr.

i try like that but i get wrong data ///

SELECT  pa0001-ename anla~txt50 anla~anlkl anla~anln1 anla~bukrs anla~sernr
         anlz~raumn anla~liefe 
  FROM  ( anlz
  INNER JOIN anla
  ON anlz~anln1  = anla~anln1 )
  *INNER JOIN pa0001*
  *ON pa0001~pernr = anlz~pernr )*
  INTO CORRESPONDING FIELDS OF TABLE it_an
  WHERE anlz~pernr = pernr.

Regards

Re: help in join

Former Member — Tue, 11 Mar 2008 09:25:59 GMT

Take pernr field into table 'it_an' and write for all entries on PA0001.

SELECT ename from pa0001

into table it_ename

for all entries in it_an

where pernr = it_an-pernr.

Re: help in join

Former Member — Tue, 11 Mar 2008 09:26:42 GMT

hi try this ,

tables :pa0001,anla.

data: begin of itab occurs 0,

pernr like pa0001-pernr,

ename like pa0001-ename,

txt50 like anla-txt50,

bukrs like anla-bukrs,

sernr like anla-sernr,

raumn like anla-raumn,

liefe like anla-liefe,

end of itab.

parameters:p_pernr like pa0001-pernr.

SELECT pa0001~ename

anla~txt50

anla~anln1

anla~bukrs

anla~sernr

anlz~raumn

anla~liefe

FROM ( ( anlz INNER JOIN anla ON anlz_{anln1 = anla}anln1 )

INNER JOIN pa0001

ON pa0001_{pernr = anlz}pernr )

INTO CORRESPONDING FIELDS OF TABLE itab

WHERE anlz~pernr = p_pernr.

regards,

venkat.

Re: help in join

Former Member — Tue, 11 Mar 2008 09:34:14 GMT

hi dude,

try this ,

SELECT pa0001-ename anla_{txt50 anla}anlkl anla_{anln1 anla}bukrs anla~sernr

anlz_{raumn anla}liefe

INTO CORRESPONDING FIELDS OF TABLE it_an

INNER JOIN anla

as anlz_{anln1 = anla}anln1

INNER JOIN pa0001

ON pa0001_{pernr = anlz}pernr )

WHERE anlz~pernr = pernr.

if help then ................................................

Edited by: pankaj vashista on Mar 11, 2008 10:35 AM

Edited by: pankaj vashista on Mar 11, 2008 10:37 AM