on 11-24-2006 11:02 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Daniel,
I have similar requirement, would appreciate if you can suggest the solution.
Thanks
Santosh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Solved.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.