SAP Loyalty Marketing Tables
Are you looking for the right table related to SAP Loyalty Marketing Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Loyalty Marketing (CRM-MKT-MPL-LOY) module.
Top 10 tables in Loyalty Marketing
| Table | Description |
|---|---|
| CRM_ACE2_PPT_ACL | Loyalty Access Control List |
| CRMC_TIERPOINT | Loyalty Mgmt Point Expiration Procedure Override |
| CRM_ACE2_PSH_ACL | Loyalty Access Control List |
| CRMC_MODL_LMIL | Loyalty Management applications BOL Model |
| CRMC_LOY_POINT | Loyalty Management Point Type Table |
| CRM_ACE2_MSH_GRP | Loyalty ACE user groups |
| CRM_ACE2_MEM_ACL | Loyalty Access Control List |
| CRM_ACE2_MEM_UCT | Loyalty ACE user-contexts |
| CRMD_LOY_BINREL | LOY - 1O object references |
| CRMD_MKTPL_CTPRO | Card Type to Card Processor (BP) Mapping |
List of tables in Loyalty Marketing
| Table | Description |
|---|---|
| CRM_ACE2_PPT_ACL | Loyalty Access Control List |
| CRMC_TIERPOINT | Loyalty Mgmt Point Expiration Procedure Override |
| CRM_ACE2_PSH_ACL | Loyalty Access Control List |
| CRMC_MODL_LMIL | Loyalty Management applications BOL Model |
| CRMC_LOY_POINT | Loyalty Management Point Type Table |
| CRM_ACE2_MSH_GRP | Loyalty ACE user groups |
| CRM_ACE2_MEM_ACL | Loyalty Access Control List |
| CRM_ACE2_MEM_UCT | Loyalty ACE user-contexts |
| CRMD_LOY_BINREL | LOY - 1O object references |
| CRMD_MKTPL_CTPRO | Card Type to Card Processor (BP) Mapping |
| CRMC_LOY_POINT_T | Loyalty Management Point Type Text Table |
| CRMC_PT_EXP_PROF | Point Expiration profile |
| CRMC_LOY_FOLLUP | Follow-up assignments for Loyalty Objects |
| CRMD_MKTPL_PTSM | Point Type and Settlement Material Mapping |
| CRM_ACE2_PA_GRP | Point Accounts: Loyalty ACE user groups |
| CRMC_DATE_REFER | Table to maintain date references. |
| CRMC_OBJ_C_LMIL | BOL Object Table for Loyalty Management applications ( Cust) |
| CRMC_LOY_OBJCK_T | Text table for Objects allowed for relationships in Loy Objs |
| CRMC_TIERLEVEL | Loyalty Mgmt Tier Level Table |
| CRMC_POINT_PROFT | Loyalty Point type profile |
| CRMC_LOY_MA_TY | table for member activity types |
| CRMC_MODL_C_LMIL | Loyalty Management applications BOL Model (Customer table) |
| CRM_ACE2_PSH_GRP | Loyalty ACE user groups |
| CRMC_IMPL_LMIL | Gen. IL -Loyalty Managemen : Object - Impl classes ( Cust) |
| CRM_ACE2_PA_UCT | Point Accounts: Loyalty ACE user-contexts |
| CRM_ACE2_MA_GRP | Loyalty ACE user groups |
| CRMC_LOY_OBJCHK | Business Object Types allowed for Loyalty Objects |
| CRMC_LOY_DTRUL | DB Table to store the date calculation rules for loyalty |
| CRMC_TIERGROUP_T | Loyalty Management Tier Group Text Table |
| CRMD_MKTPL_CORR | Assignment type table for Loyalty Outbound Correspondence |
| CRM_ACE2_PPT_GRP | Loyalty ACE user groups |
| CRMC_LOY_OBJPROF | Object Relationships - Customizing data for Loyalty Objects |
| CRM_ACE2_MEM_GRP | Loyalty ACE user groups |
| CRM_ACE2_MA_ACL | Loyalty Access Control List |
| CRMC_LOY_OBJRF_T | Object Relationship Profiles and Texts for Loyalty Obj |
| CRMC_METH_LMIL | Executable methods of an object |
| CRMC_TIERLEVEL_T | Loyalty Management Tier Level Text Table |
| CRMC_METH_C_LMIL | Executable Methods of an Object ( Customer table) |
| CRMC_TIERPROFILE | Tier profile |
| CRM_ACE2_LOY_ACL | Loyalty Access Control List |
| CRMC_PT_EXP_PRFT | Point Expiration Profile Text table |
| CRM_ACE2_PA_ACL | Point Accounts: Loyalty Access Control List |
| CRMC_TIERGROUP | Loyalty Management Tier Group |
| CRM_ACE2_MA_UCT | Loyalty ACE user-contexts |
| CRM_ACE2_MSH_UCT | Loyalty ACE user-contexts |
| CRMC_LOY_DTRUL_T | DB Table to store the date calculation rules for loyalty |
| CRM_ACE2_LOY_UCT | Loyalty ACE user-contexts |
| CRMC_LOY_RFC_DES | LOY : Loyalty Key & Value |
| CRM_ACE2_PPT_UCT | Loyalty ACE user-contexts |
| CRM_ACE2_MSH_ACL | Loyalty Access Control List |
| CRMC_OBJ_LMIL | BOL Object Table for Loyalty Management applications |
| CRMC_IMPL_C_LMIL | Gen. IL -Loyalty Managemen : Object - Impl classes |
| CRMC_LOY_OBJ | Object Profile assignments for Loyalty Objects |
| CRMC_IC_MEIDENT | Account Identification Profile for Member Search |
| CRMC_LOY_OBJREF | Object Relationship Profile IDs for Loyalty Objects |
| CRM_ACE2_PSH_UCT | Loyalty ACE user-contexts |
| CRMC_POINT_PROF | Point Profile |
| CRM_ACE2_LOY_GRP | Loyalty ACE user groups |
| CRMC_TIERPROFILT | Loyalty Tier Profile Text |