Extended Program Check Warning For Syntax Check

Former Member — Tue, 08 Jun 2010 10:16:57 GMT

Warning:

Syntax Check Warning

This Warning only Displayed in SLIN

WHERE lgtyp IN S_LGTYP.

Messages :

In "SELECT SINGLE...", the where condition for the key field "LGTYP" does not test for equality .

There fore the single record yuor searching may not be unique.

IF NOT S_LGTYP[] IS INITIAL.

SELECT SINGLE * FROM T301

WHERE lgtyp IN S_LGTYP.----

>IT SHOWING THIS LINE

IF SY-SUBRC NE 0.

MESSAGE E005(Z01).

ENDIF.

Re: Extended Program Check Warning For Syntax Check

Former Member — Tue, 08 Jun 2010 12:43:52 GMT

Hi Raghu,

When you are using SELECT SINGLE, it is always better to use EQ in the condition than IN.

Instead of using select-options S_LGTYP, declare a parameter: P_LGTYP and if possible re-write the select query as below:

SELECT SINGLE * FROM T301 into lv_variable

WHERE lgtyp EQ P_LGTYP .

Regards

Deepa.