Table schema for managing customer loyality

CRM and CX Blogs by Members

Find insights on SAP customer relationship management and customer experience products in blog posts from community members. Post your own perspective today!

Hi!

I designed table schema for managing customer loyality.

So, I decided to publish it here and hope that somebody may find it helpful.

SAP CRM loyalty tables:

LOYD_MSH_MEMS
- LOYD_PT_ACCT_SET
  - LOYD_PT_ACCT
  - LOYD_PT_TXN
  - LOYD_PT_TXN_REASON
  - LOYD_PT_TXN_RSNT
- CGPL_PROJECT
  - CRM_MKTPL_ATTR
  - CRMC_MKTPL_CTYPE
  - CRMC_POINT_PROF
  - CRMC_LOY_POINT
  - CRMD_MKTPL_DYNAT
  - CRMC_DYNATTR_DEF
  - LOYD_MSH_MSDYN
- LOYD_MSH_MS_TIER
  - LOYD_MSH_MSQTIER
  - CRMC_TIER_LEVEL
  - CRMC_TIERGROUP
  - CRMC_TIER_PROFILE
- LOYD_MSH_MS_MEMB
  - LOYD_MEM_MEMBER
  - BUT000
- LOYD_CRD_CARD
- LOYD_MA_GENATTR
  - LOYC_MA_ERR_CODE
  - LOYD_MA_SPECATTR
  - LOYC_MA_CAT
  - LOYC_MA_CAT_TYPE
  - LOYC_MA_TYPE_T
  - LOYC_MA_TYPE
  - LOYS_MA_TYPEATTR
  - CRMC_FDT_ATTR
  - CRMC_FDT_BO
  - CRMC_FDT_APPL