customer mobile number

[Former Member]

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

[former_member190818]

Hi,

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

Regards,

JMB

[Former Member]

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

[i048168]

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

[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

[Former Member]

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.

[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