Database Field

[Former Member]

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??

[Former Member]

In SE11,

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

- Selvapandian Arunachalam

[Former Member]

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...

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

HI

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

[Manohar2u]

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

[Former Member]

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.

[Former Member]

SE84

SE85

regards,

Amiya Shrivastava