07-19-2007 11:26 AM
Hi,
i have a select statement where i want to fetch only those starting with 'PG' and 'PL' tell me the syntax plz.
correct the following statement.
Select * from RSDODSO into table it_odsobj where ODSOBJECT like
'0%' and OBJVERS ='A'.
Thanks a lot,
Vijaya
07-19-2007 11:30 AM
RANGES : R_OBJ FOR RSDODSO-ODSOBJECT.
R_OBJ-LOW = 'PG*'.
R_OBJ-SIGN = 'I'.
R_OBJ-OPTION = 'CP'.
APPEND R_OBJ.
R_OBJ-LOW = 'PL*'.
R_OBJ-SIGN = 'I'.
R_OBJ-OPTION = 'CP'.
APPEND R_OBJ.
Select * from RSDODSO into table it_odsobj where ODSOBJECT IN R_OBJ and OBJVERS ='A'.
REGARDS
SHIBA DUTTA
07-19-2007 11:30 AM
hI,
See following code ;
data : v1(3) value '26%',
v2(3) value '46%',
v3(3) value '66%',
v4(2) value 'C%',
v5(2) value 'N%'.
*select data from EKPO
select ebeln ebelp matnr werks txz01 matkl brtwr bprme
menge meins mwskz netpr untto uebto uebtk loekz
from ekpo into table i_ekpo
where ( ebeln like v1 or
ebeln like v2 or
ebeln like v3 or
ebeln like v4 or
ebeln like v5 )
and werks not in ('ADMN','LGHS','XO01','NGM1','ADMM').
Reward points if helpful.
Regards.
Srikanta Gope