E1 RDA - is there a way to sort a table to read a particular column sequentially?
I created a business view between two tables and both are keyed by (i.e., document number - these records were added sequentially via next numbers). Along with it are columns that were saved including company information CO. When records are appended, the company information varies. In RDA, I would like to read it sorted by company(not by doc or record number) where all company 10000, 20000, 30000, etc will be grouped together so I can create a logic for each company group and write it to another table sorted by company.
Something like: ORDER by CO in a sql script.