tables in crm

[Former Member]

hi CRM Gurus

How can we find table names in CRM and SVBAP table is there in CRM

regards

shekhar

[Former Member]

Hi,

you can use FM: TABLE_EXISTENCE.

Regards, Robert

[Former Member]

Hi,

In CRM you can find table same like in R/3 through F1 help and then where used list like that below are improtant CRM tables and likns between those Tables :

System Systempart Object Table Field

CRM BP Business Partner But000 PARTNER Key

PARTNER_GUID Key

TYPE Person/Organization/Gruppe

BPKIND Business partner type (GAAH, GAH, LKAH, LAH, SMBH, u2026)

XDELE

XBLCK

CONTACT

NOT_RELEASED

ZZ_SAP_MASTER

BP Roles But100 RLTYP Rolle

Business Partner Relations But050 PARTNER1 Key

PARTNER2 Key

DATE_TO Key

RELTYP

ID Numbers But0ID

Industries But0IS

Contact Person Relationship But051 ZZ_XDFREL Default Flag

CP Roles ZBP_BUT051_ATTR

Assignment BP - Adress But020

Assignment BP Relationship - Address But052

Address ADRC

Address ADRP

Sales Classification CRMM_BUT_FRG0041

Sales Area - Partner Function CRMM_BUT_FRG0081

Mapping Table Business Partner - Customer CRMM_BUT_CUSTNO

Mapping Table Business Partner Relationship - Contact Person CRMM_BUT_CONTNO

Segment Builder Profile Set CRMD_MKTTG_SET_H

Profile CRMD_MKTTG_PF_H

CRMD_MKTTG_PF_S Filter

CRMD_MKTTG_PF_SR Filter Conditions

Target Group CRMD_MKTTG_TG_H

CRMD_MKTTG_TG_I

Attribute List CRMD_MKTTG_SAL

Attribute CRMD_MKTTG_SA

Attribute Filter CRMD_MKTTG_SAF

Data Source CRMD_MKTTG_SDS

Assignment AL / DS CRMD_MKTTG_SALDS

IC Call List CRMD_TM_CL

Calls CRMD_TM_IACT

Call List Assignments CRMD_TM_ASSIGN

Call list statistics CRMD_TM_CLSTAT

Business context information: campaign, scripts CRMD_TM_CL_CMPGN

IC SAS Project based Expert Finder Matrix YSRL_EXPERTS

Index table for inbox ZSRL_CLASSIF_EXT

Call cycle time for BW reports YSRL_BW_CYCLETIM

Business context information: one order and business par CRMD_TM_IACT_BP

Interactive Scripts Telemarketing Scripting Decision Tree CRMD_TM_DCS_TREE CRM

Telemarketing Scripting Node CRMD_TM_NODE CRM

Categorization of node CRMD_TM_NODE_CAT

Telemarketing Scripting Node - Description CRMD_TM_NODE_T CRM

Telemarketing Option text CRMD_TM_OPTION_T CRM:

Telemarketing Scripting Tree CRMD_TM_TREE CRM:

CRMD_TM_TREE_LCK CRM Interactive Scripting (for locking only).

CRM Table Informationu2019s

CRMD_ORDER_INDEX

Table Name Field Name Description

Crmd_order_index

(Index table for one-order document ) Sales Org Sales Organization

Dis_Channel Distribution Channel

Division Division

Sales_Office Sales Office

Sales_group Sales Group

Object_type Sales Document type(Order Type)

Process_type_ix Business Transaction Category (Order Type)

Posting_date_hd Posting Date

Po_number_uc External Reference

Partner_no Soldto partner (PFT_1 flag EQ 'X')

Guid (order) Guid for one order(Key field)

CRMD_ORDERADM_H

Table Name Field Name Description

Crmd_orderadm_h

(Table for header information of an order) Guid Guid for order header

Object_id Order number

Posting_date Posting date

Description Transaction Description

CRMD_ORDERADM_I

Table Name Field Name Description

Crmd_orderadm_i Guid Guid of line item in an order

Header Header guid of that order

