Timestamp/Timezone issue

[SandeshK]

Hi All,

We have an issue with the SAP system timestamp and timezone. Hope you can help me out:

We are on SAP CRM system and basically we have this issue with standard business documents. SAP System is configured to CET timezone. I have checked in TTZCU table too , TZONESYS and TZONEDEF are both CET and there is no user specific timezone when checked in SU01D(user profile).

To make things simpler, I have written a small program which explains the issue:

DATA locl_tstmp TYPE  crmt_date_timestamp_from.

WRITE: 'Current Date',  sy-datum.
WRITE:/'Current Time',  sy-uzeit.
WRITE:/'Time Zone',  sy-zonlo.


 CONVERT DATE sy-datum
         TIME sy-uzeit
         INTO TIME STAMP locl_tstmp
         TIME ZONE 'CET'.

Now when I execute this above program, below is the result I get:

Current Date 23.09.2014
Current Time 11:17:20
Time Zone CET
CET 23.09.2014 09:17:20

Current Date, Current Time, Time zone are correct. But when i explicitly (Line 08) convert the date and time to time zone CET , it actually converts to UTC time i.e 09:17:20 in the above program result which is wrong.

Why is it converting to UTC and not CET though I have given TIME ZONE 'CET'  at line 10?

[SandeshK]

Closing the issue. I think I got it , CONVERT DATE TIME INTO TIME STAMP TIME ZONE will convert with respective to UTC timezone and not with the current system timezone.