Skip to Content
0
Former Member
Oct 13, 2005 at 09:47 PM

Finding Foreign Keys in SAP table through DD26S

310 Views

Hi,

I am currently using DD26S to look up TableName, ForeignTableName, and ForeignColumnName. In my query, I use SELECT tabname fortabname forcolname into (a,b,c) from DD26S. However, I still have two questions:

1. Is DD26S the right table to look for foreign keys(constraint data)?

2. I would also like to know the column name of the tabname that corresponds to forcolname. Can anyone tell me how or which table I can join with to obtain this information?

I would appreciate any help.

Thank you in advance,

Sunny