How to find out the aligning Data dictionary table for a structure.

[former_member655569]

Hi

As the table controls are associated with strucures, the data input goes to the data dictionary table aligned to that structure. Is there any way we can find out the table related to that particular structure ?

Thanks,

Dhareppa

[former_member194416]

There is no specific way for this. Structure don't have to be connected with one table it can be collection of different table fields or only collection of fields so wiser thing to do checking fields one by one to see if they are belong to a table.

Edited by: Gungor Ozcelebi on Jul 23, 2009 6:09 PM

[Former Member]

There is no easy way to find that out. Typically program structure fields are comprised of multiple table fields.

By reviewing the where-used list of the data element, you can some times determine the table.

Debugging and SQL trace are your best tools for this task.

[Former Member]

Hi,

The structure and its fields may be associated with multiple database tables.

You can try by where-used list of the structure/field and then you can look and determine the table by hit and try method.

Also as suggested above you can try get the SQL trace and then ypu can look for table associated behind the structure/fields I believe this is the best way to find the DB table.

Thanks,

Ravi

[Former Member]

SQL Trace ST05

Debudding in PAI module for At USER Command

OR give table control details in SDN..exp guys can help..

regards