How to search all the tables name which all have the same field contained

[Former Member]

For example:

Material#: MATNR

Material Description: MAKTX

And obviously we can find these 2 field name in Table MAKT.

But if within the system, there exist the Zcustomized Table such as ZMAKTX.

Ans also contained the fields name MATNR and MAKTX...

So what i want is to <b>list all the table's name which contain the same fields</b>, such as MAKTX...

How to check this??

Thanks.

[Former Member]

you can try

SE15 -> ABAP dict. -> fields -> table fields -> field name: MAKTX

Execute

[Former Member]

Hi,

Go to SE11 -> enter dataelement name as MAKTX -> choose dataelement radiobutton -> choose where used list icon from application tool bar -> check table fields -> click on execute.

You will be displayed with all the tables that are using MAKTX.

Regards,

Naveen.

[Former Member]

Hi,

Goto transaction SE49 and just put down your transaction code for which you want to see all the table.

In this way ,you can find the tables with common fields.

Reward points if it helps.

Regards

Karan