table field value dependent tables

[Former Member]

Hi,

Kindly suggest, I have a requirement in which  for a given check table field value using a where used list I would have to find the dependent tables that use this field with this value. The primary idea behind using this logic is when an user attempts to delete a  table field value while it is still being used in dependent tables, I would have to show a warning message by providing a list of all where used tables list when attempting to delete the value.

So far I have come up with a FM RS_EU_CROSSREF which is marginally helpful in finding out the table names but I personally feel that I would have to come up with a design by myself by building a function module with the  table field and value field and even then is there a possibility of listing out the dependent tables using the field name and field values. Any helpful suggestion would be rewarded with maximum points.

[kakshat]

Hi Sreekanth,

A quick thought. The dependent tables here would be the foreign key tables, right? So, your problem boils down to figuring out a way to determine the foreign key tables linked to a field of a check table.

Just found this FM - DD_FORKEY_GET. It can give you the foreign key tables for a check table field.

Message was edited by: Kumar Akshat