cancel
Showing results for 
Search instead for 
Did you mean: 

Common Feilds in Tables..........

Former Member
0 Kudos

Hi there ,

From where we can see the link between the fields of the tables........ for eg : If I want to find all the tables where the material type field is being used...........

Please enlighten me .......

Regards

Kaushik

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Dear Kaushik,

Enter the dataelement as MTART in SE11 -> Choose 'Where used List' option in the application tool bar -> Check Database Tables -> Execute -> You will be displayed with all the tables that are using MTART.

However, it would cumbersome as it may display more than what you are looking for.

Let us know your requirement, if you are looking for any specific table.

Regards,

Naveen.

kaushik_choudhury2
Active Contributor
0 Kudos

Hi Erwan LE BRUN & Naveen Bathini ,

Thanks for your reply....... After I enter the field name & click the <u>where use list</u> in SE11........I am getting the list of data elements........but not the table name....... Please help me ...... whree is the Check Database Tables in the menu ........

Regards

Kaushik

Former Member
0 Kudos

Dear Kaushik,

You would be displayed tables names along with data elements. Check the checkbox and choose display.

make sure you have checked 'Table Fields' option in the where used list. The table name is displayed above the data element. 'Check' the checkbox beside the dataelement and choose display option from application toolbar.

Table Names and Dataelements have different background colours.

Regards,

Naveen.

kaushik_choudhury2
Active Contributor
0 Kudos

Hi Naveen Bathini,

After I click the diaplay icon I am gettin the defination of the data element like Data type,Length , Decimal places etc....... but I am sorry ....... I am not able to locate the table name there ........

Please telll me where I am going wrong........

Thanks

Kaushik

Former Member
0 Kudos

Dear Kaushik,

Go to SE11 -> enter MTART in dataelement (choose dataelement radiobutton) -> click on where used list on application toolbar -> check 'Table Fields' option -> click enter

I believe you are displaying the dataelement instead of choosing where used list !!

Regards,

Naveen.

kaushik_choudhury2
Active Contributor
0 Kudos

Hi Naveen Bathini ,

Thanks a lot....... I was making a silly mistake .....

Thanks & Regards

Kaushik

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Use the "<b>Where Used List</b>" functionnality for <b>Domain</b> MTART ( Mat. Type ) in txn SE11

Hope this helps,

Erwan