topic Re: select datas in Application Development and Automation Discussions

select datas

Former Member — Mon, 29 Jan 2007 08:31:43 GMT

Hi,

The datas are in the table like this 1234(T), 1233,6788,1657(P),3421(T),6787(T),4668,3454(T),4578(P). SO i want to select the data only T using the parameter .In the parameter if i give (T) then my program should select only T available in the table.so how to get like this pls help me to solve this.

Thanks,

Rajendra.

Re: select datas

Former Member — Mon, 29 Jan 2007 08:33:43 GMT

select * from ztable into table itab where field like '%T%'.

Re: select datas

Former Member — Mon, 29 Jan 2007 08:34:27 GMT

Did you try this option ?

select f1 f2 into table itab from XXXX

where f = '%T%'

regards,

vijay.

Re: select datas

Former Member — Mon, 29 Jan 2007 08:34:28 GMT

First

Concatenate '%' p_para '%' into v_par.

SELECT * from table
                into itab
                where field LIKE v_par.

Re: select datas

Former Member — Mon, 29 Jan 2007 08:35:06 GMT

Try this way:

parameters: var(1) type c.

data: pat(3) type c.

concatenate '%(' var ')' into pat.

select fld1 fld2 ...
   into table <itab>
   from <table>
   where fld1 like pat.

Hope this helps.

Regards

Eswar

Re: select datas

Former Member — Mon, 29 Jan 2007 08:35:15 GMT

Hi Rajendra ,

Try using the following

v_string type string . ' Make it same as the data element you want to select.

concatenate '%' '(' <input> ')' into v_string.

and in the where clause use
  where <field> like v_string.

Regards

Arun

Re: select datas

Former Member — Mon, 29 Jan 2007 08:36:26 GMT

to use with parameter

parameters : p_str(5) default 'T'.

concatenate '%'  p_str '%' into v_var.

select * from ztable into table itab where field like v_var.

Re: select datas

Former Member — Mon, 29 Jan 2007 08:36:35 GMT

SORRY I CANNOT GET YOUR ACTUAL REQUIREMENT IF YOU WANT TO FECTH ONLY THE DATAS WHICH CONTAINS T THEN YOU CAN GO FOR

<FIELDVNAME> LIKE '%T%' IN SELECT STATEMENT.

NO NEED TO GIVE THE VALUE IN PARAMETER.

REGARDS

SHIBA DUTTA

Re: select datas

Former Member — Mon, 29 Jan 2007 08:38:30 GMT

Hi ,

Search your data with respect to parameter and *

for eg then concatenate<b> *</b> with the parameter if you enter T into a variable

use the like operator with the variable.

SELECT * FROM VBAK WHERE AUART <b>LIKE</b> '*T'.

It will select data ending with order type 'T'

Please reward if useful.

Re: select datas

Former Member — Mon, 29 Jan 2007 10:11:22 GMT

Hi,

Sorry i tryed in all ways but i could not take the data from the ztable.below is my code i used.

SELECT-OPTIONS : S_ZMATNR FOR Z2006TMMAMEND-ZMATNR,

S_ZWEEKS FOR Z2006TMMAMEND-ZWEEKS,

S_ZCHARG FOR Z2006TMMAMEND-ZCHARG,

S_ZDATES FOR Z2006TMMAMEND-ZDATES.

PARAMETERS: p_ZAMEND like Z2006TMMAMEND-ZAMEND.

*data: pat(12) type c.

data: v_string type string.

concatenate '*' '(' P_ZAMEND ')' into v_string.

SELECT * FROM Z2006TMMAMEND INTO CORRESPONDING FIELDS OF TABLE ITAB

WHERE ZAMEND like v_string

AND ZMATNR IN S_ZMATNR

AND ZWEEKS IN S_ZWEEKS

AND ZCHARG IN S_ZCHARG

AND ZAMEND IN S_ZAMEND

AND ZDATES IN S_ZDATES.

Here the sy-subrc eq 4.but in the v_string i can get *(T)pls help me to solve the issue.

Thanks,

Rajendra.

Re: select datas

Former Member — Mon, 29 Jan 2007 10:14:38 GMT

Hi Rajendra,

Instead of

concatenate '*' '(' P_ZAMEND ')' into v_string.

Use

concatenate '%' P_ZAMEND '%' into v_string.

Re: select datas

Former Member — Mon, 29 Jan 2007 10:15:02 GMT

try this.

SELECT-OPTIONS : S_ZMATNR FOR Z2006TMMAMEND-ZMATNR,
S_ZWEEKS FOR Z2006TMMAMEND-ZWEEKS,
S_ZCHARG FOR Z2006TMMAMEND-ZCHARG,
S_ZDATES FOR Z2006TMMAMEND-ZDATES.
PARAMETERS: p_ZAMEND like Z2006TMMAMEND-ZAMEND.

*data: pat(12) type c.
data: v_string type string.
concatenate '%'  P_ZAMEND '%' into v_string.

SELECT * FROM Z2006TMMAMEND INTO CORRESPONDING FIELDS OF TABLE ITAB
WHERE ZAMEND like v_string
AND ZMATNR IN S_ZMATNR
AND ZWEEKS IN S_ZWEEKS
AND ZCHARG IN S_ZCHARG
AND ZAMEND IN S_ZAMEND
AND ZDATES IN S_ZDATES.