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 |
Nice One Pramod
🙂