Selection field filtering issue..

[vijay_kumar134]

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.

[Former Member]

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?

[vijay_kumar134]

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.

[Former Member]

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?