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 |
