The CRMC_TIERLEVEL_T table in SAP ERP or S/4HANA stores Loyalty Management Tier Level Text Table data. There are total 7 fields in CRMC_TIERLEVEL_T table. The Loyalty Management Tier Level Text 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_TIERLEVEL_T 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_TIERLEVEL_T Table Fields
Following is the list of fields that are available in SAP CRMC_TIERLEVEL_T table. The primary key fields of the table are CLIENT (Client), TIER_LEVEL_CODE (ID of Tier), TIER_GROUP (ID of Tier Group), TIER_PROFLILE_ID (ID of Tier Profile), CAMP_TYPE (Type), LANGUAGE (Language Key).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| TIER_LEVEL_CODE | ID of Tier | CRMT_MKTPL_LOY_TIERLEVEL_CODE | CRMC_TIERLEVEL | CHAR (10) |
| TIER_GROUP | ID of Tier Group | CRMT_MKTPL_LOY_TIERGRP_CODE | CHAR (10) | |
| TIER_PROFLILE_ID | ID of Tier Profile | CRM_MKTPL_LOY_TIER_PROFILE_ID | CHAR (10) | |
| CAMP_TYPE | Type | CRM_MKTPL_CAMPTYPE | CHAR (4) | |
| LANGUAGE | Language Key | SYLANGU | LANG (1) | |
| TIER_LEVEL_NAME | Description of Tier | CRMT_MKTPL_LOY_TIERLEVEL_NAME | CHAR (20) |
