06-08-2007 10:55 PM
Hi Guys,
I am downloading the data from SAP to text file.Whats the problem is , for ex consider EKPO table in this we r having MENGE filed which contains values like "1,500.00" , " 2,345,564.00" ..........like that we r having i want those values like 1500.00 and 2345564.00 .so is ther any FM which can do like this i mean for whole table where ever we face these type of values. r can anybody suggest is there any way of converting for each field if not for table?
Thanks,
Gopi.
06-08-2007 11:52 PM
Hi Gopi Anne,
a basic concept of SAP is the automatic input/output conversion for screen and list fields. In debugger you will see that actually the data are stored as 1500.00 and 2345564.00. The output conversion according to user settings creates 1,500.00 or 2,345,564.00 in US, in Germany it would be 1.500,00 or 2.345.564,00.
You will face another problem: Internally the values are stored as packed decimals. For download you will have to move them to char type field.
The best thing will be to create your download program and learn a lot more...
Regards,
Clemens
06-09-2007 12:19 AM
Hi Clemens,
I am writing a program for downloading the program.I just wrote the select statement for downloading the data into text file.i used gui_download and csv Fm for comma seperated values.Can u tell me any FM which removes " ," from the datain Internal table.
Thanks,
Gopi.
06-09-2007 12:27 AM
You just have to move it toa text variable & remove the commas ie
data: w_menge(16).
w_menge = '1,632.26'.
replace all occurrences of ',' in w_menge with space.
condense w_menge.
~Suresh
06-09-2007 12:40 AM
Hi Suresh,
I am downloading the whole table EKPO into atext file with CSV Format. i mean all columns.Can u tell me how to do now?
Very urgent.
Thanks,
Gopi.