topic Re: User setting for date format and decimal format in Application Development and Automation Discussions

User setting for date format and decimal format

Former Member — Wed, 04 Dec 2013 01:16:30 GMT

Hi Gurus,

I created a report which output ALV grid as below:

But user want to change the display Date format (as YYYY/MM/DD) and display Decimal Format (as 1,234,567.89) as below From SU3 (Maintain User Profile) :

But I am not sure how to set this in my program, can any experts give me direction?

Really appreciate your help.

Re: User setting for date format and decimal format

Former Member — Wed, 04 Dec 2013 01:44:24 GMT

Please you refer to the following link,

Maybe you need to change your fields' format in your program.

Re: User setting for date format and decimal format

Former Member — Wed, 04 Dec 2013 01:55:30 GMT

Thank you Jack for the response.

I am just wonderinga is it possible to do what user want, I meant user can change the ALV date display format according what they set in SU3?

Re: User setting for date format and decimal format

Former Member — Wed, 04 Dec 2013 04:56:31 GMT

Hi,

Yes it is possible.

-> you need to get the date format of the user as per the SU3 settings. For this you can use the below FM: SUSR_USER_DEFAULT_DATE_FORMAT ( FM provide the user date format)

-> Pass the date format and date to this FM /OSP/TRVL_DATE_IN_USER_FORMATE

Example:

CALL FUNCTION 'SUSR_USER_DEFAULT_DATE_FORMAT'
IMPORTING
DATFM = l_dateformat.

CALL FUNCTION '/OSP/TRVL_DATE_IN_USER_FORMATE'
   EXPORTING
     iv_date               = date                  " which you want to display
     IV_DATE_FORMATE       = l_dateformat
IMPORTING
    EV_DATE_TEXT          = alv_date

Re: User setting for date format and decimal format

Former Member — Wed, 04 Dec 2013 06:06:00 GMT

Yes Blue,

Its very simple.

In the field catalog, just set the following attributes for the date field. The format as defined in logon master data of user would be used to display the date field.

LVC_S_FCAT-DATATYPE = 'DATS'.

LVC_S_FCAT-INTTYPE = 'D'.

LVC_S_FCAT-INTLEN = '000008'.

LVC_S_FCAT-DD_OUTLEN = '000010'.

Or another option is, you could just move this to a date field in the internal table. The date format in ALV would automatically be according to SU3 settings.

begin of it_data.

...

date type datum "date type ekbe-budat.

...

end of it_data.

Re: User setting for date format and decimal format

Former Member — Wed, 04 Dec 2013 07:11:11 GMT

Hi,

For date.

I suppose you got a list box. You can feel it with different formats of date.

To do so you can use the following link.

FUNCTION MODULE FOR CONVERTING DATE INTO THE GIVEN FORMAT - Code Gallery - SCN Wiki

Then use the following FM to convert date into user selected format.

FORMAT_DATE_4_OUTPUT.

And pass that value to the ALV.

For decimal notation.

Create a list box with entries like in field DCPFM of USR01.

For logic please check the below link.

https://scn.sap.com/thread/1449990

Hope this helps.

Re: User setting for date format and decimal format

Former Member — Wed, 04 Dec 2013 13:21:05 GMT

Hi Susmitha,

Thank you so much for your reply. I used your way, it is simple and works well.

The only thing is the DATA in the other columns seems all messed up, and also do you know how to do the same thing for Decimal format set in SU3?

Re: User setting for date format and decimal format

Former Member — Wed, 04 Dec 2013 13:26:17 GMT

Table USR01 stores the date format and user format for user.

Pass the user name to the table USR01, and get the date and decimals format.

Based on the user fomate, change the date and decimal formate.

Re: User setting for date format and decimal format

Former Member — Wed, 04 Dec 2013 13:45:27 GMT

Thank you abap udupi for your reply.

Is it possible to set Decimal format using FieldCatalog like Susmitha suggested for Date format as below?

LVC_S_FCAT-DATATYPE = 'DATS'.

LVC_S_FCAT-INTTYPE = 'D'.

LVC_S_FCAT-INTLEN = '000008'.

LVC_S_FCAT-DD_OUTLEN = '000010'.

Re: User setting for date format and decimal format

Former Member — Wed, 04 Dec 2013 14:01:39 GMT

you need to use the date function module DATE EXTERNAL FORMAT and DATE INTERNAL FORMAT.

or else u can concatenate depend on the formate

Re: User setting for date format and decimal format

Former Member — Wed, 04 Dec 2013 14:03:48 GMT

Hi abap,

Is it possible you give a sample code on how to use DATE EXTERNAL FORMAT and DATE INTERNAL FORMAT?

Re: User setting for date format and decimal format

Former Member — Wed, 04 Dec 2013 14:05:04 GMT

Hi kiran,

I tried your way, the syntax is correct, but it seems not outputing the Date format set in SU3. Not sure if I missed anything

Re: User setting for date format and decimal format

Former Member — Wed, 04 Dec 2013 14:15:28 GMT

u can use concatenate also.

for example if u get the '/' date format

concatenate DD '/' MM '/' YYYY into s_date.

similarly if u get the '.' date format

concatenate DD '/' MM '.' YYYY into s_date.

Re: User setting for date format and decimal format

Former Member — Thu, 05 Dec 2013 02:54:22 GMT

Have you cleared the field catalog work area before adding the attributes of other columns?

LVC_S_FCAT-DATATYPE = 'DATS'.

....

APPEND lvc_s_fcat TO lvc_t_fieldcat.

clear LVC_S_FCAT.

Probably the clear statement is missing after you set the attributes of the date column in field catalog.

For decimal numbers, try this.

LVC_S_FCAT-datatype = 'QUAN' .

LVC_S_FCAT-inttype = 'P'.

LVC_S_FCAT-intlen = 13 .

LVC_S_FCAT-dd_outlen = 17 .

......

APPEND lvc_s_fcat TO lvc_t_fieldcat.

clear LVC_S_FCAT.

Re: User setting for date format and decimal format

former_member215575 — Thu, 05 Dec 2013 06:06:47 GMT

This should be default behavior if variable is declared correctly.

Ex:

DATA lv_date TYPE c LENGTH 8. --> results date in YYYYMMDD format

DATA lv_date1 TYPE D. --> results date in YYYYMMDD format

DATA lv_date2 TYPE DATS. --> results date in User default format

DATA lv_date3 TYPE sy-datum. --> results date in User default format

DATA lv_date4 TYPE vbak-erdat. --> results date in User default format

Alternatively, Date format can be modified by providing the 'Reference field' (REF_FIELD) and 'Reference table' (REF_TABLE) in field catalog(structure LVC_S_FCAT).

Same holds good for quantity field also.

For Date format conversion, other alternative solution is to call function module 'SLS_MISC_CONVERT_TO_DATE' to convert date into user default format from system default format(YYYYMMDD).

Please check and let us know the result.

Re: User setting for date format and decimal format

Former Member — Thu, 05 Dec 2013 10:06:48 GMT

Hi,

Please refer following link,

How to display date field in ALV in format 'YYYY-MM-DD'?