table field value dependent tables

Former Member — Tue, 05 Feb 2013 10:28:48 GMT

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.

Re: table field value dependent tables

kakshat — Tue, 05 Feb 2013 10:41:45 GMT

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

topic Re: table field value dependent tables in Application Development and Automation Discussions

table field value dependent tables

Re: table field value dependent tables