‎2008 Apr 30 7:24 AM
Hi,
Could you guys please give me some codin to fetch all the tcodes which begins with ZPR..?
please please please...
‎2008 Apr 30 7:30 AM
Hi Nalina,
You can do one thing declare a range and in the assign the values sign as 'I' Options as 'CP' and low value as 'ZPR*' and write a select statement for the table TSTC. Then you can obtain the required output.
Please reward pints if I am correct.
Please let me know if i am wrong.
Thanks & Regards,
M.Ramana Murthy.
Edited by: Ramana Murthy on Apr 30, 2008 8:31 AM
‎2008 Apr 30 7:25 AM
hi
use the table TSTC to fetch the tcodes.
here is the sample code:
tables: tstc.
DATA: V_STR(20).
CONCATENATE 'Z' '%' INTO V_STR.
SELECT * UP TO 10 ROWS
FROM TSTC
WHERE tcode LIKE V_STR.
WRITE: / tstc-tcode.
ENDSELECT.
regards,
madhu
‎2008 Apr 30 7:42 AM
hi
check this one
data:
begin of itab occurs 0,
t_code like tstc-tcode.
end of itab.
select tcode
from tstc
into table itab
where tstc-tcode like 'zpr%'.
‎2008 Apr 30 7:30 AM
Hi Nalina,
You can do one thing declare a range and in the assign the values sign as 'I' Options as 'CP' and low value as 'ZPR*' and write a select statement for the table TSTC. Then you can obtain the required output.
Please reward pints if I am correct.
Please let me know if i am wrong.
Thanks & Regards,
M.Ramana Murthy.
Edited by: Ramana Murthy on Apr 30, 2008 8:31 AM
‎2008 Apr 30 7:33 AM
Hi nalini,
data : Begin of it_tstc occurs 0,
tcode type TCODE,
End of it_tstc.
select tcode from tstc into table it_tstc where tcode like 'ZPR%'.
This statement will fetch all the tcodes starting with ZPR.
‎2011 Jan 05 7:44 AM