table query

[Former Member]

hai

i need to find table name using a field name

can anybody suggest a way i am not into ABAP i am functional person.

regards

nalla

[Former Member]

Find the table using where used list by selecting database table. It will list all tables that this field is existing.

[Former Member]

Press F1 on parameters/field and it will take to u the description screen .

From there u can click on technical settings button.

It will take u to technical screen.. there u can get the table / structure/ view name..

reward if useful...

Regards

Prax

[Former Member]

in SE11..

Datatype : give the fieldname and give F7

then check where used list ...this will show the tables.

[mohammed_moqeeth]

Dear Chakravarthy,

You first find the fields data type,

For Example: generally most of the field have name with "same data type "

like FIELD NAME = KUNNR

DATA TYPE = KUNNR for that field

<b>--> go to se11

--> click data type --> in that give the data type of that field

--> from application tool --> click [where use list] --> then check "table fields" and execute.

--> then it will shows the list of tables in which this data type (with reference to the field) exists in these list tables.</b>

Reward points for useful answers.

Moqeeth.

[Former Member]

u can check that in table DD03L

goto SE16

give the table name as DD03L and click on execute button

give the fieldname and F8

you can get many tables , you have to select the appropriate table from them

[Former Member]

Hello ,

Caheck this Table : DD03L .

Give the field name in the SSCRN. It gives u the Table.

Regards,

Deepu.K