cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (0)