The CRMC_LOY_POINT table in SAP ERP or S/4HANA stores Loyalty Management Point Type Table data. There are total 7 fields in CRMC_LOY_POINT table. The Loyalty Management Point Type Table table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRMC_LOY_POINT table. It is in CRM Marketing: Loyalty Program Backend (CRM_MKTPL_LOY) ABAP package and is part of the Loyalty Marketing (CRM-MKT-MPL-LOY) module.
SAP CRMC_LOY_POINT Table Fields
Following is the list of fields that are available in SAP CRMC_LOY_POINT table. The primary key fields of the table are CLIENT (Client), POINT_CODE (ID of Point Type), POINT_PROFILE_ID (ID of Point Profile), CAMP_TYPE (Type).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| POINT_CODE | ID of Point Type | CRMT_MKTPL_LOY_POINT_CODE | CHAR (10) | |
| POINT_PROFILE_ID | ID of Point Profile | CRM_MKTPL_LOY_POINT_PROFILE_ID | CRMC_POINT_PROF | CHAR (10) |
| CAMP_TYPE | Type | CRM_MKTPL_CAMPTYPE | CRMC_POINT_PROF | CHAR (4) |
| CONVERSION_FACT | Conversion Factor for Loyalty Points | CRMT_MKTPL_LOY_POINT_CF | DEC (5) | |
| EXPIRE_PROC_ID | ID of Date Calculation Procedure | CRM_MKTPL_LOY_DATE_RULE_CODE | CRMC_LOY_DTRUL | CHAR (10) |
| STATUS | Status | CRMT_MKTPL_LOY_POINT_STATUS | CHAR (10) |
