SAP ABAP Table CRMM_PR_SALESGH (Product - Sales Pricing Set - History)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PRO (Application Component) Products
     ⤷ CRM_PRODUCT_SALES_MD (Package) Product: Sales Data on a Product in CRM

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMM_PR_SALESGH	Table Relationship Diagram
Short Description	Product - Sales Pricing Set - History

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	Set History Key
2	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	FRG_GUID	☑	COMT_FRG_GUID	SYSUUID	RAW	16	0	Set GUID
4	VALID_TO	☑	COMT_VALID_TO	BCOS_TSTMP	DEC	15	0	Valid To (Time Stamp)
5	.INCLUDE	☐				0	0	Sales Data on Product: Groupings (Without Key)
6	PROD_PR_GROUP	☐	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	CRMC_PRC_PRGRP
7	PRC_GROUP1	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	CRMC_PRC_GRP1
8	PRC_GROUP2	☐	CRMT_PRC_GROUP2	CRM_PRC_GROUP2	CHAR	3	0	Product Group 2	CRMC_PRC_GRP2
9	PRC_GROUP3	☐	CRMT_PRC_GROUP3	CRM_PRC_GROUP3	CHAR	3	0	Product Group 3	CRMC_PRC_GRP3
10	PRC_GROUP4	☐	CRMT_PRC_GROUP4	CRM_PRC_GROUP4	CHAR	3	0	Product Group 4	CRMC_PRC_GRP4
11	PRC_GROUP5	☐	CRMT_PRC_GROUP5	CRM_PRC_GROUP5	CHAR	3	0	Product Group 5	CRMC_PRC_GRP5
12	REBATE_GROUP	☐	CRMT_REBATE_GROUP	CRM_REBATE_GROUP	CHAR	2	0	Volume Rebate Group	CRMC_REBATEGRP
13	COMM_GROUP	☐	CRMT_COMM_GROUP	CRM_COMM_GROUP	CHAR	2	0	Commission Group	CRMC_COMM_GRP
14	ACCTGRP_PROD	☐	CRMT_ACCTGRPPROD	CRM_ACCTGRPPROD	CHAR	2	0	Account Assignment Group for Product	CRMC_ACGRPPROD
15	SALESCAT_GUID	☐	CRMT_SALESCAT_GUID	SYSUUID	RAW	16	0	Distribution Chain Dependent Category
16	.INCLUDE	☐				0	0	Product History: Sets - Administration Data
17	VALID_FROM	☐	COMT_VALID_FROM	BCOS_TSTMP	DEC	15	0	Valid From (Time Stamp)
18	UPNAME	☐	COMT_UPNAME	UNAME	CHAR	12	0	Name of the User Who Last Changed the Set

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMM_PR_SALESGH	ACCTGRP_PROD	CRMC_ACGRPPROD	ACCTGRP_PROD
2	CRMM_PR_SALESGH	COMM_GROUP	CRMC_COMM_GRP	COMM_GROUP
3	CRMM_PR_SALESGH	PRC_GROUP1	CRMC_PRC_GRP1	PRC_GROUP1
4	CRMM_PR_SALESGH	PRC_GROUP2	CRMC_PRC_GRP2	PRC_GROUP2
5	CRMM_PR_SALESGH	PRC_GROUP3	CRMC_PRC_GRP3	PRC_GROUP3
6	CRMM_PR_SALESGH	PRC_GROUP4	CRMC_PRC_GRP4	PRC_GROUP4
7	CRMM_PR_SALESGH	PRC_GROUP5	CRMC_PRC_GRP5	PRC_GROUP5
8	CRMM_PR_SALESGH	PROD_PR_GROUP	CRMC_PRC_PRGRP	PRC_PR_GROUP	REF	1	CN
9	CRMM_PR_SALESGH	REBATE_GROUP	CRMC_REBATEGRP	REBATE_GROUP

History

Last changed by/on	SAP	20100420
SAP Release Created in