The CRMC_PT_EXP_PROF table in SAP ERP or S/4HANA stores Point Expiration profile data. There are total 3 fields in CRMC_PT_EXP_PROF table. The Point Expiration profile 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_PT_EXP_PROF 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_PT_EXP_PROF Table Fields
Following is the list of fields that are available in SAP CRMC_PT_EXP_PROF table. The primary key fields of the table are CLIENT (Client), POINT_EXP_PROF (Point Expiration Override Profile ID), CAMP_TYPE (Type).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| POINT_EXP_PROF | Point Expiration Override Profile ID | CRM_MKTPL_LOY_PT_EXPIR_PROF_ID | CHAR (10) | |
| CAMP_TYPE | Type | CRM_MKTPL_CAMPTYPE | CRMC_MKTPL_CTYPE | CHAR (4) |
