topic Re: Selection according in Application Development and Automation Discussions

Selection according

Former Member — Mon, 07 Jul 2008 10:52:59 GMT

Hi experts,

I want to modify the selection below.

v_repid is the program name, tvarv-name is tvarv variable name. I need the record from tvarv only if the t_varv-name contains the string of v_repid. How can I check for example the first eight characters of the name, during the selection. I hope I was clear.

SELECT name

type

numb

sign

opti

low

high

FROM tvarv

INTO TABLE i_tvarv

WHERE name EQ v_repid

AND type EQ i_type.

Re: Selection according

Former Member — Mon, 07 Jul 2008 10:56:19 GMT

here what you can do is use string operations.

1>select the records as per your need.

2>check if t_varv-name CA v_repid

hope it helps and i guess ths is what 1 of the option that can be done

regards

bhanu

Re: Selection according

Former Member — Mon, 07 Jul 2008 10:59:27 GMT

HI,

you can use the selction like below

concatenate v_repid(8) '%' into v_repid1.

SELECT SINGLE parva INTO v_kokrs FROM usr05

WHERE parid = 'CAC'

AND bname like v_repid1. *

i hope this slves ur probelm.

Re: Selection according

Former Member — Mon, 07 Jul 2008 10:59:59 GMT

Hi,

Try this:

Data: lv_repid(9) type c,

lv_repid = 'abcdefg%' (your repid with %).

SELECT name

type

numb

sign

opti

low

high

FROM tvarv

INTO TABLE i_tvarv

WHERE name like lv_repid

*WHERE name EQ v_repid

AND type EQ i_type.

Kind Regards

Re: Selection according

Former Member — Mon, 07 Jul 2008 11:02:07 GMT

hi friend ,

put a loop and use offset.

loop at i_tvarv into wa_tvarv.

if tvarv-name0(7) = v_repid0(7).

do your operation

else.

exit

endif.

endloop.

regards

sandeep

Re: Selection according

Former Member — Mon, 07 Jul 2008 11:04:55 GMT

U can use LIKE in the select to search the name from TVARV table.

Check this sample code:

REPORT zdemo LINE-SIZE 180 LINE-COUNT 60(10) NO STANDARD PAGE

HEADING.

data: i_tvarv type standard table of tvarv.

data: l_search_text(10) type c.

data: v_repid like sy-repid.

v_repid = sy-repid.

concatenate v_repid+0(8) '%' into l_search_text in character mode.

SELECT name

type

numb

sign

opti

low

high

FROM tvarv

INTO TABLE i_tvarv

WHERE name like l_search_text.

AND type EQ i_type.

check sy-subrc = 0.

Regards,

Joy.

Re: Selection according

Former Member — Mon, 07 Jul 2008 12:20:18 GMT

Thanks for the answers.