topic Re: CRM-relation tables in Application Development and Automation Discussions

CRM-relation tables

Former Member — Tue, 18 Dec 2007 12:32:27 GMT

Hi Experts

Can you plz tel relation tables in CRM

for customer, user name, and sales org?

cheers

Re: CRM-relation tables

Former Member — Tue, 18 Dec 2007 12:47:19 GMT

These are some important tables in CRM :

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

- 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

- CRMD_OPPORT_H OPPORTUNITY HEADER DATA

- 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_OPPORT_H OPPORTUNITY HEADER DATA

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

- 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

Reward points if useful,

Thanks,

Usha

Re: CRM-relation tables

Former Member — Wed, 19 Dec 2007 05:27:20 GMT

hi Usha garu,

Thanks for the response.

We need tables to find out

1. the users for particular sales organization and

2. Customers in a particular sales organization .

i.e.

1. userid and sales organization fields.. - table name

2. sales organization and customer fields - table name.

Regards,

Re: CRM-relation tables

Former Member — Wed, 19 Dec 2007 05:35:53 GMT

Please refer the following links

http://help.sap.com/saphelp_nw04/helpdata/en/6c/8a568832e85d4082c306df14e7cbf1/frameset.htm

List of tables in CRM .

CRMADPTST1 Adapter Test - Header Table

CRMADPTST2 Adapter Test - Lower-Level Table

CRMAHR Check Results Management: Personal Data

CRMAHRA Check Results Management: Personalization

CRMAHRROL Check Results Management: Positions

CRMAHRROLT Check Results Management: Role Description

CRMA_MKTPL_CPGNM APO Integration: Match CRM and generated A

CRMATAB Tables Permitted for Customizing Download

CRMBW_BWRFC_MAP Dialog RFC Destinations for BW Systems

CRMBWCVSYSTAT BBP/CRM: Mapping BW Status / OLTP System S

CRMBWCVUSSTAT Customizing: Mapping BW Status/ OLTP User

CRMBWIDSSAMPLE Assignment of DataSources to Samples

CRMBWSTT Text Table for BW Status

CRMBWSYSTATGRP BBP/CRM: BW Status Object Group for System

CRMBWSYSTATGRPT BBP/CRM: BW Status Object Group for System

CRMBWSYSTATOBJ BBP/CRM: BW Status Object for System Statu

CRMBWSYSTATOBJT BBP/CRM: BW Status Object for System Statu

CRMBWTARGETS Data Targets for BW Upload

CRMBWT_ATTR Attribute Definition for Attributes Determ

CRMBWT_ATTRS Status Administration: Status of the Data

CRMBWT_ATTRT Text Table for Attribute Definition

CRMBWT_ATTR_VAL Texts for Attribute Values

CRMBWT_ATTR_VALT Check Table for Attribute Values

CRMBWTGTDEF Data Target Check Table for BW Upload

CRMBWTGTDEFT Data Target Check Table for BW Upload - Te

CRMBWT_OIC_SRC Query for OIC

Reward Points if useful.

Re: CRM-relation tables

Former Member — Wed, 19 Dec 2007 06:02:48 GMT

CRMM_BUT_FRG0081 Business Partner - Sales Area - Partner Function

T Code: se11

put crm*..then search..you will get the list of all the tables..

put t*..then search...the list of tables related to configuration...

you can search by description also..

So that's the list of complete tables in CRM...

Re: CRM-relation tables

upen_Chinnari7 — Thu, 22 May 2014 11:32:40 GMT

CRMV_PROD_SALESA - CRM Product + Sales area table Name