topic Re: Data format in Application Development and Automation Discussions

Data format

Former Member — Tue, 31 Oct 2006 08:53:07 GMT

Hi Friends,

I have to change the format in the form

It is displaying in this formart

value = 20.000

data = 20.10.2006

I want to display in this format

value = 20

data = 20/10/2006

Thanx in advance,

Venu

Re: Data format

Former Member — Tue, 31 Oct 2006 08:56:33 GMT

&value&(.0)

/: SET DATE MASK = 'DD/MM/YYYY'

&DATE&

Re: Data format

Former Member — Tue, 31 Oct 2006 08:57:36 GMT

declare

data: value(16) type p.

and for date.

use fm.

CONVERSION_EXIT_PDATE_OUTPUT

DATA formatted_text TYPE c LENGTH 50.

WRITE sy-datum TO formatted_text MM/DD/YYYY.

Re: Data format

Former Member — Tue, 31 Oct 2006 08:59:05 GMT

Hope this gives you some idea:

data: l_date(10) type c.
CALL FUNCTION 'CONVERSION_EXIT_PDATE_OUTPUT'
  EXPORTING
    INPUT         = sy-datum
 IMPORTING
   OUTPUT        = l_date.

write:/ l_date.

Alternatively, you can change the date as
  concatenate sy-datum+6(2) sy-datum+4(2) sy-datum(4) into l_date separated by '/'.
write:/ l_date.

data: l_dec(6) type p decimals 2 value 2.
data: l_int type i.

write:/ l_dec.
l_int = l_dec.
write:/ l_int.

Kind Regards

Eswar

Re: Data format

Former Member — Tue, 31 Oct 2006 08:59:06 GMT

Hi Venu,

The date format inside the field is always YYYYMMDD.

The default format (for display purpose)is based upon user settings.

If we want in some other format,

then we need to write extra code for it

using OFFSET

eg. mm/dd/yyyy

CONCATENATE MYDATE4(2) '/' MYDATE6(2) '/' MYDATE(4)

INTO DTS.

For 20.000, store this value into a variable which is of Interger Type.

*REWARD for all helpful answers

Message was edited by: Palak Limbachiya

Re: Data format

Former Member — Tue, 31 Oct 2006 09:09:11 GMT

Hi,

The date format is fine, but I am unable to get the value in the proper format(Ex:20) It is displaying 20.000

Thanx in advance,

Venu

Re: Data format

Former Member — Tue, 31 Oct 2006 09:13:34 GMT

Venu,

Check this link:

http://help.sap.com/saphelp_erp2004/helpdata/en/d1/803479454211d189710000e8322d00/content.htm

Re: Data format

Former Member — Tue, 31 Oct 2006 09:17:55 GMT

Have you tried moving the value to integer and display the same.

Alternatively, you can use WRITE statement with addition

DECIMALS

write:/ l_dec DECIMALS 0.

Kind Regards

Eswar

Re: Data format

Former Member — Tue, 31 Oct 2006 09:21:58 GMT

as u rewared the point i think ur using sapscript.han use like that.

&value(.0)&