Function Module to display the amount

[Former Member]

Dear Experts,

I had searched in forum for my answer to my question. but unable to find the exact solution. thats why i am posting my question in the forum.

My requirement is:

need to display the amout in required format. As my client as to display the Thousand separation as " ' " instead of comma or dot or space, which we will specify in user profile settings.

Eg: 1,000 - they want to dispaly this in 1'000

       10,000 - 10’000

if any decimals, i has to be separated by dot. means it does not depends upon user profile settings, what ever it is in settings, they in the above format.

please help me to resolve this issue.

Thanks & Regards,

Srinivas

[Former Member]

Hi Srini,

Can you please share us how you are getting the output currently ?

Thanks,

Bhaskar

[Former Member]

Hi Bhaskar,

As far, the output is coming as the setting provide in User profile.

Thanks & Regards,

Srinivas

[Former Member]

In that case , Cant we define the custom defined profile for the user other than the existed default settings given by SAP ?

I think we can, give a try.

If that is not possible you can make the things in your program itself, but not recommended .

Regards,

Bhaskar

[Former Member]

Hi Bhaskar,

can you let me know how a custom defined profile can be created. i am not aware of this.

if this is not possible, i will convinence my client, to use what SAP had given. changining other program or creation of custom FM is risky factor.

Thanks

Srini

[nabheetscn]

Hi Srini

Which currency it is ..? Do you see in SAP standard transactions those format. If yes then you can use WRITE to statemnt along with currency specification it will automatically convert it

Nabheet

[Former Member]

Hi Madam,

my currency is CHF - Swiss Franc. but eventhough if we write WRITE Statement by passing currency, it wont populate as my requirement needed.

Thanks & Regards,

Srinivas

[Former Member]

Hi Srini,

Please check if the format you want is of valid type belonging to some country currency format. Currency conversion happens based on values in TCURX. Please check it or else you need to write custom function module for altering display as required.

Regards,

Sheetal.

[Former Member]

Hi Sheetal,

It seems, the format what i want to display, is not in specified currency format.

may be i need to go with Customer FM to fullfill my requirement.

Hi All (Sheetal, Madan & Bhaskar), thank you for all for your response.

Thanks,

Srini

[sai_krishna24]

Yes Srini, you have to develop your own customlogic. My question is it will be same for all users or any specific users. check this and add some validation.

[Former Member]

Hi Sai,

for specific user (Country wise) we want this requirement.

Eg. For Hungary we done have decimals, but the separator is ',' and decimals is '.' which SAP is already given in USER PROFILE.

in USER PROFILE, which suits my requirement is not yet done.

best way is to convinence my client or in User profile, need to assigne the comma as thousand as separator, later ward replace the ',' with " ' " which include in my program.

Thanks for your response.

Thanks

Srini

[sai_krishna24]

I feel that works! .

Check this http://scn.sap.com/thread/1770827

http://scn.sap.com/thread/2039500

[Bhavani_Baisani]

please use replacestring function like below

use with your amount field.

If it is SAP PI issue handle like above solution.