Loyalty table Table in SAP

• CRMC_LOY_DTRUL
  Table for DB Table to store the date calculation rules for loyalty
  Table Type : TRANSP
  Package : CRM_MKTPL_LOY
  Module : CRM-MKT-MPL-LOY
• CRMC_LOY_DTRUL_T
  Table for DB Table to store the date calculation rules for loyalty
  Table Type : TRANSP
  Package : CRM_MKTPL_LOY
  Module : CRM-MKT-MPL-LOY
• CRMC_LOY_POINT
  Table for Loyalty Management Point Type Table
  Table Type : TRANSP
  Package : CRM_MKTPL_LOY
  Module : CRM-MKT-MPL-LOY

• CRMC_LOY_POINT_T
  Table for Loyalty Management Point Type Text Table
  Table Type : TRANSP
  Package : CRM_MKTPL_LOY
  Module : CRM-MKT-MPL-LOY
• CRMC_MODL_C_LMIL
  Table for Loyalty Management applications BOL Model (Customer table)
  Table Type : TRANSP
  Package : CRM_LOY_CUSTOMIZING
  Module : CRM-MKT-MPL-LOY
• CRMC_OBJ_C_LMIL
  Table for BOL Object Table for Loyalty Management applications ( Cust)
  Table Type : TRANSP
  Package : CRM_LOY_CUSTOMIZING
  Module : CRM-MKT-MPL-LOY
• CRMC_OBJ_LMIL
  Table for BOL Object Table for Loyalty Management applications
  Table Type : TRANSP
  Package : CRM_LOY_CUSTOMIZING
  Module : CRM-MKT-MPL-LOY
• CRMC_OUTBND_QRES
  Table for Loyalty Outbound Table For Storing the Residence Time
  Table Type : TRANSP
  Package : CRM_LOY_OUTBOUND
  Module : CRM-LOY-OUT
• CRMC_SO_LOY_PNT
  Table for Loyalty Management Point Type Table
  Table Type : TRANSP
  Package : CRM_LOY_SO_INTEG
  Module : CRM-LOY-BTX-SLO
• CRMC_SO_LOY_PNTT
  Table for Loyalty Management Point Type Text Table
  Table Type : TRANSP
  Package : CRM_LOY_SO_INTEG
  Module : CRM-LOY-BTX-SLO
• CRMC_TIERGROUP_T
  Table for Loyalty Management Tier Group Text Table
  Table Type : TRANSP
  Package : CRM_MKTPL_LOY
  Module : CRM-MKT-MPL-LOY
• CRMC_TIERLEVEL
  Table for Loyalty Mgmt Tier Level Table
  Table Type : TRANSP
  Package : CRM_MKTPL_LOY
  Module : CRM-MKT-MPL-LOY

• CRMC_TIERLEVEL_T
  Table for Loyalty Management Tier Level Text Table
  Table Type : TRANSP
  Package : CRM_MKTPL_LOY
  Module : CRM-MKT-MPL-LOY
• CRMD_LOY_RRL_MEM
  Table for CRM Loyalty RRL: Table for Valid Members for RRL
  Table Type : TRANSP
  Package : CRM_MKTPL_RRL
  Module : CRM-MKT
• CRMD_MKTPL_CORR
  Table for Assignment type table for Loyalty Outbound Correspondence
  Table Type : TRANSP
  Package : CRM_MKTPL_ASSIGN_CORRDEF
  Module : CRM-MKT-MPL-LOY
• LOYC_BATCH_PARMT
  Table for Loyalty Batch parameters text table
  Table Type : TRANSP
  Package : LOY_COMMON
  Module : CRM-LOY
• LOYC_CONT_PARAMT
  Table for General customizing for Loyalty Management - Text Table
  Table Type : TRANSP
  Package : LOY_COMMON
  Module : CRM-LOY
• LOYC_CRD_CARD_CT
  Table for Loyalty management : Card Types customizing table.
  Table Type : TRANSP
  Package : LOY_CRD_CUST
  Module : CRM-LOY-MSH-CRD
