Most Used Database Tables in SAP CRM
| Table | Description |
| CRMD_ORDERADM_H | Contains the basic Header Information on Any Transaction created through CRMD_ORDER. This could be lead, opportunity, orders, quotations etc |
| CRMD_ORDERADM_I | Contains the basic item Information on Any Transaction created through CRMD_ORDER. This could be lead, opportunity, orders, quotations etc |
| BUT000 , BUT001 |
Business Partner General Data |
| BUT100 | SAP CRM Business Partner Roles |
| BUT150 | SAP CRM BP Relationship |
| COMM_PRODUCT | Product Master |
| CRMD_ORDER_INDEX | Description |
| CRMD_PARTNER | Order partner Information |
| CRM_JEST | Order Status |
For more on SAP CRM Training or SAP SD Training, please visit the respective pages. If you are interested in other training areas of SAP, please visit our home page for a list of schedules, registrations etc – SAP Training
Exercises :
Answer the following questions at the database level ( using SE16 and SE11 etc ). The intent is to find out the relationship at the database level between the most important tables. Also, give the technical field that you have used to find it out. For example, to find out the CITY of the BP 3360, you answer should be – ‘Find out the ADDRNUMBER of the customer from table BUT020 and find out the city as ADRC-CITY1 through table ADRC’.
Question 1 : Find out the Transaction Type of the Transaction Number – 8279
Question 2 : List the products in the line items in the Transaction Number – 8279
Question 3 : What is the Net Value of the Transaction – 8279 ?
Question 4 : Who (Which User ID ) created the Transaction – 8279 ?
Question 5 : What is the BP Type of the BP – 3360 ?
Question 6 : What is the Name of the BP – 3360 ?