Product Product used for line item,product guid

Ordered_prod Material number (product name)

Description Product description

Number_int Line item number

Subst_reason Substitute product(like ZGEN)

CRMD_ACTIVITY_H

Table Name Field name Description

Crmd_activity_h

(activity table header) Guid Guid = header guid of an order

Category Activity Category (Communication Type) like EDI, Fax number, internet, telephone etc.

Relation between CRMD_ORDER_INDEX,

CRMD_ORDERADM_H,

CRMD_ORDERADM_I

And CRMD_ACTIVITY_H.

CRMD_ORDER_INDEX (header) = CRMD_ORDERADM_H (guid).

CRMD_ORDER_INDEX (item) = CRMD_ORDERADM_I (guid).

CRMD_ORDER_INDEX (header guid) = CRMD_ORDERADM_H (GUID).

CRMD_ORDER_INDEX (item guid) = CRMD_ORDERADM_H (GUID).

CRMD_ORDERADM_H (guid) = CRMD_ORDERADM_I (header guid).

CRMD_ORDER_INDEX (header) = CRMD_ORDERADM_H (guid).

CRMD_ORDER_INDEX (item ) = CRMD_ORDERADM_I (guid).

CRMD_ORDER_INDEX (header) = CRMD_ACTIVITY_H (guid).

CRMD_ORDERADM_H (guid) = CRMD_ACTIVITY_H (guid).

COMM_PR_FRG_REL

Table Name Field Name Description

Comm._pr_frg_rel

(Product - Set - Assignment ) Product_guid Internal Unique ID of Product

Fragment_guid guid

ZSPECS1(Custom table for YORK)

Table Name Field Name Description

Zspecs1

(Product attributes- Price family ) Frag_guid Fragment guid

Valid_from Valid up to date

Valid_to Valid to date

Relation between COMM_PR_FRG_REL

And ZSPECS1.

COMM_PR_FRG_REL (fragment_guid) = ZSPECS1 (frg_guid).

COMM_PR_FRG_REL (product_guid) = CRMD_ORDERADM_I (product).

CRM_JEST

Table Name Field Name Description

Crm_jest

(Individual Object Status) Objnr Guid (header)

Stat Object status

inact Indicator: Status Is Inactive

NOTE: - To see header status pass header guid in objnr and for item status pass item guid in objnr.

Relation between CRM_JEST,

CRMD_ORDER_INDEX.

CRM_JEST (objnr) = CRMD_ORDER_INDEX (header) for header status.

CRM_JEST (objnr) = CRMD_ORDER_INDEX (item) for item status.

CRMD_LINK

Table Name Field Name Description

Crmd_link

(Transaction - Set u2013 Link) Guid_hi

Guid_set

Objtype_hi

Objtype_set

CRMD_PRICING

Table Name Field Name Description

Crmd_pricing

(Business Transaction Pricing Parameter Set )

Guid Pricing guid

Price date Price date for order item & header

Currency Currency

Pmnttrms Terms of payment

Price_grp Price group

Price_list Price list type

Cust_group Customer group

Exchg_rate Exchange rate

Valid_from Valid from date

Valid_to Valid to date

Taxjurcode Tax Jurisdiction Code (Structure for tax calculation)

NOTE: - All pricing related information available and it keeps header pricing date as well as item pricing date in this table.

CRMD_PRICING_I

Table Name Field Name Description

Crmd_pricing_i

(Transaction Item Price ) Guid Guid

Net_value_man Total Expected Net Value Products in Document Currency

Cashflow_type Flow category

Taxjurcode_from Tax Jurisdiction Code (Structure for tax calculation)

Net_value Net value

Net_price Net price

Tax_amount Tax Amount in Document Currency

freight Shipment costs in document currency

Gross_value Gross Order Value in PO Currency

Net_wo_freight Item Net Value Exclusive Shipment

Relation between CRMD_LINK,

CRMD_PRICING,

CRMD_PRICING_I .

For line items price date take.

CRMD_LINK (guid_hi) = CRMD_ORDER_INDEX (item)..

