topic Re: tables and fields in Application Development and Automation Discussions

tables and fields

Former Member — Fri, 04 Jan 2008 14:28:22 GMT

How can we know that which data is going in which table in a trnsaction?

for example in transaction MM01 for material creation the fields are

MATERIAL , INDUSTRY SECTOR , etc .

Now how can I know that the material I entered is stored in which tables?

Thanks.

Re: tables and fields

Former Member — Fri, 04 Jan 2008 14:34:05 GMT

You can click on the field and press the F1 key. This will give you information and technical details on the field. You can figure out the table/structure names and much other information.

From there once you've found the table name you can go to transaction se16 and enter the table name. There you can look at all the fields in the table.

Re: tables and fields

Former Member — Fri, 04 Jan 2008 14:34:10 GMT

hi,

Press F1 on the fields --> a pop window will be displayed --> click on Technical Information button on the toolbar --> A pop window will be displayed, there you can see the tables and fields. The table name mentioned in the table field, that table will be bet updated.

Thanks,

Sriram Ponna.

Re: tables and fields

Former Member — Fri, 04 Jan 2008 14:34:31 GMT

Run ST05 in another sessions and enable the SQL trace. Then when you run a transaction and save it. Disbale the SQL trace. View the trace and do a search for the words: -

MODIFY

INSERT

DELETE

UPDATE

This will tell you what tables have been updated.

Re: tables and fields

Former Member — Fri, 04 Jan 2008 14:40:28 GMT

Hi ,

if u have authorization to create TC(se93).

u have to create on new TC with program SAPMSEUZ, with that TC u can get 4 radio button.

1.program

2.tc----

> here u need to give MM01.

3.fg

4.dialog module.

In the 2 option u need to give MM01. and f8.

u will get all tables.

Reward me if helpfull

Re: tables and fields

Former Member — Fri, 04 Jan 2008 14:41:24 GMT

The answer to your question is not that easy.....Only your experience will make it easy.

Anyways... try following the few steps given elow.

The first step is always to find out the table and field name of the screen field. With the cursor in the field you want, press F1 or click on the "?".

The initial help screen will give you descriptions and information about the field.

From there press F9 or click on [Technical info].

Here you can get names of the table, field and the data element.

If you are lucky the system gives you a transparent table name. If you're not lucky you'll get a structure name.

Doubleclick on the data element and search via the where used of the dictionary.

Failing above you can set up the TCODE or a portion of it just before screen where the field exists and then switch on SQL Trace, run the screen, turn off SQL trace and then list the Trace Log following which tables/views were hit. Obviously it is best to turn on and off the trace in the smallest time-window possible to lessen the number of Trace Log entries you have to look through.

Another thing to try is : run program RSSDOCTB. This gives you a list with info about the table such as fields, check tables ....

Or try Transaction SE84 (Repository Info System)- Select in the tree ABAP Dictionary -> Fields -> Table Fields - Insert in the Select-Option "Field name" the name of the files (E.g. CARRID and CONNID) and execute it - now you will get a list of all tables which have one or both of this fields - it's easy to identify the tables which contain both fields in the list.

Or start an sql trace and look at the tables that are read

Last resort, find the program name (click on the triangle icon at botton right t oexpand information and click on the icon right of client number) and look the ABAP code with TCODE SE38 .

Finally Get into Debugging of the Transaction and you will see the flow of data for each and every line of code.

Re: tables and fields

Former Member — Fri, 04 Jan 2008 14:44:25 GMT

Hi ,

if u have authorization to create TC(se93).

u have to create on new TC with program SAPMSEUZ,

with screen no 200.

with that TC u can get 4 radio button.

1.program

2.tc----

> here u need to give MM01.

3.fg

4.dialog module.

In the 2 option u need to give MM01. and f8.

u will get all tables.

Reward me if helpfull

Re: tables and fields

Former Member — Fri, 04 Jan 2008 14:45:58 GMT

No vinodh,

you are mistaken, simple procedure is here, go throgh in this way,

if u have authorization to create TC(se93).

u have to create on new TC with program SAPMSEUZ,

with screen no 200.

with that TC u can get 4 radio button.

1.program

2.tc----

> here u need to give MM01.

3.fg

4.dialog module.

In the 2 option u need to give MM01. and f8.

u will get all tables.

Reward me if helpfull