Master Data Tables
Business Partner | |
BUT000 | BP: General dataContains Business Partner Number, Partner Category, Partner Type, First Name, Last Name etc. |
BUT020 | BP: Addresses |
BUT050 | BP relationships/role definitions: General dataContains Relationship, Partner Number (PARTNER1), Relationship Category |
BUT051 | BP Relationship: Contact Person RelationshipSimilar to BUT050 , additionally contains Contact Person’s Address data |
BUT0BK | Business Partner: Bank Data & DetailsBP 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:
responsible for the transaction. To get the Partner No, link it with CRM_ORDER_INDEX.
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.It doesn’t store the Business Transaction No (Object ID). To get the Business Transaction No link the table with CRMD_ORDERADM_H 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.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
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. |
Tags: SAP, SAP CRM 2007 Tables, SAP CRM 7.0 Tables, SAP Tables
Leave a comment