topic Re: Decimal in Application Development and Automation Discussions

Decimal

Former Member — Tue, 20 May 2008 05:28:33 GMT

Hi abapers ,

My requirement is , ALV report contains field of quan datatype , and its value is suppose 5,000 which displayed in ALV report , while downloading the data of ALV report in excel sheet ,it displays value as

5,000 . i want to display this value with ' .' (decimal) instead of ' ,'(comma).

for this requirement i have converted quantity data type field to char field ,now 5,000 value displayed as 5

in excelsheet , i want 5.000 value in excelsheet.

If u have some idea pls let me know.

Thanks

Re: Decimal

Former Member — Tue, 20 May 2008 05:30:05 GMT

Hi,

replace ',' with '.' into dzahl.

Regards

Nicole

Re: Decimal

Former Member — Tue, 20 May 2008 05:53:40 GMT

Hi,

There are 2 things that you need to note.

1. comma instead of decimals : This is some thing you need to check the User setting.

a. Check T-code SU01D

b. enter your Login ID

c. check the Default Tab

according to the user setting the value will be populated into the excel file.

2. If you want to display say for example '2.000' instead of '2' then move the actual value to a character variable and use replace all occurence of ',' to '.' and also populate the new value to the final output table.

Reward if helpful.

Regards,

Ramkumar.K