richen
13th October 2006, 12:43
I want to know in which tables article is being used.

I have to rename an article number in tiitm001 and I want to know where it is being used. I have tried session ttaad4229m000 but it is not showing everything. I'm sure that the article I want to rename also is present is table tdpur051 but that's not what session ttaad4229m000 is showing me.

Is there an other way??? :)

bdittmar
13th October 2006, 13:27
I want to know in which tables article is being used.

I have to rename an article number in tiitm001 and I want to know where it is being used. I have tried session ttaad4229m000 but it is not showing everything. I'm sure that the article I want to rename also is present is table tdpur051 but that's not what session ttaad4229m000 is showing me.

Is there an other way??? :)

Hello,

if sure that domain used for article (tcitem) is only used for itemcode, session
ttadv4410m000 "print where used domains" will show you all tablefields, where this domain is used.

Because item is used not only in the above tables , it's used in e.g.
tdilc , tdinv , ticpr tables a.s.o.
based on your baan parameters.

Regards