CRMD_LINK (objtype_set) = u201809u2019.

CRMD_PRICING (guid) = CRMD_LINK (guid_set).

For header price date take.

CRMD_LINK (guid_hi) = CRMD_ORDER_INDEX (header)..

CRMD_LINK (objtype_set) = u201809u2019.

CRMD_PRICING (guid) = CRMD_LINK (guid_set).

PRSDT Error Price Date error (Price date for items are different in R3 and CRM)

u2022 Take CRMD_ORDERADM_H guid by entering OBJECT_ID ( Order Number)

u2022 Put it in header field in table CRMD_ORDERADM_I and get all items , take guid of error item

u2022 Put it in CRMD_LINK guid_hi field. Take guid_set for OBJTYPE_HI = 06 and OBJTYPE_SET = 09

u2022 Put it in table CRMD_PRICING guid will give the record with price date

u2022 Place /h in command line press ENTER ,now in debugging mode go to the end of ENDFORM put a break point there and click on code = u2018SHOWu2019 change it to EDIT and execute it. Change the date manually and save it execute and refresh it to get changed value.

CRMD_BILLING

Table Name Field Name Description

Crmd_billing

(Business Transaction - Billing Set) Guid Guid

Billing_block Business Partner (CRM): Billing Block Reason

Invcr_date Billing Document Created On (Invoice)

Relation between CRMD_BILLING,

CRMD_LINK,

CRMD_ORDER_INDEX.

CRMD_BILLING (guid) = CRMD_LINK (guid_set).

CRMD_LINK (guid_hi) = CRMD_ORDER_INDEX (item).

For line items crmd_link~objtype_set = '46'.

CRMD_SCHEDLIN

Table Name Field Name Description

Crmd_schedlin

(Business Transaction Item - Schedule Line) Guid GUID for Schedule Line in Business Transaction

Schedlin_no Schedule Line Number

Quantity CRM Schedule Line Quantity (ordered quantity)

Event_type Date Type

Item_guid Item GUID for a CRM Document

CRMD_CUMULATED_I

Table Name Field Name Description

Crmd_cumulated_i

(Transaction Item - Cumulated Value/ used for delivered,shipped,billed and $ billed qty for line items) Guid guid

Item_guid Item guid

Cum_type Cumulation Type

Cum_rule Cumulation Rule

Quantity CRM Quantity for Cumulated I

Quantity_unit Unit of Measure in Which the Product Is Sold

Value Cumulative Value

Currency currency

Relation between CRMD_SCHEDLIN,

CRMD_CUMULATED_I,

CRMD_ORDER_INDEX.

CRMD_SCHEDLIN (item_guid) = CRMD_ORDER_INDEX (item).

For Ordered Quantity for line item take EVENT_TYPE = u2018ORDERu2019.

Ordered Quantity for line item take

CRMD_SCHEDLIN (item_guid) = CRMD_ORDER_INDEX (item) and

CRMD_SCHEDLIN (event_type) = u2018ORDERu2019.

CRMD_CUMULATED_I (item_guid) = CRMD_ORDER_INDEX (item).

NOTE: -

u2022 Delivered quantity for line item CRMD_CUMULATED_I (item_guid) = CRMD_ORDER_INDEX (item). And

o CRMD_CUMULATED_I (cum_type) = u201805u2019 and

o CRMD_CUMULATED_I (cum_rule) = u201803u2019.

u2022 Shipped quantity for line item CRMD_CUMULATED_I (item_guid) = CRMD_ORDER_INDEX (item). And

o CRMD_CUMULATED_I (cum_type) = u201802u2019 and

o CRMD_CUMULATED_I (cum_rule) = u201803u2019.

u2022 Billed quantity for line item CRMD_CUMULATED_I (item_guid) = CRMD_ORDER_INDEX (item). And

o CRMD_CUMULATED_I (cum_type) = u201804u2019 and

o CRMD_CUMULATED_I (cum_rule) = u201803u2019.

u2022 $ Billed for line item CRMD_CUMULATED_I (item_guid) = CRMD_ORDER_INDEX (item). And

