component tables

[Former Member]

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

[gopi_narendra]

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

[Former Member]

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

[Former Member]

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

[Former Member]

thanks guyz.