SAP CRM Loyalty Management Important Tables and Reports
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
🙂