Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to use function SPELL_AMOUNT for Laos

Former Member
0 Likes
2,206


I have problem about display amount in word in Laos. Amount in word in Loas same as in Thai and I set up value in table T015Z.

But return result in Laos is different from Thai. Please give me advice.


I have problem about display amount in word in Laos. Amount in word in Loas same as in Thai and I set up value in table T015Z.

But return result in Laos is different from Thai. Please give me advice.

7 REPLIES 7
Read only

dibyajeeban_jena
Active Participant
0 Likes
2,025

pLANGU LIKE T002-SPRAS DEFAULT SY-LANGU,
pCURR LIKE TCURC-WAERS DEFAULT 'USD',
pAMOUNT LIKE VBAP-MWSBP ,
pFILLER(1) TYPE C DEFAULT ' '.

DATA :
WS_SPELL TYPE SPELL.

CALL FUNCTION 'SPELL_AMOUNT'
EXPORTING
  AMOUNT =    pAMOUNT
  CURRENCY =   pCURR
  FILLER =     pFILLER
  LANGUAGE = pLANGU "SY-LANGU
IMPORTING
  IN_WORDS = WS_SPELL
EXCEPTIONS
  NOT_FOUND = 1
  TOO_LARGE = 2
  OTHERS = 3

Read only

dibyajeeban_jena
Active Participant
0 Likes
2,025

Hi,

Refer  Report- RF_SPELL ,for sample use of SPELL_AMOUNT.

Regards

DJ

Read only

0 Likes
2,025

Dear Dibyajeeban Jena,

I already used it but return result is incorrect. Test result as attachment and set up in table T015Z as following:

Thank you very much for your advice.

