SriksAdi
4th September 2004, 07:35
Hi,
I need to delete a customer from the customer master table. I have checked out all the possible places where the customer code has been used. Still I get an error, reference exists.

How do I get the table list where this customer has been used ?

regards
Sriks

malutz
6th September 2004, 08:45
Hej,

we gave up with deleting customers or items. There are just too many references on these tables. I recommand to set it inactiv.

SriksAdi
8th September 2004, 13:55
Hi,
I have written a script to get the list of tables where a customer is being used. I have noticed that for a few customers, there are no references. Still I could not delete the customer.

What might be the problem ?


regards
Sriks

Hitesh Shah
8th September 2004, 14:13
Reference counters may have wrong value . U can repair the reference counter re-organize tables (ttaad4225m000).

Atul Khungar
8th September 2004, 16:03
You could try using the session ttaad4229m000 (Print References to Parent).
All the Best !!!

Atul

SriksAdi
9th September 2004, 08:11
Hi,
Thanks for the replies. I could solve the problem.


Regards
Sriks