You need to create a model from a SQL View. You can check an example in the project_report.py in the project module. That shows pretty well how to create models from views

I hope this information is helpful for you.  refer this link: http://stackoverflow.com/questions/33252030/add-the-new-dynamic-field-in-odoo?answertab=votes#tab-top) it's works for me

http://odoo-development.readthedocs.io/en/latest/dev/py/postgres-views.html