topic Re: fields in Application Development and Automation Discussions

fields

Former Member — Thu, 14 Sep 2006 19:16:49 GMT

Hi experts,

i need to see the field (like ex: kunnr) is there in how many tables.How can i view.

Is there any table for system status field.

Thanks

Re: fields

Former Member — Thu, 14 Sep 2006 19:20:17 GMT

Go to SE11 transaction and enter KUNNR in Data element field and press F7 key. It will go in to display mode.

place the cursor on the dataelement KUNNR and on the application tool bar you will have option 'where used in' button. Click on it and select database tables and press enter key.

It would display all the tables in which KUNNR is used.

Re: fields

Former Member — Thu, 14 Sep 2006 19:20:48 GMT

hi nitin

I think u can use where-used list to find out.

Re: fields

RichHeilman — Thu, 14 Sep 2006 19:21:08 GMT

You can do a where used in SE11 for the data element being used, this will get you started. Go to SE11, enter table name KNA1, check the data element for KUNNR. Now do where used on this data element, this may not get you all as there could be more than one data element used for KUNNR, but will get you most.

Regards,

Rich Heilman

Re: fields

Former Member — Thu, 14 Sep 2006 19:21:40 GMT

SE11-> Enter the KUNNR in Datatype and press where used list(beside delete button) button. You will find the tables.

System infformationm you will get it from through SYST structure.

Rew, the points,if it helps Thanks