on 07-01-2007 3:25 PM
plz send sap crm tables and relation's
crm.mahesh@yahoo.co.in
i will reword piont's
thank's
mahesh kumar.p
thank you very match sll gurus and pl z send me some test script's this mail
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 Persons 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)
BPs 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 doesnt 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 doesnt 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.