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.
Table of Contents
COMM_PCAT_HDR is the Product Catalog Header table.
The Catalog is identified by a GUID
| Field | Description |
|---|---|
| GUID | Product Catalog GUID (Header) |
| ACTIVE | Activation Indicator |
| ORIG_SYSTEM | Original System |
| CREATED_BY | System Name of Object Creator |
| CREATED_ON | Date of Object Creation |
| .INCLUDE | Administrative Data on Last Object Change |
| LASTCHG_BY | System Name of Last Object Modifier |
| LASTCHG_ON | Date of Last Object Change |
| LASTCHG_AT | Time of Last Object Change |
| ID | Product Catalog Number |
| PCAT_TYPE | Catalog Type |
| VALID_FROM | Date from Which Catalog is Valid |
| VALID_TO | Date Until Which Catalog is Valid |
| BASE_SET | Product Catalog: Set Type GUID for Basic Attribute |
| BASE_LOC | Product Catalog: GUID of Characteristics List |
| PCAT_SHORTCUT | Product Catalog ID |
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 |
|---|---|
| AUTO | Automatic product assignment |
| DRPT | Design Registration |
| MANU | Manual product assignment |
| PURC | Purchasing catalog |
The description of Catalog is stored in the table COMM_PCAT_HDR_T for Product Catalog Description.
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 |
|---|---|
| GUID | Key Fields for Product Catalog Variant |
| PARENT_CATALOG | Object GUID |
| ACTIVE | Activation Indicator |
| ID | Catalog Variant Number |
| LANGU | Display Language of Catalog Variant |
| MAIN_CURRENCY | Primary Currency of Catalog Variant |
| SCND_CURRENCY | Second Currency of Catalog Variant |
| UOM | Unit of Measure Type |
| VALID_FROM | Catalog Variant Validity Beginning |
| VALID_TO | Catalog Variant Expiration Date |
| SALES_ORG | Sales Organization ID |
| DIST_CHANNEL | Distribution Channel |
| DIVISION | Division |
| CUST_GROUP | Customer Group |
| PRICE_GROUP | Customer Price Group |
| PRICE_LIST | Price List Type |
| PRICE_PROC | Pricing Procedure |
| SALES_ORG_RESP | Organizational Unit (Sales) |
| SERVICE_ORG | Service Organization |
| SERVICE_ORG_RESP | Organizational Unit (Service) |
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 )
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 |
|---|---|
| GUID | GUID of a Product Catalog Area |
| ACTIVE_SUBCTY | Active Sub Area Indicator Exists |
| INACTIVE_SUBCTY | Inactive Sub Area Indicator Exists |
| PARENT_CATALOG | Product Catalog GUID (Header) |
| PARENT_CATEGORY | GUID of a Product Catalog Area |
| ID | Catalog Area Number |
| CATEGORY_TYPE | Catalog Area Type |
Description for Area of the Catalog is set on SAP CRM table COMM_PCAT_CTY_T (Product Catalog Area Description)
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
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 |
|---|---|
| ITEMGUID | GUID of Product Catalog Item |
| ORIG_SYSTEM | Original System |
| PARENT_CATALOG | Product Catalog GUID (Header) |
| PARENT_CATEGORY | GUID of a Product Catalog Area |
| OBJECT | Object GUID |
| ILROLE | Role of Item in a Link |
| VERSIONGUID | GUID of Product Catalog Item Version |
| ACTIVE | Activation Indicator |
| POS_NR | Object Item Number |
Here the main important fields for Product Catalog Item View:
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
SAP ISU Tables for Technical master data, for Billing Master Data, Billing and invoicing Tables?…
SAP Fiori 3 UX and Design of SAP Fiori Apps for SAP S/4HANA, SAP TechEd…
Dunning is the business practice of informing a customer of past due payment. Dunning letters…
SAP AP Tcodes & SAP AR Tcodes: House Banks Tcodes, Advance Payments or Down Payments,…
What are the main SAP Payment Terms Tables ? What are the related Tables in…
Work center consists of master data related to routing of products. It contains data related…