Customer Relationship Management Blogs by Members
Find insights on SAP CRM and other customer relationship management products and topics in blog posts from community members and share your own perspective.
cancel
Showing results for 
Search instead for 
Did you mean: 
In this blog, I will walk you through on how to get attributes from set type of product master.
From my experience, additional fields are created in product master to meet the customer’s requirement.

The concept of product master can be found in the below link.
http://help.sap.com/saphelp_crmscen70/helpdata/en/47/b85853da7c2d64e10000000a42189c/content.htm
As a SAP developer, I will focus on the technical side.

Let me explain the tables related to our example.

  1. COMM_PRODUCT stores general data of products

  2. COMC_SETTYPE stores set type guid and read/update functions

  3. COMM_PR_FRG_REL is a relationship table which can be used to get the data from assigned set type.

  4. ZPRODINFO is a set type table which contains additional product information


T-code: COMM_ATTRSET can be used to create set types and attributes.
Set types are groups of attributes that are used to describe products.

Table relationship and coding example are shown below.

Figure 1: Table relationship



Figure 2 : Product Master



Figure 3 : Set type and Attributes






Coding Example



FUNCTION zget_prodexcl_flag.
*"----------------------------------------------------------------------
*"*"Local Interface:
*" IMPORTING
*" REFERENCE(IM_PRODUCT_GUID) TYPE COMT_PRODUCT_GUID
*" EXPORTING
*" REFERENCE(EX_PRODEXCL_FLAG) TYPE FLAG
*"----------------------------------------------------------------------
* Note:
* IMPORTING parameter - product_guid.

DATA: lv_prodinfo_guid TYPE comc_settype-frgtype_guid,
lv_prodexcl TYPE flag.
* Set Type
DATA: lc_prod_info TYPE comc_settype-frgtype_id VALUE 'ZPRODINFO'.

CLEAR: ex_prodexcl_flag.

SELECT SINGLE frgtype_guid INTO lv_prodinfo_guid FROM comc_settype
WHERE frgtype_id EQ lc_prod_info.
IF sy-subrc EQ 0.
* Get attribute of product info set type
SELECT SINGLE b~zz0012
INTO ex_prodexcl_flag
FROM comm_pr_frg_rel AS a
INNER JOIN zprodinfo AS b
ON a~fragment_guid = b~frg_guid
WHERE a~product_guid EQ im_product_guid
AND a~fragment_type EQ lv_prodinfo_guid.
ENDIF.

ENDFUNCTION.