SAP ABAP Table CRMC_LOY_TGCL_BI (Tier Group Classification for BI reporting)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOY (Application Component) Loyalty
     ⤷ CRM_LOY_BI (Package) Package for CRM Loyalty BI objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMC_LOY_TGCL_BI	Table Relationship Diagram
Short Description	Tier Group Classification for BI reporting

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	PROGRAM_TYPE	☑	CRM_MKTPL_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	Type	CRMC_TIERPROFILE
3	PROFILE_ID	☑	CRM_MKTPL_LOY_TIER_PROFILE_ID	CRM_MKTPL_LOY_TIER_PROFILE_ID	CHAR	10	0	ID of Tier Profile	CRMC_TIERPROFILE
4	TIER_GRP_CLASS	☑	CRM_MKTPL_LOY_TIER_GRP_CLASS	CRM_MKTPL_LOY_TIER_GRP_CLASS	CHAR	15	0	Tier Group Classification
5	TIER_GROUP_CODE	☐	CRMT_MKTPL_LOY_TIERGRP_CODE	CRM_MKTPL_LOY_TIER_CODE	CHAR	10	0	ID of Tier Group	CRMC_TIERGROUP

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMC_LOY_TGCL_BI	PROFILE_ID	CRMC_TIERPROFILE	TIER_PROFILE_ID
2	CRMC_LOY_TGCL_BI	PROGRAM_TYPE	CRMC_TIERPROFILE	CAMP_TYPE
3	CRMC_LOY_TGCL_BI	TIER_GROUP_CODE	CRMC_TIERGROUP	TIER_GROUP_CODE

History

Last changed by/on	SAP	20100421
SAP Release Created in	701