topic Re: parameters in Application Development and Automation Discussions

parameters

Former Member — Mon, 13 Aug 2007 06:42:51 GMT

IF I TYPE A VALUE IN THE PARAMETER IN SELECTION SCREEN, THAN IF I PRESS THE TAB BUTTON OR CLICK THE ANOTHER FIELD, IT SHOULD AUTOMATICALLY CHECK THE DATABASE TABLE.... IF ENTERED VALUE IS FOUND IN TABLE... IT SHOULD SAY ''VALUE ALREADY EXIST'.

Re: parameters

Former Member — Mon, 13 Aug 2007 06:46:36 GMT

use event AT SELECTION-SCREEN for validations.

cheers

Sameer

Re: parameters

Former Member — Mon, 13 Aug 2007 06:50:15 GMT

Hi,

Use this

AT SELECTION-SCREEN ON 'PARAMETERS FIELD'.

AT SELECTION-SCREEN ON 'CARRID'.

Re: parameters

Former Member — Mon, 13 Aug 2007 06:51:16 GMT

Hi Sasi

at selection-screen.

here read the parameter calue that u have entered and check whether the value is existing in database.

select single matnr from mara where matnr eq p_matnr.

if sy-subrc eq 0.

message i000(z00) ' the material is already exits'.

endif.

reward points to all helpful answers

kiran.M

Re: parameters

Former Member — Mon, 13 Aug 2007 06:56:24 GMT

Hello,

Message was edited by:

LIJO JOHN

Re: parameters

Former Member — Mon, 13 Aug 2007 06:57:17 GMT

for that parameter add extra key word VALUE CHECK

PARAMETERS : P_P1 LIKE MARA-MATNR VALUE CHECK .

REWARD IF USEFULL

Re: parameters

Former Member — Mon, 13 Aug 2007 06:57:48 GMT

Hello,

Use the Event

<b>At Selection-screen on 'PARAMETER_NAME'.</b>

This event is assigned to the selection screen fields corresponding to the report parameter . If the report starts an error dialog at this point, precisely these fields become ready for input.

Reffer the following code.

Validate Account Group.

AT SELECTION-SCREEN ON p_code.

SELECT SINGLE * FROM t001 WHERE bukrs = p_code.

IF sy-subrc <> 0.

MESSAGE e041 WITH 'Enter valid Company Code'.

ENDIF.

Reward Points for good answers

Regards,

LIJO JOHN.