Typical number of tables and views in JDE OneWorld system

kiran g

kiran g

Well Known Member
Hi,

I am categorizing tables and views present in the JDE OneWorld 8.10 system database according to System codes.

I use the F0005 table to get all the distinct System Codes. then i fetch all the tables from F9860 with column "FUNO" = "tble" , AND I BELIEVE that the COLUMN "SYR" in F9860 is the table's ASSOCIATED SYSTEM CODE..(PLEASE Confirm this !!!!! )

Currently in my JDE system,there are around 2500 tables and 5000 views. Is this the maximum number of tables and Views present in any JDE system ????
Or can this number exceed ?? ..if it exceeds , whats the maximum no of tables and views that can be present.

You can pour in the nos from your JDE systems .. that would be a gr8 help...

Thanks,
Kiran
 

Similar threads

E9.2 Access SQL View as JDE Table
Replies
16
Views
782
JohnDanter2
JohnDanter2
E9.2 AS400 How JDE determine CCSID for table's columns where generate table via OMW
Replies
0
Views
611
Manoch
E9.2 prodctl.f0002 Next Numbers
Replies
1
Views
863
eydeak
A7.3 List of database tables used by the HR and Payroll modules
Replies
0
Views
504
Daniel Ulisses Da Meda
E9.2 Power Edit form and transaction management, are tableIO statements working in transaction within an APPL ?
Replies
12
Views
392
jdelisths
jdelisths
Back
Top