SAP ABAP Table CRMC_TIERPOINT (Loyalty Mgmt Point Expiration Procedure Override)

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_TIERPOINT	Table Relationship Diagram
Short Description	Loyalty Mgmt Point Expiration Procedure Override

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	POINT_ID	☑	CRMT_MKTPL_LOY_POINT_CODE	CRM_MKTPL_LOY_POINT_CODE	CHAR	10	0	ID of Point Type	CRMC_LOY_POINT
3	TIER_ID	☑	CRMT_MKTPL_LOY_TIERLEVEL_CODE	CRM_MKTPL_LOY_TIER_CODE	CHAR	10	0	ID of Tier	CRMC_TIERLEVEL
4	CAMP_TYPE	☑	CRM_MKTPL_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	Type	CRMC_PT_EXP_PROF
5	PROFILE_ID	☑	CRM_MKTPL_LOY_PT_EXPIR_PROF_ID	CRM_MKTPL_LOY_PT_EXPIR_PROF_ID	CHAR	10	0	Point Expiration Override Profile ID	CRMC_PT_EXP_PROF
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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMC_TIERPOINT	CAMP_TYPE	CRMC_PT_EXP_PROF	CAMP_TYPE	KEY
2	CRMC_TIERPOINT	EXPIRE_PROC_ID	CRMC_LOY_DTRUL	CODE
3	CRMC_TIERPOINT	POINT_ID	CRMC_LOY_POINT	POINT_CODE	KEY
4	CRMC_TIERPOINT	PROFILE_ID	CRMC_PT_EXP_PROF	POINT_EXP_PROF	KEY
5	CRMC_TIERPOINT	TIER_ID	CRMC_TIERLEVEL	TIER_LEVEL_CODE	KEY

History

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