topic Re: Select Statement. in Application Development and Automation Discussions

Select Statement.

Former Member — Fri, 13 Oct 2006 16:59:06 GMT

i need to compare two status and then diplay how should i do that.

if the stat - 'I0002' , stat - 'I0042'.

if the object id is having both the stat then only i need to display it.

how should i write the select statement.

SELECT SINGLE * INTO I_JEST FROM JEST

WHERE OBJNR = I_TMP_CAUFV-OBJNR and STAT IN ('I0002','I0042')

Re: Select Statement.

Former Member — Fri, 13 Oct 2006 17:02:06 GMT

Do like this:

data: i_jest type standard table of jest,

wa_jest type jest.

SELECT * INTO table I_JEST FROM JEST

WHERE OBJNR = I_TMP_CAUFV-OBJNR and

( STAT = 'I0002' or STAT = 'I0042' ).

if sy-subrc = 0.

endif.

Regards,

Praaksh.

Re: Select Statement.

Former Member — Fri, 13 Oct 2006 17:02:33 GMT

Hi,

I think you cannot do this in a single select statement..

Instead Try this..

SELECT * INTO TABLE IT_JEST FROM JEST

WHERE OBJNR = I_TMP_CAUFV-OBJNR and STAT IN ('I0002','I0042')

READ TABLE IT_JEST WITH KEY OBJNR = I_TMP_CAUFV-OBJNR

STAT = 'I0002'.

IF SY-SUBRC = 0.

READ TABLE IT_JEST WITH KEY OBJNR = I_TMP_CAUFV-OBJNR

STAT = 'I0004'.

IF SY-SUBRC = 0.

Both the status are found..

ENDIF.

Thanks,

Naren

Re: Select Statement.

Former Member — Fri, 13 Oct 2006 17:03:02 GMT

SELECT SINGLE * INTO I_JEST FROM JEST

WHERE OBJNR = I_TMP_CAUFV-OBJNR and STAT = 'I0002' or stat = 'I0042'.

Re: Select Statement.

Former Member — Fri, 13 Oct 2006 17:05:48 GMT

Hi Kamlesh,

write this select ...

SELECT SINGLE * INTO I_JEST FROM JEST

WHERE OBJNR = I_TMP_CAUFV-OBJNR and

( STAT = 'I0002' or STAT = I0042)

Regards

Sudheer

Re: Select Statement.

Former Member — Fri, 13 Oct 2006 17:12:05 GMT

SELECT SINGLE * INTO I_JEST FROM JEST
WHERE OBJNR = I_TMP_CAUFV-OBJNR and STAT = 'I0002'.
if sy-subrc = 0.
  SELECT SINGLE * INTO I_JEST FROM JEST
WHERE OBJNR = I_TMP_CAUFV-OBJNR and STAT = 'I0042'.
endif.

so now ur object id will contain both the status