How to find in which file is a field from the alias ?

Hello list,

I am a functionnal consultant trying to get more knowledge on tehcnicals
issues :

If there a way on OW to find in which file(s) a field is stored once you
know the alias name ?

I am sure it is ovious for you!

Many thanks in advance.

Michel MAUREL
OW XE, standalone, SP13.
--
Privileged/Confidential Information may be contained in this message.
If you are not the addressee indicated in this message (or responsible
for delivery of the
message to such person), you may not copy or deliver this message to
anyone. In such case, you should destroy this message and kindly notify
the sender by reply
email.

There's a great way to find out what tables contain a particular data item,
what forms use a data item as a variable, what UBE's use a data item, etc.

This great facility is the Cross Reference Facility (P980011). It takes
several hours to build (It took me 10 hours using 3 PIII 733mHz
workstations) but it's well worth the trouble.

Colin

Hi Michel,

Check the F98711 "Table Columns" table with the UTB (Universal Table Browser). Type the alias of the data item (field) into the TDOBND field of the QBE line and hit Find. Check the TDOBNM column for the tables that contains this data item (field).

Hope, could be a bit of help.

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

Try using the Cross Reference Facility (P980011)on menu GH902. This
information needs to be built before you can use it. There is a document on
the Knowledge Garden on how to build it and how to use it.

__________________________
Kathy Winter
IT Mgr
The Foreign Candy Company
B733.1
Win NT
SP 11.1

Michel,

Just an addition to my previous reply.
The specification of tables rarely could be different under different Path Codes. If you want to check this then open F98711 table in different Central Object data sources belonging to different Path Codes.

Regards,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

Michel MAUREL,

(in B733)

Fast Path to GH902
Open Cross Reference Facility
-- to find tables in which the alias resides, open TABLES USING DATA ITEMS
-- to find applications in which the alias resides, open INTERACTIVE
APPLICATIONS USING A DATA ITEM AS A VARIABLE or FORMS USING A DATA ITEM.

Steve Shepard
O'Gara - Hess & Eisenhardt

OW&Number=23749
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE 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®

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

Hi Zoltan,
Oh yes it helps !
Many thanks for the answer, from which I learn at least one half of my answer.
But for the time being the F98711 file is empty. And on my standalone I only find one location.
However I will try on monday on a fat customer PC.

The other half I need is to know how to have the F98711 file feeded.
May be I need to tun a batch to populate this file.
If yes, which batch R98xxxx .

Thanks in advance

Michel
OW, XE


Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the
message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply
email.

Hi Kathy, Zoltan, Colin, and Steve,

Many many thanks to all of you for very complementory elements.

Now I know my way through this topic.
I will run the P980011 and get the document on the KG as well.

Best regards.
Michel.