topic select statement in Application Development and Automation Discussions

select statement

Former Member — Thu, 19 Jul 2007 10:26:53 GMT

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

Former Member — Thu, 19 Jul 2007 10:30:28 GMT

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

Former Member — Thu, 19 Jul 2007 10:30:44 GMT

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