topic Re: Select using text field is possible? in Application Development and Automation Discussions

Select using text field is possible?

Former Member — Wed, 25 Aug 2010 11:36:53 GMT

Hi friends! I need some help.

I have table with field type char20. In this field is saved a serial number with a fixed layout like 00.00.00.00.00.00.00. User wants a report that he can use this field for search criteria in selection-screen, some like that:

Table

78.00.03.00.44.11.00

78.00.03.00.44.12.00

80.00.03.00.44.13.00

So, he wants to select all entries who have '44' in 5ª position. Its possible do it using select or I have to select all and do one by one?

Thanks for any help!

Re: Select using text field is possible?

kesavadas_thekkillath — Wed, 25 Aug 2010 11:59:20 GMT

may be you can build a range like if its 5th position.

wa-sign = 'I'.

wa-option = 'CP'.

wa-low = '++++++++++++44*'

append wa to ra.

Aslo try using the escape symbol # instead of +

then select using ra.

you can refer to build the range

Re: Select using text field is possible?

Former Member — Wed, 25 Aug 2010 12:51:59 GMT

Thanks Keschav. Works greats here!

Re: Select using text field is possible?

Former Member — Wed, 25 Aug 2010 12:57:14 GMT

I will agree with Keshav's post. just adding the sample code for that

DATA w_belnr TYPE belnr_d.

ranges : r_belnr FOR w_belnr.

r_belnr-sign = 'I'.
r_belnr-option = 'CP'.
r_belnr-low = '++++++1294'.
append r_belnr.


select SINGLE belnr from rseg
  into w_belnr
  WHERE belnr in r_belnr.

  IF sy-subrc EQ 0.

    WRITE / w_belnr.

  ENDIF.

Re: Select using text field is possible?

Former Member — Wed, 25 Aug 2010 17:27:25 GMT

I used this and works great but user wants a select-options for select this, some like '44' to '55'. Any idea?

Thanks again!!

Edited by: Fulvio Valente on Aug 25, 2010 7:28 PM

Re: Select using text field is possible?

Former Member — Wed, 25 Aug 2010 17:35:46 GMT

why you don't use a select option that point to a integer or c type data and concatenate to the range that you all ready had

Re: Select using text field is possible?

Former Member — Wed, 25 Aug 2010 17:50:22 GMT

I'm using select options, but when I use 'CP' I can't use 'BT', so I lost the use of range-high...

When user digits on screen:

sign        option      low    high
   I               BT         44      55

I can build a range like

sign        option      low                             high
   I              CP         '++++++++++++44*'    
sign        option      low                             high
   I              CP         '++++++++++++55*'

But in this case I lost values between 44 and 55.

Re: Select using text field is possible?

kesavadas_thekkillath — Wed, 25 Aug 2010 17:58:44 GMT

you can try this\

if its a integer always and not numeric then,

data:num type n.

loop at sel_opt.

if sel_opt-option = 'BT'.

do.

wa-low = sel_opt-low + 1.

append to range here.

if wa-low = sel_opt-high.

exit.

endif.

endloop.

Re: Select using text field is possible?

Former Member — Wed, 25 Aug 2010 18:12:33 GMT

Thanks again. My problem is a character, so I can't add...

Edited by: Fulvio Valente on Aug 25, 2010 8:27 PM

Re: Select using text field is possible?

Clemenss — Wed, 25 Aug 2010 18:56:47 GMT

Hi Fulvio,

you could teach your user some details about using SELECT-OPTIONS on the selection screen. He can enter everything he ever wants and save it as a Report Variant.

No need for any code. Most users are happy if they learn about the multiple selections button and the various possibilities given there and the use of + and * wildcards.

Regards,

Clemens