o CRMD_CUMULATED_I (cum_type) = u201804u2019 and

o CRMD_CUMULATED_I (cum_rule) = u201804u2019.

BUT000

Table Name Field Name Description

BUT000 (BP: General data I ) partner Business Partner Number

Name_org1 Name 1 of organization

Name_last Last Name of Business Partner (Person)

Name_first First Name of Business Partner (Person)

Emplo Employer of business partner

Bpkind Business partner type

Bu_group Business Partner Grouping

Partner_guid Business Partner GUID

Type Business Partner Category

Relation between BUT000,

CRMD_ORDER_INDEX.

For Soldto partner

CRMD_ORDER_INDEX (header) = CRMD_ORDERADM_H (guid) and

CRMD_ORDER_INDEX (item) = CRMD_ORDERADM_H (guid) and

CRMD_ORDER_INDEX (pft_1) = u2018Xu2019.

Gives partner number.

BUT000 (partner) = CRMD_ORDER_INDEX (partner_no), gives partner name.

CRMD_PRODUCT_I

Table Name Field Name Description

Crmd_product_i (Transaction Item - Product ) Guid Guid

Gross_weight Gross weight

Net_weight Net weight

Weight_unit Weight unit

Process_qty_unit Unit of Measure in Which the Product Is Sold

Prod_pr_group Product Group

Relation between CRMD_PRODUCT_I,

CRMD_ORDER_INDEX.

CRMD_PRODUCT_I (guid) = CRMD_ORDER_INDEX (item).

CRMD_SALES

Table Name Field Name Description

Crmd_sales(Business Transaction - Sales Set) Guid Guid

Po_number_uc Sold-to Party's External Reference No. (in Capital Letters)

Po_number_sold Sold-To Party's External Reference Number

Po_date_sold Reference Document Date

Po_number_ship Ship-To Party's External Reference Number

Po_date_ship Ship-To Party's Reference Document Date

Req_dlv_date Requested Delivery Date Header

Relation between CRMD_SALES,

CRMD_LINK,

CRMD_ORDERADM_H .

CRMD_ORDERADM_H (guid) = CRMD_LINK (guid_hi)

And CRMD_LINK (objtype_hi) = u201805u2019

And CRMD_LINK (objtype_set) = u201811u2019.

CRMD_SALES (guid) = CRMD_LINK (guid_set).

BUT000

Table Name Field Name Description

BUT000 ( Business Partner u2013 General data ) PARTNER Business Partner Number

BU_GROUP Business Partner Grouping

PARTNER_GUID Business Partner GUID

BU_GROUP = 0001 ( for sold to party )

= INTC (for inter company)

AUSP

Table Name Field Name Description

AUSP (Characteristic Values ) ATINN Internal characteristic ( Mkt attribute name )

ATWRT Characteristic Value ( Mkt attribute value )

PARTNER_GUID Business Partner GUID

Relation between BUT000,

AUSP.

PARTNER_GUID ( BP guid) = PARTNER_GUID ( BP guid).

We take the BP guids belonging to the desired group (sold to party or any other) from BUT000 and substitute

These guds in table AUSP to find the respective marketing attributes.

Table :- MVKE

Table description :- Sales Data for Material

Field :- VMSTA

Field description :- Distribution-chain-specific material status

Relation between PRODUCT CATALOG & VIEW.

TABLE PATH : -

COMM_PCAT_HDR (product catalog) --> COMM_PCAT_VIEW (product catalog view) -->

COMM_PCAT_ITM --> COMM_PCAT_CTY .

COMM_PCAT_HDR

Table Name Field Name Description

COMM_PCAT_HDR ( Product Catalog ) GUID Product Catalog guid

ID Product ID

All the Product Catalogs can be found in this table ( In YORK scenario we have EQUIPMENTS , PARTS & LITERATURE )

COMM_PCAT_VIEW

Table Name Field Name Description

COMM_PCAT_VIEW ( Product Catalog View ) GUID Product Catalog View guid

