Skip to Content
0
Former Member
Oct 17, 2006 at 02:49 PM

Select Statement

33 Views

I need to compare two or status and dont diplay the data for the following status entered in the select statement.

if the status are like stat - 'I0002' , stat - 'I0042', stat - 'I0010', stat - 'I0009'.

if the object id is having all the status which has being entered in the select statement then i dont display the obj id of the status entered.

how should i write the select statement.

SELECT SINGLE * INTO I_JEST FROM JEST

WHERE OBJNR = I_TMP_CAUFV-OBJNR and STAT......