Display of totals in Indian lakhs / Crores (1,000,000 to 10,00,000)

[Former Member]

Hello all,

I am encountering a problem in printing the totals / values in smartforms in Indian rupees. It currently exists as 1,000,000 whereas i want it to be 10,00,000 (Ten lakhs Indian Rupees). I have referred to posts here at SDN and as per suggestions checked Function Module "HR_IN_CHG_INR_WRDS" and table T005X for field LAND . The values which exist for country INdia in table is :

Client 700

Country IN

Dec.pt.format X

Date format 1

12/24 Hours

Here for decimal format has blank , X and Y which stands for ;

Blank 1.234.567,89

X 1,234,567.89

Y 1 234 567,89

By default X format is printed value for country code IN. Its not desirable. Function Module only converts to words hence not useful.

Also by using code

*Write sourceamt CURRENCY 'INR' to targetamt*

it is not throwing desired output. Uisng T.Code SU01 it is same as table T005X output so I have reached an end there too. Anybody who knows how to convert it to desirable format please suggest .

Thank you.

[former_member213340]

Use Edit mask '--,---,--'

Thanks.

[former_member490505]

Hi,

Use Edit mask '--,---,--' we can use the in z development. but problem is all SAP reports currently display the format 123,456,789.00. User requirement all standard report to display Indian currency format is 12,34,56,789.00.

thanks

[Former Member]

Hello Both,

Sorry for the late reply and thank you for the suggestions. But , in transaction OY01, displays the same entries as in table T005X and user profile definitely doesnt have anything in Indian decimal notation.

Thank You.

[nils_buerckel]

Hi Richard,

ABAP standard systems do not cover this Indian specific number format.

Currently the number format is restricted to

1,234,567.89

1.234.567,89

1 234 567,89

One exception would be the Adobe forms area - there it is possible to use the requested format.

Best regards,

Nils Buerckel

SAP AG

[Former Member]

HI

Can we use append values in the domain "xudcpfm" with Z - 12,34,56,789.00. This then is displayed in the User Own Data.

But even if this is selected in User Pofile, System does not display the desired value format.

Any suggestion on this.....

Regards

Kamlesh

[former_member490505]

Following Three format only available in SU01-> Default, OY01 and domain level also.

X 1,234,567.80

Y 1 234 567,80

  1.234.567,80

I have changed the domain  value range like "xudcpfm" with Z - 12,34,56,789.00. it didn't add in decimal notation.I want to add Rupees format like 12,34,567.80.

[Former Member]

were you able to solve this issue?

[Former Member]

It depends on the how it is configured in SU01 Transaction -> Defaults Tab-> Decimal notation

Change to the required notoation

Hope it helps.

[Former Member]

Hi

It depends on the way it is configured in OY01 transaction (Country Global Parameters)

Regards

Raj