Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers