Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Finding out table

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

former_member404244
Active Contributor
0 Kudos

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

5 REPLIES 5

Former Member
0 Kudos

check adrc table

raj

Former Member
0 Kudos

Hi

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

former_member404244
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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,

Former Member
0 Kudos

Hi,

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

Address details:ADRC-->full address details

Company plant details:T001W-->Plant address

Regards,

Rama chary.Pammi