Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

select statement

Former Member
0 Kudos

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

2 REPLIES 2

Former Member
0 Kudos

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
0 Kudos

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