Deleting foreign key dependent data.

[ashok_mohan]

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.

[ashok_mohan]

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.

[Former Member]

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

[ashok_mohan]

Thanks