topic Error Msg in Select Statement in Application Development and Automation Discussions

Error Msg in Select Statement

Former Member — Wed, 22 Aug 2007 06:12:06 GMT

Hi,

Can you declare an error message under select statement?

Re: Error Msg in Select Statement

varma_narayana — Wed, 22 Aug 2007 06:31:43 GMT

Hi..

You can use the Message statement for this..

PARAMETERS: P_MATNR TYPE MARA-MATNR.

AT SELECTION-SCREEN ON P_MATNR.

SELECT SINGLE * FROM MARA WHERE MATNR = P_MATNR.

IF SY-SUBRC NE 0.

<b> MESSAGE E100(ZCLASS).</b>

ENDIF.

<b>Reward if Helpful</b>

Re: Error Msg in Select Statement

Former Member — Wed, 22 Aug 2007 06:34:35 GMT

AT SELECTION-SCREEN ON P_MATNR.

SELECT SINGLE * FROM MARA WHERE MATNR = P_MATNR.

IF SY-SUBRC NE 0.

MESSAGE E000(Z00) WITH 'NO MATNR EXISTS'.

CLOSE ALL U R THREADS.

KIRAN.M

Re: Error Msg in Select Statement

Former Member — Wed, 22 Aug 2007 06:38:24 GMT

Hi,

That depends on the event where u have used the error message.

In selection screen events u can use error message as control stops in selection screen it self. Where as if u used in selection events program execution is terminated by displaying an empty screen. So it is better not to use error message in start of selection events.

Regards,

Sankar