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 ?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s