Structure: SZA.1_D0100 (Packet: SZAD)

[Former Member]

Dear Experts,

for a Data Migration Project we need to extraxt the Mobile Phone Numer (Field: MOB_NUMBER or Object: AD_MBNMBR1)

for a Supplier out of a SAP Database. Unfortunately I can not find the correct Database-Table to retrieve this data from?

All I can find are many structures where this field is used. But as far as I know you can´t extract data from a structure?

Can anybody tell me how to proceed to get the Mobile Phone Number?

Thank´s for any feedback.

KRGDS

Jo

[Former Member]

Hi,

Try Table ADR2 but you will have to link it to ADRC using the address Number field.

Best to use TCode SQVI and set up a query to do this.

Hope this helps

Allen

[samar_jose2]

Try table ADRC

[Former Member]

Hi sajcon,

I have already searched in the ADRC but there are only fields for telephone & faxnumber,

not the mobile phone numer. This is stored in a different place which i couldn´t find.

KRGDS

JO

[Former Member]

Tip from a colleague,

LFA1_TELF2 is the correct field