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: 

Best way to find the table names

Former Member
0 Kudos

Gurus..

What is the best way to find out the table/field names for any field in SAP.

For example; In tcode VA03 we have sales document number and its details. we know that its stored in VBAK table.I would like to know the way to find out table name for any field in any transaction in SAP.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

Goto table "DD03L" --->Enter Field name

---> you will get tables name.

OR

Press F1 on the field ->again press F9(technical Info)->get the table name.

Don't forget to reward if useful...

8 REPLIES 8

Former Member
0 Kudos

F1-> Tech info

Former Member
0 Kudos

Hi

Place your cursor at the field you like to know the details..

Press --> F1 --> Pop Up Window Opens on its Toolbar select

technical Information -->

Check the details needed under the Field Data Block..

Hope it helps.

Praveen

former_member567553
Participant
0 Kudos

You can also try using ST05 and trace the source of data (table name - field)

Former Member
0 Kudos

ploace the cursor at the field

press F1

a Performance Assistance window will pop up

Click on Technical Information

here you can find all the information like

program name

screen number

status

table name

field name

data element

parameter id

screen field

thank you

reward if useful

Former Member
0 Kudos

hi,

try using F1, where you can find the table's and field's name in technical information.

regards,

ritika

0 Kudos

thanks all you guys for your quick replies..

I knew the F1 >technical info method and I normally use it .I would like to learn the ST05 trace method.

Could anyone please elaborate the ST05 trace method step by step or give the pointers to the links to it on help.sap.

Also,one folow up question.

If I want to find the tables for config data,like statement groups,sales order reason codes etc, will this F1 method be of helpful?

thanks in advance

Former Member
0 Kudos

Hi,

Goto table "DD03L" --->Enter Field name

---> you will get tables name.

OR

Press F1 on the field ->again press F9(technical Info)->get the table name.

Don't forget to reward if useful...

Rakesh_Y
Explorer
0 Kudos

SE16N Extended Search can also be used to do a table search using Field name. The icon for extended search is just besides the Table entry field.