topic Re: Data conversion in Application Development and Automation Discussions

Data conversion

Former Member — Wed, 05 Jul 2006 05:30:31 GMT

Hi all,

I am using Spell_amount, in which i am getting the value as 356,586.00.

I need to convert it as 356586.00

Expecting ur reply.

ravi.

Re: Data conversion

Former Member — Wed, 05 Jul 2006 05:33:21 GMT

Hi Ravi,

Take a characrer variable and replace , with space.

Try as follows.

DATA V_AMOUNT(18).

V_AMOUNT = '356,586.00'.

REPLACE ',' WITH SPACE IN V_AMOUNT.

CONDENSE V_AMOUNT.

Thanks,

Vinay

Re: Data conversion

dani_mn — Wed, 05 Jul 2006 05:34:44 GMT

Hi,

SPELL_AMOUNT is used to convert amounts in words, not for omiting commas.

Regards,

Wasim Ahmed

Re: Data conversion

Former Member — Wed, 05 Jul 2006 05:35:32 GMT

if u want to display it in sap script (form)

than in from write this way..

<b>ex....

&EKPO-MENGE& -

>1,234.560

&EKPO-MENGE(T)& -

>1234.560</b>

andSPELL_AMOUNT is used to convert amounts in words

Re: Data conversion

Former Member — Wed, 05 Jul 2006 05:37:14 GMT

Hi,

1. REPLACE ',' WITH SPACE IN <LV_AMT>

2. CONDENSE <LV_AMT>.

Regs,

Venkat Ramanan

Re: Data conversion

Former Member — Wed, 05 Jul 2006 05:42:50 GMT

My field is komk-fkwrt.

In which i need to send the value like 12323.56, without coma to spell_amount.

Re: Data conversion

Former Member — Wed, 05 Jul 2006 05:43:51 GMT

Function module SPELL_AMOUNT converts an amount or number into words. It can be used as follows:

1. Convert a number into words

To do this, the transfer parameters LANGUAGE and AMOUNT have to be entered.

2. Convert an amount into words

To do this, the fields LANGUAGE, CURRENCY, and AMOUNT have to be entered.

3. Set the number of places before and after the decimal point for an amount

To do this, the parameters CURRENCY and AMOUNT have to be entered. The LANGUAGE field must be transferred with the value SPACE! This option optimizes the runtime of the function module.

The structure SPELL transfers the converted amounts. The FB enters the number of places before and after the decimal point in the NUMBER and DECIMAL fields, the amount in words in the WORD and DECWORD fields, and the figure in words in the DIGnn fields. The numbers converted into words can be protected by a star or some other FILLER.

Re: Data conversion

Former Member — Wed, 05 Jul 2006 05:52:41 GMT

Hi Ravi,

First take a character field of length 18 and move komk-fkwrt value into character field and then replace comma with space and do condense and reassign

Try with this code.

DATA V_AMOUNT(18).

DATA V_FKWRT TYPE KOMK-FKWRT.

V_AMOUNT = KOMK-FKWRT.

REPLACE ',' WITH SPACE IN V_AMOUNT.

CONDENSE V_AMOUNT.

CATCH SYSTEM-EXCEPTIONS ARITHMETIC_ERRORS = 4

OTHERS = 8.

V_FKWRT = V_AMOUNT.

ENDCATCH.

Thanks,

Vinay

Re: Data conversion

Former Member — Wed, 05 Jul 2006 06:06:48 GMT

Hi vinay

Thanks for ur response.

Bur WITH SPACE is showing syntax error.

Re: Data conversion

Former Member — Wed, 05 Jul 2006 06:09:14 GMT

Hi Ravi,

Then try as follows.

REPLACE ',' WITH <b>''</b> IN V_AMOUNT. -->Dont give any space between single quotes.

*CONDENSE V_AMOUNT. --> Comment this statement.

Note: Plz award points to all helpful answers and Close the thread if it is solved.

Thanks,

Vinay

Re: Data conversion

Former Member — Wed, 05 Jul 2006 06:10:52 GMT

REPLACE ',' with SPACE in V_AMOUNT.

Condense V_AMOUNT no-gaps.

Re: Data conversion

Former Member — Wed, 05 Jul 2006 06:18:03 GMT

Hello Ravi,

Consider this code. Just copy and execute it.


REPORT abc.

DATA : spell_amt(15).

spell_amt = '356,586.00'.


WRITE : 'Before Conversion :' ,spell_amt.


TRANSLATE spell_amt USING ', '.
CONDENSE spell_amt NO-GAPS.

WRITE : 'After Conversion :' ,spell_amt.

Regards,

Arun S.

Re: Data conversion

Former Member — Wed, 05 Jul 2006 06:31:30 GMT

Ex. Input is 123,232.56

if i convert into type N of 10 , it becoms 0012323256.

how to suppress leading zeros.

Re: Data conversion

Former Member — Wed, 05 Jul 2006 06:37:52 GMT

Hi ravi,

check it its working perfect.

REPORT ZTEST.

DATA: ALPHABET(15) VALUE '0000EFGHIJ'.

SHIFT ALPHABET LEFT DELETING LEADING '0'.

write : alphabet.

Re: Data conversion

Former Member — Wed, 05 Jul 2006 06:38:01 GMT

Hi,

Use FM CONVERSION_EXIT_ALPHA_OUTPUT to remove the leading zero

e.g.

CONVERSION_EXIT_ALPHA_OUTPUT

import

input = 00123

export

output = lv_without_zero.

result lv_without_zero = 123.

Regards,

Sameena

Re: Data conversion

Former Member — Wed, 05 Jul 2006 06:41:22 GMT

Hi Ravi,

Consider this code.


REPORT abc.

DATA : spell_amt(10) TYPE  n.

spell_amt = '123,232.56'.


WRITE : 'Before Conversion :' ,spell_amt.


TRANSLATE spell_amt USING ', '.

WRITE spell_amt NO-ZERO NO-GAP TO spell_amt.


WRITE : 'After Conversion :' ,spell_amt.

Regards,

Arun S.