topic Re: Database Field in Application Development and Automation Discussions

Database Field

Former Member — Fri, 16 Jun 2006 11:11:18 GMT

If we know the field name and want to search to which Database Table it belongs,then what can we do?Is there any Transaction code??

Re: Database Field

Former Member — Fri, 16 Jun 2006 11:15:28 GMT

In SE11,

Put the cursor on the field. and Click the Where used List Button. then u'll get.

- Selvapandian Arunachalam

Re: Database Field

Former Member — Fri, 16 Jun 2006 11:15:42 GMT

Use the ST05 transaction.

click on the trace on.

then goto ur transaction and do the steps u normally do.

After that Off the trace.

and then display the trace.

There u can able to see many fields and their tables.

Now u search for ur field and which table it is getting updated.

May be the same dataelement will be as other name also.

Just check patiently...

Re: Database Field

Former Member — Fri, 16 Jun 2006 11:16:56 GMT

Go to se11, give the filed name in the Data Type.

Then keep the cursor on the data element of that field and click on the where used list.

2) YOu can chekc the data base table DD03L also.

regards,

ravi

Re: Database Field

Former Member — Fri, 16 Jun 2006 11:20:51 GMT

Hi Ravi,

If the field name is not same as the data element name then how you will search the table name.

Regards,

Mukesh Kumar

Re: Database Field

Former Member — Fri, 16 Jun 2006 11:22:58 GMT

Hi,

You can go to SE84 transaction. from the tree menu

<b>ABAPDICTIONARY -> FIELDS -> click on Table Fields</b>

Here you give the field name and execute ,and find the tables using that field.

Regards

vijay

Re: Database Field

Former Member — Fri, 16 Jun 2006 11:26:05 GMT

GOOD

YOU KNOW THE FIELD NAME AND YOU WANT TO SEARCH THE PARTICUALAR DATABASE TABLE NAME THAN YOU CAN USE THE SE11 TO DO THAT.

THANKS

MRUTYUN

Re: Database Field

Manohar2u — Fri, 16 Jun 2006 11:34:35 GMT

1) Goto SE11 and place your fieldname's dataelement in datatype field and click on where used in table field to know the list of tables used.

2) If you would like to know the field's table which is used in particular transaction. Goto ST05

Activate the trace

Execute your transaction in another session

De-activate the trace

List the trace.

Here you will get the list of tables triggered in your session.

Regds

Manohar

Re: Database Field

Former Member — Fri, 16 Jun 2006 11:35:30 GMT

Hi Anurita,

You can find the table names and field names in the database table : DD03L.

1) Go to SE11 transaction

2) Give this table name DD03L,

the first two fields are TABNAME, FIELDNAME

3) Give the fieldname whatever u want, then press F8,

it will list out all the table names which have

that field.

Re: Database Field

Former Member — Fri, 16 Jun 2006 12:03:09 GMT

SE84

SE85

regards,

Amiya Shrivastava