topic Re: Add table in query. in Application Development and Automation Discussions

Add table in query.

Former Member — Sun, 22 Feb 2009 13:30:01 GMT

Hello experts ,

I have query with 1 table , if i want to add one more table to my query and make a join with 2 tables or more than 2 , how can i do this ?

Thanks for your help,

Avi.

Re: Add table in query.

Former Member — Sun, 22 Feb 2009 13:33:51 GMT

hi.

select kna1~kunnr kna1~sortl zsdo~asmid pa0001~ename
       zsdo~pc_p01_begda zsdo~pc_p01_ded_per
        into corresponding fields of table it_samptb_all
        from zsdo
        inner join kna1 on ( zsdo~kunnr = kna1~kunnr )
        inner join pa0001 on ( zsdo~asmid = pa0001~pernr )
    where zsdo~samp_flag eq 'X'     " Sampling is Active
      and zsdo~ostact = '1'         " Active Outlets only
      and zsdo~pc_p01_cshare ne '0'
      and pa0001~endda eq '99991231'
      and zsdo~ssok in ssok1
      and zsdo~kunnr in kunnr1.

Re: Add table in query.

vinod_vemuru2 — Sun, 22 Feb 2009 13:34:27 GMT

Hi,

Go to SQ02 tcode, open ur query in change mode. Click on JOIN button.

Here u can specify JOIN tables as per ur requirement.

Thanks,

Vinod.

Re: Add table in query.

Former Member — Sun, 22 Feb 2009 13:40:09 GMT

Hello ,

I don't have join button when i open SQ02 transaction , i have 1 table and i want to add more .

Avi.