Data Dictionary/Column Search Question

[maikeru-sama]

Hi, I am not sure if the Data Dictionary is what I am looking for.

Say I needed to find out what Table the Field/Column RPKCO was in, how would I find that?

In the Data Dictionary, I can search for the column using the alias, but once I bring it up by double clicking, it does not tell me what table it is in. I would think that would be in the "parent" field.

 

[jdecnc]

You would need to build the cross reference relationship if it has not previously been built. Once it is built you can use the cross reference program (P980011) to see where it is used.

 

[tmackin]

use the cross reference facility

 

[JDE User11]

Re: RE: Data Dictionary/Column Search Question

F98711 contains the tables and their column names. It has both the aliases and the table column prefix + alias as fields.

I'm not sure if this is generated by the cross reference facility or not.

Steven

 

[maikeru-sama]

Re: RE: Data Dictionary/Column Search Question

Thanks everyone, that was a big belp.

 

[jitender]

Re: RE: Data Dictionary/Column Search Question

Hi
You can do this by CROSS reference utility.

from the fast path type XREF.

a application opens and there you have options in left rebuild relationship. there build the realtionships for the DD items.

after this you can see that in which tables this data item is used.

Regards
Jitender

 

[Dragon61]

The F98711 is one of the tables built by XREF UBE