topic Re: FM in Application Development and Automation Discussions

FM

Former Member — Thu, 12 Jan 2006 20:32:57 GMT

Hi,

My requirement is that for the interface I have to pick the file application server do changes to functional area, dates and subnit to the std SAP prog. Go to SM35 & process the session. For me in the input file date is coming in 1st record line and in 3 places ... T_INPUTFILE21(8)BLDAT, T_INPUTFILE35(8) BUDAT, T_INPUTFILE+70(8) WWERT. ... whatever date format comes in these places has to be convereted according to the user who will run the SM35 ... so that the date format comes exactly to his settings... for this which FM should I use ... Is it CONVERT_DATE_TO_EXTERNAL ?? Or

CONVERT_DATE_TO_INTERNAL ?? & how to pass these 3 dates to the FM??

Thank You,

Seema.

Re: FM

RichHeilman — Thu, 12 Jan 2006 20:43:37 GMT

Yes, that function module will convert to the user specification, you will have to call the function module three times for each date. You can use it in a FORM.




report zrich_0003.


data: formatted_date(10) type c.

parameters: p_datum type sy-datum.



perform convert_date using p_datum
                     changing formatted_date.


write:/ formatted_date.


*---------------------------------------------------------------------*
*       FORM convert_date                                             *
*---------------------------------------------------------------------*
form convert_date using in
                  changing out.


  call function 'CONVERT_DATE_TO_EXTERNAL'
       exporting
            date_internal            = in
       importing
            date_external            = out
       exceptions
            date_internal_is_invalid = 1
            others                   = 2.



endform.

Regards,

Rich Heilman

Re: FM

Former Member — Thu, 12 Jan 2006 20:44:01 GMT

Hi ,

You can directly check the user profile and change the date format.

SELECT SINGLE * FROM USR01 WHERE BNAME = SY-UNAME.

MOVE INPUT_DATE TO OUTPUT_DATE.

IF USR01-DATFM = '1'.

CONCATENATE INPUT_DATE+6(2)

INPUT_DATE+4(2)

INPUT_DATE(4)

INTO OUTPUT_DATE.

ELSEIF USR01-DATFM = '2' OR USR01-DATFM = '3'.

SHIFT OUTPUT_DATE CIRCULAR BY 4 PLACES.

ENDIF.

Lanka

Re: FM

Former Member — Thu, 12 Jan 2006 20:49:53 GMT

Hi ,

Use FM 'SLS_MISC_GET_USER_DATE_FORMAT' & find out the format of the user.

Then modify the internal table fields accordingly.

Re: FM

Former Member — Thu, 12 Jan 2006 20:53:48 GMT

Hi Lanka,

Can u pls tell me what USR01-DATFM = 1, 2,& 3 stand for ... also in my USR01 table there is one entry with "4"..

Thank You,

Re: FM

RichHeilman — Thu, 12 Jan 2006 20:56:47 GMT

The DATFM field is tied to the radiobuttons that you see in the user profile when viewing the date format defaults. Each number corresponds to a certain format.


1	DD.MM.YYYY
2	MM/DD/YYYY
3	MM-DD-YYYY
4	YYYY.MM.DD
5	YYYY/MM/DD
6	YYYY-MM-DD

Again, I don't think you have to do this, the function module will convert it to the format specified in the user profile.

Regards,

Rich Heilman

Re: FM

Former Member — Thu, 12 Jan 2006 20:58:29 GMT

Hi SB,

As Rick mentioned DATFM tell u about the date format using by the users.

If 1 means date is in "US" and 2 means "Europe" date format.

Please try to changes your user profile and check the table.

Hope this will help you.

Lanka

Re: FM

Former Member — Thu, 12 Jan 2006 21:03:22 GMT

Ok Rich,

If I use the FM 'CONVERT_DATE_TO_EXTERNAL' then how do I test it & confirm that the output date will be of the user format ??

Thank You,

Re: FM

RichHeilman — Thu, 12 Jan 2006 21:06:49 GMT

In debug mode, you should see that the character field has the date with formatting.

Regards,

Rich Heilman

Re: FM

