Thanks Niyas Raphy for the support, the video answered it but one need to make some edit for newer Odoo version. Here is my working test code.

product_id = fields.Many2one('product.product')
invoice_date = fields.Date()

@api.model
def init(self):
tools.drop_view_if_exists(self.env.cr, 'cashflow_actual')
self.env.cr.execute("""​
CREATE OR REPLACE VIEW cashflow_actual AS (
	​SELECT row_number() OVER () AS id, aml.product_id, am.invoice_date
	​FROM account_move_line aml
	​LEFT JOIN account_move am ON (am.id = aml.move_id)
	​)
""")