cancel
Showing results for 
Search instead for 
Did you mean: 

Extract Mobile Phone for CRM Business Partner

Former Member
0 Kudos

Hi Experts

I would like to extract the mobile phone number for a business partner from CRM. Transaction BP shows the number in the address tab, communication area together with the telephone number and the fax number.

The business content DataSource 0BP_DEF_ADDRESS_ATTR delivers only the telephone number and the fax number. Does anyone know of a DataSource that also delivers the mobile phone? Otherwise, in which table is the mobile phone number stored?

Thanks in advance

Daniel

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Santosh

We've opted to extend the standard extractor 0BP_DEF_ADDRESS_ATTR. The missing bit was that the mobile number is actually stored in a field called TEL_NUMBER in table ADR2 when you filter for R3_USER = 3. So it's the same field as the fixed phone number (which has R3_USER = 1). That's why I couldn't find it at first. At least that's how it was for us.

I hope that helps.

Regards

Daniel

Former Member
0 Kudos

Hi Daniel,

Thanks for replying.

I will check out this option if it helps in our case.

regards

Santosh

Answers (3)

Answers (3)

0 Kudos

Hi Daniel,

I'm currently attempting to extend the 0BP_DEF_ADDRESS_ATTR for the same reason, and sending support call to SAP to see if standard extractor can be updated to include mobile number.

Can you give more detail on how you extended?

We have appended a field to the extract structure & are now trying to fill it from ADR2 where r3_user = 3

In particular a copy of any code you added to EXIT_SAPLRSAP_002 would be helpful.

Cheers

Don

Former Member
0 Kudos

Hi Daniel,

I have similar requirement, would appreciate if you can suggest the solution.

Thanks

Santosh

Former Member
0 Kudos

Solved.