validation error

[Former Member]

perform CHECK_T300.

*FORM CHECK_T300.

• IF NOT P_LGNUM IS INITIAL.
•    SELECT SINGLE * FROM T300 WHERE LGNUM EQ P_LGNUM.
•       IF SY-SUBRC NE 0.
•          MESSAGE E016(Z01) WITH P_LGNUM.
•       ENDIF.
• ENDIF.

*ENDFORM.               " CHECK_T300

Error:  THE INTO CLAUSE IS MISSING AT SELECT OR FROM ADDTION AT EITHER DELETE, INSERT, MODIFY, OR UPDATE IS MISSING.

P_LGNUM IS PARAMETER.

[Former Member]

Hi Raghu,

data : st_t300 type t300. " This acts as a work Area to hold values from T300 Or

Tables : T300 " This works as Implicit Work Area then you can omit INTO clause


FORM CHECK_T300.
 IF NOT P_LGNUM IS INITIAL.
 SELECT SINGLE * FROM T300 INTO ST_T300 WHERE LGNUM EQ P_LGNUM.
 IF SY-SUBRC NE 0.
 MESSAGE E016(Z01) WITH P_LGNUM.
 ENDIF.
 ENDIF.
ENDFORM. " CHECK_T300

Cheerz

Ram

[Former Member]

Hi,

Add TABLES keyword.

TABLES : T300.

SELECT SINGLE * FROM T300 WHERE LGNUM EQ P_LGNUM.

will work after you add TABLES keyword mentioned above.

Regards

Vinod