Skip to Content
0
Former Member
Apr 16, 2014 at 06:44 AM

Conversion Error in Function Module

272 Views


Hi All,

We are using FM : TZ_LOCAL_TO_GLOBAL in our SAP BW system to populate one of the timestamp fields passing date, time and time zone -UK. FM is generating Conversion Error for all the records where date is 30th March 2014 & time is between 2 - 3AM.

On Further testing we observed that this issue is occuring betwee 2-3 AM on every 5th Sunday of March each year.

We guessed that the issue might be due to Day Light Saving settings becasue in dubugging it was failing at below convert statement.

CONVERT DATE ltimestamp_imp-date TIME ltimestamp_imp-time

INTO TIME STAMP lv_timestamp TIME ZONE timezone.

We checked DayLight Saving settings in SPRO and found an entry for UK in Variable Summer Time Rules which we guess causing the issue but not sure.

Now I am looking for 3 answers here.

1. Is it above setting that is causing the issue.

2. if Yes, what this setting mean? Does it says not to post any transaction during this time.

3. What would be advisble approach to use this FM without converion error.

Regards

Jitendra

Attachments