how to find out name of table for a structure.

[Former Member]

hello all,

I want to find out name of table for a structure ADDR1_DATA. can anybody pls tell me how to find out it?

Thanks,

Ashu

[Former Member]

Hi,

Go to SE11, enter structure name ADDR1_DATA.And select WHERE USED LIST.

A pop up will open in which u have to check TABLES and press continue.

U will find th elist of tables where the structure is used.

regards,

Naveen

[Former Member]

There is no check box for tables. there are check boxes for program,classes,screens etc.

[Former Member]

keep the pointer in structure name....and click in where used list...

u will get the list of tables................

Regards

Anbu

[Former Member]

Hi Ashu,

You write the structure name in se11 
after selecting the database table radio button
click on the where used list button in the application tool bar.
You will find the table name if it is used else where.
Check out the website at: 
http://sap-idoc2edi-consulting.com/ 
Read the blog at: 
http://blogs.ittoolbox.com/sap/ehadzipetros

Regards,

Jagadish

[Former Member]

Hi ashu,

To find out name of table for any structure,just use the where-used list.

The steps are;-

1.go to se11

2.select the radiobutton 'Data Type'.

3.Enter the name of the structure,i.e,ADDR1_DATA.

4.Then click on where-used -list icon on the application toolbar

5.Select your choices

6.Here, it gives you where the structure is used.

Hope this is useful,

Revert back if any issues

Good luck,

Bhumika

[Former Member]

use database tables checkbox

[Former Member]

Hi Anusha,

I think tere is no table associated to it.It may have table fields but not a part of table.

its only defined for programming usage(here for transferring data).

Thanks,

Surya.

[Former Member]

Hi Ashu,

Are you looking for contact person? if yes, look for table ADRC and field NAME_CO. I hope this will help you.

Reward points if useful

Regards,

Mark

[Former Member]

Hi,

To get address details of customer check tables ADRC, ADRP, ADR6.

U can also get the address details based on address number using FM ADDR_GET_COMPLETE.

But to get address details of contact person u should go to tables ADRC, ADR6, ADRP based on PARNR number.

Regards,

Shravan