topic How to retrieve data based on different inputs from selection screen in Application Development and Automation Discussions

How to retrieve data based on different inputs from selection screen

former_member470523 — Mon, 29 Dec 2014 13:08:14 GMT

For ex:

on selection screen i have 6 input fields.

1.vendor name

2.Vendor Number(Mandatory)

3.Address

4.telephone number

5.company code(Mandatory)

6.Terms of payment

case 1.

so while entering input values, I entering only "vendor name" and 2 mandatory fields values,So that i need get output with given vendor name.

case 2.

In this case I an entering "terms of payment" and 2 mandatory fields values,So that i need get output with given Terms of payment.

For such cases, How we can write SELECT query and WHERE Clause conditions..Please give solution...its my requirement

Re: How to retrieve data based on different inputs from selection screen

VenkatRamesh_V — Mon, 29 Dec 2014 13:12:51 GMT

Hi Vijay,

Instead of declaring obligatory syntax write the logic.

AT SELECTION-SCREEN.

if vendor is initial and payment terms is initial.

message 'Select vendor or payment terms' type 'S' Display like 'E'.

STOP.

endif.

if vendor is not initial.

CHECK FIELD1 IS INITIAL AND FIELD2 IS INITIAL.

message 'enter field1 field2' type 'S' DISPLAY LIKE 'E'.

STOP.

elseif payment terms is not initial.

CHECK FIELD2 IS INITIAL AND FIELD3 IS INITIAL.

message 'enter field2 field3' type 'S' DISPLAY LIKE 'E'.

STOP.

endif.

Try to combine the selection-field tables in a single select query using joins

Regards,

Venkat.

Re: How to retrieve data based on different inputs from selection screen

krishna_k19 — Mon, 29 Dec 2014 13:22:51 GMT

Hi Vijay,

this one we can achieve by using the Selection screen events or in normal way also.

1) normal way

if vendorname & your two input fields is initial.

write the select statement accordingly.

elseif termsofpayment & your 2 mandatory fields is initial.

write the select statements accordingly.

endif.

2) we can achieve by selection screen events & using radio buttons ,& modify screen.

Regards,

Krishna