SAP ABAP Table COMM_PCAT_VRT (Product Catalog Variant)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PCT (Application Component) Product Catalog
     ⤷ COM_PRDCAT (Package) Product Catalog

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	COMM_PCAT_VRT	Table Relationship Diagram
Short Description	Product Catalog Variant

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	COMM_PCAT_VRT	CLIENT	T000	MANDT	KEY	1	CN
2	COMM_PCAT_VRT	CUST_GROUP	CRMC_CUSTGRP	CUST_GROUP	REF	1	CN
3	COMM_PCAT_VRT	DIST_CHANNEL	CRMC_DISTCHAN	DISTCHAN	REF	1	CN
4	COMM_PCAT_VRT	DIVISION	CRMC_DIVISION	DIVISION	REF	1	CN
5	COMM_PCAT_VRT	LANGU	T002	SPRAS
6	COMM_PCAT_VRT	MAIN_CURRENCY	TCURC	WAERS	REF	1	CN
7	COMM_PCAT_VRT	PARENT_CATALOG	COMM_PCAT_HDR	CLIENT
8	COMM_PCAT_VRT	PRICE_GROUP	CRMC_PRICEGRP	PRICE_GROUP	REF	1	CN
9	COMM_PCAT_VRT	PRICE_LIST	CRMC_PRICELIST	PRICE_LIST	REF	1	CN
10	COMM_PCAT_VRT	PRICE_PROC	PRCC_COND_PPD	KAPPL	REF	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in