govind_seenivasan — Thu, 12 Jan 2006 21:08:26 GMT

Hi,

You can not do any changes after creating a session. Session contains only the Tcode,Screen Nos and data.

Thanks

Govind.

Re: FM

RichHeilman — Thu, 12 Jan 2006 21:08:38 GMT

In my sample, put a break-point after the call to the subroutine. Double click on the FORMATTED_DATE field and check the value, notice that it is formatted.



report zrich_0003.


data: formatted_date(10) type c.

parameters: p_datum type sy-datum.



perform convert_date using p_datum
                     changing formatted_date.
<b>break-point.</b>

write:/ formatted_date.

*---------------------------------------------------------------------*
*       FORM convert_date                                             *
*---------------------------------------------------------------------*
form convert_date using in
                  changing out.


  call function 'CONVERT_DATE_TO_EXTERNAL'
       exporting
            date_internal            = in
       importing
            date_external            = out
       exceptions
            date_internal_is_invalid = 1
            others                   = 2.


endform.

Regards,

RIch Heilman

Re: FM

Former Member — Thu, 12 Jan 2006 21:09:09 GMT

Hi,

How will you change the date format once the session is already created in SM35??& Do yu previously know who is going to execute the session in SM35.

Re: FM

Former Member — Thu, 12 Jan 2006 21:09:10 GMT

Hi SB,

Change date format in your user data.

Path: system~~Userprofile~~> Owndata~~defaults~~> changes the date format.

And test the " function module:'CONVERT_DATE_TO_EXTERNAL' " using Sy-datum.

Or As <u>Rick mentioned Set a break point at above function</u> and change date format in your user profile and check the date format after executing above function

If Date format not changed as per user profile then you will get error while processing the BDC thru call transaction.

Lanka

Message was edited by: Lanka Murthy

Re: FM

Former Member — Thu, 12 Jan 2006 21:54:54 GMT

Hi Lanka/Rich,

I used the FM & changed the date format & I am able to process the transaction... but these date are coming in 3 different place in the 1st record How do i handle them in one go

Thank You,

SB.

Re: FM

Former Member — Thu, 12 Jan 2006 21:59:19 GMT

Hi SB,

I don't think you are passing same date field in all 3 places.

in this case :

My suggestion is to call the function in 3 places before passing the value in order to avoid any issues.

Other wise :

Define a Varible and pass the value of the date to that variable after calling the function module.

Pass this variable to all the date fields.

Lanka

Re: FM

Former Member — Thu, 12 Jan 2006 22:42:22 GMT

Hi,

Can u please give me the example by using the perform statement... that would be of a great help to me...

Thank You,

Re: FM

Former Member — Thu, 12 Jan 2006 22:55:30 GMT

Hi SB,

Please use the following code :

data: V_date(10) type c.

CALL FUNCTION 'CONVERT_DATE_TO_EXTERNAL'

EXPORTING

DATE_INTERNAL = INPUTDATE

IMPORTING

DATE_EXTERNAL = V_DATE

EXCEPTIONS

DATE_INTERNAL_IS_INVALID = 1

OTHERS = 2.

Pass this V_date value to your code.

Lanka

Re: FM

RichHeilman — Thu, 12 Jan 2006 23:03:44 GMT

The example above showed how to call it in a FORM. It would be just like this.



report zrich_0003.


data: formatted_date(10) type c.

parameters: p_datum1 type sy-datum.
parameters: p_datum2 type sy-datum.
parameters: p_datum3 type sy-datum.


perform convert_date using p_datum1
                     changing formatted_date.
write:/ formatted_date.
perform convert_date using p_datum2
                     changing formatted_date.
write:/ formatted_date.
perform convert_date using p_datum3
                     changing formatted_date.
write:/ formatted_date.



*---------------------------------------------------------------------*
*       FORM convert_date                                             *
*---------------------------------------------------------------------*
form convert_date using in
                  changing out.


  call function 'CONVERT_DATE_TO_EXTERNAL'
    exporting
      date_internal            = in
    importing
      date_external            = out
    exceptions
      date_internal_is_invalid = 1
      others                   = 2.


endform.                    "convert_date

Regards,

Rich Heilman