topic Re: Select statment in Application Development and Automation Discussions

Select statment

Former Member — Thu, 13 Nov 2008 11:26:33 GMT

I want select data from ztable.

ztable contains fields like objnr,stat,acc.

i want to read records from Objnr like 'OR.....'.

I have some exclude conditions.

stat = '23' and acc = ' '.

stat = '28' and acc = ' '.

stat = '39' and acc = ' '.

please the provide the logic.

Regards,

Suresh

Re: Select statment

former_member404244 — Thu, 13 Nov 2008 11:29:47 GMT

Hi,

create two range tables as r_stat and r_acc with the values u want to exclde..

Select * from ztable where objnr like 'OR%'

and stat not in r_stat

and acc not in r_acc.

Regards,

Nagaraj

Re: Select statment

Former Member — Thu, 13 Nov 2008 11:35:24 GMT

Hi,

How to bulid range table give me simple example

Regards,

Suresh

Re: Select statment

Former Member — Thu, 13 Nov 2008 11:38:58 GMT

Hi,

Ex:

Ranges declaration

DATA: r_bukrs TYPE RANGE OF tka02-bukrs.

rs_bukrs-sign = 'I'

rs_bukrs-option = 'EQ'

rs_bukrs-low = 'IN01'.

APPEND rs_bukrs TO r_bukrs.

Regards,

Kalp...

Re: Select statment

Former Member — Thu, 13 Nov 2008 11:42:54 GMT

Select * from ztable INTO TABLE itab where objnr like 'OR%'
and stat NOT in ( '23', '28', '29')
and acc NE ''.

Re: Select statment

Former Member — Thu, 13 Nov 2008 12:15:38 GMT

Hi Suresh,

You can try something like this,

tables ztable.

ranges: r_stat for ztable-stat,

r_acc for ztable-acc.

r_stat-sign = 'E'.

r_stat-option = 'EQ'.

r_stat-low = '23'.

append r_stat.

r_stat-sign = 'E'.

r_stat-option = 'EQ'.

r_stat-low = '28'.

append r_stat.

r_stat-sign = 'E'.

r_stat-option = 'EQ'.

r_stat-low = '39'.

append r_stat.

r_acc-sign = 'E'.

r_acc-option = 'EQ'.

r_acc-low = ''.

append r_acc.

now use the select statement and use these ranges to be excludes in the where clause as follows

select * from ztable into table itab where objnr like 'OR%' and stat in r_stat and acc in r_acc.

This should exclude all values in the r_stat and r_acc along with objnr like OR.

Thanks and Regards,

Sachin Dargan