Skip to Content
avatar image
Former Member

plant address details

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 29, 2007 at 05:33 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 29, 2007 at 05:23 AM

    Hi,

    Check the tables<b> ADRC</b>

    Regards,

    Maha

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 29, 2007 at 05:24 AM

    check table adr6

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 29, 2007 at 05:26 AM

    Hi,

    chek ADRC table only in that we have field

    Regards

    kishore

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 29, 2007 at 05:27 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 29, 2007 at 05:35 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • avatar image
    Former Member
    Nov 29, 2007 at 05:55 AM

    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

    Add comment
    10|10000 characters needed characters exceeded