topic Re: validate user input with the screen flow logic. in Application Development and Automation Discussions

validate user input with the screen flow logic.

Former Member — Mon, 22 Feb 2010 12:00:51 GMT

Hello guys, im facing some troubles with the following code

field mara-matnr SELECT * 
                    from mara
                    into table itab_mara
                    where  matnr = mara-matnr
                    and  matnr = mara-matkl
                    WHENEVER NOT FOUND SEND ERRORMESSAGE 107
                               WITH  mara-matnr .

the editor doest recognize this code in PAI., is the same with VALUES clause.

what im doing wrong ? . thank you very mch.

Re: validate user input with the screen flow logic.

Former Member — Mon, 22 Feb 2010 12:11:45 GMT

Hi,

Please check code in where condition. Is the condition is right?

field mara-matnr SELECT *

from mara

into table itab_mara

where matnr = mara-matnr

and matnr = mara-matkl

WHENEVER NOT FOUND SEND ERRORMESSAGE 107

WITH mara-matnr .

MATNR is comparing with MATNR and also MATKL.

When you are doing the valiation make sure that use the chain and endchain stamt.

PAI

CHAIN:

MODULE VALI_DATA.

END CHAIN.

Like above do the code.

Re: validate user input with the screen flow logic.

Former Member — Mon, 22 Feb 2010 12:13:16 GMT

In PAI you have to write

chain.

field mara-matnr module check_material.
endchain.

now dbl click on the check_material it will ask for the program name just write the select query in the program.

module check_material input.
SELECT * 
                    from mara
                    into table itab_mara
                    where  matnr = mara-matnr
                    and  matnr = mara-matkl
                    WHENEVER NOT FOUND SEND ERRORMESSAGE 107
                               WITH  mara-matnr .

endmodule.

Regards

Shiba Prasad Dutta

Re: validate user input with the screen flow logic.

Former Member — Mon, 22 Feb 2010 17:12:12 GMT

but then , this is wrong :

http://help.sap.com/saphelp_nw04/helpdata/EN/9f/dbaa3a35c111d1829f0000e829fbfe/content.htm

Re: validate user input with the screen flow logic.

Former Member — Thu, 25 Feb 2010 11:46:51 GMT

i guess im going to do it like you told me , however i think i could write the select in pbo directly

Re: validate user input with the screen flow logic.

mukundkansara — Thu, 25 Feb 2010 11:51:09 GMT

Hi,

It will not work in PBO module. Do as SHIBA write This is the only way to do it

Re: validate user input with the screen flow logic.

TMNielsen — Wed, 14 Nov 2012 10:20:22 GMT

Hi José

Actually the syntax works fine, but there are as already mentioned by Thiru the problem that you compare matnr wit matkl. That doesn't make sense.

A second problem is that the editor (even when you get the correct syntax) will paint some of the words in the select statement red as if some error still exists. Don't worry about this. The dynpro will generate ok and all will work.

Ex. of correct syntax:

FIELD MARA-MATNR SELECT * FROM mara

WHERE matnr = MARA-MATNR

WHENEVER NOT FOUND SEND ERRORMESSAGE 221.

Finally you must make sure to have the messag-id addition to the program statement in top of your program. Like this:

REPORT ztest123 message-id M3.

Best regards

Thomas Madsen Nielsen