cancel
Showing results for 
Search instead for 
Did you mean: 

hi gurus

Former Member
0 Kudos

plz send sap crm tables and relation's

crm.mahesh@yahoo.co.in

i will reword piont's

thank's

mahesh kumar.p

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

thank you very match sll gurus and pl z send me some test script's this mail

Former Member
0 Kudos

Hi Mahesh,

Please find below the same.

SAP CRM Tables.

Sl.NO. Table Name Description

Business Partner

1 BUT000 BP: General data

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

2 BUT020 BP: Addresses

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

BUT0CC bank details

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)

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

19 (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.

20 Note:

21 1.        It doesn’t store the Business Partner

responsible for the transaction. To

22 get the Partner No, link it with

23 CRM_ORDER_INDEX.

2.        This table can be used for search

24 based on the Object Id(Business

25 Transaction No).

CRMD_CUSTOMER_H Additional Site Details at the Header Level of a Business Transaction

26 CRMC_PROC_TYPE Master table Business Transaction Type

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

31 CRMC_PROC_TYPE_T Text for a transaction type

CRMC_ACT_OBJ_T Objective Number and Text for Activities

32 TJ30T All the status code and text

33 CRMC_PR_ASSIGN Transaction Type and its Transaction Type Object.

IBIB Installed Base/Ibase

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

Business Partner

ADR2 Telephone Numbers (Business Address Services)

ADR3 Fax Numbers (Business Address Services)

ADR6 SMTP Numbers (Business Address Services)

ADRC Addresses (Business Address Services)

ADRCT Address Texts (Business Address Services)

BP001 Treasury Attributes Organization

BP011 Business Partner Master (Employment Data)

BP021 Business Partner Master (Fiscal Year Information)

BP1010 BP: Credit standing data

BP1012 Ratings

BP1013 Business Partner: Differentiation Type Dependent Attributes

BP1030 BP: Business partner - reporting data

BP3010 BP: Additional Data (from Darwin BP)

BP3100 Business Partner/Additional Information

BPCRITERFLDS Structure Fields for Differentiation Type Criterion

BPID001 Additional Partner Numbers for the BP

BUS000EMPL Business Partner: Work and Screen Fields Employee

BUT000 BP: General data I.

BUT001 BP: General data II

BUT020 BP: Addresses

BUT021 BP: Address usages

BUT021_FS BP: Address Usage With Validity Data

BUT0BANK Business Partner: Bank Data

BUT0BK BP: Bank details

BUT0CC BP: Payment Cards

BUT0ID BP: ID Numbers

BUT0IS BP: Industries

BUT100 BP: Roles

BUT_FRG0011 Business Partner: Tax Classification

CMSM_BP_FRG10 CMS: BP additional attributes

CRMM_BUT_SET0010 Business Partner - Sales Rule Period

CRMM_BUT_SET0020 Business Partner - Shipping Rule Period

CRMM_BUT_SET0030 Business Partner - Billing Rule Period

CRMM_BUT_SET0140 Business Partner Organization Rule Period

CRMPHAM_BP_FRG10 CRM Pharma. BP - Group / Subgroup

CRMPHAM_BP_FRG20 CRM Pharma. BP : Specification

CRMPHAM_BP_FRG30 CRM Pharma. BP: RPM Segments

CRMPHAM_BP_FRG50 CRM Pharma BP: assigned DEA schedules

CRMPHAM_BP_FRG60 CRM Pharma BP: assigned DEA schedules

DFKKBPTAXNUM Tax Numbers for Business Partner

SZA11_0100 Screen Fields SAPLSZA110100

Former Member
0 Kudos

its available in service.sap.com.

Just do a search.

Julius