topic Re: component tables in Application Development and Automation Discussions

component tables

Former Member — Tue, 28 Nov 2006 02:13:11 GMT

Hi guyz,

may i know how to find component tables for a field

for eg:

if we got kunnr , we have to find all the tables where kunnr is key element.

is there anyway to find all the tables(having kunnr in them) in one go.

plz advise.

thanks in advance

sudheer

Re: component tables

gopi_narendra — Tue, 28 Nov 2006 02:16:38 GMT

one way is to use the WHERE USED LIST (Ctrl + Shift + F3 Button)

but u will NOT know the field as Primary Key, it lists all the tables in which the field is used.

place the cursor at the field name and press the where used list button

Regards

- Gopi

Re: component tables

Former Member — Tue, 28 Nov 2006 02:37:27 GMT

Hi Sudheer

Please check table DD03L.

As you were saying, you have the fieldname and need to check the existence of the field as KEY: try passing the field to FIELDNAME and 'X' to KEYFLAG in table DD03L and check.

Hope this helps.

Kind Regards

Eswar

Re: component tables

Former Member — Tue, 28 Nov 2006 02:39:00 GMT

Hi,

Go to SE16

Give the table name as DD03L

In the FIELDNAME field give KUNNR

In the field KEYFLAG give value 'X'.

Press F8..You will find the list of tables that is having KUNNR as key field..

Thanks

Naren

Re: component tables

Former Member — Tue, 28 Nov 2006 03:14:33 GMT

thanks guyz.