SAP CRM Catalog Data Model and Tables RelationShip

SAP CRM Catalog e1461269538601

SAP CRM Catalog Data Model lists the most important SAP Tables for Catalog in SAP CRM and the link between the different tables in order to easily retrieve Catalog Data.

Main Product Catalog Tables in SAP CRM

SAP Product Catalog Header COMM_PCAT_HDR

COMM_PCAT_HDR is the Product Catalog Header table.
The Catalog is identified by a GUID

Field Description
GUIDProduct Catalog GUID (Header)
ACTIVEActivation Indicator
ORIG_SYSTEMOriginal System
CREATED_BYSystem Name of Object Creator
CREATED_ONDate of Object Creation
.INCLUDEAdministrative Data on Last Object Change
LASTCHG_BYSystem Name of Last Object Modifier
LASTCHG_ONDate of Last Object Change
LASTCHG_ATTime of Last Object Change
IDProduct Catalog Number
PCAT_TYPECatalog Type
VALID_FROMDate from Which Catalog is Valid
VALID_TODate Until Which Catalog is Valid
BASE_SETProduct Catalog: Set Type GUID for Basic Attribute
BASE_LOCProduct Catalog: GUID of Characteristics List
PCAT_SHORTCUTProduct Catalog ID

SAP CRM Catalog Type

COMC_PCAT_TP is the main customizing table for Product Catalog Type.
The Description language depended is stored on SAP CRM table COMC_PCAT_TP_T.

Some Standard Product Catalog Types in SAP CRM are:

Catalog Type Description
AUTOAutomatic product assignment
DRPTDesign Registration
MANUManual product assignment
PURCPurchasing catalog

SAP CRM Catalog Description

The description of Catalog is stored in the table COMM_PCAT_HDR_T for Product Catalog Description.

SAP Product Catalog Variant COMM_PCAT_VRT

Product Catalog Variants are set on SAP table COMM_PCAT_VRT.
The link to retrieve Variant of a SAP CRM catalog is:

COMM_PCAT_VRT- PARENT_CATALOG = COMM_PCAT_HDR-GUID

The SAP CRM Catalog Variant contains the Sales Data such as Sales Organization, Main currency, Price List and Price Group.

The Catalog Variant description can be found in the SAP table COMM_PCAT_VRT_T (Description of Product Catalog Variant)
Here the list of main Catalog Variant Fields:

Field Description
GUIDKey Fields for Product Catalog Variant
PARENT_CATALOGObject GUID
ACTIVEActivation Indicator
IDCatalog Variant Number
LANGUDisplay Language of Catalog Variant
MAIN_CURRENCYPrimary Currency of Catalog Variant
SCND_CURRENCYSecond Currency of Catalog Variant
UOMUnit of Measure Type
VALID_FROMCatalog Variant Validity Beginning
VALID_TOCatalog Variant Expiration Date
SALES_ORGSales Organization ID
DIST_CHANNELDistribution Channel
DIVISIONDivision
CUST_GROUPCustomer Group
PRICE_GROUPCustomer Price Group
PRICE_LISTPrice List Type
PRICE_PROCPricing Procedure
SALES_ORG_RESPOrganizational Unit (Sales)
SERVICE_ORGService Organization
SERVICE_ORG_RESPOrganizational Unit (Service)

SAP Product Catalog Area COMM_PCAT_CTY

The Product Catalog can be managed by hierarchy which called in SAP CRM Area and sub-area.
A sample SAP CRM Product Catalog Structure can be ( example from help.sap.com )

SAP CRM Catalog Structure
Product Catalog Area Table is COMM_PCAT_CTY.
The link between the view and the Parent Catalog is done on

COMM_PCAT_CTY-PARENT_CATALOG = COMM_PCAT_HDR-GUID

Some important fields for Product Catalog Area in CRM are:

Table Description
GUIDGUID of a Product Catalog Area
ACTIVE_SUBCTYActive Sub Area Indicator Exists
INACTIVE_SUBCTYInactive Sub Area Indicator Exists
PARENT_CATALOGProduct Catalog GUID (Header)
PARENT_CATEGORYGUID of a Product Catalog Area
IDCatalog Area Number
CATEGORY_TYPECatalog Area Type

Description for Area of the Catalog is set on SAP CRM table COMM_PCAT_CTY_T (Product Catalog Area Description)

SAP Product Catalog Area COMM_PCAT_CTV

Use the table COMM_PCAT_CTV for Product Catalog Area ? Version to check if a subarea and an area is active.

Use the following link to retrieve the Area Version for a SAP CRM Product Catalog :

COMM_PCAT_CTV-parent_category?=?COMM_PCAT_CTY-guid

Product Catalog Item COMV_PCAT_ITM

Once the Catalog header and the Product Catalog Hierarchy are defined in SAP CRM, it is the time to assign Products to Catalog.

The SAP CRM COMV_PCAT_ITM can be a good SAP View to have an idea on Products in a particular Catalog.
Here the main important fields for Product Catalog Item View:

Table Description
ITEMGUIDGUID of Product Catalog Item
ORIG_SYSTEMOriginal System
PARENT_CATALOGProduct Catalog GUID (Header)
PARENT_CATEGORYGUID of a Product Catalog Area
OBJECTObject GUID
ILROLERole of Item in a Link
VERSIONGUIDGUID of Product Catalog Item Version
ACTIVEActivation Indicator
POS_NRObject Item Number

Here the main important fields for Product Catalog Item View:

  • COMM_PCAT_ITM:
    Product Catalog ItemAcutally, the COMV_PCAT_ITM is not a table but it is SAP Database View based on SAP CRM Tables:
  • COMM_PCAT_ITV:
    Product Catalog Item- Version.

The Join condition is

COMM_PCAT_ITM-GUID????? =???? COMM_PCAT_ITV-PARENT_ITEM

Check the list of the main Tables for SAP Product Catalog Tables here