Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SEARCH FOR SPECIFIC TABLE FIELD

Former Member
0 Kudos

<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.

6 REPLIES 6

Former Member
0 Kudos

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!

0 Kudos

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

0 Kudos

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

0 Kudos

Hi John,

thanks for advice. Very useful.

Kind Regards

Oliver

0 Kudos

> 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

0 Kudos

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

Regards,

John.