Finding technical field and table from a transaction

In this example, lets look at the material group field which is in material master.

We will try to find out what is the field name and the table this material group can be found and also lets see the list of parts which is assigned to this material group-

Lets go!

This is in MM02 and in basic data 1 tab -

Press F1 in material group field ?and select technical information , which will show the field name and table name.

Below is the screen shot for reference.

So in this case the field name is MATKL and table is MARA

In case of writing a functional specification, this detail needs to be added to be shared with technical team.

In case of getting a report -

Go to SE16 or SE16N- T code

It gives the list of materials for a specific material group.

It can be downloaded in the form of spreadsheet.

Point to note - Generally authorization for SE16 or SE16N is not provided to end users instead to consultants only as sometimes the tables can be so big that the system may hang up.

Thank you

Suhas.