create a report that trick E1 to use the database views as E1 table

Hi I am very new in JDE. sorry for dump question.

I was given a SQL ( select statement with outter join, left join, right join on 9+ table). I need to write a report and it will generate a csv file base on all the column from this SQL . I found this ( ID 640352.1 ) from my oracle support.

It said that is possible by doing this

1. Create the database view TEST.FD55134
2. Grant all on TEST.FD55134 to public;
3. create E1 table with same name FD55134, save and close the table design Aid
4. now the E1 table is the database view
5. now you create E1 Business views on this E1 table. To further create reports..