number format

[Former Member]

Dear Experts,

In the MM01 screen in accounting 1 tab the standard price is displaying value like 15,177,443.

In my report i am getting the value like 151,774.43.

my requirement is i have print exactly like what it looks like in the screen and remember that the standard price value will differ for other record ie some case it is only 443, in some case 12679.

pls let me know how to code this to solve this problem,

thanks in advance

karthik

[Former Member]

Hi Karthik ,

in the write statement there is an addition called <b>currency</b> , which formats the amount based on the currency .

Try using this.

Regards

Arun

[Former Member]

Dear Arun,

Could you pls give me th sample code for this, bez i didn't found currency addition in write statement

[Former Member]

Hi Karthik ,

The format would be

write /: v_amount <b>currency 'EUR'</b>.

where v_amount is the variable which contains the amount.

Regards

Arun

[Former Member]

Dear arun,

Thanks for the answer but i am using ALV grid to display the report in that case , i can't use the write statement. is there any other solution for this?

thanks in advance

[jayanthi_jayaraman]

Hi,

I am not sure.Just try this.

write v_amount currency 'EUR' to itab-amount.

[Former Member]

Hi Karthik ,

I you all your amount are in same currency then there is a field in catalog called CURRENCY where you can put in the Currency unit .

Plese try using it.

Regards

Arun

[Former Member]

Dear arun,

i tried all but it is not working. in the structure the domain is given like curr 11 ,2 decimals. do i need to change this domain or any function module is tere to covert to desired format

thanks in advance

karthik

[Former Member]

Hi Karthik ,

In MM01 , please check what is the conversion exit used for the amount field.

Please tell me that,

Reagrds

Arun

[former_member508729]

HI Karthik,

You can achieve this using write statement

look at below code

data w_amount(16) type c.

write wa-price to w_amount currency wa_t001-currency.

hope this will help u.

regards

Ashutosh

reward points if helpfull.

[Former Member]

Karthik,

have u checked the currency code in configuration window? if so, the decimal is 2 then mutliply with 100 into the actual value , if 3 multiply with 1000 into actual... like that we have done.

imean 151,774.43 * 100 = 151,774,443.

if any solution getting this, i update u.