SAP ABAP Table COMT_PCAT_VRTIL (PCAT GENIL Structure for Catalog Variants)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PCT (Application Component) Product Catalog
     ⤷ CRM_PCATIL (Package) Product Catalog GENIL Layer

Basic Data

Table Category	INTTAB	Structure
Structure	COMT_PCAT_VRTIL	Table Relationship Diagram
Short Description	PCAT GENIL Structure for Catalog Variants

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Work Structure for Product Catalog Variant
2	GUID	☐	COMT_PCAT_VRT_GUID	SYSUUID	RAW	16	0	Product Catalog Variant GUID
3	ID	☐	COMT_PCAT_VRT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Variant Number
4	LANGU	☐	COMT_PCAT_VRT_LANG	SPRAS	LANG	1	0	Display Language of Catalog Variant	T002
5	MAIN_CURRENCY	☐	COMT_PCAT_MAINCURRENCY	WAERS	CUKY	5	0	Primary Currency of Catalog Variant	*
6	SCND_CURRENCY	☐	COMT_PCAT_2NDCURRENCY	WAERS	CUKY	5	0	Second Currency of Catalog Variant	*
7	UOM	☐	COMT_PCAT_UOM	COM_PC_UOM	CHAR	1	0	Unit of Measure Type
8	VALID_FROM	☐	COMT_PCAT_VRT_VALID_FROM	DATS	DATS	8	0	Catalog Variant Validity Beginning
9	VALID_TO	☐	COMT_PCAT_VRT_VALID_TO	DATS	DATS	8	0	Catalog Variant Expiration Date
10	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
11	DIST_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	CRMC_DISTCHAN
12	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
13	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	CRMC_CUSTGRP
14	PRICE_GROUP	☐	CRMT_PRICE_GRP	CRM_PRICE_GRP	CHAR	2	0	Customer Price Group	CRMC_PRICEGRP
15	PRICE_LIST	☐	CRMT_PRICE_LIST	CRM_PRICE_LIST	CHAR	2	0	Price List Type	CRMC_PRICELIST
16	PRICE_PROC	☐	PRCT_PRIC_PROC	PRC_PRIC_PROC	CHAR	6	0	Pricing Procedure	PRCC_COND_PPD
17	.INCLUDE	☐				0	0	Internal Fields for Product Catalog Variant
18	PARENT_CATALOG	☐	COMT_PCAT_GUID	SYSUUID	RAW	16	0	Object GUID	COMM_PCAT_HDR
19	ACTIVE	☐	COMT_ACTIVE_FLAG	COM_PCAT_BOOLEAN	CHAR	1	0	Activation Indicator
20	.INCLUDE	☐				0	0	Administrative Data for Object Creation
21	ORIG_SYSTEM	☐	COMT_ORIG_SYSTEM	LOGSYS	CHAR	10	0	Original System	*
22	CREATED_BY	☐	COMT_CREATOR	UNAME	CHAR	12	0	System Name of Object Creator
23	CREATED_ON	☐	COMT_CREATIONDATE	DATS	DATS	8	0	Date of Object Creation
24	.INCLUDE	☐				0	0	Administrative Data on Last Object Change
25	LASTCHG_BY	☐	COMT_LASTCHG_NAME	UNAME	CHAR	12	0	System Name of Last Object Modifier
26	LASTCHG_ON	☐	COMT_LASTCHG_DATE	DATS	DATS	8	0	Date of Last Object Change
27	LASTCHG_AT	☐	COMT_LASTCHG_TIME	UZEIT	TIMS	6	0	Time of Last Object Change
28	SALES_ORG_RESP	☐	CRMT_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Sales)
29	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
30	SERVICE_ORG_RESP	☐	CRMT_SERVICE_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Service)
31	DESCRIPTION	☐	COMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
32	PUBLICATION_STATE	☐	COMT_PCAT_PUBLISHED_FLAG	COM_PCAT_PUBLISHED_FLAG	CHAR	1	0	Indicator Exported to XML Interface
33	PUBLICATION_TEXT	☐	FDESCR	FB_STRING	STRG	0	0	General String Field

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	COMT_PCAT_VRTIL	CUST_GROUP	CRMC_CUSTGRP	CUST_GROUP	REF	1	CN
2	COMT_PCAT_VRTIL	DIST_CHANNEL	CRMC_DISTCHAN	DISTCHAN	REF	1	CN
3	COMT_PCAT_VRTIL	LANGU	T002	SPRAS
4	COMT_PCAT_VRTIL	PARENT_CATALOG	COMM_PCAT_HDR	CLIENT
5	COMT_PCAT_VRTIL	PRICE_GROUP	CRMC_PRICEGRP	PRICE_GROUP	REF	1	CN
6	COMT_PCAT_VRTIL	PRICE_LIST	CRMC_PRICELIST	PRICE_LIST	REF	1	CN
7	COMT_PCAT_VRTIL	PRICE_PROC	PRCC_COND_PPD	KAPPL	REF	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	510