The CRMC_TPM_QUERY table in SAP ERP or S/4HANA stores TPM: Query for access of BI key figures in Promotions data. There are total 3 fields in CRMC_TPM_QUERY table. The TPM: Query for access of BI key figures in Promotions 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_TPM_QUERY table. It is in TPM: Customizing for BI data retrieval (CRMC_MKTPL_TPM_BI_DATA) ABAP package and is part of the Marketing Planner (CRM-MKT-MPL) module.
SAP CRMC_TPM_QUERY Table Fields
Following is the list of fields that are available in SAP CRMC_TPM_QUERY table. The primary key fields of the table are CLIENT (Client), APPLICATION_TYPE (Application in Project Planning), OBJECT_CLASS (Category of Marketing Project).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| APPLICATION_TYPE | Application in Project Planning | CGPL_APPLICATION_TYPE | CHAR (3) | |
| OBJECT_CLASS | Category of Marketing Project | CRM_MKTPL_OBJ_CLASS | CRM_MKTPL_OCLAS | CHAR (3) |
