A Database View is a subset of the database sorted and displayed in a particular way. For example, in an Invoice database, perhaps you only wish to display the Vendors stored in the database.

EnterpriseOne Views are similar in nature, where it sits on top on JD Edwards Tables, to retrieve data, or a subset of data.

With Business Views, we can join tables using Left outer, Right outer, Union, Intersect joins. One can usually join up to 5 tables in a Business View if using Simple joins. If one uses a Complex join, then number of tables is limited to 3.

What if you need to use more than 5 tables? What if you need to do some complex joins? And What if you need a column which would give you a Count of records for the group?
For e.g. if you have a need to display the number of items on Open orders and quantities shipped, with the order details, you may have to do the following SQL

SELECT sddoco, sdkcoo, sddcto, count(*), sum(sduopn)
FROM F4211
WHERE sdnxtr <=540
GROUP BY sddoco,sdkcoo,sddcto

To accomplish this in current JD Edwards EnterpriseOne Reporting, you will need to do a little more programming.

We can do this easily via Database Views. We can trick the EnterpriseOne software to use the Database views as E1 tables.

Read Rest of this article at http://www.deepeshmd.com/enterpriseone/using-complex-database-views-on-enterpriseone/

Related Articles:

1. EnterpriseOne 9.0 Standalone – Oracle Local Database Login Credentials
2. Change Database values using MS Access (JDE E1 Oracle)
3. Uninstall JD Edwards EnterpriseOne Standalone/Demo
4. Troubleshooting JD Edwards EnterpriseOne 9.0 Demo Installation
5. EnterpriseOne Roadmap