08-12-2009 1:21 AM
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
08-12-2009 1:38 AM
SELECT * FROM coss INTO CORRESPONDING FIELDS OF TABLE
WHERE OBJNR LIKE 'OP000001147344%'
AND VRGNG = 'KSOS'.
a®
08-12-2009 1:38 AM
SELECT * FROM coss INTO CORRESPONDING FIELDS OF TABLE
WHERE OBJNR LIKE 'OP000001147344%'
AND VRGNG = 'KSOS'.
a®