Regarding select statement

Former Member — Wed, 12 Aug 2009 00:21:55 GMT

Hi ,

data: t_coss like coss occurs 0 with header line.

concatenate 'OP' t_aufk-aufnr '%' into l_aufnr.

select * from coss into corresponding fields of table t_coss

where OBJNR = l_aufnr and

VRGNG = 'KSOS'.

in the above statement i want to get all teh records from table which have

l_aufnr as OP000001147344*

ie there are almost 5 records in teh table with l_aufnr value as

OP0000011473440002

OP0000011473440003

OP0000011473440006

OP0000011473440007

OP0000011473440009

as of now iam writing the l_aufnr as above but the statementis failing to fetch data please suggest

Re: Regarding select statement

former_member194669 — Wed, 12 Aug 2009 00:38:31 GMT


SELECT * FROM coss INTO CORRESPONDING FIELDS OF TABLE
  WHERE OBJNR LIKE 'OP000001147344%'
   AND VRGNG = 'KSOS'.

a®