topic Re: Selection field filtering issue.. in Application Development and Automation Discussions

Selection field filtering issue..

vijay_kumar134 — Wed, 16 Apr 2014 17:43:03 GMT

Hi Friends,

My req is to filter the data based on app id with company code, date and pay run id.

Here the the app id is from global constant table, there is no key field, but we fetch the same app id in the smartform to print using the below query, i don't know how to use this query for selection screen with filtering condition.

    SELECT SINGLE high FROM zglobconstants INTO v_app_name
                 WHERE programname = 'ZFI_OK_FILEVALUE'
                 AND low = v_file_name.

VJ.

Re: Selection field filtering issue..

Former Member — Wed, 16 Apr 2014 20:39:27 GMT

Vijay, Can you please provide more details.

My understanding is the selection screen you have shown and the smartform you have mentioned have nothing to do with each other.

What are you trying to select based on the fields on the selections screen? Is the APP ID one of the fields that is present on the table on which selection is to be made?

Re: Selection field filtering issue..

vijay_kumar134 — Wed, 16 Apr 2014 21:15:15 GMT

Vikram,

thanks for your response.

In the selection screen i want to add the app id with proper filtering.

But the app id field is avail in the global constant custom table. this one was populated in the form related to this program. this one was achived thru the above code.

Now i want to add the same in the selection screen. User want to get the op based on the company code and app id.

Once again Thanks for your help. If u wnat more details pls ping me.

Vijay.

Re: Selection field filtering issue..

Former Member — Wed, 16 Apr 2014 21:41:03 GMT

can you ask the question in a human way?

do you want to create a search help? if yes, for which field and if yes - what is the problem with the search-help.

if you do not want the search-help - then what?