SAP ABAP Table CRMC_TIERLEVEL (Loyalty Mgmt Tier Level Table)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-LOY (Application Component) Loyalty Marketing
     ⤷ CRM_MKTPL_LOY (Package) CRM Marketing: Loyalty Program Backend

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMC_TIERLEVEL	Table Relationship Diagram
Short Description	Loyalty Mgmt Tier Level Table

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	TIER_LEVEL_CODE	☑	CRMT_MKTPL_LOY_TIERLEVEL_CODE	CRM_MKTPL_LOY_TIER_CODE	CHAR	10	0	ID of Tier
3	TIER_GROUP	☑	CRMT_MKTPL_LOY_TIERGRP_CODE	CRM_MKTPL_LOY_TIER_CODE	CHAR	10	0	ID of Tier Group	CRMC_TIERGROUP
4	TIER_PROFLILE_ID	☑	CRM_MKTPL_LOY_TIER_PROFILE_ID	CRM_MKTPL_LOY_TIER_PROFILE_ID	CHAR	10	0	ID of Tier Profile	CRMC_TIERGROUP
5	CAMP_TYPE	☑	CRM_MKTPL_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	Type	CRMC_TIERGROUP
6	SEQUENCE	☐	CRMT_MKTPL_LOY_TIER_SEQUENCE	CRM_MKTPL_LOY_TIER_SEQUENCE	NUMC	5	0	Tier Sequence
7	EXPIRE_PROC_ID	☐	CRM_MKTPL_LOY_DATE_RULE_CODE	CRM_MKTPL_LOY_DATE_RULE_CODE	CHAR	10	0	ID of Date Calculation Procedure	CRMC_LOY_DTRUL
8	STATUS	☐	CRMT_MKTPL_LOY_TIER_STATUS	CRM_MKTPL_LOY_TIER_STATUS	CHAR	10	0	Status of Tier
9	CARD_TYPE	☐	CRM_LOY_CRD_CARD_CTYPE	CRM_LOY_CRD_CARD_CTYPE	CHAR	5	0	Card Type
10	RETAIN_OLD_NO	☐	CRM_LOY_CRD_BOOLEAN	CRM_LOY_CRD_BOOLEAN	CHAR	1	0	Loyalty card boolean
11	IS_OLD_CRD_VALID	☐	CRM_LOY_CRD_BOOLEAN	CRM_LOY_CRD_BOOLEAN	CHAR	1	0	Loyalty card boolean

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMC_TIERLEVEL	CAMP_TYPE	CRMC_TIERGROUP	CAMP_TYPE	KEY
2	CRMC_TIERLEVEL	EXPIRE_PROC_ID	CRMC_LOY_DTRUL	CODE
3	CRMC_TIERLEVEL	TIER_GROUP	CRMC_TIERGROUP	TIER_GROUP_CODE	KEY
4	CRMC_TIERLEVEL	TIER_PROFLILE_ID	CRMC_TIERGROUP	PROFILE_ID	KEY

History

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