SAP CRM Loyalty Management Important Tables and Reports

[Former Member]

SAPCRM Loyalty Management Important tables  and Reports

Master tables – Business Partner – Member – membership

Table Name	Description
BUT000	BP: General data Contains Business Partner Number, Partner Category, Partner Type, External no First Name, Last Name etc.
LOYD_MSH_MS_MEMB	To get the Membership details – take the PARTNER_GUID and pass it to table LOYD_MSH_MS_MEMB – field - MEMB_GUID
LOYD_MSH_MEMS	To get the membership ID - pass the (MEMS GUID)from LOYD_MSH_MS_MEMB to the field GUID of LOYD_MSH_MEMS
LOYD_PT_ACCT	To get the point account set pass the value to REF_GUID  from the table LOYD_MSH_MEMS field PA_SET_GUID
LOYD_PT_TXN	Loyalty point account transaction
LOYD_MEM_ADDR	Loyalty member address table
LOYD_MEM_MEMBER	Data base table for member
LOYD_MSH_MS_TIER	LOY MSH: Tier Relation Table
CRMD_AUSP_HIST	Marketing attributes of Business partner

Product Master –

Table Name	Description
COMM_CATEGORY	Category
COMM_PRODUCT	Product
COMM_PRPRDCATR	Product category assignment – MA product guide link to Product guide

Member activity

Table Name	Description
LOYD_MA_SPECATTR	Table for member activity
LOYC_MA_TYPE	Table for member activity types
LOYC_MA_CAT	Table for member category
LOYD_MA_GENATTR	Table for member activity generic attributes
LOYD_MSH_STMT	Table for statement generation

Dynamic Attributes

Table Name	Description
CRMC_DYNA_OBJTPT	Text table for object types - object type, Campaign type and description
CRMC_DYNA_OBJTYP	object type and campaign type table
CRMC_DYNATTR_DEF	Dynamic attributes definition Table - only attribute ID and data type
CRMC_DYNA_DEFVAL	Default value for dynamic attributes
CRMC_DYNATR_ASG	Dynamic attribute assignment table - mapping relationship between object type and attribute
CRMD_FDT_RULE	Rule Builder Rules
CGPL_PROJECT	Loy Program ID
CGPL_HIERARCHY	Loy Program Hierarchy

Function Modules

FM Name	Description
LOY_GET_CGPL_OBJECTS	Get CGPL objects

Reports

RLOY_TIER_EXPIRY_REPORT	Expired Tier processing
RLOY_PT_ACCT_INA_EXPR_RUN	Points- Inactivity based expiration
RLOY_PT_ACCT_EXPR_RUN	Points- Data based expiration
RLOY_MEMSHIP_CREATE	Membership Create
CRM_LOY_MEMBER_ACTIVITY_LOAD	Member activity upload