SAP ABAP Table CRMS_LOY_MA_SEARCH_ATTR (Structure for member activity search attributes)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-LOY (Application Component) Loyalty Marketing
     ⤷ CRM_LOY_MEMBER_ACTIVITY (Package) Loyalty Member activity

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_LOY_MA_SEARCH_ATTR	Table Relationship Diagram
Short Description	Structure for member activity search attributes

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	OBJECT_ID	☐	CRM_LOY_MA_ACT_ID	CRM_LOY_MA_ACTID	CHAR	10	0	Member Activity ID
2	ACTIVITY_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
3	MEMBERSHIP_ID	☐	CRM_LOY_MEMS_ID	CRM_LOY_MEMS_ID	CHAR	10	0	Membership ID
4	MEMBER_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
5	PROGRAM_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
6	PARTNER_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
7	PROCESS_TYPE	☐	CRM_LOY_COM_PROCESS_TYPE	CRM_LOY_COM_PROCESS_TYPE	CHAR	15	0	Process Type
8	CARD_ID	☐	CRM_CRD_CARD_ID	CRM_CRD_CARD_ID	CHAR	16	0	Card ID
9	ESTAT	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*
10	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
11	PRODCATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
12	SHORT_ERR_CODE	☐	CRM_LOY_MA_SHORT_CODE		CHAR	20	0	Short Code
13	CREATED_ON	☐	CRM_LOY_COM_CREATED_ON	SYDATS	DATS	8	0	LOY : Created On - OBSOLETE !!!
14	CREATED_BY	☐	CRM_LOY_COM_CREATED_BY	UNAME	CHAR	12	0	LOY: Created By
15	CHANGED_ON	☐	CRM_LOY_COM_CHANGED_ON	SYDATS	DATS	8	0	LOY : Changed On - OBSOLETE !!!
16	CHANGED_BY	☐	CRM_LOY_COM_CHANGED_BY	UNAME	CHAR	12	0	LOY : Changed By
17	ACTIVITY_TZ	☐	CRM_LOY_MA_TIMEZONE	TZNZONE	CHAR	6	0	Member Activity Timezone	*
18	.INCLUDE	☐				0	0	Extensibility Include Structure for Member Activity Search
19	MASEARCH_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
20	.INCLUDE	☐				0	0
21	PARTNERSHIP_ID	☐	CRM_LOY_PSH_ID	CRM_LOY_PSH_ID	CHAR	10	0	Partnership ID
22	PARTNSHIP_EXT_ID	☐	CRM_LOY_MA_PART_EXT_ID	CRM_LOY_MA_PART_EXT_ID	CHAR	10	0	CRM LOY MEMBER ACTIVITY PARTNER EXTERNAL ID
23	EXTERNAL_CARD_NU	☐	CRM_LOY_CRD_CARD_EXT_ID	CRM_LOY_CRD_CARD_EXT_ID	CHAR	25	0	External Card ID

History

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