topic Re: Data Type conversion in Application Development and Automation Discussions

Data Type conversion

Former Member — Wed, 20 Nov 2013 11:59:17 GMT

Hi experts,

I have a char field with value 1,000.00

i need to copy this to a currency field.

how to achieve this?

Re: Data Type conversion

Former Member — Wed, 20 Nov 2013 12:05:31 GMT

Hi,

try to copy it to a field of type P decimal 2. then copy it to currency from this field. I cannot check this as i dont have access to sap at this time.

thanks.

Re: Data Type conversion

former_member226419 — Wed, 20 Nov 2013 12:09:12 GMT

Hi,

Try moving it to NEWR TYPE field

DATA :

VAL1 TYPE CHAR10 VALUE '1000.00',

VAL2 TYPE NETWR.

VAL2 = VAL1.

WRITE : / VAL1,

VAL2.

Regards

Sumeet

Re: Data Type conversion

sivaganesh_krishnan — Wed, 20 Nov 2013 12:11:53 GMT

HI dhivya,

Try moving the char value to currency field .

DATA :

VAL1 TYPE CHAR10 VALUE '1000.99',

VAL2 TYPE NETWR. "Currency field

VAL2 = VAL1.

WRITE : / VAL1,

VAL2.

try passing the string value directly in the function module CHAR_FLTP_CONVERSION , you will get the currency value in FLSTR parameter.

Regards,

sivaganesh.

Re: Data Type conversion

Former Member — Wed, 20 Nov 2013 12:15:38 GMT

Hi Dhivya,

Use FM HRCM_STRING_TO_AMOUNT_CONVERT pass decimal separator and thousand separator (Ex: '.' and ',')

Thanks

Siddhu

Re: Data Type conversion

Former Member — Wed, 20 Nov 2013 12:41:52 GMT

use this FM HRCM_STRING_TO_AMOUNT_CONVERT

pass the string , thousand separator,decimal separator and if it is currecy pass currecy key WAERS.

Re: Data Type conversion

Former Member — Wed, 20 Nov 2013 13:28:53 GMT

Function module HRCM_STRING_TO_AMOUNT_CONVERT does the work.

thnks.

Re: Data Type conversion

Former Member — Wed, 20 Nov 2013 13:29:07 GMT

Function module HRCM_STRING_TO_AMOUNT_CONVERT does the work.

thanks

Re: Data Type conversion

Former Member — Wed, 20 Nov 2013 13:30:18 GMT

data type NETWR works only if the value is w/o thousands separator.

eg: if the value is like '1000.99'

but if the value is like '1,000.99' it gets to dump.

thanks.

Re: Data Type conversion

former_member191569 — Wed, 20 Nov 2013 14:18:56 GMT

Why to use a function module included in SAP HR module to process a simple task as to convert a character-based value into a decimal value? Maybe this function module is not available in every SAP system.

My recommendation is to use other more general function or procedure or do it manually using standard ABAP constructions.

Re: Data Type conversion

SuhaSaha — Wed, 20 Nov 2013 17:02:26 GMT

Why to use a function module included in SAP HR module to process a simple task as to convert a character-based value into a decimal value?

Lack of common sense may be

I could write a simple ABAP routine for this purpose; but alas - "the end justifies the means"

Cheers,

Suhas