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

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply