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

navigation for database tables in a transaction code

Former Member
0 Likes
2,918

Hi all !

Is there any way to know the database tables linked to a transaction code, so that searching for fields in tables gets easier right?Please help.

What is the use of Tcode SE80.How can we make use of this transaction?

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,865

Hi Jaya,

Follow the below steps.

go to se11 and display TSTCP table and execute it

and in the PARAM field give as below

/*SM30 VIEWNAME=/BEV2/ED916_V;UPDATE=X;

Replace /BEV2/ED916 with your table name

and execute it .

Reward points if useful

Regards,

Nageswar

Hi all !

Is there any way to know the database tables linked to a transaction code, so that searching for fields in tables gets easier right?Please help.

What is the use of Tcode SE80.How can we make use of this transaction?

6 REPLIES 6
Read only

Former Member
0 Likes
1,865

hi,

SE80 - Object Navigator

se80 is a tool to develope and navigate programs and dd-obj.

SE80 Object Navigator - > means all the objects qill be available there.

in se80 in addition to viewing the objects related to programming and classess, there are more priviliges to view such as some other repositories suchas mime, object repository,object browser and all..

The 2 editors are se38 and se80 both have the abap editor in place. In se38 you can go create programs and view online reports and basically do all thedevelopmet of objects in this editor. In se80 ( object navigator) there are additional features such as creating packages,module pool , function group ,classes, programs ( where you can create ur programs) and BSP applications .

SE38, u will get more space in editor when u compare with the SE80 screen, the tree structure available will occupy more space so it will be eay for us to code.

If u want to do any special navigation then u can got to SE80, but there is no specific reason.

It depends on teh users convineince.

se80 is to navigate to every object .....

but everytime there is no need to navigate to several steps and go to abap editor.

So there certain transactions which takes us to directly to the objects such as SE38 for abapaeditor

SE37 for function module

SE93 for creating transaction codes...etc.

U can also traverse to se80 from SE38 itself using CtrlShiftF5.

SE 38 ->Abap Editor thru which we can create/modify the programs.

SE80 ->Object Navigator thru which we can navigate to many areas like message classes,Function modules,application areas,transactions, programs etc.

Read only

0 Likes
1,865

Hi Naveen!

Thank you for giving such information , but please tell me how to know the database tables linked to a standard transaction code.

Read only

0 Likes
1,865

The table which store information about Structures and Tables are as follows:

DD02L - table properties

DD02T - table texts

DD03L - field properties

DD03T - field texts

How to find data related to a structure? With GREAT difficulty, but here are some ways (which will NOT always work! LOL) to find specific fields if you know the structure’s fieldname.

1) First, goto SE11, and enter your structure name. Goto the field that holds your data, and double-click on the element name. Once inside the element, do a where-used list for that element, searching tables only. Then go into each table, and see if you can find the one holding your data. There may sometimes be a huge number of tables displayed, but a lot of them will be empty.

2) Get the name of the program behind your transaction, goto SE80, and enter the program name. 99% of the time it will be part of a module-pool and bring up the pool. Goto the dictionary structures, and search each table there for the one holding your data.

3) Open a new session with transaction ST05, select SQL Trace, click on the Trace On button, and go back to your transaction (while leaving the session with ST05 open). Submit your transaction, and go back to the ST05 session. Click on the Trace Off button, then select the List Trace button. Continue with standard selections, and a BASIC TRACE LIST will appear. search thru the tables displayed under ObjectName.

Read only

Former Member
0 Likes
1,866

Hi Jaya,

Follow the below steps.

go to se11 and display TSTCP table and execute it

and in the PARAM field give as below

/*SM30 VIEWNAME=/BEV2/ED916_V;UPDATE=X;

Replace /BEV2/ED916 with your table name

and execute it .

Reward points if useful

Regards,

Nageswar

Read only

0 Likes
1,865

Hi Nag!I want to know the names of tables to which the fields in a transaction code are linked.(i.e. I would like to know the tables in which the data records are generated when we enter data through a standard transaction code.).Then how can I give the table name in the parameter you have mentioned?

Read only

Former Member
0 Likes
1,865

Hi all ! I am closing this thread. I got some idea to find out table names through SE80.Thank u.