Skip to Content

Demystifying BDOCs, CRM Tables and BADIs

Hi All,

Hope this document helps for those who are frequently using Google search for finding the most commonly used BDOCs, Database Tables and BADIs in SAP CRM. This document is kind of demystifying the SAP CRM Technical especially CRM Middleware and Master Data for Data loading operations.

Commonly used BDOC Types

  1. Customer and Prospect

CAPGEN_OBJECT_WRITE

   2. Contact Person

CONGEN_OBJECT_WRITE

   3. Sales Order

SALESDOCGEN_OBJECT_WRITE

   4. Material

PRDCT_OBJECT

   5. Opportunity

OPPORTUNITY_WRITE

   6. Activity

ACTIVITY_WRITE

   7. Campaign

CAMPAIGN_WRITE

   8. Promotion

PROMOTION_WRITE

   9. Service Notification

NOTIFN_WRITE

  10. Employee

EMPLOYEE_WRITE

  11. Condition Objects

DNL_COND_*

  12. Customizing Objects

DNL_CUST_*

Note: (*) Indicates the Condition Object or Customizing Object Name. Ex: DNL_COND_ALL ( To download all the Condition Object / it can be specific to table(or a group of tables) like DNL_COND_PROD. Similarly for Customizing Data.

Master Data Tables

Table Name

Description

Business Partner

BUT000

BP: General data

Contains Business Partner Number, Partner Category, Partner Type, First Name, Last Name etc.

BUT020

BP: Addresses

BUT050

BP relationships/role definitions: General data

Contains Relationship, Partner Number (PARTNER1), Relationship Category

BUT051

BP Relationship: Contact Person Relationship

Similar to BUT050 , additionally contains Contact Person’s Address data

BUT0BK

Business Partner: Bank Data & Details

BP Number, Bank Key, Bank Country Key, Bank Account Number

BNKA

Bank Master Data

BUT100

BP: Roles

ADR2

Telephone Numbers (Business Address Services)

ADR6

SMTP Numbers (Business Address Services)

Contains Email – Id of the BP.

ADRC

Addresses (Business Address Services)

BP’s Complete Address Details- City, Country, Post Code, District, Street, Title No Etc

TSAD3T

Table containing the Title text against a Title No.

Note:

        Pass the langu key with the

        language in which you want the

        text.

COMM_PRODUCT

Master Table for Product

CRMM_BUAG

Master table for Business Agreement

CRMM_BUAG_H

Header Data for Business Agreement such as Tax Category, Tax Characteristic, Form key, Business Agreement Class. Data in this table correspond to ISU Contract account table FKKVKP.

CRMM_BABR_H

Rule data for business agreements – data in this table correspond to ISU Contract account table FKKVK

Business Transaction(Service Contracts in Particular)

CNCCRMPRCUSZZBUR

Condition Records for Service Contracts. We get Basic Unit Rate, Standing Charge Rate etc.

(This is a Z table used in a leading ISU SAP-CRM implementation. You can give the table SAP0090 – this is a standard table. – in general all condition tables have the naming convention CNCC*)

CRMD_ORDERADM_H

Contains the Header Information for a Business Transaction.

Note:

  1. 1.      It doesn’t store the Business Partner

       responsible for the transaction. To 

       get the Partner No, link it with

       CRM_ORDER_INDEX.

  1. 2.      This table can be used for search

       based on the Object Id(Business

       Transaction No). 

CRMD_CUSTOMER_H

Additional Site Details at the Header Level of a Business Transaction

CRMC_PROC_TYPE

Master table Business Transaction Type

CRMC_PARTNER_FCT

Definition of Partner Functions

SCPRIOT

Priorities for Activities with priority text.

Note:

        Pass the langu key with the

        language in which you want the

        text.

CRMC_PROC_TYPE_T

Text for a transaction type

CRMC_ACT_OBJ_T

Objective Number and Text for Activities

TJ30T

All the status code and text

CRMC_PR_ASSIGN

Transaction Type and its Transaction Type Object.

IBIB

Installed Base/Ibase

IBIN

Installed Base Components

Transaction Data Tables

Table Name

Description

CRMD_LINK

Transaction GUID set for all the Business Transactions

CRMD_ORDER_INDEX

Contains Header as well as Item details for a Business Transaction.

Note:

  1. 1.It doesn’t store the Business 

      Transaction No (Object ID).

      To get the Business Transaction No  

      link the table with

CRMD_ORDERADM_H

  1. 2.   This table can be used for search

      based on the Partner No

CRMD_ORDERADM_I

Stores the Item information for a Business Transaction. The scenarios where we have a Contract Header and within contract we have Line Items for the contract, this table can be useful.

  1. E.g. Service Contracts

CRMD_CUSTOMER_I

Additional Site Details at the Item Level of a Service Contract

SCAPPTSEG

Table for individual Appointment Types for a transaction. 

CRM_JEST

Individual Object Status for any business transaction.

CRM_JCDS

Current Status for a business transaction along with set date, set time and status code.

Table Enhancements

Following tables were enhanced as per the project requirement in a leading ISU-SAP CRM implementation. Easy Enhancement workbench can be used for enhancing most of the transactions in CRM.

Table Name

Description

BUT000

Fields such as Registration No, SIC Code, Cost to Serve etc. that appear in the additional details tab in BP transaction

CRMM_BUAG_H

Fields such as Acc in Legacy, Invoice Output, Clearing Category, Bill Form, Lock Process Type etc. that appear in the Business Agreement tab in BP transaction

CRMD_CUSTOMER_H

This table is used as an extension of the service contract header i.e. if there is a requirement to add new fields to CRMD_ORDERADM_H then; this table has to be used to add the fields.

CRMD_CUSTOMER_I

This table is used as an extension of the service contract header i.e. if there is a requirement to add new fields to CRMD_ORDERADM_I then; this table has to be used to add the fields. For e.g. fields required for additional site details tab at item level of Service Contract are added to this table.

Commonly Used BADIs

Transaction

Description

CRM_MKT_MODIFY_ORDER

Partner Determination badi

CRM_TERRMAN_ATTRIB

Territory Enhancement

CRM_COPY_BADI

Copy Badi for dates

ORDER_SAVE

Raise event on lead create

Hope this document helps everybody in deed and need. Happy coding.

Regards,

V S Bhargav.

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

    1. V S BHARGAV MYLAVARAPU Post author

      Hi Maddy,

      We have Like option as well with Bookmark.

      Please rate the document that helps me in correcting myself if I have undergone any mistakes, so that In future I cannot repeat the same. Thanks for your comment.

      (0) 
  1. DJ Mike

    Hi Bhargav,

    Nice document, Thanks! Is there a table from where we can get the Equipment ID in the Service Contract item ?

    Kindly let know.

     

    -Mike

    (0) 

Leave a Reply