PARENT_CATALOG Object GUID ( Product catalog guid )

ID Product View ID

Relation between COMM_PCAT_HDR,

COMM_PCAT_VIEW.

PARENT_CATALOG ( comm_pcat_view ) = GUID ( comm_pcat_hdr ).

We get the view guids in GUID field of COMM_PCAT_VIEW for the respective Product catalog.

COMM_PCAT_VITM

Table Name Field Name Description

COMM_PCAT_VITM ( Product Catalog View-Item ) VIEWGUID Product Catalog View guid

PARENTGUID Object GUID ( Initially 0 & for the sub catalog area the Object guid of the previous catalog area )

OBJECTGUID Object Guid

Relation between COMM_PCAT_VIEW,

COMM_PCAT_VITM.

VIEWGUID ( comm_pcat_vitm ) = GUID ( comm_pcat_view ),

PARENTGUID ( comm_pcat_vitm ) = 0 ( For initial value )

= OBJECTGUID ( comm_pcat_vitm ) from the previous Product Catalog Area .

We start with PARENT_GUID = 0 & VIEWGUID = guid from comm_pcat_view we get the initial Product catalog area or the Brand related to that particular view.

The Object guid from the previous Product catalog area when put in Parent guid we get the

Sub Product catalog area. When the sub product catalog area ends we find the no of entries to be 0 in this table i.e the products have reached . we take the last object guids & place it in table

COMM_PCAT_ITM u2013 product catalog item field GUID & we get the Object guids which are

Nothing but guid of the products .we place these Object guids in table COMM_PRODUCT

Field GUID and we find the products in this product catalog area with specific brand & price family.

COMM_PCAT_ITM

Table Name Field Name Description

COMM_PCAT_ITM ( Product Catalog Item ) GUID Product Catalog Item guid

OBJECTGUID Object Guid

Relation between COMM_PCAT_VITM,

COMM_PCAT_ITM.

OBJECTGUID ( comm_pcat_vitm ) = GUID ( comm_pcat_itm ) .

COMM_PRODUCT

Table Name Field Name Description

COMM_PRODUCT ( Product ) PRODUCT_GUID Internal Unique ID of Product

PRODUCT_ID Product ID

Relation between COMM_PCAT_ITM,

COMM_PRODUCT.

OBJECTGUID ( comm_pcat_itm ) = PRODUCT_GUID ( comm_product ) .

Note u2013 To find the name (description) of the Product catalog area or Sub product catalog area we can find in table COMM_PCAT_CTY - Product Catalog Area. We place the Object guid of the

Product Catalog area or sub product catalog area in the GUID field of table comm_pcat_cty.

COMM_PCAT_CTY

Table Name Field Name Description

COMM_PCAT_CTY (Product Catalog Area ) GUID GUID of a Product Catalog Area

ID Catalog Area Number

Relation between COMM_PCAT_VITM,

COMM_PCAT_CTY.

OBJECTGUID ( comm_pcat_vitm ) = GUID ( comm_pcat_cty ) .

Transaction u2013 COMM_PCAT_ADM

Menu path u2013 SAP menu --> Master Data --> Product Catalog --> Maintain Product catalog.

For any product catalog the Product catalog area , sub product catalog areas & products

In other words Brands & Brands with price family (note u2013 the above relation is with respect to views & this relation is for all i.e. not related to views).

COMM_PCAT_HDR

Table Name Field Name Description

COMM_PCAT_HDR ( Product Catalog ) GUID Product Catalog guid

ID Product ID

All the Product Catalogs can be found in this table ( In YORK scenario we have EQUIPMENTS , PARTS & LITERATURE )

COMM_PCAT_CTY

Table Name Field Name Description

COMM_PCAT_CTY (Product Catalog Area ) PARENT_CATALOG Product Catalog GUID (from comm_pcat_hdr)

PARENT_CATEGORY GUID of a Product Catalog Area

Relation between COMM_PCAT_HDR,

COMM_PCAT_CTY.

GUID ( comm_pcat_hdr ) = PARENT_CATALOG ( comm_pcat_cty ) .

