on 10-20-2010 2:08 AM
Hello Experts
Which CRM tables should I look to find out the product, plant and the business partner that was used, if I have the CRM transaction number. How are these tables linked to get the required information? If I require this info to be extracted to BW, what additional information is required for the BW resource?
Thanks in advance.
Hi,
The main table for the CRM Product Master is COMM_PRODUCT. But based on the CRM One Order Transaction it can access a wide number of tables. You can use the following technique of using ST05 - SQL Trace. You can switch on the trace and then note down all the tables that are accessed during the process. Then you can start the analysis to get to know the actual access sequence.
You can also have a look at the following link for a list of important tables in CRM - [CRM Tables 1|http://www.sap-img.com/general/find-the-table-names-for-a-crm-transaction.htm] & [Frequently Used Tables|http://www.sap-img.com/crm/list-of-frequently-used-crm-tables-list.htm]
Hope this helps.
Thanks,
Samantak.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Samantak
Thank you very much for your reply. From table COMM_PRODUCT, I can find the PRODUCT_ID, but which table would I link it to find the order number, plant and Business Partner in the transaction? I also ran a trace as you suggested but it gives me a report with more than 5000 lines and I'm lost to find out the few tables that's required. Can you please give more details?
Thanks
Hi know.how!
CRM_ORDER_READ is a function module which can be used to get the details of any business transaction based on the Header GUID, Item GUID or both.
Some Exporting Parameters in CRM_ORDER_READ Function Module
Return Structure Name Details Fetched
ET_ORDERADM_H Header Details of a Business Transaction such as OBJECT_ID, PROCESS_TYPE etc.
ET_ORDERADM_I Item Details of a Business Transaction such as PRODUCT, PRODUCT_KIND, HEADER etc.
ET_ACTIVITY_H Header Details of an activity such as PRIORITY, OBJECTIVE, Address Details etc.
ET_ACTIVITY_I Item Details of an activity.
ET_CUSTOMER_H Additional details at Header level
ET_CUSTOMER_I Additional details at Item level
ET_APPOINTMENT All the dates at Header and Item level
ET_PARTNER Partner Details at Header and Item level
ET_STATUS Status of Business Transaction at Header and Item level
ET_BILLING Billing related details for a Business Transaction both at Header and Item (This structure was enhanced in a leading ISU SAP-CRM implementation to include BUAG_ID(Business Agreement) field in a Service Contract
ET_ORDPRP_OBJL_I_D Object List details such as PRODUCT
ET_DOC_FLOW Ref. Details of the previous Business Transaction
Ex:
CALL FUNCTION 'CRM_ORDER_READ'
EXPORTING
IT_HEADER_GUID = lt_header_guid
IMPORTING
ET_ORDERADM_H = lt_orderadm_h
ET_ORDERADM_I = lt_orderadm_i
.
Best regards, Kostya
User | Count |
---|---|
5 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.