topic Re: SEARCH FOR SPECIFIC TABLE FIELD in Application Development and Automation Discussions

SEARCH FOR SPECIFIC TABLE FIELD

Former Member — Wed, 28 Apr 2004 07:16:33 GMT

<b></b>

Hallo.

I am new with ABAP programming. I am finding too difficult to find out specific field and table containing that field in SAP. Please suggest me the easy way to get table and field name when I only know the data which I want to extract from.

Re: SEARCH FOR SPECIFIC TABLE FIELD

Former Member — Wed, 28 Apr 2004 08:44:00 GMT

Hello Anand!

Find a transaction that displays the data your're looking for.

F1 and Button 'Technical Information' in the field will lead you to the technical field information.

In box 'field data' there's an entry showing the data element. Double-click on the data-element to navigate to the dictionary.

Most programmers use the identical Data element, that is used for storing the field in a table, also for the structures that display field data on the screens. So, in data dictionary viewing your data element you can use Button 'Where-used-list' to search for usage of your data element in table fields.

In the hint list, double-click will navigate to data dictionary showing the selected table. Here, verify if your entry is physically stored in the table with 'Utilities -> Table contents -> display' (or directly via SE16)

greetinx, Kathrin!

Re: SEARCH FOR SPECIFIC TABLE FIELD

Former Member — Fri, 18 Jun 2004 09:26:54 GMT

Hi,

if I only know the tec. name e.g. ZPROJKAT, how can I find further information in the system (e.g. the table etc.)?

Kind Regards

Oliver

Re: SEARCH FOR SPECIFIC TABLE FIELD

Former Member — Fri, 18 Jun 2004 11:28:14 GMT

You can use transaction SE16 to browse table DD03L. In the selection screen enter ZPROJKAT for 'FIELDNAME' and you will get a list of tables containing this field.

Regards,

John

Re: SEARCH FOR SPECIFIC TABLE FIELD

Former Member — Mon, 21 Jun 2004 07:02:03 GMT

Hi John,

thanks for advice. Very useful.

Kind Regards

Oliver

Re: SEARCH FOR SPECIFIC TABLE FIELD

Former Member — Tue, 22 Jun 2004 01:56:25 GMT

> You can use transaction SE16 to browse table DD03L.

> In the selection screen enter ZPROJKAT for

> 'FIELDNAME' and you will get a list of tables

> containing this field.

> Regards,

> John

Wow!

Does this work in every version? This is so far the best tool I've ever heard of. It is sometimes mind twisting to know where do these functional folks get the fields from, you yet ask yaself, mm do they search every single table on the dictionary?

Let us know on what versions of R/3 this works on if you can.

Kind Regards,

Francisco

Re: SEARCH FOR SPECIFIC TABLE FIELD

Former Member — Tue, 22 Jun 2004 07:25:54 GMT

This works for every R/3 version up to now...

Regards,

John.