topic Re: Selection Screen input data in Application Development and Automation Discussions

Selection Screen input data

Former Member — Fri, 19 Jul 2013 06:58:15 GMT

Hi Experts,

I am writing a report in my FI module. In that my requirement is in the selection screen I have group of input fields like Article, Article description and so on. So when the user can filter using Article number as input as well as with the Article description also. So now the user is asking if wants to filter with Article description he wants to give (**with some part of the description**) like if the Article description is "Blue color T-shirt" he will give "**Blue**". So how can I achieve this? Please help me..

Thanks

Re: Selection Screen input data

Former Member — Fri, 19 Jul 2013 08:59:18 GMT

Hi Sudheer,

To achieve your requirement you must use "Regular Expressions" along with FIND statement.

With the combination of Regular Expression and FIND statement you can find set of characters in a string etc...

There are lot of examples on internet to achieve this.

Try it and let me know if you require more help.

Thanks & Regards,

Abdul

Re: Selection Screen input data

Former Member — Fri, 19 Jul 2013 09:12:30 GMT

Hi Sudheer,

Use operator like in your select query it will work. I have tested the below code in my system.

PARAMETER: p_name type zupload_data-name.

DATA: T_DATA TYPE STANDARD TABLE OF ZUPLOAD_DATA,

L_NAME TYPE STRING.

CONCATENATE '%' p_name '%' INTO L_NAME.

SELECT * FROM ZUPLOAD_DATA

INTO TABLE T_DATA

WHERE NAME LIKE L_NAME.

In your example even if user enter only 'BLUE' it will work.

Regards,

Vinay

Re: Selection Screen input data

Former Member — Fri, 19 Jul 2013 09:35:47 GMT

Sudheer if user wants to enter **BLUE** then use below code for your reference.

parameter: p_name type zupload_data-name.

select-options: s_name for zupload_data-name no-display.

data: T_DATA TYPE STANDARD TABLE OF ZUPLOAD_DATA.

s_name-sign = 'I'.

s_name-option = 'CP'.

s_name-low = p_name.

append s_name.

SELECT * FROM ZUPLOAD_DATA

INTO TABLE T_DATA

WHERE NAME in s_name.

Hope it helps.

Regards,

Vinay

Re: Selection Screen input data

bastinvinoth — Fri, 19 Jul 2013 09:42:55 GMT

http://scn.sap.com/thread/3393569

Delete adjacent duplicates statement is missing in SCN i think

Re: Selection Screen input data

prkash_s — Fri, 19 Jul 2013 21:05:27 GMT

assuming Article description is a field in a table.

lets assume field as ztable-artdesc

declare as

*** declaring internal table

data znewtab type table of ztable.

*** Declare select options for field.

SELECT-OPTION zartdesc FOR ztable-artdesc.

then use select stament as

*** check select option for initial.

if not zartdesc is initial.

Select article artdesc into znewtab from ztable

where znewdesc IN zartdesc.

endif.

try in this format .

with regards

Prakash.s