Hi - Releated to Tables and fields.

[Former Member]

Hi,

If we know any field name and want to find the name of the table how do we find the table name.

eg - I Know Matnr exists in MARA.

However if i didnt knew that how can i find that Matnr exists in MARA.

Any help on this will be highly appericiated.

Shejal.

[Former Member]

select that field & click on "where used list " button on application tool bar.

you will see a pop-up with different check boxes for TABLES,STRUCTURES.... & select TABLES & enter.

you will see all the tables in which this particular field exists

what do you mean by field (it may be either dataelement or domain) so go to that domain/data element, then use the above technique of searching it.

regards

srikanth

Message was edited by: Srikanth Kidambi

[Former Member]

A field name can be the same in several tables. Taking your own example of MATNR, it exists not only in MARA, it exists in EKPO, VBAP and many more tables. So if you are expecting one table given a field name as input, then you are in for a surprise.

DD03L stores the fields of all table and structures.

[Former Member]

Hi Shejal,

1) Go to SE15 (Repository info system)

2) Expand ABAP Dictionary

3) Expand Fields

4) Click on Table Fields

5) Enter the field name you want to search in field name and Execute.

Regards,

Vicky

PS: Award points if helpful

[former_member181966]

Moreover,

Check out the tables realtions. its also help you in future

http://www.sapgenie.com/abap/tables.htm

Hope this’ll give you idea!!

<b>P.S award the points.</b>

Good luck

Thanks

Saquib Khan

"Some are wise and some are otherwise"