Hi Viyaja,
i think the easiest solution for you is to replace values in the table you are putting into GUI_DOWNLOAD.
It means to loop all records and replace zeroes with blanks. (if you have zeroes in types like "i" or "f" then you need to concatenate values into string variable ... - here you have two possibilities:
one is to create internal table with one string field and concatenate all fields into this one field separated by ';' or ',' depending on your excel setting - to get CSV file which excel opens as separated values into appropriate columns - and then save this table on hdd)\
second possibility is to create table with exactly the same list of fields as your table you are saving on HDD has but all data types like "i" will be replaces with datatype string. Then just loop all records and use move-corresponding command and for all fields do check if contains value 0 - if so - replace it with blank. Then save this internal table via gui_download)
Second chance is to create excel file and then use function modules to read this file and replace the zeroes with blanks - for this purpose please follow FM ALSM_EXCEL_TO_INTERNAL_TABLE to load data from excel into internal table and FM MS_EXCEL_OLE_STANDARD_DAT to store data to excel.
I propose the first solution is much better ...
Regards,
Karol
Edited by: Karol Seman on Sep 16, 2008 8:45 AM
Bluesky
