Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

select statement

hi i all i have a requirement please look at this

select orders where field1 lies between 1000000-399999

if no orders found then select orders excluding the above crietria

i can use ranges

r_field-sign = 'I'.

r_field-option = 'BT'.

r_field-low = '100000'.

r_field-high = '399999'.

this will go for my 1select but what to do for the 2nd select where i need to

search excluding 1000000-3999999

please let me knw



Former Member
Not what you were looking for? View more on this topic or Ask a question