CRM TABLE AND RELATION

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, …)
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 Information’s

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 – 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) = ‘09’.
CRMD_PRICING (guid) = CRMD_LINK (guid_set).

For header price date take.
CRMD_LINK (guid_hi) = CRMD_ORDER_INDEX (header)..
CRMD_LINK (objtype_set) = ‘09’.
CRMD_PRICING (guid) = CRMD_LINK (guid_set).


PRSDT Error Price Date error (Price date for items are different in R3 and CRM)
• Take CRMD_ORDERADM_H guid by entering OBJECT_ID ( Order Number)
• Put it in header field in table CRMD_ORDERADM_I and get all items , take guid of error item
• Put it in CRMD_LINK guid_hi field. Take guid_set for OBJTYPE_HI = 06 and OBJTYPE_SET = 09
• Put it in table CRMD_PRICING guid will give the record with price date
• 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 = ‘SHOW’ 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 = ‘ORDER’.
Ordered Quantity for line item take
CRMD_SCHEDLIN (item_guid) = CRMD_ORDER_INDEX (item) and
CRMD_SCHEDLIN (event_type) = ‘ORDER’.

CRMD_CUMULATED_I (item_guid) = CRMD_ORDER_INDEX (item).

NOTE: -
• Delivered quantity for line item CRMD_CUMULATED_I (item_guid) = CRMD_ORDER_INDEX (item). And
o CRMD_CUMULATED_I (cum_type) = ‘05’ and
o CRMD_CUMULATED_I (cum_rule) = ‘03’.

• Shipped quantity for line item CRMD_CUMULATED_I (item_guid) = CRMD_ORDER_INDEX (item). And
o CRMD_CUMULATED_I (cum_type) = ‘02’ and
o CRMD_CUMULATED_I (cum_rule) = ‘03’.

• Billed quantity for line item CRMD_CUMULATED_I (item_guid) = CRMD_ORDER_INDEX (item). And
o CRMD_CUMULATED_I (cum_type) = ‘04’ and
o CRMD_CUMULATED_I (cum_rule) = ‘03’.
• $ Billed for line item CRMD_CUMULATED_I (item_guid) = CRMD_ORDER_INDEX (item). And
o CRMD_CUMULATED_I (cum_type) = ‘04’ and
o CRMD_CUMULATED_I (cum_rule) = ‘04’.

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) = ‘X’.
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) = ‘05’
And CRMD_LINK (objtype_set) = ‘11’.
CRMD_SALES (guid) = CRMD_LINK (guid_set).

BUT000
Table Name Field Name Description
BUT000 ( Business Partner – 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 – 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 – 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 – COMM_PCAT_ADM
Menu path – 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 – 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 – 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 ‘X’ 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 ‘X’ 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
‘BO’ (Instances of BOR Object types)
INSTID_B Format - ‘F/CRM_FOLDER/guid’

Relation between COMM_PCAT_ITV,
SKWG_BREL .

INSTID_A ( skwg_brel ) = GUID ( comm_pcat_itv ) .
CATID_A = ‘BO’

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 ‘.ext’ ext can be jpg , jpeg , pdf …..etc


Relation between SKWG_BREL ,
BDSLOIO18 .

PROP08 ( bdsloio18 ) = INSTID_B GUID part ( skwg_brel ) .
PROP01 = ‘CRM_IMAGE’ for the main image
= ‘CRM_THUMB’ for the thumb image
= ‘DOC_PDF’ 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 ‘.ext’ ext can be jpg , jpeg , pdf …..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 — 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