Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

E1 RDA - is there a way to sort a table to read a particular column sequentially?

edited Jun 1, 2016 5:05AM in Design Tools & Output Technologies - JDE1 (MOSC) 10 commentsAnswered

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. 


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center