Range

[kiran_k8]

r_kschl-sign = 'I'.

r_kschl-option = 'EQ'.

r_kschl-low = 'JEC1'.

APPEND r_kschl.

r_kschl-low = 'JEC2'.

APPEND r_kschl.

r_kschl-low = 'JM01'.

APPEND r_kschl.

r_kschl-low = 'JM02'.

APPEND r_kschl.

......

....

...........

IF NOT itab3[] IS INITIAL.

CLEAR: R_KSCHL,ITAB3.

SELECT belnr AS belnr1

mwskz

hwbas

hwste

kschl

kbetr

FROM bset INTO CORRESPONDING FIELDS OF TABLE itab4

FOR ALL ENTRIES IN itab3

WHERE belnr = itab3-belnr1

AND kschl IN r_kschl

AND kbetr NE 0.

ENDIF.

I need to fetch all the conditon types declared in the range but it is fetching me only one.How a range works?

Thanks,

K.Kiran.

[Former Member]

hi

write it like dis

r_kschl-sign = 'I'.

r_kschl-option = 'EQ'.

r_kschl-low = 'JEC1'.

APPEND r_kschl.

r_kschl-sign = 'I'.

r_kschl-option = 'EQ'.

r_kschl-low = 'JEC2'.

APPEND r_kschl.

r_kschl-sign = 'I'.

r_kschl-option = 'EQ'.

r_kschl-low = 'JM01'.

APPEND r_kschl.

r_kschl-sign = 'I'.

r_kschl-option = 'EQ'.

r_kschl-low = 'JM02'.

APPEND r_kschl.

[kiran_k8]

Will,

IN debuggin R_KSCHL is having both the condition types but while fetchng the data using select query it is fetching only JEC1.

K.Kiran.

[Former Member]

kiran

check ur select query if it is

where < > IN R_KSCHL

[Former Member]

hi,

Append all entries like first one only.

r_kschl-sign = 'I'.

r_kschl-option = 'EQ'.

r_kschl-low = 'JEC1'.

APPEND r_kschl.

r_kschl-sign = 'I'.

r_kschl-option = 'EQ'.

r_kschl-low = 'JEC2'.

APPEND r_kschl.

r_kschl-sign = 'I'.

r_kschl-option = 'EQ'.

r_kschl-low = 'JM01'.

APPEND r_kschl.

r_kschl-sign = 'I'.

r_kschl-option = 'EQ'.

r_kschl-low = 'JM02'.

APPEND r_kschl.

[seshatalpasai_madala]

Hi,

Run an SQL trace (ST05) and check if the query is getting executed in the same way as you want it. Also make sure that the table has other conditions which are checking for, that is there are values in the table as per your condition.

Regards

Sesh

[arpit_shah]

hi,

try like this,

e.g

ranges : temp for mkpf-budat.

temp-low = from_date.

temp-high = to_date.

append temp to temp.

now pass this temp in like ur using select-options.

i.e.

select field ..into..

where

date in temp.

Regards,

Arpit.

[Former Member]

check ur table itab3 with which u are fetching values. check whether the lines u r fetching based on this table have kschl with all values defined in ur range.

Rgds

Sathar