topic Select query.... in Application Development and Automation Discussions

Select query....

anupam_srivastava2 — Fri, 01 Nov 2013 13:52:03 GMT

Hi All

I have one simple requirement, hope you guys able to help me..

I have got two tables..

table A kna1(table B)

kunnr kunnr

x ktokd

y x

z y

table A and table B are linked with kunnr.

Now my requirement is I have to select all kunnr from table A, where ktokd(account group) in KNA1 is having values (a,b,c,d).

Can you please suggest me how can I write my select query.

Regards

Anup

Re: Select query....

kjetil_sandvik2 — Fri, 01 Nov 2013 14:17:51 GMT

Hi,

try this:

SELECT

T0.kunnr

FROM TABLEA T0

INNER JOIN TABLEB T1 ON T0.kunnr = T1.kunnr

WHERE T1.kunnr in(a,b,c,d)

Kjetil Sandvk

Re: Select query....

kjetil_sandvik2 — Fri, 01 Nov 2013 14:19:27 GMT

Sorry, you will have to use in('a','b','c','d')

Re: Select query....

Former Member — Fri, 01 Nov 2013 14:22:04 GMT

Hi,

Select kunnr x y z into table it_table A.

Select Kunnr ktokd x y into table it_tableB for all entries in it_table A where kunnr = it_table A-kunnr.

by using above select query you get necessary data,

after that you can perform any operation on your tables.

Re: Select query....

Ruediger_Plantiko — Fri, 01 Nov 2013 14:33:35 GMT

and the column was different:

...

WHERE T1.ktokd in('a','b','c','d')

...

Re: Select query....

Former Member — Fri, 01 Nov 2013 14:38:32 GMT

Hi Anupam,

You can try like this.

TYPES: BEGIN OF t_cust,

kunnr TYPE kunnr,

END OF t_cust.

DATA: i_cust TYPE STANDARD TABLE OF t_cust,

i_knvv TYPE TABLE OF knvv,

i_kna1 TYPE TABLE OF kna1.

Select kna1~kunnr

into table i_cust

from kna1

inner join knvv

on kna1~kunnr = knvv~kunnr

WHERE KTOKD eq 'A'

OR KTOKD eq 'B'

OR KTOKD eq 'C'

OR KTOKD eq 'D'.

Thanks,

Shreekant