The CRMC_MKTGS_TGR table in SAP ERP or S/4HANA stores CRM Marketing: Tier growth rebate data. There are total 9 fields in CRMC_MKTGS_TGR table. The CRM Marketing: Tier growth rebate 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_MKTGS_TGR table. It is in Tier Growth Rebate Assignment Package (CRM_MKTGS_TGR) ABAP package and is part of the Marketing Planner (CRM-MKT-MPL) module.
SAP CRMC_MKTGS_TGR Table Fields
Following is the list of fields that are available in SAP CRMC_MKTGS_TGR table. The primary key fields of the table are CLIENT (Client), APPLICATION (Application in Project Planning), TGR_TYPE (TGR ID for Type Definition).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| APPLICATION | Application in Project Planning | CGPL_APPLICATION_TYPE | CHAR (3) | |
| TGR_TYPE | TGR ID for Type Definition | CRM_MKTGS_TGR_TYPE | CHAR (12) | |
| BDIM_TYPE | Base dimension KPI | CRM_MKTGS_BASEDIMENSION_TYPE | CRMC_MKTGS_BDIM | CHAR (6) |
| COMP_TYPE | Comparison KPI | CRM_MKTGS_COMPARISON_TYPE | CRMC_MKTGS_COMP | CHAR (6) |
| TIER_TYPE | Tier type for TGR | CRM_MKTGS_TIER_TYPE | CRMC_MKTGS_TIER | CHAR (6) |
| RATE_TYPE | Spend Value Type | CRM_MKTGS_RATE_TYPE | CRMC_MKTGS_RATE | CHAR (6) |
| CALC_TYPE | Calculation method ID | CRM_MKTGS_TGR_CALCMETHOD_ID | CRMC_MKTGS_CALC | CHAR (6) |
| ACTIV_TYPE | Active status | CRM_MKTGS_ACTIV_YESNO | CHAR (1) |
