• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Which programs update or read a field in JDE?

Eric_Lehti

Active Member
The cross-reference function (Inquire on a field name in Data Dictionary,
then press F15) has a limitation. It shows all programs that access
characters 2 through 6 of a field name in ALL data files. It does not let
you specify the entire 6-character field name for the file in question.

You can determine which programs access ( update / read ) a field in a file
by querying F98003LC and searching for the field in question.

Example: To learn which programs read or update field ABLNGP in F0101,
query F98003LC as shown:

Select fields:

#3DTAN (field name in file)

#3UPD (Y'es, is updated, 'N'o, not updated)

#3PGM (Program accessing the field in file

I selected #3DTAN EQ 'ABLNGP'

This works for all JD Edwards files, so far as I know.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Eric Lehti Certified JD Edwards Professional

Fike Corporation, 704 SW 10th Street, Blue Springs, Missouri 64015

mailto:Eric.Lehti@fike.com <mailto:Eric.Lehti@fike.com> * Phone (816)
229-3405 ext. 231 * Fax (816) 229-4615

JD Edwards A73 Cume 10, AS/400 9406-730, OS/400 V4R4

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 

SallyWhite

Well Known Member
If you have program P980014, will let you inquire on a data field name from
a file, as well as any of the other relationships for which F98003 contains
information. (Use * in the 'Type' field for a list of options.)

Regards,
Sally White
<P ID="edit"><FONT SIZE=-1>Edited by ekempter on 2/13/01 08:31 AM.</FONT></P>
 

adcaswell

Member
The XREF function does let you look up the full 6 character field name. In
the name field enter the name (i.e. ABAN8); in the type field enter a 'D',
in the next field enter a 'P'. If your XREF files have been built deep
enough (the way they usually come from JDE) you should get a listing of
programs using the field. The far left column of the display shows the
update status (Y/N).

Also you can rebuild the XREF files to even greater depth if you wish.

Alan Caswell
Alan Caswell Consulting
Cell: 206-799-8823
EM: adcaswell@home.com
 
Top