• LOYD_BNFT_HDR
  Table for Loyalty Benefits Header Table
  Table Type : TRANSP
  Package : LOY_BNFT_DB
  Module : CRM-LOY
• LOYD_MEM_ADDR
  Table for Loyalty Member address table
  Table Type : TRANSP
  Package : LOY_MEM_DB
  Module : CRM-LOY-MEM
• LOYD_MEM_MEMBER
  Table for Loyalty Menagement : Database Table for Member
  Table Type : TRANSP
  Package : LOY_MEM_DB
  Module : CRM-LOY-MEM
• LOYD_MSH_MEMS
  Table for Loyalty Membership Table
  Table Type : TRANSP
  Package : LOY_MSH_DB
  Module : CRM-LOY-MSH
• LOYD_PSH
  Table for Loyalty Partnership Table
  Table Type : TRANSP
  Package : LOY_PSH_DB
  Module : CRM-LOY-PSH
• LOYD_PSH_TXN_TMP
  Table for Loyalty table to store temporary partnership transactions
  Table Type : TRANSP
  Package : LOY_COMMON
  Module : CRM-LOY

• LOY_LOGS_BNFT
  Table for Logs table for Loyalty Benefits
  Table Type : TRANSP
  Package : LOY_BNFT_DB
  Module : CRM-LOY
• CRMC_CHK_MSH
  Table for Define Complaint Types for loyalty
  Table Type : TRANSP
  Package : CRM_LOY_COMPL_INTG
  Module : CRM-BTX-COM
• CRMC_IMPL_C_LMIL
  Table for Gen. IL -Loyalty Managemen : Object - Impl classes
  Table Type : TRANSP
  Package : CRM_LOY_CUSTOMIZING
  Module : CRM-MKT-MPL-LOY
• CRMC_IMPL_LMIL
  Table for Gen. IL -Loyalty Managemen : Object - Impl classes ( Cust)
  Table Type : TRANSP
  Package : CRM_LOY_CUSTOMIZING
  Module : CRM-MKT-MPL-LOY
• CRMC_LOYPRODCAT
  Table for Hierarchy for Loyalty Products
  Table Type : TRANSP
  Package : CRM_LOY_SO_INTEG
  Module : CRM-LOY-BTX-SLO
• CRMC_LOY_FOLLUP
  Table for Follow-up assignments for Loyalty Objects
  Table Type : TRANSP
  Package : CRM_LOY_FRW_DOCFLOW_CUST
  Module : CRM-MKT-MPL-LOY
• CRMC_LOY_OBJ
  Table for Object Profile assignments for Loyalty Objects
  Table Type : TRANSP
  Package : CRM_LOY_FRW_DOCFLOW_CUST
  Module : CRM-MKT-MPL-LOY
• CRMC_LOY_OBJCHK
  Table for Business Object Types allowed for Loyalty Objects
  Table Type : TRANSP
  Package : CRM_LOY_FRW_DOCFLOW_CUST
  Module : CRM-MKT-MPL-LOY
• CRMC_LOY_OBJPROF
  Table for Object Relationships - Customizing data for Loyalty Objects
  Table Type : TRANSP
  Package : CRM_LOY_FRW_DOCFLOW_CUST
  Module : CRM-MKT-MPL-LOY
• CRMC_LOY_OBJREF
  Table for Object Relationship Profile IDs for Loyalty Objects
  Table Type : TRANSP
  Package : CRM_LOY_FRW_DOCFLOW_CUST
  Module : CRM-MKT-MPL-LOY
• CRMC_LOY_OBJRF_T
  Table for Object Relationship Profiles and Texts for Loyalty Obj
  Table Type : TRANSP
  Package : CRM_LOY_FRW_DOCFLOW_CUST
  Module : CRM-MKT-MPL-LOY
• CRMC_LOY_RFC_DES
  Table for LOY : Loyalty Key & Value
  Table Type : TRANSP
  Package : CRM_LOY_COMMON_CUST
  Module : CRM-MKT-MPL-LOY
