How are subqueries performed in SEI without creating a custom DB view ?
Creating an Order Shortage Report.
I have a process that pull sinformation form the ITMMVT table in summary (Orders, Item info) but I need to join to the ORDERS table to find the earliest PO.
1 to many relationship.
I can solve this in SQL (view) but can it be done in SEI ?