2008 Jan 30 4:43 AM
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?
2008 Jan 30 1:08 PM
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?
2008 Jan 30 4:55 AM
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.
2008 Jan 30 9:17 AM
Hi Naveen!
Thank you for giving such information , but please tell me how to know the database tables linked to a standard transaction code.
2008 Jan 30 10:54 AM
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 structures 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.
2008 Jan 30 1:08 PM
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
2008 Jan 31 5:33 AM
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?
2008 Feb 15 3:41 AM
Hi all ! I am closing this thread. I got some idea to find out table names through SE80.Thank u.