‎2008 Jan 30 11:33 AM
hi exprts,
i want to see all my ztcode and its description and want data in excel sheet...
<REMOVED BY MODERATOR>
Thanks.
Edited by: Alvaro Tejada Galindo on Jan 30, 2008 6:01 PM
‎2008 Jan 30 11:36 AM
Hi...
Go to Table TSTCT and go for values...
and in Edit...You have Download option...
Then Download it to Spreadsheet...
Thanks,
Swaminathan
‎2008 Jan 30 11:37 AM
select the records form TSTC table where tcode starts with Z.
and download into xls using gui_download FM
‎2008 Jan 30 11:39 AM
All the tcodes are stored in table "TSTC"....execute the table with "Z*" and then right click on the screen and click on download, check the spreadsheet option and u have it in xl file.
<REMOVED BY MODERATOR>
Edited by: Alvaro Tejada Galindo on Jan 30, 2008 6:04 PM
‎2008 Jan 30 11:42 AM
Hi Sir ,
Please have a look below .Hope it is suitable and simpler solution for your question.
Please do reward if useful.
Thankx.
go to Table TSTCT to look for the values in it,
and in Edit you have Download option,
and download it to Spreadsheet or excel sheet.
‎2008 Jan 30 11:43 AM
Hi,
goto SE11-Transaction code and type in the db table option TSTC table.and goto diplsay mode and see the contents button.
put z* in the tcode field of that TSTC table. press f4 for search. If anyother ztcodes are there. It will display. It is not displaying anything means there is not ztcodes are available.
Thanks,
Sankar M
‎2008 Jan 30 11:46 AM
HI,
Please refer to the table TSTCT.
in Selection Screen of TSTCT table in TCode field enter as Z* and press F8. Once data is displayed GO to Table Entry menu -->List -->Export --> Excel.
Thanks,
Sriram Ponna.
‎2008 Jan 30 12:02 PM
TABLES : tstct.
DATA : itab LIKE STANDARD TABLE OF tstct WITH HEADER LINE.
SELECT * INTO CORRESPONDING FIELDS OF TABLE itab FROM tstct
WHERE tcode LIKE 'Z%'.
CALL FUNCTION 'GUI_DOWNLOAD'
EXPORTING
filename = 'C:\TCODE.XLS'
write_field_separator = 'X'
TABLES
data_tab = itab.
‎2008 Feb 01 10:45 AM