topic Re: validation error in Application Development and Automation Discussions

validation error

Former Member — Sat, 05 Jun 2010 02:57:33 GMT

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.

Re: validation error

Former Member — Sat, 05 Jun 2010 03:22:50 GMT

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

Re: validation error

Former Member — Sat, 05 Jun 2010 04:50:07 GMT

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