New Decimal Notation Format Required For Indian Projects

[Former Member]

Respected Members,

As at the user level or tcode SU01 only three decimal notations are provided.

But for country India the decimal notation format is totally different.

Given decimal notation format is

1,234,567.89

And the Required Format For India is

1,23,456.78

Becoz we mention the Rupees in this format only.

And this second format is not available in SPRO also .

How to create the desired decimal notation and add the corresponding functionality.

And if we use the given format (1,234,567.89) then when we converting the amount in words through Function module

SPELL_AMOUNT ,it is not converting properly even though we have maintain the entries in View V_T015Z.

Suppose our amount is 1,00,000 that is One lakh but it will show in the output ONE HUNDRED THOUSAND.

I know that there is another function Module HR_ch_ something to convert in words according to indian currency.

But it does not solve the issue properly.

THis DECIMAL NOTATION format for Indian Projects is a BIG MESS.

So kindly tell me any solution or it is the drawback of SAP.

So that we can ask SAP to append this Decimal Notation and required Functionality for the Indian Projects.

Kindly Send Your Valuable answer and Try To Make clear picture and SAP Technical People if Reading this thread then kindly give stress on the REQUIRED DECIMAL NOTATION.

THANKS A LOT.

[Former Member]

Respected Members,

As at the user level or tcode SU01 only three decimal notations are provided.

But for country India the decimal notation format is totally different.

Given decimal notation format is

1,234,567.89

And the Required Format For India is

1,23,456.78

Becoz we mention the Rupees in this format only.

And this second format is not available in SPRO also .

How to create the desired decimal notation and add the corresponding functionality.

And if we use the given format (1,234,567.89) then when we converting the amount in words through Function module

SPELL_AMOUNT ,it is not converting properly even though we have maintain the entries in View V_T015Z.

Suppose our amount is 1,00,000 that is One lakh but it will show in the output ONE HUNDRED THOUSAND.

I know that there is another function Module HR_ch_ something to convert in words according to indian currency.

But it does not solve the issue properly.

THis DECIMAL NOTATION format for Indian Projects is a BIG MESS.

So kindly tell me any solution or it is the drawback of SAP.

So that we can ask SAP to append this Decimal Notation and required Functionality for the Indian Projects.

Kindly Send Your Valuable answer and Try To Make clear picture and SAP Technical People if Reading this thread then kindly give stress on the REQUIRED DECIMAL NOTATION.

THANKS A LOT.

[Former Member]

Hi Manish

You can do this by now itself.

In the initial sap screen goto->system->userprofile

-

---

>owndata .

There u can can set the default parameters.

And for the other one , .One more function module is there.

HR_IN_CHG_INR_WRDS' Use this function Module,

You can get the whole amount.

*************Reward points if useful

Regards

Karthik

Edited by: karthikeyan palaniayya on Dec 24, 2007 5:17 AM

[arpit_shah]

Hi manish,

hv u solved ur requirements?...

I'm also facing same problem.

Regards,

Arpit

[Former Member]

I am also facing the same issue.

Were you able to solve this issue?

[Sreenith]

Hi Manish please you can try this code

REPORT ZAMOUNT_CONVERSION.

DATA : RESULT1(20).

PARAMETERS : NUM TYPE P DECIMALS 2.

DATA : num2 type STRING.

DATA :  col_amt(20) type n,"15

         col_b type i,

         num_1(20) type C,"15

         Length type i.

num_1 = num.

write : 'default format      :',num.

uline.

skip.

IF ( num >= 999999999 ).

       write num_1 using edit mask 'RR__,__,__,__,______' to col_amt.

       CONDENSE col_amt.

       length = STRLEN( col_amt ).

       if length = 16.

         REPLACE first OCCURRENCE OF ',' in col_amt with space.

         write :/'amount indian format:',col_amt.

       else.

       write :/'amount indian format:',col_amt.

       endif.

ELSEIF NUM < 999999999 AND NUM >= 9999999.

       write num_1 using edit mask 'RR__,__,__,______' to col_amt.

       condense col_amt .

       length = STRLEN( COL_AMT ).

       if length = 13.

         REPLACE first OCCURRENCE OF ',' in col_amt with space.

         write :/'amount indian format:',col_amt.

       else.

         write :/'amount indian format:',col_amt.

      endif.

ELSEIF NUM < 9999999  AND NUM >= 99999.

       write num_1 using edit mask 'RR__,__,______' to col_amt.

       condense col_amt .

       length = STRLEN( COL_AMT ).

       write :/'amount indian format:',col_amt.

ELSEIF NUM < 99999.

   data : dumy(10) type c.

   dumy = num .

   CONDENSE dumy.

   length = STRLEN( dumy ).

     if length <= 6.

       write :/'amount indian format:',num.

       else.

       write num_1 using edit mask 'RR__,______' to col_amt.

       write :/'amount indian format:',col_amt.

      endif.

   ENDIF.

   uline.

create a function module with this code .hope this will solve the issue.