How to find Table name for a Field which is shown structure name on press F1.
As we know about the tables and fields.
We also know all information are stored in a table and a particular field. It’s very difficult to memorize all tables and all fields.
We can get this from F1 – Technical Information for table and field.
The fields names are always shown correct. But for table name, sometime its shows the structure name instead of table name.
For an example
When we press F1 on field Short Text on screen ME51N. We can see as well the Short Text field name, but in table portion we can see a structure name not a table name.
As we know the field Short Text (TXZ01) is stored in EBAN table, but we can’t find this from F1 screen.
Its shown a structure name as MEREQ3211GRID.
In that situation, we have to find the original table name for this field.
Here I am giving the 3 way to find the original table for any field.
When the above pop-up comes, double click on the “Data Element”.
Now you can see a screen of Display Data Element.
Now you can see the data element screen for the field Short Text.
You can see another pop-up screen will come, which is like below screen.
As we need the table name, so remove the all tick without Table Fields.
Now press enter or continue.
After pressing enter, you will find a list.
This list shows you on which table the field is used.
It means in the listed tables, you can find the field Short Text (TXZ01)
We can see 15 Hits comes on the screen.
It means the field TXZ01 is used in 15 tables.
Now we can find the table as per our requirement. We need the table for ME51N (Purchase Requisition).
We can see Purchase requisition is also listed in the list.
And we can also see the table name for Purchase Requisition.
If you have found a many number of hits, then you can search for your table with given description.
Like as if you want to know the table for PR, then you can search as purchase requisition
In that way we can find the original table name for this particular field.
(Note: I know I have given an easy field and table name, But I am just sharing the procedure to see the original table name for a particular field)
Way 2 :
This is a similar way as way one.
Just first step is little different.
If you know the field name, then we can enter it directly in SE11 screen and we can get the Table name.
In SE11 screen, on the field Database Table, give the field name (Where usually we give the table name)
Now press display.
You can see the Display Data Element screen.
You can do the further process which we have already discussed in the Way 1 section.
Way 3 :
This is little different way.
Use t-code SE84 or SE15.
You can see an initial screen is appearing for Object Navigator.
Now from here select the option
ABAP Dictionary-Fields-Table Fields.
Now Double click on Table Fields.
You can see a screen is will come on right side of the screen.
Here give the field name as TXZ01.
Then Press execute.
Now you will get the all table list for the field TXZ01.
Here you also use the search option which I have discussed in way 1.
In these above 3 ways, you can find the original table name for a particular field.
So don’t worry when you see a structure name in table field, just use one option from above and you will get the table original table name.
Thanks and Regards