topic Re: Deleting foreign key dependent data. in Application Development and Automation Discussions

Deleting foreign key dependent data.

ashok_mohan — Wed, 06 Aug 2014 06:57:41 GMT

I have 2 tables - zcar and zcolor. Zcolor key field is color number and zcar key field is engine number. The check table for zcar is zcolor table with color number as the key. So a car should be added to zcar if the corresponding color exists in zcolor table. Its working properly. But when i delete a particular color from the zcolor table, the corresponding car with that color is not deleted. Pls suggest a solution.

Re: Deleting foreign key dependent data.

Former Member — Wed, 06 Aug 2014 09:17:41 GMT

Hello,

you must delete the zcar entries manually when you're deleting the zcolor entry.

Only other option would be to configure your database tables on database level as key dependent but then you need direct access to the databse (not from inside SAP).

Regards Nico

Re: Deleting foreign key dependent data.

ashok_mohan — Thu, 14 Aug 2014 11:01:17 GMT

Thanks