LanguageUnitFigureNumber in words
LO%2AND TWO ;
LO&1UND ONE ;
LO&2AND TWO ;
LO&3AND THREE ;
LO&4AND FOUR ;
LO&5AND FIVE ;
LO&6AND SIX ;
LO&7AND SEVEN ;
LO&8AND EIGHT ;
LO&9AND NINE ;
LO*2TWO ;
LO0&;
LO00ສູນ;
LO01ໜຶ່ງ;
LO02ສອງ;
LO03ສາມ;
LO04ສີ່;
LO05ຫ້າ;
LO06ຫົກ;
LO07ເຈັດ;
LO08ແປດ;
LO09ເກົ້າ;
LO0@;
LO10ສິບ;
LO11ສິບເອັດ;
LO12ສິບສອງ;
LO13ສິບສາມ;
LO14ສິບສີ່;
LO15ສິບຫ້າ;
LO16ສິບຫົກ;
LO17ສິບເຈັດ;
LO18ສິບແປດ;
LO19ສິບເກົ້າ;
LO20ຊາວ;
LO21ຊາວເອັດ;
LO22ຊາວສອງ;
LO23ຊາວສາມ;
LO24ຊາວສີ່;
LO25ຊາວຫ້າ;
LO26ຊາວຫົກ;
LO27ຊາວເຈັດ;
LO28ຊາວແປດ;
LO29ຊາວເກົ້າ;
LO30ສາມສິບ;
LO31ສາມສິບເອັດ;
LO32ສາມສິບສອງ;
LO33ສາມສິບສາມ;
LO34ສາມສິບສີ່;
LO35ສາມສິບຫ້າ;
LO36ສາມສິບຫົກ;
LO37ສາມສິບເຈັດ;
LO38ສາມສິບແປດ;
LO39ສາມສິບເກົ້າ;
LO40ສີ່ສິບ;
LO41ສີ່ສິບເອັດ;
LO42ສີ່ສິບສອງ;
LO43ສີ່ສິບສາມ;
LO44ສີ່ສິບສີ່;
LO45ສີ່ສິບຫ້າ;
LO46ສີ່ສິບຫົກ;
LO47ສີ່ສິບເຈັດ;
LO48ສີ່ສິບແປດ;
LO49ສີ່ສິບເກົ້າ;
LO50ຫ້າສິບ;
LO51ຫ້າສິບເອັດ;
LO52ຫ້າສິບສອງ;
LO53ຫ້າສິບສາມ;
LO54ຫ້າສິບສີ່;
LO55ຫ້າສິບຫ້າ;
LO56ຫ້າສິບຫົກ;
LO57ຫ້າສິບເຈັດ;
LO58ຫ້າສິບແປດ;
LO59ຫ້າສິບເກົ້າ;
LO60ຫົກສິບ;
LO61ຫົກສິບເອັດ;
LO62ຫົກສິບສອງ;
LO63ຫົກສິບສາມ;
LO64ຫົກສິບສີ່;
LO65ຫົກສິບຫ້າ;
LO66ຫົກສິບຫົກ;
LO67ຫົກສິບເຈັດ;
LO68ຫົກສິບແປດ;
LO69ຫົກສິບເກົ້າ;
LO70ເຈັດສິບ;
LO71ເຈັດສິບເອັດ;
LO72ເຈັດສິບສອງ;
LO73ເຈັດສິບສາມ;
LO74ເຈັດສິບສ່ ;
LO75ເຈັດສິບຫ້າ;
LO76ເຈັດສິບຫົກ;
LO77ເຈັດສິບເຈັດ;
LO78ເຈັດສິບເເປດ;
LO79ເຈັດສິບເກົ້າ;
LO80ແປດສິບ;
LO81ແປດສິບເອັດ;
LO82ແປດສິບສອງ;
LO83ແປດສິບສາມ;
LO84ແປດສິບສີ່;
LO85ແປດສິບຫ້າ;
LO86ແປດສິບຫົກ;
LO87ແປດສິບເຈັດ;
LO88ແປດສິບແປດ;
LO89ແປດສິບເກົ້າ;
LO90ເກົ້າສິບ;
LO91ເກົ້າສິບເອັດ;
LO92ເກົ້າສິບສອງ;
LO93ເກົ້າສິບສາມ;
LO94ເກົ້າສິບສີ;
LO95ເກົ້າສິບຫ້າ;
LO96ເກົ້າສິບຫົກ;
LO97ເກົ້າສິບເຈັດ;
LO98ເກົ້າສິບເເປດ;
LO99ເກົ້າສິບເກົ້າ;
LOA101;
LOA202;
LOB121;
LOB222;
LOC;
LOC131;
LOC232;
LOD141;
LOD242;
LOE151;
LOE252;
LOF161;
LOF262;
LOG171;
LOG272;
LOH1ໜຶ່ງຮ້ອຍ;
LOH2ສອງຮ້ອຍ;
LOH3ສາມຮ້ອຍ;
LOH4ສີ່ຮ້ອຍ;
LOH5ຫ້າຮ້ອຍ;
LOH6ຫົກຮ້ອຍ;
LOH7ເຈັດຮ້ອຍ;
LOH8ແປດຮ້ອຍ;
LOH9ເກົ້າຮ້ອຍ;
LOH>ຮ້ອຍ;
LOI181;
LOI282;
LOJ191;
LOJ292;
LOK)ລ້ານລ້ານ;
LOK1ໜຶ່ງລ້ານລ້ານ;
LOK=ລ້ານລ້ານ;
LOK>ລ້ານລ້ານ;
LOL)ຕື້;
LOL1ໜຶ່ງຕື້;
LOL=ຕື້;
LOL>ຕື້;
LOM)ລ້ານ;
LOM1ໜຶ່ງລ້ານ;
LOM=ລ້ານ;
LOM>ລ້ານ;
LON1KOPEKA;
LON2KOPEKI;
LON5KOPEJEK;
LOR)RUBLJA;
LOR1ODIN RUBL;
LOR=RUBL;
LOR>RUBLEJ;
LOT)TIJSJATSCHI;
LOT0TEN THOUSAND ;
LOT1ໜຶ່ງພັນ;
LOT2TWO THOUSAND ;
LOT3THREE THOUSAND ;
LOT4FOUR THOUSAND ;
LOT5FIVE THOUSAND ;
LOT6SIX THOUSAND ;
LOT7SEVEN THOUSAND ;
LOT8EIGHT THOUSAND ;
LOT9NINE THOUSAND ;
LOT=TIJSJATSCHA;
LOT>ພັນ;
LOX);
LOX1100;
LOX>ຫມື່ນ;
LOXA;
LOXB;
LOXC;
LOXD;
LOXE;
LOXF;
LOXG;
LOXI;
LOXJ;
LOXX;
LOY1100 ;
LOY2200 ;
LOY3300 ;
LOY4400 ;
LOY5500 ;
LOY6600 ;
LOY7700 ;
LOY8800 ;
LOY9900 ;
LOY>ແສນ;
LOYA;
LOYB;
LOYC;
LOYD;
LOYE;
LOYF;
LOYG;
LOYI;
LOYJ;
Read only

0 Likes
2,025

Hi,

In this function module you have to manually convert one hundred thousand to one lakh manually .

like..

if word cs 'one hundred thousand' .

replace ....


endif .

Read only

0 Likes
2,025

Dear DJ,

Thank you very much for your response. I will try again.

Regards,

Jurairat D.

Read only

Former Member
0 Likes
2,025

Hi Jurairat,

Check below  sample code


DATA :LV_SPELL TYPE SPELL,

       lv_string TYPE string.

CALL FUNCTION 'SPELL_AMOUNT'

  EXPORTING

    AMOUNT          = 1000

    CURRENCY        = 'INR '

*   FILLER          = ' '

*   LANGUAGE        = SY-LANGU

  IMPORTING

    IN_WORDS        = LV_SPELL

  EXCEPTIONS

    NOT_FOUND       = 1

    TOO_LARGE       = 2

    OTHERS          = 3

           .

IF sy-subrc <> 0.

* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

   WRITE:

       / lv_SPELL-WORD(64),

       / lv_spell-WORD+64(64),

       / lv_spell-WORD+128(64),

       / lv_spell-WORD+192.


Output


TEN (Because Indian rupees 10,00-Ten Rupees).



Thanks and Regards,

Rajkumar Parthipan.








Read only

0 Likes
2,025

Dear Rajkumar Parthipan,

Thank you very much, I will try. But I'm not sure that I maintained data in table T015Z correctly.

Do you have any recommendation?

Best Regards,

Jurairat D.