SAP - CRM - Table - 图文

2.0 Tables

2.1 Master Data Tables

Table Name Business Partner BUT000 Description 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. It doesn’t store the Business Partner responsible for the transaction. To get the Partner No, link it with CRM_ORDER_INDEX. 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

Page 5 of 14

CRMC_PROC_TYPE CRMC_PARTNER_FCT SCPRIOT CRMC_PROC_TYPE_T CRMC_ACT_OBJ_T TJ30T CRMC_PR_ASSIGN IBIB IBIN Master table Business Transaction Type Definition of Partner Functions Priorities for Activities with priority text. Note: Pass the langu key with the language in which you want the text. Text for a transaction type Objective Number and Text for Activities All the status code and text Transaction Type and its Transaction Type Object. Installed Base/Ibase Installed Base Components 2.2 Transaction Data Tables

Table Name CRMD_LINK CRMD_ORDER_INDEX Description Transaction GUID set for all the Business Transactions 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 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 Additional Site Details at the Item Level of a Service Contract Table for individual Appointment Types for a transaction. Individual Object Status for any business transaction. Current Status for a business transaction along with set date, set time and status code. CRMD_ORDERADM_I CRMD_CUSTOMER_I SCAPPTSEG CRM_JEST CRM_JCDS

2.3 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 BUT000 CRMM_BUAG_H Description Fields such as Registration No, SIC Code, Cost to Serve etc. that appear in the additional details tab in BP transaction 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 This table is used as an extension of the service CRMD_CUSTOMER_H

Page 6 of 14

CRMD_CUSTOMER_I 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. 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.

Page 7 of 14

3.0 Table Links for Data Retrieval

Business Partner BUT0BK BUT050 BUT051 BUT100 BUT000 BUT020 BNKA ADRCC ADR2 ADR6 TSAD3T Contract Active CRMD_ORDER_INDEX CRMD_LINK CRMD_ORDERADM_H CRMD_CUSTOMER_H CRMC_PROC_TYPE CRMD_ORDERADM_I CRMC_PROC_ASSIGN CRMD_CUSTOMER_I

Page 8 of 14