Hi
We are using additional date ranges in our project for Trade Promotions. The table to store the dates for a trade promotion is CRMD_MKTPL_DATE ( it also stores the time stamp of the promotion). When I see the date stored in the table for a particular trade promotion, it is not matching with the one on UI. I am not getitng where the dates are getitng stored in a different time zone ( yes, it is actually showing some fixed time for the date which is actually changing the date in the table). Can someone suggest a solution for seeing the actual date in the table?
Regards
Sunil
Edited by: Sunil Dangwal on Feb 14, 2010 1:51 AM
To add further, I know that I can change the user time zone to be defaulted across the system and also it can be changed at user specific level but the main thing I want to know is where to make settings for picking up the time for a particular date, for example, if we enter plan start date as 01/01/2011, what time stamp will the system pick out of 24 hrs available in the said date.
strangely, the standard extractor in BW is picking up the right date irrespecitve of what is stored in the table CRMD_MKTPL_DATE.
Any pointers to explain this behaviour willbe appreciated....Thanks....
Edited by: Sunil Dangwal on Feb 14, 2010 1:51 AM