PARENT_CATEGORY ( comm_pcat_cty ) = 0 ( For initial value )

= GUID ( comm_pcat_cty ) from the previous Product Catalog Area .

We start with PARENT_CATEGORY = 0 & PRODUCT_CATALOG = guid from comm_pcat_hdr we get the initial Product catalog area or the Brand.

The Guid from the previous Product catalog area when put in Parent category we get the

Sub Product catalog area. When the sub product catalog area ends we find the no of entries to be 0 in this table i.e the products have reached . we take the last guids & place it in table

COMM_PCAT_ITM u2013 product catalog item field PARENT CATEGORY and also give the Parent Catalog & we get the Object guids which are

Nothing but guid of the products .we place these Object guids in table COMM_PRODUCT

Field GUID and we find the products in this product catalog area with specific brand & price family.

COMM_PCAT_ITM

Table Name Field Name Description

COMM_PCAT_ITM ( Product Catalog Item ) PARENT_CATALOG Product Catalog GUID (from comm_pcat_hdr)

PARENT_CATEGORY GUID of a Product Catalog Area

Relation between COMM_PCAT_ITM,

COMM_PCAT_CTY.

PARENT_CATALOG ( comm_pcat_itm ) = GUID ( comm_pcat_hdr corresponding catalog guid ) .

PARENT_CATEGORY( comm_pcat_itm ) = GUID ( comm._pcat_cty ).

COMM_PRODUCT

Table Name Field Name Description

COMM_PRODUCT ( Product ) PRODUCT_GUID Internal Unique ID of Product

PRODUCT_ID Product ID

Relation between COMM_PCAT_ITM,

COMM_PRODUCT.

OBJECTGUID ( comm_pcat_itm ) = PRODUCT_GUID ( comm_product ) .

COMM_PRSHTEXT

Table Name Field Name Description

COMM_PRSHTEXT ( Product text ) PRODUCT_GUID Internal Unique ID of Product

LANGU Language

Table :- TFDIR

Table description :- Function Module

Field :- FUNCNAME

Field description :- Name of Function Module

Field :- PNAME

Field description :- Program name

Table :- TNRO

Table description :- Definition of Number Range Objects

Field :- OBJECT

Field description :- Name of number range object

Table :- NRIV

Table description :- Number Range Intervals

Field :- OBJECT

Field description :- Name of number range object

Table :- USREFUS

Table description :- Reference user for internet applications

Field :- BNAME

Field description :- User Name in User Master Record

****_T

Table Name Field Name Description

Any table name TABLE **_T

( Description of the table ) PARENT_ CATEGORY GUID ( from the table of whose description is seeked )

COMM_PCAT_CTV

Table Name Field Name Description

COMM_PCAT_CTV (Product Catalog Area version ) PARENT_ CATEGORY Product Catalog Area GUID ( from comm_pcat_cty )

ACTIVE u2018Xu2019 if the Product Area is ACTIVE

COMM_PCAT_ITV

Table Name Field Name Description

COMM_PCAT_ITV (Product Catalog Item version ) PARENT_ITEM Product GUID (from comm_product)

ACTIVE u2018Xu2019 if the Product is ACTIVE

LINK FOR IMAGES OF PRODUCTS IN A PRODUCT CATALOG

SKWG_BREL

Table Name Field Name Description

SKWG_BREL ( Table for WCM Object Link Service ) INSTID_A GUID ( from comm_pcat_itv )

CATID_A

u2018BOu2019 (Instances of BOR Object types)

INSTID_B Format - u2018F/CRM_FOLDER/guidu2019

Relation between COMM_PCAT_ITV,

SKWG_BREL .

INSTID_A ( skwg_brel ) = GUID ( comm_pcat_itv ) .

CATID_A = u2018BOu2019

BDSLOIO18

Table Name Field Name Description

BDSLOIO18 (BDS: Instances of Logical Information Objects) LOIO_ID Logical document

PROP01

Image / Thumb nail / PDF

PROP08 INSTID_B GUID ( from skwg_brel )

