SAP ABAP Table CRMS_LOY_MSH_MEMS_TIER (CRM LOY : Attribute structure of Membership-Tier table)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOY (Application Component) Loyalty
     ⤷ CRM_LOY_MSH_GENIL (Package) Loyalty Management Membership GENIL

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_LOY_MSH_MEMS_TIER	Table Relationship Diagram
Short Description	CRM LOY : Attribute structure of Membership-Tier table

Delivery and Maintenance

Pool/cluster
Delivery Class
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	LOY : Loyalty Key Structure
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☐	CRM_LOY_COM_GUID	SYSUUID	RAW	16	0	LOY : CRM Loyalty GUID
4	.INCLUDE	☐				0	0	LOY : Loyalty Object Strucure
5	REF_GUID	☐	CRM_LOY_COM_GUID	SYSUUID	RAW	16	0	LOY : CRM Loyalty GUID
6	APPLICATION	☐	CRM_LOY_COM_APPLICATION	CRM_LOY_COM_APPLICATION	CHAR	4	0	LOY : Application
7	PROCESS_TYPE	☐	CRM_LOY_COM_PROCESS_TYPE	CRM_LOY_COM_PROCESS_TYPE	CHAR	15	0	Process Type
8	TIER_GROUP	☐	CRM_LOY_MSH_TIERGRP_CODE	CRM_LOY_MSH_TIERGRP_CODE	CHAR	10	0	Tier Group ID
9	TIER_LEVEL	☐	CRM_LOY_MSH_TIERLEVEL_CODE	CRM_LOY_MSH_TIERGRP_CODE	CHAR	10	0	Tier ID
10	START_DATE	☐	CRM_LOY_MEMS_DATE	DATS	DATS	8	0	Date
11	END_DATE	☐	CRM_LOY_MEMS_DATE	DATS	DATS	8	0	Date
12	EXPIRY_DATE	☐	CRM_LOY_MEMS_DATE	DATS	DATS	8	0	Date
13	STATUS	☐	CRM_LOY_MSH_STATUS	TEXT30	CHAR	30	0	Membership Status
14	PREV_ACT_TIER	☐	CRM_LOY_MSH_TIERLEVEL_CODE	CRM_LOY_MSH_TIERGRP_CODE	CHAR	10	0	Tier ID
15	.INCLUDE	☐				0	0	CRM LOY : Structure for Status in Loyalty
16	ISTAT	☐	CRM_LOY_COM_JISTAT	J_ISTAT	CHAR	5	0	CRM LOY : Element for System Status	*
17	ESTAT	☐	CRM_LOY_COM_JESTAT	J_ESTAT	CHAR	5	0	CRM LOY : Element For User Status	*
18	.INCLUDE	☐				0	0	Include Structure for Membership
19	MEMST_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
20	.INCLUDE	☐				0	0
21	.INCLUDE	☐				0	0	LOY : Loaylty Action Structure
22	PROCESS_MODE	☐	CRM_LOY_COM_MODE	CRM_LOY_COM_MODE	CHAR	1	0	LOY: Loyalty Mode
23	TIER_GRP_DESC	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
24	TIER_LVL_DESC	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters

History

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