• CRMC_LOY_SLS_PMT
  Table for Loyalty Sales Order: Mixed Payment Option
  Table Type : TRANSP
  Package : CRM_LOY_POINTS_COND
  Module : CRM-LOY-BTX-SLO
• CRMC_LOY_WIZARD
  Table for Loyalty Wizards
  Table Type : TRANSP
  Package : CRM_MKTPL_RRL
  Module : CRM-MKT
• CRMC_MODL_LMIL
  Table for Loyalty Management applications BOL Model
  Table Type : TRANSP
  Package : CRM_LOY_CUSTOMIZING
  Module : CRM-MKT-MPL-LOY
• CRMC_POINT_PROFT
  Table for Loyalty Point type profile
  Table Type : TRANSP
  Package : CRM_MKTPL_LOY
  Module : CRM-MKT-MPL-LOY
• CRMC_TIERGROUP
  Table for Loyalty Management Tier Group
  Table Type : TRANSP
  Package : CRM_MKTPL_LOY
  Module : CRM-MKT-MPL-LOY
• CRMC_TIERPOINT
  Table for Loyalty Mgmt Point Expiration Procedure Override
  Table Type : TRANSP
  Package : CRM_MKTPL_LOY
  Module : CRM-MKT-MPL-LOY
• CRMC_TIERPROFILT
  Table for Loyalty Tier Profile Text
  Table Type : TRANSP
  Package : CRM_MKTPL_LOY
  Module : CRM-MKT-MPL-LOY
• CRM_ACE2_LOY_ACL
  Table for Loyalty Access Control List
  Table Type : TRANSP
  Package : CRM_LOY_ACE
  Module : CRM-MKT-MPL-LOY
• CRM_ACE2_LOY_GRP
  Table for Loyalty ACE user groups
  Table Type : TRANSP
  Package : CRM_LOY_ACE
  Module : CRM-MKT-MPL-LOY
• CRM_ACE2_LOY_UCT
  Table for Loyalty ACE user-contexts
  Table Type : TRANSP
  Package : CRM_LOY_ACE
  Module : CRM-MKT-MPL-LOY
• CRM_ACE2_MA_ACL
  Table for Loyalty Access Control List
  Table Type : TRANSP
  Package : CRM_LOY_ACE
  Module : CRM-MKT-MPL-LOY
• CRM_ACE2_MA_GRP
  Table for Loyalty ACE user groups
  Table Type : TRANSP
  Package : CRM_LOY_ACE
  Module : CRM-MKT-MPL-LOY
• CRM_ACE2_MA_UCT
  Table for Loyalty ACE user-contexts
  Table Type : TRANSP
  Package : CRM_LOY_ACE
  Module : CRM-MKT-MPL-LOY
• CRM_ACE2_MEM_ACL
  Table for Loyalty Access Control List
  Table Type : TRANSP
  Package : CRM_LOY_ACE
  Module : CRM-MKT-MPL-LOY
• CRM_ACE2_MEM_GRP
  Table for Loyalty ACE user groups
  Table Type : TRANSP
  Package : CRM_LOY_ACE
  Module : CRM-MKT-MPL-LOY
• CRMT_LOY_POINTS_SPENT
  Table Data element for Loyalty Points Spent
• CRM_LOY_PT_POINT
  Table Data element for Loyalty Point
• LP_CODE
  Table Data element for Loyalty program code
• LP_SDATE
  Table Data element for Loyalty Program Start Date
• LP_EDATE
  Table Data element for Loyalty Program End Date
• LP_GRANT_PT
  Table Data element for Loyalty Point Granted
• LP_REFIND
  Table Data element for Determine Loyalty Points Using Basis Value
• LP_CRMD
  Table Data element for Loyalty Account Line Item Creation Mode
• LP_DISTRIBUTOR
  Table Data element for Loyalty Point Distributor
• LP_RDMP_LA
  Table Data element for Loyalty Account
• LP_ACCLNBR
  Table Data element for Consecutive Number for Loyalty Account Item
• LP_CDFL
  Table Data element for Credit/Debit for Loyalty Account Line Item

Loyalty table related terms

Definitions

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.