Skip to Content
avatar image
Former Member

customer mobile number

hi,

i am new to abap.

can u pls tell me how to find the table name of particular fields which are in UI.

in xd03 we can see the details of customer.how to know the customer mobileno table for this screen.

regards

Guru

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Feb 18, 2008 at 12:35 PM

    In Table ADR2,

    If R3_USER field is set as ''2' or '3' , then TEL_NUMBER field gives the mobile No.

    1. IF R3_USER = '2' then TEL_NUMBER is Telephone is mobile telephone but not default mobile phone.

    3. IF R3_USER = '2' then TEL_NUMBER is Telephone is default mobile telephone.

    To select record from ADR2 table,

    1. go to kna1 table

    2. Give the customer no (kunnr)and fetch the (adrnr)

    3. Now go to ADR2 table

    4. Put ADDRNUMBER = ADRNR from KNA1 table and R3_USER = '2' or '3'.

    5. TEL_NUMBER will return the mobile no of the customer no.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      Goto ADR2 table if R3_user field is set to 3 then that is mobile number fo the user and the field is TELNR_LONG

      regards

      Shiva

  • avatar image
    Former Member
    Feb 18, 2008 at 11:50 AM

    Hi,

    you can click on F1 on that field and click on Technical Settings and see the table name and field name.

    Regards,

    JMB

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 18, 2008 at 11:52 AM

    hi

    press F1 on a particular field. then u click on the technical information tabm(like a cross spanner), ther u ll find it.

    Regrads

    karthik

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 18, 2008 at 11:57 AM

    Hi,

    Press F1 on the telephone field.

    A popup window will come.

    Then press Technical information button on the tool bar of popup window.

    There u will see the table name in Field data tab.

    Table name for Telephone number is:

    SZA1_D0100.

    Regards

    Vadi

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      hi

      how to see the data of the table SZA1_D0100 .

      when i am going ti se11. it is tell me that SZA1_D0100 is structure..

      regards

      Guru