topic Re: select data with select option in Application Development and Automation Discussions

select data with select option

Former Member — Mon, 09 Jul 2018 15:33:06 GMT

Hi Experts,

I am trying to call the selected data that I am entering in the selecting screen but the program call all the data without taking the entering data in to consideration like e.g.

When I enter a company code in the field p_bukrs2 I receive all the company codes.

Can you guide me to receive a specific data for a selected company code and supplier number?

your help well be appreciated.

Jenie

Re: select data with select option

Jelena_Perfiljeva — Mon, 09 Jul 2018 21:49:35 GMT

If using prefixes, I'd strongly encourage to use different ones for parameters (p_...) and select options (s_...).

As to the question - from the top of my head, you are not JOINing by all the key fields, so could that be part of the problem? There is also a mix of AND and OR that could be problematic.

You can always run ST05 (SQL Trace) and then use Explain button there to see how exactly the DB interprets your SELECT. Also when I get strange results in JOIN I usually try to separate it into multiple SELECTs or change WHERE conditions to pinpoint the problem.

Re: select data with select option

DoanManhQuynh — Tue, 10 Jul 2018 00:31:15 GMT

I tried your SQL on my system and it work as expected. How did you input into selection option? You can try to build a quick view in SQVI to check your join first.

Re: select data with select option

RaymondGiuseppi — Tue, 10 Jul 2018 06:46:46 GMT

The problem comes from the OR operators in the where clause. Do you guess how the system interpret your clause?

Re: select data with select option

RaymondGiuseppi — Tue, 10 Jul 2018 06:48:35 GMT

You didn't copy his where clause, I suppose you added some parentheses, else the statement wont respect the criteria for the select-option when ...

Re: select data with select option

DoanManhQuynh — Tue, 10 Jul 2018 07:03:58 GMT

Yes, sorry. I didnt copy his OR. The problem is because his OR need to be inside ( ).

Re: select data with select option

Jelena_Perfiljeva — Tue, 10 Jul 2018 21:37:33 GMT

Providing the name is real, it's "her", not "his". 🙂

Re: select data with select option

matt — Wed, 11 Jul 2018 06:43:33 GMT

Those ORs should in IN ('KM', 'KV', ..., 'SD')