Skip to Content
0
Former Member
Aug 12, 2009 at 12:21 AM

Regarding select statement

30 Views

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