Table schema for managing customer loyality

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