Application Development and Automation 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: 
Read only

Help on finding table..

former_member2382
Active Participant
0 Likes
646

Hi All,

I want to know how to find out the tables if only fields are given to us..??

Thanks,

Parvez.

1 ACCEPTED SOLUTION
Read only

anversha_s
Active Contributor
0 Likes
620

hi,

There are various ways exists to find the table list.

1. Go to transaction SE11 and enter data element name for corresponding field and click where used-list button in the application tool bar in the application tool bar. It will show you a popbox, select only 'database tables' check box and lick enter.

This will give you all tables where this field is present.

2. The other way is..The database table DD03L stores all tables along with their field names.

Go to transaction SE16 and enter the table DD03L and enter you field name here and execute the transaction.

This wil give all the tables where the field is present.

Also Check

http://www.sap-img.com/abap/easy-way-to-remember-table-in-sap.htm

TO know the functionalities of tables and relationships,check this link.

http://www.sap-img.com/sap-download/sap-tables.zip

try this link

http://www.erpgenie.com/sap/abap/tables.htm

regards

Anver

4 REPLIES 4
Read only

Former Member
0 Likes
620

Hi

go to table dd03l and enter the field name

it will show all the tables

thanks

shiva

Read only

0 Likes
620

use transection se84 and se11 . where used list u get table.

Read only

Former Member
0 Likes
620

go to se15. choose abap dictionary. choose fields. and then table fields give your field name to right hand side input box and press F8.

regards

shiba dutta

Read only

anversha_s
Active Contributor
0 Likes
621

hi,

There are various ways exists to find the table list.

1. Go to transaction SE11 and enter data element name for corresponding field and click where used-list button in the application tool bar in the application tool bar. It will show you a popbox, select only 'database tables' check box and lick enter.

This will give you all tables where this field is present.

2. The other way is..The database table DD03L stores all tables along with their field names.

Go to transaction SE16 and enter the table DD03L and enter you field name here and execute the transaction.

This wil give all the tables where the field is present.

Also Check

http://www.sap-img.com/abap/easy-way-to-remember-table-in-sap.htm

TO know the functionalities of tables and relationships,check this link.

http://www.sap-img.com/sap-download/sap-tables.zip

try this link

http://www.erpgenie.com/sap/abap/tables.htm

regards

Anver