topic Re: Function Module to display the amount in Application Development and Automation Discussions

Function Module to display the amount

Former Member — Mon, 16 Dec 2013 10:32:48 GMT

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

Re: Function Module to display the amount

Former Member — Mon, 16 Dec 2013 11:04:02 GMT

Hi Srini,

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

Thanks,

Bhaskar

Re: Function Module to display the amount

nabheetscn — Mon, 16 Dec 2013 11:07:07 GMT

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

Re: Function Module to display the amount

Former Member — Mon, 16 Dec 2013 11:19:55 GMT

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.

Re: Function Module to display the amount

Former Member — Mon, 16 Dec 2013 11:46:10 GMT

Hi Bhaskar,

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

Thanks & Regards,

Srinivas

Re: Function Module to display the amount

Former Member — Mon, 16 Dec 2013 11:47:51 GMT

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

Re: Function Module to display the amount

Former Member — Mon, 16 Dec 2013 11:51:23 GMT

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

Re: Function Module to display the amount

Former Member — Mon, 16 Dec 2013 12:11:29 GMT

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

Re: Function Module to display the amount

sai_krishna24 — Mon, 16 Dec 2013 12:16:53 GMT

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.

Re: Function Module to display the amount

Former Member — Mon, 16 Dec 2013 12:30:35 GMT

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

Re: Function Module to display the amount

Former Member — Mon, 16 Dec 2013 12:34:47 GMT

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

Re: Function Module to display the amount

Bhavani_Baisani — Mon, 16 Dec 2013 12:41:29 GMT

please use replacestring function like below

use with your amount field.

If it is SAP PI issue handle like above solution.

Re: Function Module to display the amount

sai_krishna24 — Mon, 16 Dec 2013 17:28:04 GMT

I feel that works! .

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

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