cancel
Showing results for 
Search instead for 
Did you mean: 

Convert all Time Zone into a specific time Zone

Former Member
0 Kudos

Hi BW challengers,

Q) I GETTING data from CRM system To BW and CRMsystrm getting data frmom diffenrent source system. each source system has its own time zone like Japan,US,UK,India.

my BW system is US PST zone.

according to time zones 1,2,34,7,8 Hourse diffrence thier dates chnges to US date.

I want Report in BEX user acessing from thir time Zone can get their reports only.

LIKE i want to take which purchese order created on which time and DATE.in my report. IS IT POSSIBLE.

IS IT POSSIBLE TO HANDLE THIS PROBLEM AT REPORING LEVEL TO CUSTMIZE AT VARIBALE EXITS.

FOR CUSTOMIZING WHICH FUNCTION MODULE IS SUITABLE ????

CAN WE HANDEL THIS AT DESIGN LEVEL?????

IS THERE ANY DIFFEREN WAY/SCENARIO TO HANDEL THIS PROBLE.

PLEASE TAKE THIS IS ONE BIGGEST ISSUE CAN ANY ONE SUGGEST TO HANDEL HOW.

WAITING FOR GOOD RESPONCE

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

HI,

You will have to record the time zone for the respective system in your modelling based on the data you get from. You can maintain a table in bw and assign the timezone to each system that you extact data from. You can also have system in your cube to identify the source system and related timezone.

Then we have a table in BW called TTZZT which holds all the time zone( if specific one has not been created by user).

SAP has standard funcation module TZ_LOCAL_TO_GLOBAL which converts time from local to global(UCT). You can use these information to build your logic in query varibale by using the timezone based on source system id etc..

hope it will help..

regards,

bhuwan

Former Member
0 Kudos

Hi

In our sys we are using CRM & R3 in different region's

of the world.

Both CRM & R3 keep track of Time Zones in different way's.

What you need to do is bring all transaction records to the same TZ (we use PST).

You then can report on this TZ.

The way to do it is either in the extract or in Update rules (we use mostly in the extract).

Reg's

Edan