topic Re: value conversion in Application Development and Automation Discussions

value conversion

Former Member — Wed, 30 May 2007 11:11:02 GMT

Hi everybody,

i need a small help reg value conversion.

for suppose:

1>a = 1.234.567,89 in sap format

we need to convert this to a = 1,234,567.89 into flat file.

2>date format is showing as DD.MM.YYYY in sap format

we need to convert this to MM/DD/YYYY

(no matter which user is used to run the program)

please give me reply.

Re: value conversion

Former Member — Wed, 30 May 2007 11:15:57 GMT

Check the User Settings for Currency and Date in SU01 Tcode (defaults) change it and see

Other wise in Program/script you can write

SET COUNTRY 'IN' and it will change the format

Reward points if useful

Regards

Anji

Re: value conversion

Former Member — Wed, 30 May 2007 11:19:06 GMT

hi,

Check the User Settings in SU01 Tcode (defaults) change it and see

Other wise in Program you can write

SET COUNTRY 'IN' and it will change the format

n also we can manually by field positioning.

if useful reward some points.

withregards,

suresh babu aluri.

Re: value conversion

Former Member — Wed, 30 May 2007 11:19:36 GMT

Hi,

the value is displayed on the user settings, if you want the same to be changed

then use the FM

CONVERSION_EXIT_ALPHA_OUTPUT

Regards

Shiva

Re: value conversion

Former Member — Wed, 30 May 2007 11:20:12 GMT

Hi Sunil,

To dispaly the Date form System Format to User Format the FM 'CONVERT_DATE_TO_EXTERNAL' is used.

Consider this code.

REPORT zztest_arun_2.

DATA: e_date(10) type c VALUE '2/2/2006',

i_date(10).

CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL'

EXPORTING

date_external = e_date

IMPORTING

date_internal = i_date

EXCEPTIONS

date_external_is_invalid = 1

OTHERS = 2.

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 : / 'CONVERT_DATE_TO_INTERNAL',

/ 'My Date:' , e_date ,

'Conv Date:', i_date.

skip 2.

CALL FUNCTION 'CONVERT_DATE_TO_EXTERNAL'

EXPORTING

DATE_INTERNAL = sy-datum

IMPORTING

DATE_EXTERNAL = e_date

EXCEPTIONS

DATE_INTERNAL_IS_INVALID = 1

OTHERS = 2

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 : / 'CONVERT_DATE_TO_EXTERNAL',

/ 'My Date:' , sy-datum,

'Conv Date:', e_date.

Thanks,

reward If Helpful.