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