Skip to Content
0

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

Nov 16, 2016 at 03:26 PM

18

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.

Regards,

Sharath

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

0 Answers