Modeling Scenario with Date/Time Characteristics

[sap_cohort]

I have a Z Table with Date and Time Stamps recorded in UTC. I am thinking this would be the best thing to do, but when I think about how to display the date and time in BEx using local Time Zone I'm not sure this can be done. Can the date and time be coverted in BEx from UTC to User Local?

Any suggestions on the best approach for this scenario?

Thanks!

[Former Member · Accepted solution]

Hi,

you can use the functional module to do this..

STU3_ALERTS_CONV_LOCAL_2_UTC

STU3_ALERTS_CONV_UTC_2_LOCAL

You can store UTC values in z table and in then when transactional data is loaded ..make z field for local date and local time in your data target and fill it in start routine using this FM.

Hope i m clr.

Regards,

San!

[sap_cohort]

Done

[sap_cohort]

Thanks, but I am thinking that my data is loading into a virtual infocube and performance might suffer considerably. So I was hoping that BEx might offer some help. Anyone Else have ideas?