plant address details

[former_member198892]

Dear Guru,

I have to get all the plant address from t001w and adrc table. Iam getting all the address except...

<b>

mobile_number

fax_number

e-mail address</b>

Where i can get these address..plz suggest me.

Regards,

Thanuskodi T.

[Former Member]

Hi,

Check the tables<b> ADRC</b>

Regards,

Maha

[Former Member]

check table adr6

[Former Member]

Hi,

chek ADRC table only in that we have field

Regards

kishore

[Former Member]

Hi Thanuskodi,

In ADRC few similar fields are there for mobile number,fax and e-mail address,please try to use the below fields and check:

TEL_NUMBER

FAX_NUMBER

FLAGCOMM6

Please shout me for further issues.

And reward points if helpful.

Thank you.

[Former Member]

Hi,

fax number is available in ADRC table.

for email and mobile , u need to fetch the contact person for the plant.

use his username and check in tables, USR21 to get personal number, using the personal number , u can select email mob from ADR6 table and mobile from ADR2 table

hope it makes clear

[former_member624107]

Hi..

Goto the table ADR6 and give the ADDRNUMBER (addrees number)

ther is a filed SMTP_ADDR which stores email address.

Fax number is der in ADRC table itself

Message was edited by:

Sheeba Bhaskaran

[former_member198892]

Dear Friends,

I didn't get the mobile number from adrc or adr6 or t001w table, could u tell me the mobile no fields table name.

[Former Member]

select TEL_NUMBER from ADR2

into l_mob

where ADDRNUMBER EQ '1234' and

R3_USER EQ 'X' " this flag indicates tele no is mobile no

[naval_bhatt4]

R3_user = 'X' is for deactivated phone number

For mobile number R3_user = '2' or '3'