Skip to Content

How to Change field type CHAR to DATE in datasource my source is Oracle DB

Nov 16, 2016 at 03:26 PM


avatar image
Former Member

Hi All,

Source Sytem: Oracle DB,

I have two Clients Oracle Dev,Oracle PRD, Intially i built a view in oracle prd when i develop data source in SAP BW DATS datatype generated by BW System WHICH IS CORRECT. When i connect to DEV and develop data source it is showing CHAR datatype, the view is same with same code, i have used TO_CHAR function on oracle end for both DEV & PRD , i don't want to go with routines, DATS datatype has to be generated by system, can any one give me the suggestion? THE SYSTEM HAS TO GENERATE DATS instaed of CHAR.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers