topic Re: table query in Application Development and Automation Discussions

table query

Former Member — Wed, 11 Jul 2007 10:37:31 GMT

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

Re: table query

Former Member — Wed, 11 Jul 2007 10:40:01 GMT

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

Re: table query

Former Member — Wed, 11 Jul 2007 10:42:46 GMT

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

Re: table query

Former Member — Wed, 11 Jul 2007 10:43:42 GMT

in SE11..

Datatype : give the fieldname and give F7

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

Re: table query

mohammed_moqeeth — Wed, 11 Jul 2007 10:43:50 GMT

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.

Re: table query

Former Member — Wed, 11 Jul 2007 10:44:31 GMT

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

Re: table query

Former Member — Wed, 11 Jul 2007 10:45:06 GMT

Hello ,

Caheck this Table : DD03L .

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

Regards,

Deepu.K