PROP09 For extension of the image split at u2018.extu2019 ext can be jpg , jpeg , pdf u2026..etc

Relation between SKWG_BREL ,

BDSLOIO18 .

PROP08 ( bdsloio18 ) = INSTID_B GUID part ( skwg_brel ) .

PROP01 = u2018CRM_IMAGEu2019 for the main image

= u2018CRM_THUMBu2019 for the thumb image

= u2018DOC_PDFu2019 for the PDF image

BDSPHIO18

Table Name Field Name Description

BDSPHIO18 (BDS: Instances of Logical Information Objects) PHIO_ID Physical Document

LOIO_ID Logical document

PROP09 For extension of the image split at u2018.extu2019 ext can be jpg , jpeg , pdf u2026..etc

Relation between BDSLOIO18,

BDSPHIO18.

LOIO_ID ( bdsphio18 ) = LOIO_ID ( bdsloio18 ) .

The LOIO_ID field of the above table BDSPHIO18 gives us the GUID of the image & PROP09 has the extension

The above guid & the extension with the path of the image server location will display the image for us.

PRICE OF PRODUCTS IN A PRODUCT CATALOG with respect to the BRAND

ZUPI2C_CL_2BRAND is the table in R/3 which maintains BRAND & the PRICE FAMILY for the given brand

ZUPI2C_CL_2BRAND

Table Name Field Name Description

ZUPI2C_CL_2BRAND

( Brand Classes mapped to Brand and Sort Sequence ) MVGR1 Brand ( From CRM )

INACT Entry inactive

MVGR2 Price Group

Relation between ZUPI2C_CL_2BRAND,

CNCCRMPRCUS980 .

Note :- For a chosen BRAND.

ZZMVGR2 ( CNCCRMPRCUS980 ) = MVGR2 ( ZUPI2C_CL_2BRAND ) .

CNCCRMPRCUS980 ( PRICE TABLE )

Table Name Field Name Description

CNCCRMPRCUS980

( Sales org./Material/Matl grp 2 ) PRODUCT Product GUID (from comm_product)

ZZMVGR2 Material group 2 ( PRICE FAMILY

From R/3 table ZUPI2C_CL_2BRAND )

TIMESTAMP_TO Timestamp for Validity End Date

TIMESTAMP_FROM Timestamp for Validity Start Date

KBETR Condition Rate

KONWA Condition Currency

The Brands are assigned to Price Family in R/3 with respect to this,

the Products are assigned to Price family & we can have these products in those brands only which have the

corresponding price family associated with it.

i.e The same product with 2 different price families in two different Brands can have 2 different prices.

Relation between COMM_PRODUCTS -

---

COMM_PR_FRG_ROD -

---

CRM_JEST.

Relation between CRMM_BUT_LNK0031---- COMM crmm_but_set0030 -

---

BUT000.

( Link between Customer group & Customer )

Relation between CRMM_PR_SALESA -

---

COMM_PR_FRG_ROD --- COMM_PRODUCT

CRMM_PR_SALESA -

---

> COMM_PR_FRG_ROD

CRMM_PR_SALESA u2014 FRG_GUID = COMM_PR_FRG_ROD --- FRAGMENT GUID

COMM_PR_FRG_ROD -

---

> COMM_PRODUCT

COMM_PR_FRG_ROD --- PRODUCT_GUID = COMM_PRODUCT --- PRODUCT_GUID

YORK PRICE FAMILY TABLE

ZGTI2C_PRICEFAM

Table Name Field Name Description

ZGTI2C_PRICEFAM (Table for Price Family) ZPRFA Price Family

ZPRFA_DESC Pricing Family Description

ZSPECS1

Table Name Field Name Description

ZSPECS1 (Product attributes- Price family) FRG_GUID Set GUID

ZZ0010 Price Family

I think this is much for you

Regards

Amol Tambe

SAPCRM technical Consultant.

[Former Member]

Hi,

could you explain what all comes under master data in crm and its integration. Please give me details how to create BP( step by step) as well as it has to reflect in R/3

regards

raj