need help to find the useful table

[Former Member]

Hello,

Please help me on CRM rables...

1. I have to find the tables which related to service orders and bp's.

email id's of the customers/bp's

2.and technical issue is as follows...

login page is portal

and bsp has to get that user name and password for further process...

if we can do it please let me knwo hwo can we achieve

[former_member927251 · Accepted solution]

Hi Bobby,

All the Business Partner tables start with BUT, so you can search by BUT.

All the Service Order related tables start with CRMD*.

BP's email ID : Table ADR6

<b>Reward points if it helps.</b>

Regards,

Amit Mishra

[Former Member · Accepted solution]

Hello Sir,

Thanks for your reply....

what are the function module we should use to update service order tables and Bp tables.

please mention how to retrieve data from crmd tables and BP tables by using function modules.

Regrads

Bobby

[former_member927251 · Accepted solution]

FM for Service Order Updation : CRM_ORDER_MAINTAIN

BP Updation : There are lot of BAPIs provided by SAP for partner updation. E.G. BAPI_BUPA_CREATE_FROM_DATA. Search by BAPI_BUPA* you will get all the FMs.

You can retrieve all the service order data from CRM_ORDER_READ FM. SAP has provided a report with the same name for executing the FM standalone.

<b>Reward points if it helps.</b>

[Former Member · Accepted solution]

Hello Amit,

Thanks for your valuable information.....

I have to work with BSP in my project how to display the report result in the bsp.

mean how to display the list in my web page.

is there any customized pages in our BSP . I come to knwo that we hve crm_bsp_frame. How to use this standard views for my project....

please help on this

regards

Bobby