Please move this question out of this place, and into a place where it might be seen by geodatabase experts (like Geodatabase). You should also edit the original question to contain the information necessary to generate an answer, which would include:
- The version(s) of ArcGIS in use
- The RDBMS (with exact version) hosting the enterprise geodatabase ("ArcSDE" no longer exists)
- The exact command you issued to create the view
- The exact table definition of the view (especially datatypes)
- Confirmation that the view generates correct/desired results from a SQL prompt
- What you mean by "not able to see"
- V
