peturba
1st October 2009, 16:38
When I try to delete an (pcs) item using ttaad4100 it always ends up with a fatal error (reference exists). Here's what I did:

1st I've checked all existing references for table tcibd001 with session "Print Reference To Parent" (ttaad4229m000)

2nd I've tried to delete the item in all listed reference tables; to be finally able to delete the item in the tcibd001 table

The output of session ttaad4229m000 now tells me that only two references are present: in table tcibd200 and whwmd400. Although, it is not possible to delete any of those because of an existing reference.

How can I discover if there (and where) are any remaining references?

Regs

pet

Juergen
1st October 2009, 17:11
Please check first with session ttadv4430m000 "Print where used tables" where the specific table field is used in other tables as reference.

e.g tcibd200.item is used as reference in table cprpd100

regards,
Juergen

peturba
1st October 2009, 17:19
Hi Juergen,

Thanks for the hint. I was hoping that the session ttaad4229m000 can be used instead of ttadv4430m000. It is quite lot of work to check all tables this way but I guess there is no other way to get rid of the item.

Regs

pet