topic Re: select query needed in Application Development and Automation Discussions

select query needed

Former Member — Mon, 23 Apr 2007 12:46:56 GMT

Hello Experts

i am working on inventory management.

Scenario1:For a plant group there exists one key plant and the rest should be non-key plants.

Query 1: How could i prevent the user from entering 2 key plants for a plant group?

Thanks in advance.

Re: select query needed

Former Member — Mon, 07 May 2007 09:38:25 GMT

use the 'at selection-screen on screen_field' event, where u can right the code to ceck inputs given to a particular field in the selection criteria.

Example: If for example ur field name is 'Field1'.

The statement for that event to start is

At selection-screen on Field1.

In that event u have to raise an error message, which will help the user to identify the field where he has given the wrong input.

refer this program 'demo_*_selection_screen_events'.

In the particular event u have to raise the error message when the user give two key values.

Award if useful

Sudheer

Re: select query needed

Former Member — Mon, 07 May 2007 09:45:52 GMT

declare as follows:

tables: t001w

parameters: p_werks like t001w-werks .

At selection-screen.

clear t001w-werks.

select single werks from t001w into t001w-werks werks = p_werks.

if t001w-werks <> 'Key Plant'.

message 'enter correct key plant'.

endif.

Reward points if useful

Regards

Anji

Re: select query needed

Former Member — Mon, 07 May 2007 09:48:57 GMT

Hi Murli,

Use At selection-screen event to restrict ur user to enter

2 key plants.

Read help on At selection screen event.

Reward points if helpful.

Regards,

Hemant

Re: select query needed

Former Member — Mon, 07 May 2007 10:01:50 GMT

Hi Murali,

U can go either for 'At selection-screen' of 'At selection-screen on field'. Both will work, but If u go for the second one when the error message is raised what will happens is: 1) As i said in the previous reply Only the field u have mentioned in the event will be in Input mode and all the others will be display mode., otherwise all the fields will be in Display mode and ready for accepting an input.

Award if useful

Regards,

Sudheer

Re: select query needed

Former Member — Mon, 07 May 2007 10:55:22 GMT

Hi,

U need to award points for useful answers and u have to mention it as solved if ur question is solved. Dont forget.

Regards,

Sudheer