topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Thu, 04 Jan 2007 05:36:17 GMT

Hi,

I have one problem in following coding.

the condition is like that

select-options: s_kunnr for kna1-kunnr,

s_name1 for kna1-name1.

if not s_kunnr is initial.

perform kunnr_data.

else.

perform name1_data.

endif.

if not s_kunnr is initial.

select * from kna1 into corresponding fields of table lt_kna1 for all entries in s_kunnr where kunnr = s_kunnr-low.

endif,

form kunnr_data.

*under this subroutine there are some condition & we are appending multiple entries in s_kunnr.

endform.

*actually we are getting problem in above select statement.

*suppose we have 50 entries in s_kunnr then what I have to use in where condition so that it will fetch all the records based s_kunnr(rembember s_kunnr having 50 entries).

Re: select statement

Former Member — Thu, 04 Jan 2007 05:37:42 GMT

select * from kna1 into corresponding fields of table lt_kna1 for all entries in s_kunnr where kunnr in s_kunnr.

Re: select statement

former_member632991 — Thu, 04 Jan 2007 05:39:06 GMT

Hi,

use

select * from kna1 into corresponding fields of table lt_kna1 for where kunnr in s_kunnr.

Regards,

Sonika

Re: select statement

Former Member — Thu, 04 Jan 2007 05:39:14 GMT

just use kunnr in s_kunnr.

regards

shiba dutta

Re: select statement

Former Member — Thu, 04 Jan 2007 05:40:14 GMT

Hi Neha,

Declare an internal table of type kna1-kunnr.

use this internal table to fill multiple enties instead of s_kunnr.

Now use select * from dbtab for all entries in itab_kunnr where............

Hope this helps,

Pragya

Re: select statement

Former Member — Thu, 04 Jan 2007 05:54:29 GMT

Hi Kishan,

If I used the mentioned select statment I am getting error "the where condition does not refer to the FOR ALL ENTRIES table."

Could you please suggest me?

Re: select statement

Former Member — Thu, 04 Jan 2007 05:56:23 GMT

select * from kna1 into corresponding fields of table lt_kna1 where kunnr in s_kunnr.



s_kunnr-- is  not a internal table.

just write down ur requirment i m trying to solve it.

kishan negi

Re: select statement

former_member632991 — Thu, 04 Jan 2007 05:57:34 GMT

Hi,

u don't need to write for all entries, it will work without it

select * from kna1 into corresponding fields of table lt_kna1 for where kunnr in s_kunnr.

Regards,

Sonika

Re: select statement

Former Member — Thu, 04 Jan 2007 05:58:20 GMT

check this way...

loop at s_kunnr.

select * from kna1 into corresponding fields of table lt_kna1 for all entries in s_kunnr where kunnr = s_kunnr-low.

endloop.

or else...

select * from kna1 into corresponding fields of table lt_kna1 for all entries in s_kunnr where kunnr IN s_kunnr.

Re: select statement

Former Member — Thu, 04 Jan 2007 06:00:26 GMT

Dear Neha,

Please correct the following SQL Statement:

if not s_kunnr is initial.

select * from kna1 into corresponding fields of table lt_kna1 for all entries in s_kunnr where kunnr IN s_kunnr-low.

endif.

Regards,

Abir

***********************************

Don't forget to award Points *

Re: select statement

Former Member — Wed, 09 May 2007 05:02:06 GMT

hi neha,

select * from kna1 into corresponding fields of table lt_kna1 for all entries in s_kunnr where kunnr in s_kunnr.

with regards,

suresh babu