Alias

[OWWoman]

[smile]Is there an EASY way to find what tables an field is in if I only know the alias? THANKS!

 

[jfwalke]

yes use the cross reference on menu GH902






OWWoman
<lori_ann_siegle@ To: [email protected]
merck.com> cc:
Sent by: Subject: Alias
owner-support@jde
list.com


09/12/2002 02:25
PM
Please respond to
jdeapps






[smile]Is there an EASY way to find what tables an field is in if I only
know the alias? THANKS!
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=Apps&Number=41592
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World / Xe® and World Applications mailing
list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+

 

[cnc__guy]

Yes,

You must use the Cross Referece Facility which must be generated by running
a series of UBEs. It is something that should be run over a weekend (if in
a production system) because it can take several hours.

After the XREF facility is generated, type XREF in the fast path, choose
the Tables tab and search for all tables using a particular data item.

My 2 cents worth.

Thanks,
James A. Wilson
CNC Consultant

 

[tmackin]

Use the Cross Reference facility P980011, menu GH902 or GH909



Sr. Business Systems Analyst
OFS Fitel, LLC
OW B733 Cum 2 SP11.3, NT SP6a, SQL 7.0 SP3

 

[Its not on sale]

It all depend on what you looking at. You have to be specific here now.

 

[ame]

You can go through the Cross Reference Facility on GH902 menu. this should
be able to help if you have run the cross referencing capability (For
non-standard data dictionary part numbers). if it's standard it should be
there. thanks

 

[Larry_Jones]

Hi Woman!

In future please include you system configuration in your signature, OK? It saves wasted questions.

Here is a Oracle SQL script you can use for a quick Xref of what tables a DD Item is (using its alias name). If you are not Oracle you or a programmer should still be able to modify to meet your database's SQL dialect:
-------------------------------------------------
select distinct ol.siobnm as "Table", ol.simd as "Description", t.tdobnd as "Item"
from obj7333.f9860 ol, py7333.f98711 t
where ol.siobnm = t.tdobnm and ol.sifuno = 'TBLE' and
t.tdobnd in ('LITM', 'CITM','CPIL','KITL','AITM','KITA','PAIL')
order by ol.siobnm;
--------------------------------------------------
Cheers,