topic Re: Finding out table in Application Development and Automation Discussions

Finding out table

Former Member — Mon, 05 Nov 2007 07:22:15 GMT

Hi ,

I have the structure name ADDR1_DATA,

data element AD_STRSPP1

and field name STR_SUPPL1.

I want to know which table tha data is taken from.Plz help.How to find it out..I used SQL Trace....

Thanks and regards

Re: Finding out table

Former Member — Mon, 05 Nov 2007 07:24:53 GMT

check adrc table

raj

Re: Finding out table

Former Member — Mon, 05 Nov 2007 07:25:29 GMT

It is Street2 field

you can bapi BAPI_USER_GET_DETAIL to get the details

or check table USR03

no need to get table

Regards

Shiva

Re: Finding out table

former_member404244 — Mon, 05 Nov 2007 07:27:45 GMT

Hi,

the table name is ADRC...U can get this one like this..

goto SE84->abap dictionary->fields->table fields->give the field name and press on excute button.

Regards,

nagaraj

Re: Finding out table

Former Member — Mon, 05 Nov 2007 07:50:16 GMT

hi,

check the ADRC table,

or call T-CODE SE85 for object nevigator, and in that expand the object dictionatry folder, and select the last folder for FIELDS, expand it and select the database table fields, now give the field name and execute, you will get all the database table which contains this field.

got forget to reward all the helpful answer.

regards,

Re: Finding out table

Former Member — Mon, 05 Nov 2007 08:59:50 GMT

Hi,

Custmer details: KNA1-->ADRNR,PSTLZ,CITY,...

Address details:ADRC-->full address details

Company plant details:T001W-->Plant address

Regards,

Rama chary.Pammi