topic Re: make it as one select statement! in Application Development and Automation Discussions

make it as one select statement!

naveen_inuganti2 — Wed, 01 Oct 2008 05:38:45 GMT

Hi..,

See my coding..,

data: customer like kna1-kunnr,
        name like kna1-name1.

parameter: p_filed1 like ztable-filed1

select single kunnr from ztable into customer where filed1 = p_filed1.
 if sy-subrc = 0.
  select single name1 from kna1 into name where kunnr = custmer.
 endif.

So I can pass this name into other parameter(function modules) with out READ and LOOP statements as you know..

Now my question is how can modify above coding with one select statement.

I want name entry in variable only...

Thanks,

Naveen.I

Re: make it as one select statement!

Former Member — Wed, 01 Oct 2008 05:42:39 GMT

hi..

U can use joins by linking kunnr in name1 field.

Re: make it as one select statement!

naveen_inuganti2 — Wed, 01 Oct 2008 05:44:14 GMT

Hi..,

Yes, I can join.

But how i can pass name1 into single variable, please get back with sample code..,

Thanks,

Naveen.i

Re: make it as one select statement!

Former Member — Wed, 01 Oct 2008 05:47:01 GMT

Hi,

You did not mention all the fields of the ztable.

So if you have common key fields in both ztable and kna1 then you can Join both the table in single select statement.

Re: make it as one select statement!

Former Member — Wed, 01 Oct 2008 05:58:22 GMT

Hi,

Try to change the piece of code as follows:

select single kna1~name1

into name

from kna1 inner join ztable

on kna1_{kunnr = ztable}kunnr

where ztable~filed1 = p_filed1.

Thanks & Regards,

Navneeth K.