cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

you can try

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

Execute

Former Member
0 Kudos

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
0 Kudos

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